public Users Logincheck(Users user)
{
String[] w={user.getUsername(),user.getUserpass()};
Object[] s={"username","userpass"};
String hql="from Users where username=:username and userpass=:userpass";
List users=getHibernateTemplate().findByNamedParam(hql, w, s);
if(users.size()>0)
{
user =(Users) users.get(0);
}
return user;
}这样写不对吗?该怎么写?谢谢!
{
String[] w={user.getUsername(),user.getUserpass()};
Object[] s={"username","userpass"};
String hql="from Users where username=:username and userpass=:userpass";
List users=getHibernateTemplate().findByNamedParam(hql, w, s);
if(users.size()>0)
{
user =(Users) users.get(0);
}
return user;
}这样写不对吗?该怎么写?谢谢!
解决方案 »
- 在jsp页面的多个文本框里进很模糊查询,条件怎么判断
- 模糊查询不好用,大家帮我看看
- 水晶报表问题 高手指点
- 在JSP页面中怎么获得Struts2在action中配置的request
- 使用JBossTools 的 JBossWS 开发webservice时,工程中要添加哪些Jar包
- 这个错误该怎么解决啊?急,加分
- Struts2中返回类型redirect和redirectAction的区别?
- Proxool无法释放链接等问题
- 那有jbuilder的断点调试详细使用资料
- 100分求,中文版的《Java Message Service》。。。。。。。。。
- 用HttpRequester访问地址的时候,提示说cookies无效。。
- 关于GMAIL邮件的发送
return (User)getSession().createQuery(
"select User from TUser a where a.name = ? " +
"and a.pwd = ? ")
.setParameter(0, name)
.setParameter(1, pwd)
.uniqueResult();
} 看看运行时间!!
public Users Logincheck(Users user)
{ String hql="from Users where username ='"+user.getUserName()+ "'and userpass='"+user.getUserPass()+"'";
Session session = getSession();
Query query = session.createQuery(hql);
List list= query.list();
if(users.size()>0)
{
user =(Users) users.get(0);
}
return user;
}
这样绝对没问题....
public boolean checkLoginA(User u)
{
boolean boo=false;
Dbcon dbc=new Dbcon();
Connection con=dbc.getConnection();
String sql="select password from users where username=? and usertype=?";
try {
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setString(1, u.getUsername());
pstmt.setInt(2, u.getUsertype());
ResultSet rs=pstmt.executeQuery();
if(rs.next())
{
String password=rs.getString("password");
if(password.equals(u.getPassword()))
{
boo=true;
}
}
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return boo;
}
public boolean checkLoginB(User u)
{
boolean boo=false;
Dbcon dbc=new Dbcon();
Connection con=dbc.getConnection();
String sql="select count(uid) from users where username=? and password=? and usertype=? ";
try {
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setString(1, u.getUsername());
pstmt.setString(2, u.getPassword());
pstmt.setInt(3, u.getUsertype());
ResultSet rs=pstmt.executeQuery();
if(rs.next())
{
if(rs.getInt(1)==1)
{
boo=true;
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return boo;
}
采用SSHAction:
// 用户登录操作
public ActionForward checkManager(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
ManagerForm managerForm = (ManagerForm)form;
HttpSession session = request.getSession();
ManagerForm managerform = (ManagerForm)objectDAO.getObjectForm("from ManagerForm where account='"+managerForm.getAccount()+"' ");
if(managerform == null){
request.setAttribute("errorNews", "您输入的帐号不存在!");
} else if(!managerForm.getPassword().equals(managerform.getPassword())){
request.setAttribute("errorNews", "您输入的密码不正确");
} else{
session.setAttribute("managerform", managerform);
session.setAttribute("account", managerform.getAccount());
}
return mapping.findForward("checkManager");
}
objectDAO持久层方法:
//以condition为查询条件, 查询一组数据, 该方法的返回类型为Object
public Object getObjectForm(String condition){
List list = null;
Object object = null;
list = this.getHibernateTemplate().find(condition);
if(list.size() == 1){ //表示只有一条记录
object = list.get(0);
}
return object;
}objectDAO持久层 交给Spring管理.