java web招生考试报名系统（原生servlet开发）

package cn.idestiny.dao.impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.HashMap; import cn.idestiny.dao.ReginfoDao; import cn.idestiny.db.ConnectionFactory; import cn.idestiny.entity.Major; import cn.idestiny.entity.Reginfo; public class ReginfoDaoImpl implements ReginfoDao { /* * private Connection con; private PreparedStatement pre; private String * sql; * * public ReginfoDaoImpl(){ con = ConnectionFactory.getConnection(); pre = * null; sql = null; } */ public Integer add(Reginfo reginfo) { Integer rows = 0; Connection con = ConnectionFactory.getConnection(); PreparedStatement pre = null; try { String sql = "insert into reginfo(sname,idcode,ssex,nation,political,homeaddr,source,school,gradutetime,isnew,aos,major,cet,mname,mobile,telphone,zipcode,conaddr,receiver,isconfirm,username) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; pre = con.prepareStatement(sql); pre.setString(21, reginfo.getUsername()); pre.setString(1, reginfo.getSname()); pre.setString(2, reginfo.getIdcode()); pre.setString(3, reginfo.getSsex()); pre.setString(4, reginfo.getNation()); pre.setString(5, reginfo.getPolitical()); pre.setString(6, reginfo.getHomeaddr()); pre.setString(7, reginfo.getSource()); pre.setString(8, reginfo.getSchool()); pre.setString(9, reginfo.getGradutetime()); pre.setString(10, reginfo.getIsnew()); pre.setString(11, reginfo.getAos()); pre.setString(12, reginfo.getMajor()); pre.setString(13, reginfo.getCet()); pre.setString(14, reginfo.getMname()); pre.setString(15, reginfo.getMobile()); pre.setString(16, reginfo.getTelphone()); pre.setString(17, reginfo.getZipcode()); pre.setString(18, reginfo.getConaddr()); pre.setString(19, reginfo.getReceiver()); pre.setInt(20, 0); rows = pre.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (pre != null) pre.close(); if (con != null) con.close(); } catch (SQLException e) { e.printStackTrace(); } } return rows; } @Override public Reginfo findByUser(String username) { Connection con = ConnectionFactory.getConnection(); PreparedStatement pre = null; ResultSet rs = null; Reginfo reg = new Reginfo(); String sql = "select id,username,sname,idcode,ssex,aos,cet,conaddr,gradutetime,homeaddr,isnew,major,mname,mobile,nation,political,receiver,school,source,telphone,zipcode,testcardnum,examroom,seatnum from reginfo where username=?"; try { pre = con.prepareStatement(sql); pre.setString(1, username); rs = pre.executeQuery(); if (rs.next()) { reg.setId(rs.getInt(1)); reg.setUsername(rs.getString(2)); reg.setSname(rs.getString(3)); reg.setIdcode(rs.getString(4)); reg.setSsex(rs.getString(5)); reg.setAos(rs.getString(6)); reg.setCet(rs.getString(7)); reg.setConaddr(rs.getString(8)); reg.setGradutetime(rs.getString(9)); reg.setHomeaddr(rs.getString(10)); reg.setIsnew(rs.getString(11)); reg.setMajor(rs.getString(12)); reg.setMname(rs.getString(13)); reg.setMobile(rs.getString(14)); reg.setNation(rs.getString(15)); reg.setPolitical(rs.getString(16)); reg.setReceiver(rs.getString(17)); reg.setSchool(rs.getString(18)); reg.setSource(rs.getString(19)); reg.setTelphone(rs.getString(20)); reg.setZipcode(rs.getString(21)); reg.setTestcardnum(rs.getString(22)); reg.setExamroom(rs.getString(23)); reg.setSeatnum(rs.getInt(24)); } return reg; } catch (SQLException e) { e.printStackTrace(); return null; }finally { try { if (rs !=null) rs.close(); if (pre != null) pre.close(); if (con != null) con.close(); } catch (SQLException e) { e.printStackTrace(); } } } @Override public Integer update(Reginfo reginfo) { Integer rows = 0; Connection con = ConnectionFactory.getConnection(); PreparedStatement pre = null; try { String sql = "update reginfo set sname=?,idcode=?,ssex=?,nation=?,political=?,homeaddr=?,source=?,school=?,gradutetime=?,isnew=?,aos=?,major=?,cet=?,mname=?,mobile=?,telphone=?,zipcode=?,conaddr=?,receiver=?,isconfirm=? where username=?"; pre = con.prepareStatement(sql); pre.setString(21, reginfo.getUsername()); pre.setString(1, reginfo.getSname()); pre.setString(2, reginfo.getIdcode()); pre.setString(3, reginfo.getSsex()); pre.setString(4, reginfo.getNation()); pre.setString(5, reginfo.getPolitical()); pre.setString(6, reginfo.getHomeaddr()); pre.setString(7, reginfo.getSource()); pre.setString(8, reginfo.getSchool()); pre.setString(9, reginfo.getGradutetime()); pre.setString(10, reginfo.getIsnew()); pre.setString(11, reginfo.getAos()); pre.setString(12, reginfo.getMajor()); pre.setString(13, reginfo.getCet()); pre.setString(14, reginfo.getMname()); pre.setString(15, reginfo.getMobile()); pre.setString(16, reginfo.getTelphone()); pre.setString(17, reginfo.getZipcode()); pre.setString(18, reginfo.getConaddr()); pre.setString(19, reginfo.getReceiver()); pre.setInt(20, 0); rows = pre.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (pre != null) pre.close(); if (con != null) con.close(); } catch (SQLException e) { e.printStackTrace(); } } return rows; } @Override public Integer update(String str, String username) { Integer rows = 0; Connection con = ConnectionFactory.getConnection(); PreparedStatement pre = null; try { String sql = "update reginfo set piclocation=? where username=?"; pre = con.prepareStatement(sql); pre.setString(2, username); pre.setString(1, str); rows = pre.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (pre != null) pre.close(); if (con != null) con.close(); } catch (SQLException e) { e.printStackTrace(); } } return rows; } public ArrayList<Reginfo> findAll() { ArrayList<Reginfo> array = new ArrayList<Reginfo>(); Connection con = ConnectionFactory.getConnection(); PreparedStatement pre = null; ResultSet rs = null; try { String sql = "select username,sname,idcode,ssex,aos,cet,conaddr,gradutetime,homeaddr,isnew,major,mname,mobile," + "nation,political,receiver,school,source,telphone,zipcode,isconfirm,testcardnum,examroom,seatnum from reginfo"; pre = con.prepareStatement(sql); rs = pre.executeQuery(); while (rs.next()) { Reginfo reg = new Reginfo(); reg.setUsername(rs.getString(1)); reg.setSname(rs.getString(2)); reg.setIdcode(rs.getString(3)); reg.setSsex(rs.getString(4)); reg.setAos(rs.getString(5)); reg.setCet(rs.getString(6)); reg.setConaddr(rs.getString(7)); reg.setGradutetime(rs.getString(8)); reg.setHomeaddr(rs.getString(9)); reg.setIsnew(rs.getString(10)); reg.setMajor(rs.getString(11)); reg.setMname(rs.getString(12)); reg.setMobile(rs.getString(13)); reg.setNation(rs.getString(14)); reg.setPolitical(rs.getString(15)); reg.setReceiver(rs.getString(16)); reg.setSchool(rs.getString(17)); reg.setSource(rs.getString(18)); reg.setTelphone(rs.getString(19)); reg.setZipcode(rs.getString(20)); reg.setIsconfirm(rs.getInt(21)); reg.setTestcardnum(rs.getString(22)); reg.setExamroom(rs.getString(23)); reg.setSeatnum(rs.getInt(24)); array.add(reg); } } catch (SQLException e) { e.printStackTrace(); } finally { try { if (rs !=null) rs.close(); if (pre != null) pre.close();