Question

JDBC传递参数的问题

能不能这样传，很久没用jdbc了，这样传貌似报错：
sql = "select * from GOODS where GOODSNAME like %?%";

super.OpenConn();

pstmt = super.conn.prepareStatement(sql);
pstmt.setString(1, goodsname);

rs = pstmt.executeQuery();

while(rs.next()){
goods = new Goods();
goods.setId(rs.getInt("ID"));
goods.setGoodsname(rs.getString("GOODSNAME"));

goodsList.add(goods);
}

super.CloseAll(pstmt, rs);

Answer 1

sql = "select * from GOODS where GOODSNAME like %?%";

super.OpenConn();

pstmt = super.conn.prepareStatement(sql);
pstmt.setString(1, goodsname);
改为sql = "select * from GOODS where GOODSNAME like ?";

super.OpenConn();

pstmt = super.conn.prepareStatement(sql);
pstmt.setString(1, "%"+goodsname+"%");

Answer 2

模糊查询的SQL语句中?两边不要加% 直接：pstmt.setString(1, "%"+goodsname+"%");就行了~~~

Answer 3

把%放在setString(1, "%"+goodsname);里面

Answer 4

可以这样
sql="update table1 set a=?,b=?"
stmt = con.prepareStatement(sql);
stmt.setObjec t(1,"upValue1");
stmt.setObjec t(2,"upValue2");