java中的hql语句查询语句_【java】【转】HQL查询语句

最新推荐文章于 2021-10-18 13:31:59 发布
最新推荐文章于 2021-10-18 13:31:59 发布
阅读量213 收藏
点赞数
文章标签： java中的hql语句查询语句
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_39725756/article/details/114234568
版权

/****/

packagecom.b510.example;importjava.util.Iterator;importjava.util.List;importjava.util.Map;importorg.hibernate.Criteria;importorg.hibernate.FetchMode;importorg.hibernate.Query;importorg.hibernate.Session;/***

*@authorXHW

*

* @date 2011-6-18

**/

public classHibernateTest {/***@paramargs*/

public static voidmain(String[] args) {

HibernateTest test= newHibernateTest();

test.where();

test.function();

test.update();

test.jiaoChaCheck();

test.innerJoin();

test.QBC();

test.leftOuterJoin();

test.rightOuterJoin();

}public voidwhere() {//使用where查询

Session session =HibernateSessionFactoryUtil.getSessionFactory()

.openSession();

session.beginTransaction();

Query query=session

.createQuery("from User where id not between 200 and 2000");

List list =query.list();for(User user : list) {

System.out.println(user.getId()+user.getUsername());

}//投影查询 中使用where子句

query = session.createQuery("select username from User where id=2");

List listname =query.list();for(String name : listname) {

System.out.println(name);

}//in查询

query =session

.createQuery("from User where username in ('Hongten','Hanyuan','dfgd')");

List listin =query.list();for(User user : listin) {

System.out.println(user.getId()+user.getUsername());

}//like查询

query = session.createQuery("from User where username not like 'Hon%'");

List listlike =query.list();for(User user : listlike) {

System.out.println(user.getId()+user.getUsername());

}//null查询

query = session.createQuery("from User where password is null");

List listnull =query.list();for(User user : listnull) {

System.out.println(user.getId()+user.getUsername());

}//and查询

query =session

.createQuery("from User where password is not null and id<5");

List listand =query.list();for(User user : listand) {

System.out.println(user.getId()+user.getUsername()+user.getPassword());

}//order by

query = session.createQuery("from User order by username,id desc");

List listorderby =query.list();for(User user : listorderby) {

System.out.println(user.getId()+user.getUsername());

}//使用"?"号 作为参数占位符，一条HQL语句中可以使用多个？//query.setInteger(0,2)//query.setString(0,"Hongten")

query =session

.createQuery("select username from User where username=?");

query.setString(0, "Hongten");

List listwenhao =query.list();for(String name : listwenhao) {

System.out.println(name);

}

session.getTransaction().commit();

}public void function() {//把大写字母转化为小写字母//作用可以用在：比如在一个用户注册的程序中，大小写不容易区分，但是全部转化为小写后就可以很容易进行比较

Session session =HibernateSessionFactoryUtil.getSessionFactory()

.openSession();

session.beginTransaction();//输出原始的数据

Query query = session.createQuery("select username from User");

List list =query.list();for(String name : list) {

System.out.println(name);

}

System.out.println("-------------------------------------------");//输出的数据全部转化为小写

query = session.createQuery("select lower(username) from User");

List listChange =query.list();for(String name : listChange) {

System.out.println(name);

}

session.getTransaction().commit();

}public voidupdate() {

Session session=HibernateSessionFactoryUtil.getSessionFactory()

.openSession();

session.beginTransaction();

Query query=session

.createQuery("update User set username='洪伟1231' where id=?");

query.setInteger(0, 3);int rowCount =query.executeUpdate();

System.out.println(rowCount);

session.getTransaction().commit();

}public void operateProfile() {//对profile这个类执行HQL语句操作

Session session =HibernateSessionFactoryUtil.getSessionFactory()

.openSession();

session.beginTransaction();//执行查询操作

Query query = session.createQuery("from Profile");

List list =query.list();for(Profile profile : list) {

System.out.println(profile.getId()+profile.getEmail()+ profile.getAddress() +profile.getMobile()+profile.getPostcode());

}//执行删除操作

query = session.createQuery("delete from Profile where id=?");

query.setInteger(0, 3);int rowCount =query.executeUpdate();

System.out.println(rowCount);

session.getTransaction().commit();

}public void jiaoChaCheck() {//交叉查询//这种方法查询出来的结果是笛卡尔积，对于我们开发中没有多大用处

Session session =HibernateSessionFactoryUtil.getSessionFactory()

.openSession();

session.beginTransaction();

Query query=session.createQuery("from User,Profile");

List list=query.list();for(Object[] values:list){

User user=(User)values[0];

System.out.print("ID :"+user.getId()+",UserName:"+user.getUsername()+",Password:"+user.getPassword());

Profile profile=(Profile)values[1];

System.out.println(profile.getEmail()+profile.getMobile()+profile.getAddress()+profile.getPostcode());

}

session.getTransaction().commit();

}public void innerJoin(){//内连接查询

/*** 下面三种hql语句都是可以得到相同的结果

* String hql="select p from Profile as p inner join p.user";

* 在下面的hql语句中加入"fetch"后，此hql语句变为了"迫切HQL"语句，这样的查询效率要比上面的hql语句要高

* String hql="select p from Profile as p inner join fetch p.user";

*

* String hql="select p from Profile p,User u where p.user=u";

* String hql="select p from Profile p,User u where p.user.id=u.id";

**/Session session=HibernateSessionFactoryUtil.getSessionFactory()

.openSession();

session.beginTransaction();

String hql="select p from Profile as p inner join fetch p.user";//String hql="select p from Profile p,User u where p.user=u";//String hql="select p from Profile p,User u where p.user.id=u.id";

Query query=session.createQuery(hql);

List list=query.list();for(Profile p:list){

System.out.println("ID:"+p.getUser().getId()+" Username: "+p.getUser().getUsername()+" Email: "+p.getEmail()+", Address: "+p.getAddress());

}

session.getTransaction().commit();

}public void QBC(){//QBC中实现内连接查询

Session session=HibernateSessionFactoryUtil.getSessionFactory().openSession();

session.beginTransaction();

Criteria criteria=session.createCriteria(Profile.class).createCriteria("user");

List list=criteria.list();for(Profile p:list){

System.out.println("ID:"+p.getUser().getId()+" Username: "+p.getUser().getUsername()+" Email: "+p.getEmail()+", Address: "+p.getAddress());

}//QBC中实现外连接

System.out.println("##################################################");

criteria=session.createCriteria(Profile.class).setFetchMode("user", FetchMode.JOIN);

List listp=criteria.list();for(Profile p:list){

System.out.println("ID:"+p.getUser().getId()+" Username: "+p.getUser().getUsername()+" Email: "+p.getEmail()+", Address: "+p.getAddress());

}

session.getTransaction().commit();

}public void leftOuterJoin(){//左外连接

/*** String hql="select p from Profile p left outer join p.user order by p.user.id";

* 在下面的hql语句中加入"fetch"后，此hql语句变为了"迫切HQL"语句，这样的查询效率要比上面的hql语句要高

* String hql="select p from Profile p left outer join fetch p.user order by p.user.id";

*

* String hqlu="select u from User u left outer join u.profiles";

* 在下面的hql语句中加入"fetch"后，此hql语句变为了"迫切HQL"语句，这样的查询效率要比上面的hql语句要高

* String hqlu="select u from User u left outer join fetch u.profiles";*/Session session=HibernateSessionFactoryUtil.getSessionFactory().getCurrentSession();

session.beginTransaction();

String hql="select p from Profile p left outer join fetch p.user order by p.user.id";

Query query=session.createQuery(hql);

List list=query.list();for(Profile p:list){

System.out.println("ID:"+p.getUser().getId()+" Username: "+p.getUser().getUsername()+" Email: "+p.getEmail()+", Address: "+p.getAddress());

}

System.out.println("-------------------------------------");

String hqlu="select u from User u left outer join fetch u.profiles";

query=session.createQuery(hqlu);

List listu=query.list();for(User u:listu){

System.out.println(u.getId()+u.getUsername()+u.getProfiles());

}

session.getTransaction().commit();

}public void rightOuterJoin(){//右外连接

Session session=HibernateSessionFactoryUtil.getSessionFactory().getCurrentSession();

session.beginTransaction();

String hql="select u from User u right outer join u.profiles order by u.id";

Query query=session.createQuery(hql);

List listu=query.list();for(User user:listu){

System.out.println(user.getId()+user.getUsername()+user.getProfiles());

}

session.getTransaction().commit();

}

}

