?? userinfodao.java
字號(hào):
package com.david.dao;
import java.sql.Date;
import java.util.ArrayList;
import java.util.List;
import org.hibernate.Query;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.david.bo.Userinfo;
import com.david.bo.Userpoint;
public class UserinfoDao extends HibernateDaoSupport implements IUserinfoDao {
public boolean addUserinfo(Userinfo userinfo) {
// TODO Auto-generated method stub
userinfo.setAddtime(new Date(System.currentTimeMillis()));
try{
this.getHibernateTemplate().save(userinfo);
return true;
}catch(DataAccessException e){
return false;
}
}
/**
* 判斷用戶名是否存在
* 存在返回true
* 不存在返回false
*/
public boolean isExistUsername(String username) {
// TODO Auto-generated method stub
List<Userinfo> list=this.getHibernateTemplate().find("from Userinfo as userinfo where userinfo.username=? Order by userinfo.id desc", username);
return list.size()>=1;
}
public Userinfo login(Userinfo userinfo) {
// TODO Auto-generated method stub
String[] arr={userinfo.getUsername(),userinfo.getPassword()};
try{
//List<Userinfo> list=this.getHibernateTemplate().find("from Userinfo userinfo where userinfo.username='"+userinfo.getUsername()+"' and userinfo.password='"+userinfo.getPassword()+"'");
List<Userinfo> list=this.getHibernateTemplate().find("from Userinfo as userinfo where userinfo.username=? and userinfo.password=?",arr);
if(list.size()==1){
//只取出一條記錄
return list.get(0);
}else{
return null;
}
}catch(DataAccessException e){
e.printStackTrace();
return null;
}
}
public List<Userinfo> getList() {
// TODO Auto-generated method stub
return this.getHibernateTemplate().find("from Userinfo as userinfo Order by userinfo.id desc");
}
public Userinfo getUserinfoById(int userId) {
// TODO Auto-generated method stub
List<Userinfo> list=this.getHibernateTemplate().find("from Userinfo as userinfo where userinfo.id=?", userId);
if(list.size()==1){
return list.get(0);
}else{
return null;
}
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -