String expr = "select *from table where url like?";
pstmt =con.prepareStatement(expr);
String a="a";
pstmt.setString(1,"%"+a+"%");//自动添加单引号 (包装后的参数)
pstmt.execute();
System.out.println(pstmt.toString());//打印sql
//会默认生成sql: select *from table where url like '%http%'
//第二种方法
String sql="select * from emp e where upper(e.ename) like upper('%'||?||'%')";
pStmt= DBUtil.pStmt(conn, sql);
DBUtil.setParams(pStmt, name);
rs = pStmt.executeQuery();
java链接数据库使用prepareStatement参数化模糊查询的两种方法
最新推荐文章于 2024-06-18 16:11:48 发布