34,593
社区成员
发帖
与我相关
我的任务
分享
String name="张";
sql="SELECT * from books WHERE name LIKE '' "+name+"''";
pstmt=con.prepareStatement(sql);
pstmt.setString(1,name);
declare @name varchar(10)
set @name='张'
print('SELECT * FROM yourtable WHERE name LIKE '''+@name+'''')
--结果
/*
SELECT * FROM yourtable WHERE name LIKE '张'
*/
print('SELECT * FROM yourtable WHERE name LIKE ''张''')
--结果
/*
SELECT * FROM yourtable WHERE name LIKE '张'
*/