封装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