sql = "select * from abcd where name = ? ";
PreparedStatement pstmt = conn.prepareStatement(sql);
ps.setString(1,"NameYourSearch"); or ps.setNull(1,Types.STRING);
PreparedStatement pstmt = conn.prepareStatement(sql);
ps.setString(1,"NameYourSearch"); or ps.setNull(1,Types.STRING);
select * from abcd where name=?
能否具体讲解一下 setNull 的第二个参数是什么意思?
我数据库里的数据类型是 VARCHAR2(15)
那我这里第二个参数应该写什么呀?
PreparedStatement pstmt = conn.prepareStatement(sql);
ps.setString(1,"NameYourSearch"); or ps.setNull(1,Types.STRING);
ps.setString(2,"aaa"); or ps.setNull(1,Types.STRING);