《Hibernate 系列》- Hql语法

最新推荐文章于 2018-05-11 12:39:46 发布

weixin_34067049

最新推荐文章于 2018-05-11 12:39:46 发布

阅读量92

点赞数

文章标签： java 数据库 python

原文链接：https://my.oschina.net/kimisme/blog/1604849

版权

2019独角兽企业重金招聘Python工程师标准>>>

跟我学

项目结构

--src/main/java
----com.easy.c_hql
------HibernateUtils.java
------TestApp.java
------User.java
------hibernate.cfg.xml
------User.hbm.xml

User.java

public class User {
	private Integer id;
	private String username;
	private Integer age;

User.hbm.xml

<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
	<class name="com.easy.c_hql.User" table="t_user">
		<id name="id" column="ID">
			<generator class="native"></generator>
		</id>
		<property name="username" column="UserName"></property>
		<property name="age" column="Age"></property>
	</class>
</hibernate-mapping>

hibernate.cfg.xml

<!DOCTYPE hibernate-configuration PUBLIC
	"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
	"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
	<session-factory>
		<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/test</property>
		<property name="hibernate.connection.username">root</property>
		<property name="hibernate.connection.password">123456</property>
		
		<property name="show_sql">true</property>
		<property name="format_sql">true</property>
		
		<property name="hbm2ddl.auto">update</property>
		<mapping resource="com/easy/c_hql/User.hbm.xml"/>
	</session-factory>
</hibernate-configuration>

HibernateUtils.java

public class HibernateUtils {
	private static SessionFactory sessionFactory;
	static{
		URL url=HibernateUtils.class.getClass().getResource("/com/easy/c_hql/hibernate.cfg.xml");
		Configuration conf=new Configuration().configure(url);
		
		sessionFactory =conf.buildSessionFactory();
		
		Runtime.getRuntime().addShutdownHook(new Thread(
				new Runnable() {
					@Override
					public void run() {
						System.out.println("虚拟机关闭，释放资源");
						sessionFactory.close();
					}
				}));
	}
	
	public static Session openSession(){
		return sessionFactory.openSession();
	}
	
	public static Session getCurrentSession(){
		return sessionFactory.getCurrentSession();
	}
}

UT

查询多行数据

public void test_query_multi_rows(){                              
	Session session = HibernateUtils.openSession();               
	                                                              
	Query query = session.createQuery("from com.easy.c_hql.User");
	List<User>list=query.list();                                  
	System.out.println(list);                                     
	                                                              
	session.close();                                              
}

查询单行数据

public void test_query_single_row(){                                              
	Session session = HibernateUtils.openSession();                               
	                                                                              
	Query query = session.createQuery("from com.easy.c_hql.User u where u.id=1"); 
	User user =(User)query.uniqueResult();                                        
	System.out.println(user);                                                     
	                                                                              
	session.close();                                                              
}

转载于:https://my.oschina.net/kimisme/blog/1604849