package com.hiernate.util;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import com.hiernate.persistence.*;
//hibernate工具类,于数据库交互.
public class HibernateUtil {
static private Session session;
static GetHibernate hib = new GetHibernate(); //创建
// 按照用户名和密码寻找用户
public static List findUser(String strUserName, String strPwd) {
Transaction tx = null;
List list = null;
try {
session = hib.openSession(); //调用公共类的开启session方法.
tx = (Transaction) session.beginTransaction(); //开启事物
Query query = session.createQuery("from User as u where u.userName=:strUserName and u.pwd=:strPwd"); //应用HQL检索查找满足条件的集合
query.setString("strUserName", strUserName); //动态绑定参数
query.setString("strPwd", strPwd);
list = query.list(); //list方法用来执行HQL语句
tx.commit(); //事务的提交
hib.closeSession(session); //关闭session
} catch (Exception e) {
e.printStackTrace(); //输出异常信息
tx.rollback(); //事务的回滚
}
return list;
}
// 查出所有用户并分页
public static List findUser(int recPerPage,int pages) {
Transaction tx = null;
List list = null;
try {
session = hib.openSession();
tx = (Transaction) session.beginTransaction();
Query query = session.createQuery("from User");
query.setFirstResult(recPerPage);
query.setMaxResults(pages);
list = query.list();
tx.commit();
hib.closeSession(session);
} catch (Exception e) {
e.printStackTrace();
tx.rollback();
}
return list;
}
// 查找员工的总记录数
public static int findUserCount() {
Transaction tx = null;
int intCount=0;
try {
session = hib.openSession();
tx = (Transaction) session.beginTransaction();
intCount = ((Integer) session.createQuery("select count(*)from User").uniqueResult()).intValue();
tx.commit();
hib.closeSession(session);
} catch (Exception e) {
e.printStackTrace();
tx.rollback();
}
return intCount;
}
// 修改用户信息
public static void updateUser(User user) {
Transaction tx = null;
try {
session = hib.openSession();
tx = (Transaction) session.beginTransaction();
session.update(user);
tx.commit();
hib.closeSession(session);
} catch (Exception e) {
e.printStackTrace();
tx.rollback();
}
}
// 删除用户
public static void deleUser(User user) {
Transaction tx = null;
try {
session = hib.openSession();
tx = (Transaction) session.beginTransaction();
session.delete(user);
tx.commit();
hib.closeSession(session);
} catch (Exception e) {
e.printStackTrace();
tx.rollback();
}
}
// 查找用户id方法
public static List findUserId(int intId) {
Transaction tx = null;
List list = null;
try {
session = hib.openSession();
tx = (Transaction) session.beginTransaction();
Query query = session
.createQuery("from User as u where u.id =:intMedeId");
query.setInteger("intMedeId", intId);
list = query.list();
tx.commit();
hib.closeSession(session);
} catch (Exception e) {
e.printStackTrace();
tx.rollback();
}
return list;
}
// 按部门查找用户
public static List findUser(String strBranch,int intFrist,int intPages) {
Transaction tx = null;
List list = null;
try {
session = hib.openSession();
tx = (Transaction) session.beginTransaction();
Query query = session
.createQuery("from User as u where u.branch=:strBranch");
query.setString("strBranch", strBranch);
query.setFirstResult(intFrist);
query.setMaxResults(intPages);
list = query.list();
tx.commit();
hib.closeSession(session);
} catch (Exception e) {
e.printStackTrace();
tx.rollback();
}
return list;
}
// 按部门查找员工的总记录数
public static int findUserCount(String branch) {
Transaction tx = null;
int intCount=0;
try {
session = hib.openSession();
tx = (Transaction) session.beginTransaction();
intCount = ((Integer) session.createQuery("select count(*)from User u where u.branch ="+"'"+branch+"'").uniqueResult()).intValue();
tx.commit();
hib.closeSession(session);
} catch (Exception e) {
e.printStackTrace();
tx.rollback();
}
return intCount;
}
// 查找优秀员工
public static List findU() {
Transaction tx = null;
List list = null;
try {
session = hib.openSession();
tx = (Transaction) session.beginTransaction();
Query query = session
.createQuery("from User as u where u.bestMan =1");
list = query.list();
tx.commit();
hib.closeSession(session);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
tx.rollback();
}
return list;
}
// 查找菜单
public static List findMenu(int intMendId) {
Transaction tx = null;
List list = null;
try {
session = hib.openSession(); //利用公共类开启session
tx = (Transaction) session.beginTransaction(); //开启事务
Query query = session
.createQuery("from Menu as m where m.modeId =:intMedeId");
query.setInteger("intMedeId", intMendId); //绑定查询参数
list = query.list();
tx.commit();
hib.closeSession(session); //利用公共类关闭session
} catch (Exception e) {
e.printStackTrace();
tx.rollback();
}
return list;
}
// 查出会议记录,并分页
public static List finMeeting(int intFrint,int intpages) {
Transaction tx = null;
List list = null;
try {
session = hib.openSession(); //打开session
tx = (Transaction) session.beginTransaction(); //开启事务
Query query = session.createQuery("from Meeting"); //创建Query对象
query.setFirstResult(intFrint); //调用Query的分页方法
query.setMaxResults(intpages);
list = query.list(); //查询结果返回list集合
tx.commit(); //提交事务
hib.closeSession(session); //关闭session
} catch (Exception e) {
e.printStackTrace();
tx.rollback();
}
return list;
}
// 查找会议的总记录数
public static int findMeetingCount() {
Transaction tx = null; //创建事务
int intCount=0; //声明int型变量
try {
session = hib.openSession(); //调用公共类打开session
tx = (Transaction) session.beginTransaction();//开启事务
intCount = ((Integer) session.createQuery("select count(*)from Meeting").uniqueResult()).intValue();
//如果在不确定查询结果类型的时候,可用uniqueResult()方法,返回Object
tx.commit(); //提交事务
hib.closeSession(session); //关闭session
} catch (Exception e) {
e.printStackTrace();
tx.rollback(); //撤消事务
}
return intCount;
}
// 查出符合会议id集合
public static List findMeetingid(int intid) {
Transaction tx = null;
List list = null;
try {
session = hib.openSession(); //调用公共类打开session
tx = (Transaction) session.beginTransaction(); //开启事务
Query query = session.createQuery("from Meeting as m where m.id =:intid"); //按id号检索对象
query.setInteger("intid",intid); //动态绑定参数
list = query.list(); //执行HQL语句
tx.commit(); //提交事务
hib.closeSession(session); //关闭session
} catch (Exception e) {
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
JSP项目开发全程实录完整源代码(06OA办公系统补全src文件) (1616个子文件)
validate.js.bak 6KB
HibernateUtil.class 22KB
AdminAction.class 17KB
BbsAction.class 13KB
OpDB.class 12KB
InfoAction.class 10KB
GoodsAction.class 9KB
AdminAction.class 9KB
BorrowDAO.class 9KB
ArticleServlet.class 7KB
ManagerDAO.class 7KB
StartExam.class 7KB
StudentDAO.class 7KB
BookDAO.class 7KB
GoodsDao.class 6KB
EmployeeAction.class 6KB
Borrow.class 6KB
SendLetterDAO.class 6KB
LogXAction.class 6KB
ConsumerServlet.class 6KB
QuestionsDAO.class 6KB
Manager.class 6KB
Book.class 5KB
ReaderDAO.class 5KB
PhotoSerlvet.class 5KB
OpDB.class 5KB
Reader.class 5KB
StartExamDAO.class 5KB
EmployeeForm.class 5KB
Student.class 5KB
MemberDao.class 5KB
BorrowForm.class 5KB
QuestionsForm.class 5KB
Manager.class 5KB
BbsForm.class 5KB
ConsumerDao.class 5KB
SendMailDAO.class 4KB
MemberAction.class 4KB
TaoTiDAO.class 4KB
OrderDao.class 4KB
Manager.class 4KB
ShortInfo.class 4KB
SmallTypeAction.class 4KB
LessonDAO.class 4KB
Questions.class 4KB
Personnel.class 4KB
ManagerAction.class 4KB
ReaderTypeDAO.class 4KB
Customer.class 4KB
BookTypeDAO.class 4KB
ReaderType.class 4KB
UserForm.class 4KB
FriendServlet.class 4KB
BookType.class 4KB
Lesson.class 4KB
CustomerDAO.class 4KB
ShortInfoDAO.class 4KB
BookCase.class 4KB
TaoTi.class 4KB
SmallTypeDao.class 4KB
BookCaseDAO.class 4KB
DiscussServlet.class 4KB
PersonnelDAO.class 4KB
TongXunAdd.class 4KB
PayAction.class 4KB
BookForm.class 4KB
MyPagination.class 4KB
ManagerAction.class 4KB
SendLetter.class 4KB
SearchAction.class 4KB
ManagerDAO.class 4KB
ConnDB.class 3KB
MyPagination.class 3KB
ManagerDAO.class 3KB
ArticleDao.class 3KB
ReaderForm.class 3KB
AfficheAction.class 3KB
ConnDB.class 3KB
InviteJobAction.class 3KB
InviteJobForm.class 3KB
OrderAction.class 3KB
ConnDB.class 3KB
IndexAction.class 3KB
InfoType.class 3KB
CreatePage.class 3KB
PhotoDao.class 3KB
StuResultDAO.class 3KB
ManagerDao.class 3KB
GoodsForm.class 3KB
CjAction.class 3KB
VoteServlet.class 3KB
SendMail.class 3KB
FriendDao.class 3KB
AfficheDao.class 3KB
CreatePage.class 3KB
OrderForm.class 3KB
DiscussDao.class 3KB
DB.class 3KB
BigTypeAction.class 3KB
DepartmentAction.class 3KB
共 1616 条
- 1
- 2
- 3
- 4
- 5
- 6
- 17
changdianwei
- 粉丝: 0
- 资源: 4
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
前往页