userlogoutcommand.java~1~

java系统通用框架 很实用的东东 一般人都看的懂,

package com.ibm.bisc.ebiz.base;

import java.sql.*;
import com.ibm.bisc.ebiz.security.*;
import com.ibm.bisc.ebiz.member.*;
/**
 * 此处插入类型描述。
 * 创建日期：(2002-8-18 12:18:16)
 * @author：pangwei
 */
public class UserLogoutCommand implements Command {

	Connection conn =null;
/**
 * UserLogoutCommand 构造子注解。
 */
public UserLogoutCommand() {
	super();
}
/**
 * execute 方法注解。
 */
public CmdResult execute(RequestContext context, CommandMap aMap) throws Exception {

	try{
	System.out.println("-------- UserLogoutCommand ----------- begin ");
	
	javax.servlet.http.HttpSession session = context.getRequest().getSession(false);

	//记录log
	Connection conn = context.getDBConnection();
	conn.setAutoCommit(false);
	
	String sql = "insert into s_userlog values(?,?,?,current timestamp,0,?,null)";
	PreparedStatement ps = null;
	long seq = KeyContainer.getNewSequence(conn,"s_userlog",1);
	System.out.println("--------UserLogoutCommand seq= "+seq);
	
	String ipaddress = context.request.getRemoteAddr();
	System.out.println("--------UserLogoutCommand ipaddress= "+ipaddress);

	User user = (User)session.getAttribute("_webuser");
	String userid = user.getUserID();
	
	int status = 0;
	ps = conn.prepareStatement(sql);
	ps.setLong(1,seq);
	ps.setString(2,userid);
	ps.setString(3,ipaddress);
	ps.setInt(4,status);

	try{
		ps.executeUpdate();
	}catch(SQLException sqle){
		System.out.println(sqle);
	}finally{
		try{
			ps.close();
			conn.commit();
		}catch(SQLException sqle){
			System.out.println("--------UserLogoutCommand SQLException= "+sqle);
		}
		context.freeDBConnection(conn);		
	}

	
	if(session != null){
		session.invalidate();
	}

	BizComponent bizcomponent = new BizComponent("logout");

	CmdResult cmdresult = new CmdResult("00000000");
	cmdresult.setBizComp(bizcomponent);
	
	return cmdresult;

	}catch(Exception exp){
	   
		System.out.println("*************UserLogoutCommand Failed");
		System.out.println("-------------UserLogoutCommand Exception exp="+exp);
	    exp.printStackTrace(System.out);
      	throw exp;
   
   }finally {
        //context.freeDBConnection(conn);
   }
}
}