Question

SQL语句中怎样使用变量

String strSql="SELECT id,pwd FROM Users WHERE id=username AND pwd=&username"这句是错的，但是我要使用这两个变量怎么样用啊？
谢谢啦！

Answer 1

c#语法
String strSql="SELECT id,pwd FROM Users WHERE id='"+userid+"' AND pwd='"+username+"'"
vb语法
String strSql="SELECT id,pwd FROM Users WHERE id='"&userid&"' AND pwd='"&username&"'"

Answer 2

String strSql="SELECT id,pwd FROM Users WHERE id='"& username &"' AND pwd='"& username &"'"

Answer 3

String strSql="SELECT id,pwd FROM Users WHERE id='"&userid&"' AND pwd='"&username&"'"

Answer 4

往里面传值
String sql = select id , pwd from Users where id=? and pwd=?
Connection conn = DriverManage.getConnection(url,username,pwd);
PrepareStatement ps = conn.createPrepareStatement(sql);
ps.setString("id",0);
ps.setString("pwd",1);
ResultSet rs = ps.excuteQuery();