userloginhibernatedao.java~309~

hibernate+spring的相片上传项目

package org.lenovoAC.hibernateDao;

import org.lenovoAC.pojo.UserLogin;
import org.lenovoAC.dao.UserLoginDao;
import net.sf.hibernate.Hibernate;
import net.sf.hibernate.type.Type;
import net.sf.hibernate.Query;
import java.util.List;
import org.springframework.orm.hibernate.HibernateCallback;
import net.sf.hibernate.HibernateException;
import java.sql.SQLException;
import net.sf.hibernate.Session;
import java.sql.Connection;
import java.sql.PreparedStatement;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *　　　 ┃ ┃　　　 ┛　　　┃
 　　 　┏━━┛┏━━━━┃┏━━┃
 ━━━┛┏━━┃┛━┛━┛┛┏━━┃
 　　　 ┃　　┃━━　┏━┛┃　　┃
 　　　 ┛　　┛━━━━━┛━━━┛

 * @author not attributable
 * @version 1.0
 */
public class UserLoginHibernateDao
    extends BaseDao implements UserLoginDao
{
  /**
   * 添加
   * @param user UserLogin
   */
  public void insertUser(UserLogin user)
  {
    this.getHibernateTemplate().save(user);
  }

  /**
   * 删除
   * @param user UserLogin
   */
  public void delUser(UserLogin user)
  {
    this.getHibernateTemplate().delete(user);
  }

  /**
   * 修改
   * @param user UserLogin
   */
  public void updateUser(UserLogin user)
  {
    this.getHibernateTemplate().update(user);
  }

  /**
   * 得到单个实例
   * @param id String
   * @return UserLogin
   */
  public UserLogin getUser(String id)
  {
    return (UserLogin)this.getHibernateTemplate().load(UserLogin.class, id);
  }

  /**
   * 删除
   * @param id String
   */
  public void delUserTwo(String id)
  {
    UserLogin user = this.getUser(id);
    this.delUser(user);
  }

  /**
   * 得到所有实例
   * @return List
   */
  public java.util.List getAllUser()
  {
    String hql = "from UserLogin as user order by user.time desc";
    return this.getHibernateTemplate().find(hql);
  }

  /**
   * 得到所有实例
   * @return List
   */
  public java.util.List loadAll()
  {
    return this.getHibernateTemplate().loadAll(UserLogin.class);
  }

  /**
   * 用户登陆
   * @param username String
   * @param password String
   * 00:用户不存在
   * 01:用户处于停用状态
   * 02:用户可用
   * @return String
   */
  public String userLogin(String username, String password)
  {
    String msg = "00";
    String hql = "from UserLogin as ul  where ul.name=? and ul.password=?";
    java.util.List list = this.getHibernateTemplate().find(hql, new String[]
        {username, password}, new Type[]
        {Hibernate.STRING, Hibernate.STRING});
    if (list.isEmpty() || list.size() == 0)
    {
      msg = "00";
    }
    else
    {
      UserLogin user = (UserLogin) list.get(0);
      String state = user.getState();
      if ("01".equals(state))
        msg = "01";
      else
        msg = "02";
    }
    return msg;
  }

  /**
   * 检测用户是否已被注册
   * @param name String
   * @return boolean
   */
  public boolean isUser(String name)
  {
    String hql = "from UserLogin as ul where ul.name=?";
    List list = this.getHibernateTemplate().find(hql, name);
    if (list.size() == 0 || list.isEmpty())
      return true;
    else
      return false;
  }

  /**
   * 修改密码
   * @param newPassword String
   * @param userId String
   */
  public void updatePassword(final String newPassword, final String userId)
      throws Exception
  {
   Session s=this.getSession();
   Connection con=s.connection();
   String sql="update user_login set password=? where id=?";
   PreparedStatement pst=con.prepareStatement(sql);
   pst.setString(1,newPassword);
   pst.setString(2,userId);
   pst.executeUpdate();
   pst.close();
   con.close();
  }
}