PrepareStatement 中 in 参数和 like 参数的用法

 

in 参数

 

String sql = "select * from user where user.age in (?, ?, ?, ?) and name like ?;

...

...

stmt.setInt(1, 11);

stmt.setInt(2, 12);

stmt.setInt(3, 13);

stmt.setInt(4, 14);

 

like 参数

stmt.setString(5, "%" + name + "%");