empbo.java

来自「这是JAVA报表系统,如需要的请下载...QQ:398260301」· Java 代码 · 共 37 行

package com.JFreeChat.Bo;
import java.sql.*;
import java.util.*;

import com.JFreeChat.DB.DBTools;
import com.JFreeChat.bean.EmpBean;
public class EmpBo {
	public static List getAllEmployee()
	{
		List lst = new ArrayList();
		String sql = "select * from employee";
		Connection con = DBTools.getConnection();
		PreparedStatement ps = null;
		try {
			ps = con.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			while(rs.next())
			{
				EmpBean bean = new EmpBean();
				bean.setEmp_id(rs.getString(1));
				bean.setFname(rs.getString(2));
				bean.setMinit(rs.getString(3));
				bean.setLname(rs.getString(4));
				bean.setJob_id(rs.getInt(5));
				bean.setJob_lvl(rs.getInt(6));
				bean.setPub_id(rs.getString(7));
				bean.setHire_date(rs.getDate(8));
				lst.add(bean);
				
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return lst;
	}
}