userinfodb.java

struts+hibernate+mysql 一个小小的demo

package com.model.sessionfactory;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import com.model.hibernateutil.*;
import com.model.hibernateutil.HibernateUtil;
import com.model.imp.UserInfo;
import com.model.po.Usertable;

//实现接口类
public class UserInfoDB implements UserInfo {
	/*
	 * lihui @ 实现登陆的方法
	 */
	public List userlogin(String username, String pasword) {
		Configuration config = new Configuration().configure();
		SessionFactory factory = config.buildSessionFactory();
		Session session = factory.openSession();
		String hql = "from Usertable where username = '" + username
				+ "' and pasword = '" + pasword + "'";
		Query query = session.createQuery(hql);
		List list = query.list();
		return list;

	}

	/*
	 * 李辉 实现查询全部方法
	 */
	public Map userrlist(int pageSize, int pageNumber) {
		Configuration config = new Configuration().configure();
		SessionFactory factory = config.buildSessionFactory();
		Session session = factory.openSession();
		Map map = new HashMap();
		Query hsql = session.createQuery("from Usertable");
		hsql.setFirstResult(0);
		hsql.setMaxResults(5);
		List temp = hsql.list();
		Query userNumber = session
				.createSQLQuery("select count(*) from Usertable");
		userNumber.uniqueResult();
		map.put("userinfo", temp);
		map.put("userunmber", userNumber);
		return map;
	}

	/*
	 * 李辉 用户删除
	 */
	public boolean deluser(String id) {
		Configuration config = new Configuration().configure();
		SessionFactory factory = config.buildSessionFactory();
		Session session = factory.openSession();
		Transaction tx = session.beginTransaction();
		tx.begin();
		try {
			String hql = "from Usertable a where a.id='" + id + "'";
			Query query = session.createQuery(hql);
			Usertable usertable = (Usertable) query.list().get(0);
			session.delete(usertable);
			tx.commit();
		} catch (Exception ex) {
			ex.printStackTrace();
			tx.rollback();
		}
		return true;
	}

	/*
	 * 李辉 用户添加
	 */
	public boolean adduser(Usertable usertable) {
		Configuration config = new Configuration().configure();
		SessionFactory factory = config.buildSessionFactory();
		Session session = factory.openSession();
		Transaction tx = session.beginTransaction();
		session.save(usertable);
		tx.commit();
		return true;

	}

	/*
	 * 李辉 用户修改前
	 */
	/*
	 * public Usertable getUser(String id){ Session session =
	 * HibernateSessionFactory.getSession(); Usertable ut = (Usertable )
	 * session.load(Usertable.class, id); return ut; }
	 */
	/*
	 * 李辉 用户修改前
	 */
	public Usertable updatuser(String id) {
		Configuration config = new Configuration().configure();
		SessionFactory factory = config.buildSessionFactory();
		Session session = factory.openSession();
		Query query = session
				.createQuery("from Usertable user_table where user_table.id = '"
						+ id + "'");
		Usertable usertable = (Usertable) query.list().get(0);
		return usertable;
	}

	/*
	 * (李辉 修改记录)
	 * 
	 * @see com.model.imp.UserInfo#updatsucc(com.model.po.Usertable)
	 */
	public boolean updatsucc(Usertable usertable) {
		Configuration config = new Configuration().configure();
		SessionFactory factory = config.buildSessionFactory();
		Session session = factory.openSession();
		Transaction tx = session.beginTransaction();
		session.update(usertable);
		tx.commit();
		return true;

	}

	public List userlist(int zongeshu, int zongtiaoshu) {
		Configuration config = new Configuration().configure();
		SessionFactory factory = config.buildSessionFactory();
		Session session = factory.openSession();
		int count = 0; // 记录总数

		int pageSize = 20; // 每页显示记录数

		int pageCount = 0; // 总页数

		int page = 1; // 当前页数

		String totalCountSQL;// 得到总记录数sql语句

		String listSQL;// 得到查询记录sql语句
		pageCount = count / pageSize;
		if (count % pageSize == 0) {
			pageCount++;
		}
		Query query = session
				.createSQLQuery("select count(*) from Usertable user_table order by id");
		List list = HibernateUtil.pageutil(query, 0, pageSize);
		return query.list();
	}

	public List userlist() {
		// TODO Auto-generated method stub
		return null;
	}

}