SQL语句中怎样使用变量
String strSql="SELECT id,pwd FROM Users WHERE id=username AND pwd=&username"这句是错的，但是我要使用这两个变量怎么样用啊？
谢谢啦！
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&"'"
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&"'"
温馨提示：内容为网友见解，仅供参考
第1个回答 2010-06-01
String strSql="SELECT id,pwd FROM Users WHERE id='"& username &"' AND pwd='"& username &"'"
第2个回答 2010-06-01
String strSql="SELECT id,pwd FROM Users WHERE id='"&userid&"' AND pwd='"&username&"'"
第3个回答 2010-06-01
往里面传值
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();
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();
相似回答
