用户登陆 封装

首先要有一个封装类，我用UserInfo

package domain;   

import java.util.List;   

public class UserInfo {   

 private String sessionIDCR;   

 private List sessionBMQX;   

 public String getSessionIDCR() {   
  return sessionIDCR;   
 }   

 public void setSessionIDCR(String sessionIDCR) {   
  this.sessionIDCR = sessionIDCR;   
 }   

  public List getSessionBMQX() {   
  return sessionBMQX;   
 }   

 public void setSessionBMQX(List sessionBMQX) {   
  this.sessionBMQX = sessionBMQX;   
 }   
}  

登陆经过的Action

UserInfo userInfo = kk_BlacklistVehicle_UserLoginSQLBean.userInfo(kk_BlacklistVehicle_UserLoginForm);   
   session.setAttribute("userInfo", userInfo) ;   

调用：   

UserInfo user = (UserInfo )session.getAttribute("userInfo");   
   System.out.println("idcr = "+user.getSessionIDCR());//调用String型   
   System.out.println("bmqxSize = "+user.getSessionBMQX().size());   
   for(int i = 0 ;i<user.getSessionBMQX().size();i++)   
   {   
    System.out.println("bmqx"+i+" ="+user.getSessionBMQX().get(i));//调用list型   
   }   

kk_BlacklistVehicle_UserLoginSQLBean.userInfo方法（传递sql语句）   

public UserInfo userInfo(KK_BlacklistVehicle_UserLoginForm kk_BlacklistVehicle_UserLoginForm)   
 {   
  UserInfo userInfo = new UserInfo();   
//   声明一个数据库操作对象   
  PreparedStatement pstmt = null ;   
  // 声明一个结果集对象   
  ResultSet rs   = null ;   
  // DataBaseConnection为具体的数据库连接及关闭操作类,连接数据库   
  DataBaseConnection dbc  = new DataBaseConnection() ;   

  String dw = null ;   

  String SQL = "SELECT idcr,idsc,idck,idcj,dw,idzx,bm,dwidcj FROM kk.kkyh WHERE id='"+kk_BlacklistVehicle_UserLoginForm.getKk_BlacklistVehicle_UserLogin_ID()+"' and PASSWORD='"+kk_BlacklistVehicle_UserLoginForm.getKk_BlacklistVehicle_UserLogin_PASSWORD()+"' " ;   
  System.out.println(SQL);   
  try    
  {   
   pstmt = dbc.getConnection().prepareStatement(SQL) ;   
   rs = pstmt.executeQuery() ;   

   while (rs.next())    
   {   
    dw = rs.getString("dw") ;   
    userInfo.setSessionIDCR(rs.getString("idcr"));   
    userInfo.setSessionIDSC(rs.getString("idsc"));   
    userInfo.setSessionIDCK(rs.getString("idck"));   
    userInfo.setSessionIDCJ(rs.getString("idcj"));   
    userInfo.setSessionLRDW(dw);   
    userInfo.setSessionIDZX(rs.getString("idzx"));   
    userInfo.setSessionBM(rs.getString("bm"));   
    userInfo.setSessionDWIDCJ(rs.getString("dwidcj"));//往封装类里加入值   
   }   

   List<String> list = new ArrayList<String>();     

   // 编写SQL语句   
   String sql = "SELECT bm FROM kk.kkbmqx WHERE ID='"+kk_BlacklistVehicle_UserLoginForm.getKk_BlacklistVehicle_UserLogin_ID()+"' and dw='"+dw+"' " ;   

   // 实例化数据库操作对象   
   pstmt = dbc.getConnection().prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY) ;//设置PreparedStatement的ResultSet为可滚动结果集   

   // 查询记录   
   rs = pstmt.executeQuery() ;   

   while(rs.next())   
   {   
    String listTemp = rs.getString("bm") ;   
    list.add(listTemp) ;    
   }   
   userInfo.setSessionBMQX(list) ;//往封装类里加list型值   
   pstmt.close() ;   
  }    
  catch (SQLException e)    
  {   
   e.printStackTrace();   
  }    
  finally    
  {   
   if (rs != null)    
   {   
    try    
    {   
     rs.close();   
    }    
    catch (SQLException e)    
    {   
     e.printStackTrace();   
    }   
   }   
   dbc.close() ;   
  }   
  return userInfo;   
 }