package Dao;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;
import Bean.HouseBean;
import Bean.UserBean;
import Hibernate.HibernateSessionFactory;
public class UserDao {
Configuration conf=null;
SessionFactory sessionFactory=null;
Session session=null;
Transaction tt=null;
List list=new ArrayList();
public boolean UserRigest(UserBean user){
boolean b=false;
try{
conf = new Configuration();
conf.configure();
ServiceRegistry sr = new ServiceRegistryBuilder().applySettings(conf.getProperties()).buildServiceRegistry();
sessionFactory = conf.buildSessionFactory(sr); //创建sessionFactory
session=sessionFactory.openSession();//打开session
tt=session.beginTransaction();//开始一个事务
session.save(user);//持久化操作
tt.commit();//提交事务
b=true;
}
catch(HibernateException e){
tt.rollback();//回滚事务
e.printStackTrace();
}
finally{
session.close();
sessionFactory.close();
}
return b;
}
public List CheckRigester(UserBean user){
try{
session=HibernateSessionFactory.getSession();
String hql="select u.username from UserBean as u where u.username=?";
Query query=session.createQuery(hql);
query.setString(0, user.getUsername());
list=query.list();
}
catch(HibernateException e){
e.printStackTrace();
}
finally{
HibernateSessionFactory.closeSession();
}
return list;
}
public List UserLogin(UserBean user){
try{
session= HibernateSessionFactory.getSession();
String hql="from UserBean as u where u.username=?";
Query query=session.createQuery(hql);
query.setString(0, user.getUsername());
list=query.list();
}
catch(HibernateException e){
e.printStackTrace();
}
finally{
HibernateSessionFactory.closeSession();
}
return list;
}
public List GetUserHouse(int user_id,int start,int size){
try{
session=HibernateSessionFactory.getSession();
String hql="from HouseBean where user_id=? order by id desc";
Query query=session.createQuery(hql);
query.setLong(0, user_id);
query.setFirstResult(start);
query.setMaxResults(size);
list=query.list();
}
catch(HibernateException e){
e.printStackTrace();
}
finally{
HibernateSessionFactory.closeSession();
}
/*BaseDao bd=new BaseDao();
List list2=new ArrayList();
list2.add(house.getUser_id());
String hql="select h from HouseBean as h where h.id=?";
list=bd.executeQuery(hql, list2);*/
return list;
}
public int getUserHouseCount(int user_id){
long l=0;
int count=0;
try{
Session session=HibernateSessionFactory.getSession();
String hql="select count(house) from HouseBean as house where house.user_id=?";
Query query=session.createQuery(hql);
query.setLong(0, user_id);
l=(long)query.uniqueResult();//总条数
count=new Long(l).intValue();//long转换为int型
}
catch(HibernateException e){
e.printStackTrace();
}
finally{
HibernateSessionFactory.closeSession();
}
return count;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
基于Servlet+JSP+Struts2+Hibernate4开发的房屋租赁系统.zip (97个子文件)
Graduation Design
.tern-project 66B
.classpath 2KB
.settings
com.genutiec.eclipse.core.prefs 162B
org.eclipse.wst.jsdt.ui.superType.name 6B
org.eclipse.jdt.core.prefs 357B
com.genuitec.runtime.libraries.xml 110B
.jsdtscope 510B
org.eclipse.wst.common.component 484B
org.eclipse.wst.common.project.facet.core.xml 476B
org.eclipse.wst.jsdt.ui.superType.container 49B
.gitattributes 378B
src
Bean
QueryHouseBean.java 1KB
UserBean.java 933B
Point.java 259B
StreetBean.java 659B
TypeBean.java 313B
HouseBean.java 2KB
DistrictBean.java 521B
User.hbm.xml 1024B
House.hbm.xml 2KB
xwork-conversion.properties 38B
Dao
HouseDao.java 3KB
UserDao.java 4KB
StreetDao.java 1KB
DistrictDao.java 2KB
BaseDao.java 821B
TypeDao.java 632B
Biz
TypeBiz.java 194B
StreetBiz.java 326B
UserBiz.java 852B
DistrictBiz.java 425B
HouseBiz.java 853B
struts.xml 2KB
Interceptor
UserIterceptor.java 1KB
Converter
DateConverter.java 986B
PointConverter.java 807B
Type.hbm.xml 544B
hibernate.cfg.xml 1KB
District.hbm.xml 674B
test
test2.java 1KB
test5.java 477B
test1.java 2KB
test6.java 795B
test4.java 375B
test8.java 648B
test7.java 450B
test3.java 2KB
Street.hbm.xml 657B
Servlet
User_Center.java 1KB
Do_User_Register.java 2KB
Get_Street_By_District_Id.java 969B
Modify_House.java 1KB
House_Info.java 921B
Do_Modify_House.java 2KB
Do_User_Login.java 1KB
Add_House.java 1KB
Do_Add_House.java 2KB
Hibernate
HibernateSessionFactory.java 3KB
action
Login2.java 2KB
AdminAction.java 218B
ReadHouse.java 581B
UserAction.java 3KB
HouseAction.java 3KB
Index.java 1KB
Add_House.java 743B
User.java 164B
QueryHouse.java 2KB
.myhibernatedata 385B
WebRoot
Login_Message.jsp 279B
Query.jsp 2KB
Register.jsp 2KB
WEB-INF
classes
User.hbm.xml 1024B
House.hbm.xml 2KB
xwork-conversion.properties 38B
struts.xml 2KB
Type.hbm.xml 544B
hibernate.cfg.xml 1KB
District.hbm.xml 674B
Street.hbm.xml 657B
web.xml 5KB
Error.jsp 407B
Add_House.jsp 4KB
QueryResult.jsp 1KB
Login_List.jsp 744B
User_Center.jsp 2KB
Index.jsp 2KB
Management.jsp 263B
House_Info.jsp 873B
Login.jsp 1KB
META-INF
MANIFEST.MF 36B
Modify_House.jsp 3KB
.project 1KB
.gitignore 803B
.myeclipse
profiler
test4 (1).xml 1KB
test5.xml 1KB
test8.xml 1KB
test7.xml 1KB
共 97 条
- 1
资源评论
学术菜鸟小晨
- 粉丝: 1w+
- 资源: 4953
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- Screenshot_20240430_144340_com.ss.android.ugc.live.jpg
- 回到山沟沟.mp3
- 基于matlab实现自适应波束形成RLS及LMS算法仿真源程序1.rar
- 基于matlab实现自己编写的基于卡尔曼滤波的利用加速度传感器的计步器,测试数据是传感器放在腰部和手臂 .rar
- 基于matlab实现阵列信号处理,波束形成.rar
- 111111111111111111
- 基于matlab实现计步器编程;对当前的计步器装置的数值算法模拟 .rar
- Mdb学习查看PW;access;mdb;pw;password;patch
- 基于matlab实现关于语音信号声源定位DOA估计所用的一些传统算法.rar
- 基于ultralytics-yolov8, 将其检测/分类/分割/姿态等任务移植到rk3588上
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功