hibernate中的查询(一)
来源:互联网 发布:记账软件 共享 编辑:程序博客网 时间:2024/05/22 01:29
1:pojo
package com.hibernate1.entity;
import java.io.Serializable;
public class User implements Serializable {
private Integer id;
private String loginName;
private String loginPwd;
private String realName;
private String address;
private String phone;
private String email;
public User() {
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getLoginName() {
return loginName;
}
public void setLoginName(String loginName) {
this.loginName = loginName;
}
public String getLoginPwd() {
return loginPwd;
}
public void setLoginPwd(String loginPwd) {
this.loginPwd = loginPwd;
}
public String getRealName() {
return realName;
}
public void setRealName(String realName) {
this.realName = realName;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
@Override
public String toString() {
return "User [id=" + id + ", loginName=" + loginName + ", loginPwd="
+ loginPwd + ", realName=" + realName + ", address=" + address
+ ", phone=" + phone + ", email=" + email + "]";
}
}
2: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="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://127.0.0.1:3306/mydatabase</property>
<property name="connection.username">root</property>
<property name="connection.password">123456</property>
<property name="show_sql">true</property>
<property name="format_sql">true</property>
<property name="hbm2ddl.auto">update</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<mapping resource="com/hibernate1/entity/User.hbm.xml"/>
</session-factory>
</hibernate-configuration>
3:user.hbm.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<!--对象映射文件-->
<class name="com.hibernate1.entity.User" table="users" catalog="mydatabase">
<id name="id" type="java.lang.Integer">
<column name="id"/>
<!--指定主键的生成方式 -->
<generator class="native"></generator>
</id>
<property name="loginName" type="java.lang.String">
<column name="login_name" length="20"/>
</property>
<property name="loginPwd" type="java.lang.String">
<column name="login_pwd" length="20"/>
</property>
<property name="realName" type="java.lang.String">
<column name="real_name" length="20"/>
</property>
<property name="address" type="java.lang.String">
<column name="Address"/>
</property>
<property name="phone" type="java.lang.String">
<column name="Phone"/>
</property>
<property name="email" type="java.lang.String">
<column name="Email"/>
</property>
</class>
</hibernate-mapping>
4:test
package com.test;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.query.Query;
import com.hibernate1.entity.User;
import java.util.List;
import java.util.Iterator;
public class TestHQL {
public static void main(String[] args) {
new TestHQL().test_HQL1();
}
public void test_HQL1()
{
Configuration configuare = new Configuration().configure();
SessionFactory sessionFactory = configuare.buildSessionFactory();
Session session = sessionFactory.openSession();
Transaction transaction = session.beginTransaction();
String hql="from User";
Query query=session.createQuery(hql);
List list=query.list();
Iterator iter=list.iterator();
while(iter.hasNext()){
User user=(User)iter.next();
System.out.println(user);
}
transaction.commit();
// 7:关闭session
session.close();
// 8:关闭sessionFactory
sessionFactory.close();
}
}
- hibernate中的查询(一)
- Hibernate查询(一)
- Hibernate中的三种查询HQL、Criteria、Sql学习(一)
- Spring中的Hibernate(一)
- Hibernate查询方式总结(一)
- Hibernate级联查询(多对一)
- Hibernate 查询 Projections 类使用 (一)
- Hibernate高级查询一
- Hibernate查询方式(一)
- 【Hibernate】Hibernate中的QBC查询
- Hibernate中的Query cache(查询缓存)
- Hibernate 中的 Criteria 查询。
- Hibernate中的复杂查询
- hibernate中的hql查询
- Hibernate中的命名查询
- Hibernate中的命名查询
- hibernate中的查询语句
- Hibernate 中的 Criteria 查询。
- 流程控制
- java之物件导向程式设计(一)
- LINUX: 配置自己的网卡信息
- 【学习笔记】第十四章 类型信息
- HIVE之 将写好的sql 语句赋值到窗口, 出现“Display all 475 possibilities? (y or n)”问题
- hibernate中的查询(一)
- Swift、OC、C++混合编程
- Java 多态
- I/O多路转接
- Leetcode 151 Reverse Words in a String
- R中加载包失败,提示无法连接到服务器时的解决办法
- One for all, all for one
- call 方法
- 微信小程序开发过程中遇到的问题