//新增语句
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;
}