结果：

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).

log4j:WARN Please initialize the log4j system properly.

Hibernate:

select

user0_.id as id0_,

user0_.username as username0_,

user0_.password as password0_

from

users.user user0_

where

user0_.id not between 200 and 2000

1hongten

2hanyuan

3hongwei

4mingliu

5shouzhang

Hibernate:

select

user0_.username as col_0_0_

from

users.user user0_

where

user0_.id=2

hanyuan

Hibernate:

select

user0_.id as id0_,

user0_.username as username0_,

user0_.password as password0_

from

users.user user0_

where

user0_.username in (

'Hongten' , 'Hanyuan' , 'dfgd'

)

1hongten

2hanyuan

Hibernate:

select

user0_.id as id0_,

user0_.username as username0_,

user0_.password as password0_

from

users.user user0_

where

user0_.username not like 'Hon%'

2hanyuan

4mingliu

5shouzhang

Hibernate:

select

user0_.id as id0_,

user0_.username as username0_,

user0_.password as password0_

from

users.user user0_

where

user0_.password is null

Hibernate:

select

user0_.id as id0_,

user0_.username as username0_,

user0_.password as password0_

from

users.user user0_

where

(

user0_.password is not null

)

and user0_.id<5

1hongten123

2hanyuan5645645

3hongwei5645645

