jdbc自写sql语句

最新推荐文章于 2023-03-22 00:18:46 发布

fangqun663775

最新推荐文章于 2023-03-22 00:18:46 发布

阅读量1.1k

点赞数

分类专栏：数据库文章标签： jdbc sql select object string

本文链接：https://blog.csdn.net/fangqun663775/article/details/38558091

版权

数据库专栏收录该内容

42 篇文章 0 订阅

订阅专栏

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