hibernate入门--实现简单的数据查询

hibernate入门--实现简单的数据查询目录结构；：

第一步：新建数据库hibernate，再新建数据表Company

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50051
Source Host           : localhost:3306
Source Database       : hibernate

Target Server Type    : MYSQL
Target Server Version : 50051
File Encoding         : 65001

Date: 2017-04-20 18:57:04
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `company`
-- ----------------------------
DROP TABLE IF EXISTS `company`;
CREATE TABLE `company` (
  `id` int(3) NOT NULL auto_increment,
  `name` varchar(10) NOT NULL,
  `url` varchar(50) NOT NULL,
  `creation_date` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of company
-- ----------------------------
INSERT INTO `company` VALUES ('2', '华软', 'http://home.sise.cn/', '2017-04-20');

第二步：新建Company类

package com.hbp;

import java.util.Date;
//创建Company持久化类
public class Company {
	private String url;
	private int id;
	private String name;
	private Date createDate;
	public String getUrl() {
		return url;
	}
	public void setUrl(String url) {
		this.url = url;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Date getCreateDate() {
		return createDate;
	}
	public void setCreateDate(Date createDate) {
		this.createDate = createDate;
	}
	
}

第三步：创建对象-关系映射文件Company.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.hbp">
<!-- name:是Company.java中的数据成员，column:是数据库中的字段名 -->
	<class name="Company">
		<id name="id" column="id">
			<generator class="increment"></generator>
		</id>
		<property name="name" column="name"></property>
		<property name="url" column="url"></property>
		<property name="createDate" column="creation_date"></property>
	</class>
</hibernate-mapping>

第四步：创建主函数ListAllCompany.java，数据的查询

package com.hbp;

import java.util.Iterator;
import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

//查询对象
public class ListAllCompany {

	public static void main(String[] args) {
		//根据hibernate配置文件的配置信息，创建一个configuration实例
		Configuration configuration=new Configuration().configure();
		//新建SessionFactory
		SessionFactory sessionFactory=configuration.buildSessionFactory();
		//打开一个session
		Session session=sessionFactory.openSession();
		try {
			//利用session查询到的信息放到列表中
			List companies=session.createQuery("from Company").list();
			//输出获取到的数据
			for(Iterator iterator=companies.iterator();iterator.hasNext();){
				Company cp=(Company)iterator.next();
				System.out.println(cp.getId()+" "+cp.getName()+" "+cp.getUrl()+" "+cp.getCreateDate().toString());
			}
			
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}finally{
			//最后别忘了关闭session
			session.close();
		}
	}

}

第五步：创建Hibernate.cfg.xml配置文件（数据源配置）

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
		"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
		"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
    	<!-- mysql数据库驱动程序 -->
        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <!-- 数据库用户密码 -->
        <property name="hibernate.connection.password">root</property>
        <!-- 数据库 -->
        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/hibernate</property>
        <!-- 数据库用户名 -->
        <property name="hibernate.connection.username">root</property>
        <!-- 数据库方言 -->
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
        <!-- 在控制台输出数据库查询语句 -->
   		<property name="hibernate.show_sql">true</property>
   		<!-- 输出格式化的数据库查询语句，方便阅读 -->
     	<property name="hibernate.format_sql">true</property>
     <!-- 映射表 -->
   <mapping resource="com/hbp/Company.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

第六步：running