1036f196181d0017156d965e1b313a92

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

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.ExamBean;
import com.xxgl.bean.KaocangBean;
import com.xxgl.data.DBConnection;
import com.xxgl.data.DBUtil;

public class ksBO {

	
	public int insertByParameter(ExamBean parameter) {
		String sql = "insert into exam (ex_id,e_km,bj,rs,e_data,e_type,xq) values (?,?,?,?,?,?,?)";

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

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

			pstmt.setString(1, parameter.getEx_id());
			pstmt.setString(2, parameter.getE_km());
			pstmt.setString(3, parameter.getBj());
			pstmt.setInt(4,parameter.getRs());
			pstmt.setDate(5,parameter.getE_date());
			pstmt.setString(6,parameter.getE_type());
			pstmt.setString(7,parameter.getXq());

			count = pstmt.executeUpdate();

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



	
	public int insertkaocang(KaocangBean parameter) {
		String sql = "insert into kaocang (cr_NO,ex_id,jk_teacher,test_time,memory) values (?,?,?,?,?)";

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

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

			pstmt.setString(1, parameter.getCr_NO());
			pstmt.setString(2, parameter.getEx_id());
			pstmt.setString(3, parameter.getJk_teacher());
			pstmt.setDate(4,parameter.getTesttime());
			pstmt.setString(5,parameter.getMemory());
			

			count = pstmt.executeUpdate();

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


public ExamBean selectParameter(String ks) {
	String sql = "select ex_id,e_km,bj,rs,e_data,e_type,xq from exam where ex_id=?";

	Connection con = DBConnection.getConnection();
	PreparedStatement pstmt = null;
	//List list = new ArrayList();
	ExamBean pdBean = null;
	try {
		pstmt = con.prepareStatement(sql);		
		pstmt.setString(1, ks);
		ResultSet rs = pstmt.executeQuery();
		while(rs.next()) {
			 pdBean = new ExamBean();

			pdBean.setEx_id(rs.getString("ex_id"));
			pdBean.setE_km(rs.getString("e_km"));
			pdBean.setBj(rs.getString("bj"));
			pdBean.setRs(rs.getInt("rs"));
			pdBean.setE_date(rs.getDate("e_data"));
			pdBean.setE_type(rs.getString("e_type"));
			pdBean.setXq(rs.getString("xq"));
			
			//list.add(pdBean);
		}
		DBUtil.close(rs);
	} catch (SQLException e) {
		e.printStackTrace();
	} finally {
		DBUtil.close(pstmt);
		DBUtil.close(con);
	}

	return pdBean;
	
}




public KaocangBean selectkcParameter(String ex_id,String cr_NO) {
	String sql = "select cr_NO,ex_id,jk_teacher,test_time,memory from kaocang where ex_id=? and cr_NO=?";

	Connection con = DBConnection.getConnection();
	PreparedStatement pstmt = null;
	//List list = new ArrayList();
	KaocangBean kaocang = null;
	try {
		pstmt = con.prepareStatement(sql);		
		pstmt.setString(1, ex_id);
		pstmt.setString(2, cr_NO);
		ResultSet rs = pstmt.executeQuery();
		while(rs.next()) {
			 kaocang = new KaocangBean();

			kaocang.setCr_NO(rs.getString("cr_NO"));
			kaocang.setEx_id(rs.getString("ex_id"));
			kaocang.setJk_teacher(rs.getString("jk_teacher"));
			kaocang.setTesttime(rs.getDate("test_time"));
			kaocang.setMemory(rs.getString("memory"));
			
			
			//list.add(pdBean);
		}
		DBUtil.close(rs);
	} catch (SQLException e) {
		e.printStackTrace();
	} finally {
		DBUtil.close(pstmt);
		DBUtil.close(con);
	}

	return kaocang;
	
}




public List selectchaxun(String ks) {
	String sql = "select ex_id,e_km,bj,rs,e_data,e_type,xq from exam where ex_id=?";

	Connection con = DBConnection.getConnection();
	PreparedStatement pstmt = null;
	List list = new ArrayList();
	ExamBean pdBean = null;
	try {
		pstmt = con.prepareStatement(sql);		
		pstmt.setString(1, ks);
		ResultSet rs = pstmt.executeQuery();
		while(rs.next()) {
			 pdBean = new ExamBean();

			pdBean.setEx_id(rs.getString("ex_id"));
			pdBean.setE_km(rs.getString("e_km"));
			pdBean.setBj(rs.getString("bj"));
			pdBean.setRs(rs.getInt("rs"));
			pdBean.setE_date(rs.getDate("e_data"));
			pdBean.setE_type(rs.getString("e_type"));
			pdBean.setXq(rs.getString("xq"));
			
			list.add(pdBean);
		}
		DBUtil.close(rs);
	} catch (SQLException e) {
		e.printStackTrace();
	} finally {
		DBUtil.close(pstmt);
		DBUtil.close(con);
	}

	return list;
	
}





public List selectkcby(String kc) {
	String sql = "select cr_NO,ex_id,jk_teacher,test_time,memory from kaocang where ex_id=?";

	Connection con = DBConnection.getConnection();
	PreparedStatement pstmt = null;
	List list = new ArrayList();
	KaocangBean kaocang = null;
	try {
		pstmt = con.prepareStatement(sql);		
		pstmt.setString(1, kc);
		ResultSet rs = pstmt.executeQuery();
		while(rs.next()) {
			 kaocang = new KaocangBean();

			kaocang.setCr_NO(rs.getString("cr_NO"));
			kaocang.setEx_id(rs.getString("ex_id"));
			kaocang.setJk_teacher(rs.getString("jk_teacher"));
			kaocang.setTesttime(rs.getDate("test_time"));
			kaocang.setMemory(rs.getString("memory"));
			
			list.add(kaocang);
		}
		DBUtil.close(rs);
	} catch (SQLException e) {
		e.printStackTrace();
	} finally {
		DBUtil.close(pstmt);
		DBUtil.close(con);
	}

	return list;
	
}



public List selectAllParameter() {
	String sql = "select ex_id,e_km,bj,rs,e_data,e_type,xq from exam  ";

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

		ResultSet rs = pstmt.executeQuery();
		while (rs.next()) {
			ExamBean pdBean = new ExamBean();

			pdBean.setEx_id(rs.getString("ex_id"));
			pdBean.setE_km(rs.getString("e_km"));
			pdBean.setBj(rs.getString("bj"));
			pdBean.setRs(rs.getInt("rs"));
			pdBean.setE_date(rs.getDate("e_data"));
			pdBean.setE_type(rs.getString("e_type"));
			pdBean.setXq(rs.getString("xq"));
			
			list.add(pdBean);
		}
		DBUtil.close(rs);
	} catch (SQLException e) {
		e.printStackTrace();
	} finally {
		DBUtil.close(pstmt);
		DBUtil.close(con);
	}

	return list;
}





public List selectAllkaochang() {
	String sql = "select cr_NO,ex_id,jk_teacher,test_time,memory from kaocang  ";

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

		ResultSet rs = pstmt.executeQuery();
		while (rs.next()) {
			KaocangBean kaocang = new KaocangBean();

			kaocang.setCr_NO(rs.getString("cr_NO"));
			kaocang.setEx_id(rs.getString("ex_id"));
			kaocang.setJk_teacher(rs.getString("jk_teacher"));
			kaocang.setTesttime(rs.getDate("test_time"));
			kaocang.setMemory(rs.getString("memory"));
			
			
			list.add(kaocang);
		}
		DBUtil.close(rs);
	} catch (SQLException e) {
		e.printStackTrace();
	} finally {
		DBUtil.close(pstmt);
		DBUtil.close(con);
	}

	return list;
}



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

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

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

