jdbc自写sql语句

来源：互联网发布：java se可以开发web吗编辑：程序博客网时间：2024/05/20 14:40
//新增语句public int createXX(final  XInput xinput){  KeyHolder keyHolder = new GeneratedKeyHolder();///返回新增记录时的自增长主键值  final String sql = "INSERT INTO XX(A,B,C,D,E,F,G)"       + " VALUES(?,?,?,?,?,?,GETDATE())";  super.getJdbcTemplate().update(new PreparedStatementCreator() {      public PreparedStatement createPreparedStatement(Connection connection)     throws SQLException {    PreparedStatement ps = connection.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);    ps.setString(1, xinput.getA());    ps.setString(2, xinput.getB());    ps.setString(3, xinput.getC());    ps.setString(4, xinput.getD());    ps.setString(5, xinput.getE());    ps.setString(6, xinput.getF());    return ps;   }  },keyHolder) ;  return keyHolder.getKey().intValue(); }//修改public int updateXXDao(int a,int b,int c,int d,int e){  String sql = "UPDATE Eval_SubmitInfo SET A=?,B=?,C=?,D=?,E=?,UpdateTime=GETDATE() WHERE Id=?";  Object[] params = {a,b,c,d,e};  int rows = super.getJdbcTemplate().update(sql,params);  return rows; } //查询语句public List<Map<String,Object>> listXXDao(int a,String b,String tableName){  List<Map<String,Object>> list = new ArrayList<Map<String,Object>>();  String sql = "SELECT * FROM "+tableName;  List<Object> params = new ArrayList<Object>();  String wherePart = "";    if(a!=-1){   wherePart += " AND A=?";   params.add(a);  }  if(b!=""){   wherePart += " AND B=?";   params.add(b);  }    if(wherePart.length()>0){   sql += " WHERE " + wherePart.substring(4);  }  list = super.getJdbcTemplate().queryForList(sql,params.toArray());  return list; }
0 0