4mingliu5645645

Hibernate:

select

user0_.id as id0_,

user0_.username as username0_,

user0_.password as password0_

from

users.user user0_

order by

user0_.username,

user0_.id desc

2hanyuan

1hongten

3hongwei

4mingliu

5shouzhang

Hibernate:

select

user0_.username as col_0_0_

from

users.user user0_

where

user0_.username=?

hongten

Hibernate:

select

user0_.username as col_0_0_

from

users.user user0_

hongten

hanyuan

hongwei

mingliu

shouzhang

-------------------------------------------

Hibernate:

select

lower(user0_.username) as col_0_0_

from

users.user user0_

hongten

hanyuan

hongwei

mingliu

shouzhang

Hibernate:

update

users.user

set

username='Hongwei1231'

where

id=?

1

Hibernate:

select

user0_.id as id0_0_,

profile1_.id as id1_1_,

user0_.username as username0_0_,

user0_.password as password0_0_,

profile1_.user_id as user2_1_1_,

profile1_.email as email1_1_,

profile1_.phone as phone1_1_,

profile1_.mobile as mobile1_1_,

profile1_.address as address1_1_,

profile1_.postcode as postcode1_1_

from

users.user user0_,

users.profile profile1_

ID :1,UserName:hongten,Password:123hongtenzone@foxmail.com45464Guangzhoushi65465

ID :1,UserName:hongten,Password:123hanyuan@foxmail.com45648255GuangzhoushiDianbian65465

ID :1,UserName:hongten,Password:123hanyuan@foxmail.com45648255GuangzhoushiDianbian65465

ID :2,UserName:hanyuan,Password:5645645hongtenzone@foxmail.com45464Guangzhoushi65465

ID :2,UserName:hanyuan,Password:5645645hanyuan@foxmail.com45648255GuangzhoushiDianbian65465

ID :2,UserName:hanyuan,Password:5645645hanyuan@foxmail.com45648255GuangzhoushiDianbian65465

ID :3,UserName:Hongwei1231,Password:5645645hongtenzone@foxmail.com45464Guangzhoushi65465

ID :3,UserName:Hongwei1231,Password:5645645hanyuan@foxmail.com45648255GuangzhoushiDianbian65465

ID :3,UserName:Hongwei1231,Password:5645645hanyuan@foxmail.com45648255GuangzhoushiDianbian65465

ID :4,UserName:mingliu,Password:5645645hongtenzone@foxmail.com45464Guangzhoushi65465

ID :4,UserName:mingliu,Password:5645645hanyuan@foxmail.com45648255GuangzhoushiDianbian65465

ID :4,UserName:mingliu,Password:5645645hanyuan@foxmail.com45648255GuangzhoushiDianbian65465

ID :5,UserName:shouzhang,Password:5645645hongtenzone@foxmail.com45464Guangzhoushi65465

ID :5,UserName:shouzhang,Password:5645645hanyuan@foxmail.com45648255GuangzhoushiDianbian65465

ID :5,UserName:shouzhang,Password:5645645hanyuan@foxmail.com45648255GuangzhoushiDianbian65465

Hibernate:

select

profile0_.id as id1_0_,

user1_.id as id0_1_,

profile0_.user_id as user2_1_0_,

profile0_.email as email1_0_,

profile0_.phone as phone1_0_,

profile0_.mobile as mobile1_0_,

profile0_.address as address1_0_,

profile0_.postcode as postcode1_0_,

user1_.username as username0_1_,

user1_.password as password0_1_

from

users.profile profile0_

inner join