		pstmt.setString(1, id);

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

	return count;
}




/*public int deletekcxinxi(String id,String js) {
	String sql = "delete from kaocang where ex_id=? and cr_NO=?";

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

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

		pstmt.setString(1, id);

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

	return count;
}
*/



public int updateParameter(ExamBean exam) {
	String sql = "update exam set e_km=?,bj=?,rs=?,e_data=?,e_type=?,xq=? where ex_id=? ";

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

		
		pstmt.setString(1, exam.getE_km());
		pstmt.setString(2, exam.getBj());
		pstmt.setInt(3, exam.getRs());
		pstmt.setDate(4, exam.getE_date());
		pstmt.setString(5, exam.getE_type() );
		pstmt.setString(6, exam.getXq());
		pstmt.setString(7, exam.getEx_id());

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

	return count;
}







public int updatekcxinxi(KaocangBean kaocang) {
	String sql = "update kaocang set jk_teacher=?,test_time=?,memory=? where ex_id=? and cr_NO=?";

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

		
		pstmt.setString(5, kaocang.getCr_NO());
		pstmt.setString(1, kaocang.getJk_teacher());
		pstmt.setDate(2, kaocang.getTesttime());
		pstmt.setString(3, kaocang.getMemory());
		pstmt.setString(4, kaocang.getEx_id());

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

	return count;
}}