hibernate框架属于dao层,类似dbutils的作用,是一款ORM(对象关系映射)操作
使用hibernate框架好处是:操作数据库不需要写SQL语句,使用面向对象的方式完成
这里使用eclipse工具搭建:
官网下载:https://sourceforge.net/projects/hibernate/files/hibernate-orm/5.0.7.Final/
下载.zip文件后解压:
lib文件夹下的required文件夹内的jar包为必须包:
另外还需要MySQL的驱动包:
mysql-connector-java-5.1.7-bin.jar
放入WEB-INFO的lib中:
导入包完成:
导入约束:
复制这里的dtd文件以及文件中的这一行:
上边是文件路径,下边粘贴复制的那一行
数据库创建一个表,做示例:
CREATE TABLE `cst_customer` ( ?????`cust_id` BIGINT(32) NOT NULL AUTO_INCREMENT COMMENT ‘客户编号(主键)‘, ?????`cust_name` VARCHAR(32) NOT NULL COMMENT ‘客户名称(公司名称)‘, ?????`cust_source` VARCHAR(32) DEFAULT NULL COMMENT ‘客户信息来源‘, ?????`cust_industry` VARCHAR(32) DEFAULT NULL COMMENT ‘客户所属行业‘, ?????`cust_level` VARCHAR(32) DEFAULT NULL COMMENT ‘客户级别‘, ?????`cust_linkman` VARCHAR(64) DEFAULT NULL COMMENT ‘联系人‘, ?????`cust_phone` VARCHAR(64) DEFAULT NULL COMMENT ‘固定电话‘, ?????`cust_mobile` VARCHAR(16) DEFAULT NULL COMMENT ‘移动电话‘, ?????PRIMARY KEY (`cust_id`) ???) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
src下新建一个domain实体包:
Customer类:
package domain;public class Customer { ???????private Long cust_id; ???private String cust_name; ???private String cust_source; ???private String cust_industry; ???private String cust_level; ???private String cust_linkman; ???private String cust_phone; ???private String cust_mobile; ???public Long getCust_id() { ???????return cust_id; ???} ???public void setCust_id(Long cust_id) { ???????this.cust_id = cust_id; ???} ???public String getCust_name() { ???????return cust_name; ???} ???public void setCust_name(String cust_name) { ???????this.cust_name = cust_name; ???} ???public String getCust_source() { ???????return cust_source; ???} ???public void setCust_source(String cust_source) { ???????this.cust_source = cust_source; ???} ???public String getCust_industry() { ???????return cust_industry; ???} ???public void setCust_industry(String cust_industry) { ???????this.cust_industry = cust_industry; ???} ???public String getCust_level() { ???????return cust_level; ???} ???public void setCust_level(String cust_level) { ???????this.cust_level = cust_level; ???} ???public String getCust_linkman() { ???????return cust_linkman; ???} ???public void setCust_linkman(String cust_linkman) { ???????this.cust_linkman = cust_linkman; ???} ???public String getCust_phone() { ???????return cust_phone; ???} ???public void setCust_phone(String cust_phone) { ???????this.cust_phone = cust_phone; ???} ???public String getCust_mobile() { ???????return cust_mobile; ???} ???public void setCust_mobile(String cust_mobile) { ???????this.cust_mobile = cust_mobile; ???} ???@Override ???public String toString() { ???????return "Customer [cust_id=" + cust_id + ", cust_name=" + cust_name + "]"; ???}}
在domain包中,需要配置文件:Customer.hbm.xml
配置的具体参数含义后边再讲:
<?xml version="1.0" encoding="UTF-8"?><!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="domain.Customer" table="cst_customer" > ???????<id name="cust_id" ?> ???????????<!-- generator:主键生成策略 --> ???????????<generator class="native"></generator> ???????</id> ???????<property name="cust_name" column="cust_name" ></property> ???????<property name="cust_source" column="cust_source" ></property> ???????<property name="cust_industry" column="cust_industry" ></property> ???????<property name="cust_level" column="cust_level" ></property> ???????<property name="cust_linkman" column="cust_linkman" ></property> ???????<property name="cust_phone" column="cust_phone" ></property> ???????<property name="cust_mobile" column="cust_mobile" ></property> ???</class></hibernate-mapping>
核心配置文件:src目录下:
hibernate.cfg.xml(注意名字不能改)
这里没有写注释的在后边详细介绍
<?xml version="1.0" encoding="UTF-8"?><!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> ???????<!-- 数据库url --> ???????<property name="hibernate.connection.url">jdbc:mysql:///hibernate</property> ???????<!-- 数据库连接用户名 --> ???????<property name="hibernate.connection.username">root</property> ???????<!-- 数据库连接密码 --> ???????<property name="hibernate.connection.password">xuyiqing</property> ???????????????<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> ???????<!-- 将hibernate生成的sql语句打印到控制台 --> ???????<property name="hibernate.show_sql">true</property> ???????<!-- 将hibernate生成的sql语句格式化(语法缩进) --> ???????<property name="hibernate.format_sql">true</property> ???????????????<property name="hibernate.hbm2ddl.auto">update</property> ???????<!-- 引入orm元数据 路径书写: 填写src下的路径 --> ???????<mapping resource="domain/Customer.hbm.xml" /> ???</session-factory></hibernate-configuration>
好,到这里配置文件完成:
书写代码测试:
package test;import org.hibernate.Session;import org.hibernate.SessionFactory;import org.hibernate.Transaction;import org.hibernate.cfg.Configuration;import org.junit.Test;import domain.Customer;//测试Hibernate框架public class Demo { ???????@Test ???//保存 ???public void function1(){ ???????Configuration conf = new Configuration().configure(); ???????SessionFactory sessionFactory = conf.buildSessionFactory(); ???????Session session = sessionFactory.openSession(); ???????Transaction tx = session.beginTransaction(); ???????????????Customer customer = new Customer(); ???????customer.setCust_name("腾讯"); ???????session.save(customer); ???????????????tx.commit(); ???????session.close(); ???????sessionFactory.close(); ???}}
结果:
查看数据库,成功添加一条新数据
搭建测试完毕
hibernate框架学习笔记1:搭建与测试
原文地址:https://www.cnblogs.com/xuyiqing/p/8445760.html