搜档网
当前位置：搜档网 › PreparedStatement like 的用法
PreparedStatement like 的用法
PreparedStatement like 的用法
Java代码
String expr = "select * from table where url like ?";
pstmt = con.prepareStatement(expr);
String a="a";
pstmt.setString(1, "%"+a+"%");
pstmt.execute();
这样写 PreparedStatement
会默认生成sql语句：
select * from table where url like '%http%'
不要这样写
Java代码
String expr = "select * from table where url like %?%";
也不要这样写
Java代码
pstmt = con.prepareStatement(expr);
String a="%a%";
pstmt.setString(1, a);
pstmt.execute();
pstmt = con.prepareStatement(expr);
String a="%a%";
pstmt.setString(1, a);
pstmt.execute();
相关主题
相关文档
- 语法动词ing的用法
- Unit1ThingsIlikedoing
- like doing sth 和 like to do sth.说课讲解
- likedoingsth和liketodo
- Todoing用法归纳
- Module2Unit1ThingsIlikedoing
- Whatdoeshelikedoing
- Like to dodoing的用法(9)
- like doing与like to do
- Like和likes的用法讲课稿
- Feel like用法
- 深圳优质课教案 小学五年级英语 like doing的用法教学设计
- feel like doing和 feel like to do 的区别
- like to do和like doing
- like doing和like to do
- likedoing的用法
- like to do 与like doing
- like+doing的用法
- 动词接to do 和doing的总结
- like-doing-sth