基于JSP+Servlet+Dao实现的贫困认定管理系统.zip

package com.wzxy.povertyidentification.dao.impl; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import com.wzxy.povertyidentification.bean.Pkrdsqb; import com.wzxy.povertyidentification.dao.IPkrdsqbDao; import com.wzxy.povertyidentification.database.DbUtils; public class PkrdsqbDaoImpl implements IPkrdsqbDao { private DbUtils dbUtils; public PkrdsqbDaoImpl() { this.dbUtils = new DbUtils(); } public int addPkrdsqb(Pkrdsqb sqb) { //添加数据(学生) int result = 0; try { //实例化DbUtils连接数据库 Connection conn = dbUtils.getConn();//获得数据库连接 Statement stmt = conn.createStatement();//连接类创建statement创建SQL语句 //构造SQL语句 StringBuffer sqlBuffer = new StringBuffer(); sqlBuffer.append("INSERT INTO pkrdsqbxx(fullstuNo,stuName,sex,birth,idNo,money,xueyuan,className,phoneNum,reason,zhuangtai,tongguo,fandui,qingkuang,juti)"); sqlBuffer.append("VALUES('" + sqb.getFullstuNo() + "'," + "'" + sqb.getStuName() + "','" + sqb.getSex() + "','" + sqb.getBirth() + "'," + "'" + sqb.getIdNo() + "','" + sqb.getMoney() + "','" + sqb.getXueyuan() + "','" + sqb.getClassName() + "'" + ",'" + sqb.getPhoneNum() + "','" + sqb.getReason() + "','" + sqb.getZhuangtai() + "','" + sqb.getTongguo() + "','" + sqb.getFandui() + "','" + sqb.getQingkuang() + "','" + sqb.getJuti() + "')"); String sql = sqlBuffer.toString(); int c = stmt.executeUpdate(sql); result = c; } catch (Exception e) { System.out.print("添加申请表失败:" + e.getMessage()); e.printStackTrace(); } return result; } public List<Pkrdsqb> allsqb() { //查看所有数据，条件：无条件(管理员) List<Pkrdsqb> result = new ArrayList<Pkrdsqb>(); try { Connection conn = dbUtils.getConn();//获得数据库连接 Statement stmt = conn.createStatement(); StringBuffer sqlBuffer = new StringBuffer(); sqlBuffer.append("SELECT * FROM pkrdsqbxx ORDER BY fullstuNo"); String sql = sqlBuffer.toString(); ResultSet rs = stmt.executeQuery(sql); while (rs != null && rs.next()) { Pkrdsqb sqb = new Pkrdsqb(); sqb.setFullstuNo(rs.getString("fullstuNo")); sqb.setStuName(rs.getString("stuName")); sqb.setSex(rs.getString("sex")); sqb.setBirth(rs.getString("birth")); sqb.setIdNo(rs.getString("idNo")); sqb.setMoney(rs.getString("money")); sqb.setXueyuan(rs.getString("xueyuan")); sqb.setClassName(rs.getString("className")); sqb.setPhoneNum(rs.getString("phoneNum")); sqb.setReason(rs.getString("reason")); sqb.setZhuangtai(rs.getString("zhuangtai")); result.add(sqb); } } catch (Exception e) { System.out.print("查看申请表出错:" + e.getMessage()); e.printStackTrace(); } return result; } public List<Pkrdsqb> findByFullstuNo(String FullstuNo) { //查询所有字段数据，条件：学号 List<Pkrdsqb> result = new ArrayList<Pkrdsqb>(); try { Connection conn = dbUtils.getConn();//获得数据库连接 Statement stmt = conn.createStatement(); StringBuffer sqlBuffer = new StringBuffer(); sqlBuffer.append("SELECT * FROM pkrdsqbxx WHERE fullstuNo='" + FullstuNo + "'"); String sql = sqlBuffer.toString(); ResultSet rs = stmt.executeQuery(sql); while (rs != null && rs.next()) { Pkrdsqb sqb = new Pkrdsqb(); sqb.setFullstuNo(rs.getString("fullstuNo")); sqb.setStuName(rs.getString("stuName")); sqb.setSex(rs.getString("sex")); sqb.setBirth(rs.getString("birth")); sqb.setIdNo(rs.getString("idNo")); sqb.setMoney(rs.getString("money")); sqb.setXueyuan(rs.getString("xueyuan")); sqb.setClassName(rs.getString("className")); sqb.setPhoneNum(rs.getString("phoneNum")); sqb.setReason(rs.getString("reason")); sqb.setZhuangtai(rs.getString("zhuangtai")); sqb.setTongguo(rs.getInt("tongguo")); sqb.setFandui(rs.getInt("fandui")); sqb.setQingkuang(rs.getString("qingkuang")); sqb.setJuti(rs.getString("juti")); result.add(sqb); } } catch (Exception e) { System.out.print("查看申请表出错:" + e.getMessage()); e.printStackTrace(); } return result; } public List<Pkrdsqb> findbyClassName(String ClassName) { //查询所有字段数据，条件：班级 查询以下字段组员查(组长和组员所查的字段不同) List<Pkrdsqb> result = new ArrayList<Pkrdsqb>(); try { Connection conn = dbUtils.getConn();//获得数据库连接 Statement stmt = conn.createStatement(); StringBuffer sqlBuffer = new StringBuffer(); sqlBuffer.append("SELECT * FROM pkrdsqbxx WHERE className='" + ClassName + "'"); //pkrdsqbxx中可能是16xxxxx班， 管理员导入的xsxx中肯定是标准的专业名称 String sql = sqlBuffer.toString(); ResultSet rs = stmt.executeQuery(sql); while (rs != null && rs.next()) { Pkrdsqb sqb = new Pkrdsqb(); sqb.setFullstuNo(rs.getString("fullstuNo")); sqb.setStuName(rs.getString("stuName")); sqb.setSex(rs.getString("sex")); sqb.setBirth(rs.getString("birth")); sqb.setIdNo(rs.getString("idNo")); sqb.setMoney(rs.getString("money")); sqb.setXueyuan(rs.getString("xueyuan")); sqb.setClassName(rs.getString("className")); sqb.setPhoneNum(rs.getString("phoneNum")); sqb.setReason(rs.getString("reason")); sqb.setZhuangtai(rs.getString("zhuangtai")); sqb.setTongguo(rs.getInt("tongguo")); sqb.setFandui(rs.getInt("fandui")); sqb.setQingkuang(rs.getString("qingkuang")); sqb.setJuti(rs.getString("juti")); result.add(sqb); } } catch (Exception e) { System.out.print("查看班级申请表出错:" + e.getMessage()); e.printStackTrace(); } return result; } public List<Pkrdsqb> fdychakan(String ClassName) { //辅导员查看已通过小组审核的同学 List<Pkrdsqb> result = new ArrayList<Pkrdsqb>(); try { Connection conn = dbUtils.getConn();//获得数据库连接 Statement stmt = conn.createStatement(); StringBuffer sqlBuffer = new StringBuffer(); sqlBuffer.append("SELECT * FROM pkrdsqbxx WHERE className='" + ClassName + "' AND zhuangtai='班级小组通过并已提交，辅导员审核中'"); //pkrdsqbxx中可能是16xxxxx班， 管理员导入的xsxx中肯定是标准的专业名称 String sql = sqlBuffer.toString(); ResultSet rs = stmt.executeQuery(sql); while (rs != null && rs.next()) { Pkrdsqb sqb = new Pkrdsqb(); sqb.setFullstuNo(rs.getString("fullstuNo")); sqb.setStuName(rs.getString("stuName")); sqb.setXueyuan(rs.getString("xueyuan")); sqb.setClassName(rs.getString("className")); sqb.setZhuangtai(rs.getString("zhuangtai")); result.add(sqb); } } catch (Exception e) { System.out.print("查看班级申请表出错:" + e.getMessage()); e.printStackT