1.传值
statement只能执行依据完整的sql
PrepareStatment可以在sql中用?进行占位,后面进行替换
例 String sql = “select * from user where user_id = ?”
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, “9527”);
ps.executeQuery();
1.传值
statement只能执行依据完整的sql
PrepareStatment可以在sql中用?进行占位,后面进行替换
例 String sql = “select * from user where user_id = ?”
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, “9527”);
ps.executeQuery();