封装javabean(将结果集封装成集合)

 //javabean

import java.sql.Date;
import java.sql.Timestamp;

public class Employee {
 private int id;
 private String name;
 private Date birthday;
 private String sex;
 private String position;
 private Timestamp enter_duty;
 private String status;
 public int getId() {
  return id;
 }
 public void setId(int id) {
  this.id = id;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public Date getBirthday() {
  return birthday;
 }
 public void setBirthday(Date birthday) {
  this.birthday = birthday;
 }
 public String getSex() {
  return sex;
 }
 public void setSex(String sex) {
  this.sex = sex;
 }
 public String getPosition() {
  return position;
 }
 public void setPosition(String position) {
  this.position = position;
 }
 public Timestamp getEnter_duty() {
  return enter_duty;
 }
 public void setEnter_duty(Timestamp enterDuty) {
  enter_duty = enterDuty;
 }
 public String getStatus() {
  return status;
 }
 public void setStatus(String status) {
  this.status = status;
 }

}

 

 

//在实现类中将javabean封装成集合将有利于后面的对结果集的各种操作

 

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.cstp.book.domain.Employee;
import com.cstp.book.util.DBUtil;

 

public class EmployeeDaoImpl implements EmployeeDao{

 

 List list=new ArrayList();
 Connection conn=DBUtil.getConnect();
 PreparedStatement ps=null;
 ResultSet rs=null;
 Employee employee=null;

 //先将结果集封装成对象
 public Employee encapsulateEmployee(ResultSet rs) throws SQLException{

  employee=new Employee();
  employee.setId(rs.getInt("id"));
  employee.setName(rs.getString("name"));
  employee.setBirthday(rs.getDate("birthday"));
  employee.setSex(rs.getString("sex"));
  employee.setPosition(rs.getString("position"));
  employee.setEnter_duty(rs.getTimestamp("enter_duty"));
  employee.setStatus(rs.getString("stuts"));
  return employee;
 }

 //再将对象封装成集合
 public List encapsulateEmployeeList(ResultSet rs) throws SQLException{
  while(rs.next()){
   employee=this.encapsulateEmployee(rs);
   list.add(employee);
  }
  return list;
 }

}

 

 

 我是java新手，希望在以后的学习中请大家多多赐教，我的QQ:1345383602;MSN:peiqianliu@msn.cn