00bc434fc3a4001d160cac80d06a1e0b

来自「实习的时候做的数字校园系统」· 代码 · 共 57 行

package com.xxgl.business;

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.xxgl.bean.TeacherBean;
import com.xxgl.data.DBUtil;
import com.xxgl.data.DBconnection;

public class TeacherBO {
	
	public List selectAlltea() {
		String sql = "select t_id,t_name,sex,age,zzmm,phone,prtime,firetime,memory from teacher ";

		Connection con = DBconnection.getConnection();
		PreparedStatement pstmt = null;
		List list = new ArrayList();
		
		try {
			pstmt = con.prepareStatement(sql);

			ResultSet rs = pstmt.executeQuery();
			while (rs.next()) {
				TeacherBean pdBean = new TeacherBean();
				
				 pdBean.setS_id(rs.getInt("s_id"));
				 pdBean.setS_name(rs.getString("s_name"));
				 pdBean.setSex(rs.getInt("sex"));
				 pdBean.setAge(rs.getInt("age"));
				 pdBean.setZzmm(rs.getString("Zzmm"));
				 pdBean.setJg(rs.getString("jg"));
				 pdBean.setAdress(rs.getString("adress"));
				 pdBean.setPhone(rs.getString("phone"));
				 pdBean.setMemory(rs.getString("memory"));
				 pdBean.setYesorno(rs.getInt("yesorno"));
				 pdBean.setGrade(rs.getString("grade"));
				 pdBean.setClass1(rs.getString("class1"));
				 pdBean.setJob(rs.getString("job"));
				 list.add(pdBean);
			}
			DBUtil.close(rs);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(pstmt);
			DBUtil.close(con);
		}

		return list;
	}

}