java--hibernate--SQLQuery增删查改

最新推荐文章于 2024-07-28 02:34:19 发布

W了个G

最新推荐文章于 2024-07-28 02:34:19 发布

阅读量1.5k

点赞数

分类专栏： JAVA开发文章标签： java hibernate

JAVA开发专栏收录该内容

43 篇文章

订阅专栏

本文介绍了在Hibernate框架中如何使用SQLQuery进行数据查询、更新及删除操作，并提供了具体的代码实例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Hibernate中使用SQLQuery的查询：

 BaseHibernateDAO dao = new BaseHibernateDAO(); 
            //查询语句 
            String strSql  = " select * from hrrole h where h.code like ? and h.id <> ?"; 
            //设置查询对象 
            SQLQuery query = dao.getSession().createSQLQuery(strSql); 
            //设置查询参数 
            query.setString(0,(String)this.getCode().getText()); 
            //设置查询参数 
            query.setString(1,this.getTextField1().getText().toString()); 
            //添加到一个类中 
            query.addEntity(HrRole.class); 
            //结果数据 
            ArrayList<HrRole> idlist = (ArrayList<HrRole>) query.list(); 
            //判断是否有值 
            if(idlist.size() != 0){ 
                 //错误信息 
                 this.label2.setText("代码已存在"); 
            }

Hibernate中使用SQLQuery的更新：

<span style="font-size:14px;">public void updateR(String Code, String NewCode) {
		BaseHibernateDAO dao = new BaseHibernateDAO();
		
		try {
			Transaction tx = dao.getSession().beginTransaction();
			
			String sql1 = "update roleandgrant set rolecode = '" + Code + "'" + " where rolecode ='" + NewCode + "'";
			String sql2 = "update emprole set rolecode = '" + Code + "'" + " where rolecode ='" + NewCode + "'";
			
			SQLQuery query1 = dao.getSession().createSQLQuery(sql1);
			SQLQuery query2 = dao.getSession().createSQLQuery(sql2);
			
			query1.addEntity(RoleAndGrant.class);
			query2.addEntity(EmpVsRole.class);
			
			query2.executeUpdate();
			query1.executeUpdate();
			
			tx.commit();
			
			dao.closeSession();
		} catch (Exception ex) {
			System.out.println(ex);
			dao.closeSession();
		}
}</span>

Hibernate中使用SQLQuery的删除：

<span style="font-size:14px;">public void DeleteR(String Code) {
		BaseHibernateDAO dao = new BaseHibernateDAO();
		
		try {
			Transaction tx = dao.getSession().beginTransaction();
			
			String sql1 = "delete from  roleandgrant where rolecode ='" + Code + "'";
			String sql2 = "delete from emprole where rolecode ='" + Code + "'";
			
			SQLQuery query1 = dao.getSession().createSQLQuery(sql1);
			SQLQuery query2 = dao.getSession().createSQLQuery(sql2);
			
			query1.addEntity(RoleAndGrant.class);
			query2.addEntity(EmpVsRole.class);
			
			query2.executeUpdate();
			query1.executeUpdate();
			
			tx.commit();
			
			dao.closeSession();
		} catch (Exception ex) {
			System.out.println(ex);
			dao.closeSession();
		}
}</span>