users.user user1_

on profile0_.user_id=user1_.id

ID:1   Username: hongten   Email: hongtenzone@foxmail.com,   Address: Guangzhoushi

ID:2   Username: hanyuan   Email: hanyuan@foxmail.com,   Address: GuangzhoushiDianbian

ID:3   Username:Hongwei1231   Email: hanyuan@foxmail.com,   Address: GuangzhoushiDianbian

Hibernate:

select

this_.id as id1_1_,

this_.user_id as user2_1_1_,

this_.email as email1_1_,

this_.phone as phone1_1_,

this_.mobile as mobile1_1_,

this_.address as address1_1_,

this_.postcode as postcode1_1_,

user1_.id as id0_0_,

user1_.username as username0_0_,

user1_.password as password0_0_

from

users.profile this_

inner join

users.user user1_

on this_.user_id=user1_.id

ID:1   Username: hongten   Email: hongtenzone@foxmail.com,   Address: Guangzhoushi

ID:2   Username: hanyuan   Email: hanyuan@foxmail.com,   Address: GuangzhoushiDianbian

ID:3   Username: Hongwei1231   Email: hanyuan@foxmail.com,   Address: GuangzhoushiDianbian

##################################################

Hibernate:

select

this_.id as id1_1_,

this_.user_id as user2_1_1_,

this_.email as email1_1_,

this_.phone as phone1_1_,

this_.mobile as mobile1_1_,

this_.address as address1_1_,

this_.postcode as postcode1_1_,

user2_.id as id0_0_,

user2_.username as username0_0_,

user2_.password as password0_0_

from

users.profile this_

left outer join

users.user user2_

on this_.user_id=user2_.id

ID:1   Username: hongten   Email: hongtenzone@foxmail.com,   Address: Guangzhoushi

ID:2   Username: hanyuan   Email: hanyuan@foxmail.com,   Address: GuangzhoushiDianbian

ID:3   Username: 洪伟1231   Email: hanyuan@foxmail.com,   Address: GuangzhoushiDianbian

Hibernate:

select

profile0_.id as id1_0_,

user1_.id as id0_1_,

profile0_.user_id as user2_1_0_,

profile0_.email as email1_0_,

profile0_.phone as phone1_0_,

profile0_.mobile as mobile1_0_,

profile0_.address as address1_0_,

profile0_.postcode as postcode1_0_,

user1_.username as username0_1_,

user1_.password as password0_1_

from

users.profile profile0_

left outer join

users.user user1_

on profile0_.user_id=user1_.id

order by

profile0_.user_id

ID:1   Username: hongten   Email: hongtenzone@foxmail.com,   Address: Guangzhoushi

ID:2   Username: hanyuan   Email: hanyuan@foxmail.com,   Address: GuangzhoushiDianbian

ID:3   Username: 洪伟1231   Email: hanyuan@foxmail.com,   Address: GuangzhoushiDianbian

-------------------------------------

Hibernate:

select

user0_.id as id0_0_,

profiles1_.id as id1_1_,

user0_.username as username0_0_,

user0_.password as password0_0_,

profiles1_.user_id as user2_1_1_,

profiles1_.email as email1_1_,

profiles1_.phone as phone1_1_,

profiles1_.mobile as mobile1_1_,

profiles1_.address as address1_1_,

profiles1_.postcode as postcode1_1_,

profiles1_.user_id as user2_0__,

profiles1_.id as id0__

from

users.user user0_

left outer join

users.profile profiles1_

on user0_.id=profiles1_.user_id

1hongten[com.b510.example.Profile@14eaec9]

2hanyuan[com.b510.example.Profile@569c60]

3Hongwei1231[com.b510.example.Profile@d67067]

4mingliu[]

5shouzhang[]

Hibernate:

select

user0_.id as id0_,

user0_.username as username0_,

user0_.password as password0_

from

users.user user0_

right outer join

users.profile profiles1_

on user0_.id=profiles1_.user_id

order by

user0_.id

Hibernate:

select

profiles0_.user_id as user2_1_,

profiles0_.id as id1_,

profiles0_.id as id1_0_,

profiles0_.user_id as user2_1_0_,

profiles0_.email as email1_0_,

profiles0_.phone as phone1_0_,

profiles0_.mobile as mobile1_0_,

profiles0_.address as address1_0_,

profiles0_.postcode as postcode1_0_

from

users.profile profiles0_

where

profiles0_.user_id=?

1hongten[com.b510.example.Profile@10c0f66]

Hibernate:

select

profiles0_.user_id as user2_1_,

profiles0_.id as id1_,

profiles0_.id as id1_0_,

profiles0_.user_id as user2_1_0_,

profiles0_.email as email1_0_,

profiles0_.phone as phone1_0_,

profiles0_.mobile as mobile1_0_,

profiles0_.address as address1_0_,

profiles0_.postcode as postcode1_0_

from

users.profile profiles0_

where

profiles0_.user_id=?

2hanyuan[com.b510.example.Profile@e265d0]

Hibernate:

select

profiles0_.user_id as user2_1_,

profiles0_.id as id1_,

profiles0_.id as id1_0_,

profiles0_.user_id as user2_1_0_,

profiles0_.email as email1_0_,

profiles0_.phone as phone1_0_,

profiles0_.mobile as mobile1_0_,

profiles0_.address as address1_0_,

profiles0_.postcode as postcode1_0_

from

users.profile profiles0_

where

profiles0_.user_id=?

3Hongwei1231[com.b510.example.Profile@8997d1]

weixin_39725756
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
java中的hql语句查询语句_JavaWeb_(Hibernate框架)Hibernate中数据查询语句HQL基本用法...
weixin_35661850的博客
02-13 819
HQL(Hibernate Query Language) 是面向对象的查询语言, 它和 SQL 查询语言有些相似. 在 Hibernate 提供的各种检索方式中, HQL 是使用最广的一种检索方式.，HQL查询包括以下步骤:1、获取HibernateSession对象2、编写HQL语句3、以HQL语句作为参数，调用Session的createQuery方法创建查询对象。4、如果HQL语句包含...
java hql_《Java从入门到放弃》入门篇：hibernate查询——HQL
weixin_28795975的博客
02-12 162
不知不觉又到了hibernate的最后一篇了，只感觉时光飞逝~，岁月如梭~！转眼之间，我们就···························，好吧，想装个X，结果装不下去了，还是直接开始吧·前面我们已经把hibernate中添加、删改、修改和根据ID得到对象的方法都学习了，但如何才能查询出多条记录呢？比如我想查询所有姓黄的作者，查询标题包含“中”字的博客等。这一篇就来介绍查询。hiberna...
JAVA hql
sinat_28384025的博客
10-18 174
从Hibernate 3.0.x/3.1.x升级到最新的3.2版之后，3.2版的很多sql函数如count(), sum()的唯一返回值已经从Integer变为Long，如果不升级代码，会得到一个ClassCastException。 COUNT 返回Long对象 MAX MIN 返...
JavaEE之Hibernate（hql查询语句）
xiaoxiaoli0_0的博客
06-07 278
HQL单表查询 ---- Hibernate之查询语句 HQL查询数据 本章节主要学习的是HQL查询方式的单表查询，多表查询在下一章节学习记录； HQL介绍 HQL（Hibernate Query Language）：是hibernate的数据查询方式，HQL是针对持久化对象的，它用来取得对象而不进行update、delete和insert等更新操作，是一种完全面向对象的查询方式，并且具备...
Java自学笔记之Hibernate-单表hql查询语句
tsfx051435adsl的博客
08-17 286
hibernate mysql 简单的单表查询
Java_Hql_Query_Basic
我的博客
03-31 437
hql查询入门
java hql查询_Spring 中常用的hql查询方法(getHibernateTemplate())(转)
weixin_42497828的博客
03-04 246
示例：this.getHibernateTemplate().find(”from bean.User”);返回所有User对象二、find(String queryString , Object value);示例：this.getHibernateTemplate().find(”from bean.User u whereu.name=?”, “test”);或模糊查询：this.getHi...
JAVA Hibernate HQL查询、详解
草根的理想
10-28 3379
本文转载自：http://hi.baidu.com/ceoct/blog/item/7dbf2210504501cba6ef3f78.html    Hibernate Query Language（HQL）提供了十分强大的功能，推荐大家使用这种查询方式。HQL具有与SQL语言类似的语法规范，只不过SQL针对表中字段进行查询，而HQL针对持久化对象，它用来取得对象，而不进行update、dele
java hql_Hibernate之HQL
weixin_29009881的博客
02-16 189
HQL介绍Hibernate中不使用SQL而是有自己的面向对象查询语言,该语言名为Hibernate查询语言(Hibernate Query Language).HQL被有意设计成类似SQL,这样开发人员可以利用已有的SQL知识,降低学习坡度.它支持常用的SQL特性,这些特性被封装成面向对象的查询语言,从某种意义上来说,由HQL是面向对象的,因此比SQL更容易编写.本文将逐渐介绍HQL的特性.查询...
Java Hibernate中使用HQL语句进行数据库查询的要点解析
09-02
HQL是Hibernate框架中提供的关系型数据库操作脚本,当然我们也可以使用原生的SQL语句,这里我们来看一下在Java Hibernate中使用HQL语句进行数据库查询的要点解析:
hql查询（查询所有）
lph2017的博客
02-18 4031
http://blog.csdn.net/yaerfeng/article/details/6969649这一篇文章写的挺好  大家可以参考第一步导包from  实体类名称    这是查询所有调用list获得结果  存在实体类中输出结果一共是三步第一步是    创建对象  第二步      调用方法  获得结果第三步是   输出结果其实查询很简单这是别人博客上的一个人例子   现在能看懂了这些步骤...
java hql查询_java – 加入两个表HQL查询
weixin_39828715的博客
02-16 108
如何使用HQL连接两个表？首先,这是我对两个表的SQL创建查询：CREATE TABLE `subject` (`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,`name` VARCHAR(50) NOT NULL,PRIMARY KEY (`id`))CREATE TABLE `employee` (`id` INT(11) UNSIGNED NOT ...
java hql in_关于java 执行HQL语句的 问题
weixin_39533432的博客
02-20 149
importmapping.TUsers;importjava.sql.Timestamp;importjava.util.List;importorg.springframework.orm.hibernate3.support.HibernateDaoSupport;publicclassSqlConversionextendsHib...import mapping.TUsers;impor...
HQL 语句的执行
weixin_30642029的博客
09-24 228
HQL(Hibernate Query Language)面向对象的查询语言,与sql不同，hql中的对象名是区分大小写的（除了java和属性其它部分不区分大小写）；hql中查的是对象而不是表，并且支持多态；hql主要通过Query来操作。使用步骤：1获取session对象2.编写HQL语句3.创建Query对象4.执行查询，得到查询结果package cn.text.java.cn.happy....
HQL基本语句
carleigh的专栏
06-25 759
HQL基本查询•        查询指定类对应表格的所有记录–        例如：Session session = sessionFactory.openSession();Query query = session.createQuery("from User"); List names = query.list();Iterator iterator =  name
java hql 参数_HQL参数绑定
weixin_29531757的博客
02-25 472
参数绑定：Hibernate中对动态查询参数绑定提供了丰富的支持，那么什么是查询参数动态绑定呢？其实如果我们熟悉传统JDBC编程的话，我们就不难理解查询参数动态绑定，如下代码传统JDBC的参数绑定：PrepareStatement pre=connection.prepare(“select * from User where user.name=?”);pre.setString(1,”zhao...
java hql 查询所有内容,HQL查询语言<转载>
weixin_39640203的博客
03-13 689
上一章介绍了Hibernate的关联映射，在11章的例子中接触到了Hibernate的添加、查询和删除的操作。这一章将介绍Hibernate。Hibernate查询语言为HQL(HibernateQueryLanguage)，可以直接使用实体类名及属性。HQL语法类似于SQL，有SQL的关键词如select、from、orderby、count()、where等等。12.1HQL语言基础H...
java hql 参数_Hibernate查询数据的几种方式以及HQL用法及参数的几种使用方法
weixin_30094815的博客
02-25 447
Hibernate查询数据的几种方式/*** 第一种查询：利用query接口与HQL语句* 1.如果查询所有字段，则list中的元素为POJO对象* 2.如果查询若干字段，则list中的元素为对象数组* 3.如果想返回若干字段的对象，则需要通过 new TUser(username,email)方式*/Java代码publicvoidquery(){Sessionsession=null...
java 图片 hql_Java中hql语句
weixin_31014025的博客
02-24 49
根据刚刚刚我写的。周第一天是int firstDay = cal.getActualMinimum(Calendar.DAY_OF_WEEK);cal.set(Calendar.DAY_OF_WEEK, firstDay);周最后一天是int lastDay = cal.getActualMaximum(Calendar.DAY_OF_WEEK);cal.set(Calendar.DAY_OF_W...
Hibernate HQL语句完全指南
- 在映射文件配置HQL语句：可以在Hibernate的映射文件中预定义HQL语句，方便调用。 1.3 HQL的嵌套子查询 - 嵌套子查询的概念：子查询可以作为另一个查询的一部分，用于筛选满足特定条件的记录。 - `IN`谓词的子查询...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值