servlet完整的增删改查和验证码登录

package com.wxy.dao.impl; import java.sql.ResultSet; import java.util.ArrayList; import java.util.Date; import java.util.List; import com.wxy.dao.BaseDao; import com.wxy.dao.ProviderDao; import com.wxy.pojo.Provider; import com.wxy.pojo.User; public class ProviderDaoImpl extends BaseDao implements ProviderDao{ @Override public List<Provider> findAllProvider(int pageSize, int pyl, String proDesc, String startTime, String endTime) { List<Provider> listpro = new ArrayList<Provider>(); try { if(getConnection()) { //sql拼接 String sql = "select * from smbms_provider where 1=1"; if(proDesc != null) { sql += " AND proDesc like '%"+proDesc+"%'"; } if(startTime != null && startTime != "") { sql += " AND creationDate >='"+startTime+"'"; } if(endTime != null && endTime != "") { sql += " AND creationDate <='"+endTime+"'"; } sql += " order by id limit ?,?"; ResultSet rs = executeSQL(sql, new Object[] {pyl,pageSize}); while(rs.next()) { Provider pro = new Provider(); pro.setId(rs.getInt("id")); pro.setProCode(rs.getString("proCode")); pro.setProName(rs.getString("proName")); pro.setProDesc(rs.getString("proDesc")); pro.setProContact(rs.getString("proContact")); pro.setProPhone(rs.getString("proPhone")); pro.setProAddress(rs.getString("proAddress")); pro.setProFax(rs.getString("proFax")); pro.setCreatedBy(rs.getInt("createdBy")); pro.setCreationDate(rs.getString("creationDate")); pro.setModifyDate(rs.getString("modifyDate")); pro.setModifyBy(rs.getInt("modifyBy")); listpro.add(pro); } } }catch (Exception e) { e.printStackTrace(); } return listpro; } //获得总记录数 @Override public int findStudentCount(String proDesc, String startTime, String endTime) { int totalCount = 0; try { if(getConnection()) { String sql = "select count(1) as totalCount from smbms_provider WHERE 1=1 "; if(proDesc!=null) { sql += " AND proDesc like '%"+proDesc+"%'"; } if(startTime!=null && startTime!="") { sql += " AND creationDate >='"+startTime+"'"; } if(endTime!=null && endTime!="") { sql += " AND creationDate <='"+endTime+"'"; } ResultSet rs = executeSQL(sql,null); while(rs.next()) { totalCount = rs.getInt("totalCount"); } } }catch (Exception e) { e.printStackTrace(); } return totalCount; } //修改Provider的信息 @Override public int updatePro(Provider provider) { try { if(getConnection()) { String sql = "update smbms_provider set proCode=?,proName=?,proDesc=?,proContact=?,proPhone=?,proAddress=?,proFax=?,modifyDate=?,modifyBy=? where id=? "; int id = provider.getId(); String proCode = provider.getProCode(); String proName = provider.getProName(); String proDesc = provider.getProDesc(); String proContact = provider.getProContact(); String proPhone = provider.getProPhone(); String proAddress = provider.getProAddress(); String proFax = provider.getProFax(); String modifyDate = provider.getModifyDate(); int modifyBy = provider.getModifyBy(); int i = executUpdate(sql, new Object[] {proCode,proName,proDesc,proContact,proPhone,proAddress,proFax,modifyDate,modifyBy,id}); System.out.println("修改"+i+"条数据成功"); } }catch (Exception e) { e.printStackTrace(); } return 0; } //根据id获取信息 @Override public Provider getProById(int id) { try { if(getConnection()) { String sql = "select * from smbms_provider where id=? "; rs = executeSQL(sql, new Object[] {id}); Provider pro = new Provider(); while(rs.next()) { pro.setId(rs.getInt("id")); pro.setProCode(rs.getString("proCode")); pro.setProName(rs.getString("proName")); pro.setProDesc(rs.getString("proDesc")); pro.setProContact(rs.getString("proContact")); pro.setProPhone(rs.getString("proPhone")); pro.setProAddress(rs.getString("proAddress")); pro.setProFax(rs.getString("proFax")); pro.setCreatedBy(rs.getInt("createdBy")); pro.setCreationDate(rs.getString("creationDate")); pro.setModifyDate(rs.getString("modifyDate")); pro.setModifyBy(rs.getInt("modifyBy")); } return pro; } }catch (Exception e) { e.printStackTrace(); } return null; } //删除： @Override public int deletePro(int id) { try { if(getConnection()) { String sql = "delete from smbms_provider where id=? "; return executUpdate(sql, new Object[] {id}); } }catch (Exception e) { e.printStackTrace(); } return 0; } //添加： @Override public int addPro(Provider provider) { try { if(getConnection()) { String sql = "insert into smbms_provider(proCode,proName,proDesc,proContact,proPhone,proAddress,proFax,creationDate,createdBy) value(?,?,?,?,?,?,?,?,?) "; String proCode = provider.getProCode(); String proName = provider.getProName(); String proDesc = provider.getProDesc(); String proContact = provider.getProContact(); String proPhone = provider.getProPhone(); String proAddress = provider.getProAddress(); String proFax = provider.getProFax(); String creationDate = provider.getCreationDate(); Integer createdBy = provider.getCreatedBy(); int i = executUpdate(sql, new Object[] {proCode,proName,proDesc,proContact,proPhone,proAddress,proFax,creationDate,createdBy}); System.out.println("添加"+i+"条数据成功"); } }catch (Exception e) { e.printStackTrace(); } return 0; } }