Question

select * from t_user where username like %?%怎么写入程序中

Connection conn = new ConnectionFactory().getConnection();  String sql = "select * from t_user where username like '%?%'";  PreparedStatement pstm = conn.prepareStatement(sql);  pstm.setString(1, partOfName);  ResultSet rs = pstm.executeQuery(); 这样写的话 pstm.setString(1, partOfName)就报错 因为？在‘’里面了，'%?%'不用单引号就报语法错误  应该怎么写sql语句？

Answer 1

SELECT * FROM t_users WHERE username LIKE CONCAT('%',?,'%') AND parent_id = ?

Answer 2

难道需要转义么？这样写可以执行查询的吧。