select * from myusertable where text='UserName' and password='Password ' oracle中是单引号
mysql 中也是单引号吗 ?谢谢
没这么简单吧 select * from myusertable where text='"+UserName+"' and password='"+Password+"'"; 这个错在哪 请高手帮忙 谢谢
如果你的用户名(text)就是“UserName”的话,直接查询数据库的话是这个: select text, password from myusertable where text='UserName' and password='Password';不过看你写的“UserName”应该是个变量吧?如果是变量的话: select text, password from myusertable where text=UserName and password=Password;如果是在JavaBean中写代码那应该是: String sql = "select text, password from myusertable where text='" + UserName + "' and password='" + Password + "'";
其实现在的系统密码几乎全部都是加密的,比如你用mysql自带的md5加密的话,那sql就是 String sql = "select text, password from myusertable where text='" + UserName + "' and password=md5('" + Password + "')";
String sql ="select * from myusertable where text='"+UserName+"' and password='"+Password+"'"; 楼上才是对的.
oracle中是单引号
select * from myusertable where
text='"+UserName+"'
and password='"+Password+"'";
这个错在哪 请高手帮忙 谢谢
select text, password from myusertable where text='UserName' and password='Password';不过看你写的“UserName”应该是个变量吧?如果是变量的话:
select text, password from myusertable where text=UserName and password=Password;如果是在JavaBean中写代码那应该是:
String sql = "select text, password from myusertable where text='" + UserName + "' and password='" + Password + "'";
String sql = "select text, password from myusertable where text='" + UserName + "' and password=md5('" + Password + "')";
text='"+UserName+"'
and password='"+Password+"'";
楼上才是对的.
尽量用setName=rs.getString(1);
这样的写法