基于jsp+servlet、使用原生ajax，实现单表增删改查、文件上传、条件查询和分页

package cn.bdqn.jsp.dao.impl; import java.util.ArrayList; import java.util.List; import cn.bdqn.jsp.dao.BaseDao; import cn.bdqn.jsp.dao.StandardDao; import cn.bdqn.jsp.entity.Standard; import cn.bdqn.jsp.util.SQLHandler; public class StandardDaoImpl extends BaseDao implements StandardDao { @Override public int save(Standard standard) { try { if(super.openDatabase()) { String sql="insert into standard(id,stdnum,zhname,version,keys,releasedate,impldate,packagepath) "+ "values(std_id.nextval,?,?,?,?,?,?,?)"; java.sql.Date releaseDate=null; if(null!=standard.getReleaseDate()) { releaseDate=new java.sql.Date(standard.getReleaseDate().getTime()); } java.sql.Date implDate=null; if(null!=standard.getImplDate()) { implDate=new java.sql.Date(standard.getImplDate().getTime()); } Object[] params= {standard.getStdNum(),standard.getZhName(),standard.getVersion(),standard.getKeys(),releaseDate,implDate,standard.getPackagePath()}; return super.executeUpdate(sql, params); }else { return -1; } } catch (Exception e) { e.printStackTrace(); return -1; } finally { closeResource(); } } @Override public int update(Standard standard) { try { if(super.openDatabase()) { String sql="update standard set stdnum=?,zhname=?,version=?,keys=?,releasedate=?,impldate=?,packagepath=? where id=?"; java.sql.Date releaseDate=null; if(null!=standard.getReleaseDate()) { releaseDate=new java.sql.Date(standard.getReleaseDate().getTime()); } java.sql.Date implDate=null; if(null!=standard.getImplDate()) { implDate=new java.sql.Date(standard.getImplDate().getTime()); } Object[] params= {standard.getStdNum(),standard.getZhName(),standard.getVersion(),standard.getKeys(),releaseDate,implDate,standard.getPackagePath(),standard.getId()}; return super.executeUpdate(sql, params); }else { return -1; } } catch (Exception e) { e.printStackTrace(); return -1; } finally { closeResource(); } } @Override public int delete(int id) { try { if(super.openDatabase()) { String sql="delete from standard where id=?"; Object[] params= {id}; return super.executeUpdate(sql, params); }else { return -1; } } catch (Exception e) { e.printStackTrace(); return -1; } finally { closeResource(); } } @Override public Standard getById(int id) { try { if(super.openDatabase()) { String sql="select id,stdnum,zhname,version,keys,releasedate,impldate,packagepath from standard where id=?"; Object[] params= {id}; super.rs=super.executeQuery(sql, params); if (rs.next()) { Standard standard=new Standard(); standard.setId(rs.getInt("id")); standard.setStdNum(rs.getString("stdnum")); standard.setZhName(rs.getString("zhname")); standard.setVersion(rs.getString("version")); standard.setKeys(rs.getString("keys")); standard.setReleaseDate(rs.getTimestamp("releasedate")); standard.setImplDate(rs.getTimestamp("impldate")); standard.setPackagePath(rs.getString("packagepath")); return standard; }else { return null; } }else { return null; } } catch (Exception e) { e.printStackTrace(); return null; } finally { closeResource(); } } @Override public List<Standard> getList(String queryCondition, int pageIndex, int pageSize) { try { if(super.openDatabase()) { SQLHandler handler=new SQLHandler(); List<Standard> standards=new ArrayList<Standard>(); StringBuilder sql=new StringBuilder("select id,stdnum,zhname,version,keys,releasedate,impldate,packagepath from standard where 1=1"); if(null!=queryCondition && !"".equals(queryCondition)){ sql.append(" and (stdnum like ? or zhname like ?)"); } sql.append(" order by id"); if(null!=queryCondition && !"".equals(queryCondition)){ Object[] params={"%"+queryCondition+"%","%"+queryCondition+"%"}; String newSql=handler.getOraclePageSQL(sql.toString(), pageIndex, pageSize); rs=executeQuery(newSql, params); }else{ Object[] params={}; String newSql=handler.getOraclePageSQL(sql.toString(), pageIndex, pageSize); rs=executeQuery(newSql, params); } while(rs.next()) { Standard standard=new Standard(); standard.setId(rs.getInt("id")); standard.setStdNum(rs.getString("stdnum")); standard.setZhName(rs.getString("zhname")); standard.setVersion(rs.getString("version")); standard.setKeys(rs.getString("keys")); standard.setReleaseDate(rs.getTimestamp("releasedate")); standard.setImplDate(rs.getTimestamp("impldate")); standard.setPackagePath(rs.getString("packagepath")); standards.add(standard); } return standards; }else { return null; } } catch (Exception e) { e.printStackTrace(); return null; } finally { closeResource(); } } @Override public int getCount(String queryCondition) { try { if(openDatabase()) { int result=0; StringBuilder sql=new StringBuilder("select count(id) as cnt from standard where 1=1"); if(null!=queryCondition && !"".equals(queryCondition)){ sql.append(" and (stdnum like ? or zhname like ?)"); } if(null!=queryCondition && !"".equals(queryCondition)){ Object[] params={"%"+queryCondition+"%","%"+queryCondition+"%"}; rs=executeQuery(sql.toString(), params); }else{ Object[] params={}; rs=executeQuery(sql.toString(), params); } if(rs.next()) { result=rs.getInt("cnt"); } return result; }else { return 0; } } catch (Exception e) { e.printStackTrace(); return 0; } finally { closeResource(); } } @Override public Standard getByStdNum(String stdNum) { try { if(super.openDatabase()) { String sql="select id,stdnum,zhname,version,keys,releasedate,impldate,packagepath from standard where stdnum=?"; Object[] params= {stdNum}; super.rs=super.executeQuery(sql, params); if (rs.next()) { Standard standard=new Standard(); standard.setId(rs.getInt("id")); standard.setStdNum(rs.getString("stdnum")); standard.setZhName(rs.getString("zhname")); standard.setVersion(rs.getString("version")); standard.setKeys(rs.getString("keys")); standard.setReleaseDate(rs.getTimestamp("releasedate")); standard.setImplDate(rs.getTimestamp("impldate")); standard.setPackagePath(rs.getString("packagepath")); return standard; }else { return null; } }else { return null; } } catch (Exception e) { e.printStackTrace(); return null; } finally { closeResource(); } } }