Question

sql="select * from 用户表 where username='"&username&"'and password='" &userpass& "'"

提示语法错误，请大神支招。

Answer 1

我写个简单的例子，楼主可以参考下publicintgetLogin(Stringusername,Stringpassword){Stringsql="select*fromuser_tablewhereusername=?andpassword=?";SQLQueryquery=getSession().createSQLQuery(sql).addEntity(UserTable.class);query.setString(0,username);query.setString(1,password);returnInteger.parseInt(query.uniqueResult().toString());}publicstaticvoidmain(String[]args){newUserTableDAO().getLogin("zhang","yuan");}

Answer 2

笛罪过狙臼唤醒撬