b0b9d11264a5001d1e0f98aee8c5c7cb

实习的时候做的数字校园系统

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.ParameterBean;
import com.xxgl.bean.StudentBean;
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.setT_id(rs.getInt("t_id"));
				 pdBean.setT_name(rs.getString("t_name"));
				 pdBean.setSex(rs.getInt("sex"));
				 pdBean.setAge(rs.getInt("age"));
				 pdBean.setZzmm(rs.getString("Zzmm"));
				 pdBean.setPhone(rs.getString("phone"));
				 pdBean.setMemory(rs.getString("memory"));
				 pdBean.setPrtime(rs.getDate("prtime"));
				 pdBean.setFiretime(rs.getDate("firetime"));
				 list.add(pdBean);
			}
			DBUtil.close(rs);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(pstmt);
			DBUtil.close(con);
		}

		return list;
	}


	public TeacherBean selecttea(int xh) {
		String sql = "select t_id,t_name,sex,age,zzmm,phone,prtime,firetime,memory from teacher where t_id=? ";

		Connection con = DBconnection.getConnection();
		PreparedStatement pstmt = null;
		TeacherBean teaBean=null;
		try {
			pstmt = con.prepareStatement(sql);

			pstmt.setInt(1, xh);

			ResultSet rs = pstmt.executeQuery();

			if (rs.next()) {
				teaBean = new TeacherBean();

				teaBean.setT_id(rs.getInt("t_id"));
				teaBean.setT_name(rs.getString("t_name"));
				teaBean.setSex(rs.getInt("sex"));
				teaBean.setAge(rs.getInt("age"));
				teaBean.setZzmm(rs.getString("Zzmm"));
				teaBean.setPhone(rs.getString("phone"));
				teaBean.setMemory(rs.getString("memory"));
				teaBean.setPrtime(rs.getDate("prtime"));
				teaBean.setFiretime(rs.getDate("firetime"));
							
		}
			
			DBUtil.close(rs);
			

		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(pstmt);
			DBUtil.close(con);
		}

		return  teaBean;
	}

	
	public int updatetea(TeacherBean parameter) {
		String sql = "update teacher  set t_id=?,t_name=?,sex=?,age=?,zzmm=?,phone=?,memory=?,prtime=?,firetime=? where t_id=? ";

		Connection con = DBconnection.getConnection();
		PreparedStatement pstmt = null;
		int count = 0;
		try {
			pstmt = con.prepareStatement(sql);

			pstmt.setInt(1, parameter.getT_id());
			pstmt.setString(2, parameter.getT_name());
			pstmt.setInt(3, parameter.getSex());
			pstmt.setInt(4, parameter.getAge());
			pstmt.setString(5, parameter.getZzmm());
			pstmt.setString(6, parameter.getPhone());
			pstmt.setString(7, parameter.getMemory());
			pstmt.setDate(8, parameter.getPrtime());
			pstmt.setDate(9, parameter.getFiretime());
			pstmt.setInt(10, parameter.getT_id());

			count = pstmt.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(pstmt);
			DBUtil.close(con);
		}

		return count;
	}

	public int deleteByID(int id) {
		String sql = "delete from teacher  where s_id=? ";

		Connection con = DBconnection.getConnection();
		PreparedStatement pstmt = null;

		int count = 0;
		try {
			pstmt = con.prepareStatement(sql);

			pstmt.setInt(1, id);

			count = pstmt.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(pstmt);
			DBUtil.close(con);
		}

		return count;
	}	
	
	public int insertteacher(TeacherBean parameter) {
		String sql = "insert into teacher (t_id,t_name,sex,age,zzmm,phone,memory,prtime,firetime) values (?,?,?,?,?,?,?,?,?)";

		Connection con = DBconnection.getConnection();
		PreparedStatement pstmt = null;

		int count = 0;
		try {
			pstmt = con.prepareStatement(sql);

			pstmt.setInt(1, parameter.getT_id());
			pstmt.setString(2, parameter.getT_name());
			pstmt.setInt(3, parameter.getSex());
			pstmt.setInt(4, parameter.getAge());
			pstmt.setString(5, parameter.getZzmm());
			pstmt.setString(6, parameter.getPhone());
			pstmt.setString(7, parameter.getMemory());
			pstmt.setDate(8, parameter.getPrtime());
			pstmt.setDate(9, parameter.getFiretime());

			count = pstmt.executeUpdate();

			DBUtil.close(pstmt);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(con);
		}
		return count;
	}

}