Question

SQL Server带参数的查询语句，怎样用java给参数赋值

String sql = "select * from mytable where username = @username and password = @password";

Answer 1

string v1_name='sa';//用户名
string v2_pass='sa';//密码
String sql = "select * from mytable where username = '" + v1_name + " 'and password =' " +v2_pass"' ; //传值的时候注意：单引号配合双引号

Answer 2

string v1_name='sa';
string v2_pass='sa';
String sql = "select * from mytable where username = " + v1_name + " and password = " +v2_pass ;

Answer 3

select * from mytable where username =? and password =?
然后你设置参数就行了