Hibernate
来源:互联网 发布:淘宝店卖虚拟物品 编辑:程序博客网 时间:2024/06/06 17:39
Hibernate
(开放源代码的对象关系映射框架)
Hibernate的优点:
hibernate对jdbc访问数据库进行轻量级的封装,大大减少了数据访问层繁琐的重复性代码,并且减少了内存消耗,加快运行效率。
hibernate是一个基于jdbc的主流持久层框架,简化DAO层的编码工作
支持多种关系型数据库
可扩展性强
Hibernate
操作:创建数据库和数据表
mysql> create database hibernate;
Query OK, 1 row affected (0.39 sec)
mysql> use hibernate;
Database changed
mysql> 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;
Query OK, 0 rows affected (5.68 sec)
mysql> show table;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '' at
line 1
mysql> show tables;
+---------------------+
| Tables_in_hibernate |
+---------------------+
| cst_customer |
+---------------------+
1 row in set (0.11 sec)
mysql> select * from cst_customer;
Empty set (0.34 sec)
mysql> desc cst_customer;
+---------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+----------------+
| cust_id | bigint(32) | NO | PRI | NULL | auto_increment |
| cust_name | varchar(32) | NO | | NULL | |
| cust_source | varchar(32) | YES | | NULL | |
| cust_industry | varchar(32) | YES | | NULL | |
| cust_level | varchar(32) | YES | | NULL | |
| cust_linkman | varchar(64) | YES | | NULL | |
| cust_phone | varchar(64) | YES | | NULL | |
| cust_mobile | varchar(16) | YES | | NULL | |
+---------------+-------------+------+-----+---------+----------------+
8 rows in set (0.07 sec)
引入hibernate开发包
数据库驱动包
hibernate依赖包
\hibernate-release-5.0.7.Final\lib\required目录下所有jar 包
日志记录包
创建持久化类
package cn.itheima.domain;
public class Customer {
/*
* 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;
*/
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 + "]";
}
}
创建映射文件
<?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 package="cn.itheima.domain">
<class name="Customer" table="cst_customer">
<id name="cust_id">
<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>
创建hibernate核心配置文件
<?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">root</property>
<!-- 数据库方言 不同的数据库中,sql语法略有区别. 指定方言可以让hibernate框架在生成sql语句时.针对数据库的方言生成. sql99标准:
DDL 定义语言 库表的增删改查 DCL 控制语言 事务 权限 DML 操纵语言 增删改查 注意: MYSQL在选择方言时,请选择最短的方言. -->
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<!-- #hibernate.show_sql true #hibernate.format_sql true -->
<!-- 将hibernate生成的sql语句打印到控制台 -->
<property name="hibernate.show_sql">true</property>
<!-- 将hibernate生成的sql语句格式化(语法缩进) -->
<property name="hibernate.format_sql">true</property>
<!-- ## auto schema export 自动导出表结构. 自动建表 #hibernate.hbm2ddl.auto create
自动建表.每次框架运行都会创建新的表.以前表将会被覆盖,表数据会丢失.(开发环境中测试使用) #hibernate.hbm2ddl.auto create-drop
自动建表.每次框架运行结束都会将所有表删除.(开发环境中测试使用) #hibernate.hbm2ddl.auto update(推荐使用) 自动生成表.如果已经存在不会再生成.如果表有变动.自动更新表(不会删除任何数据).
#hibernate.hbm2ddl.auto validate 校验.不自动生成表.每次启动会校验数据库中表是否正确.校验失败. -->
<property name="hibernate.hbm2ddl.auto">update</property>
<!-- 引入orm元数据 路径书写: 填写src下的路径 -->
<mapping resource="cn/itheima/domain/Customer.hbm.xml" />
</session-factory>
</hibernate-configuration>
编写代码进行测试:
- hibernate
- Hibernate
- Hibernate
- Hibernate
- hibernate
- hibernate
- Hibernate
- Hibernate
- Hibernate
- hibernate
- Hibernate
- Hibernate
- hibernate
- hibernate
- hibernate
- Hibernate
- Hibernate
- hibernate
- “机器的崛起”
- 深度优先搜索与宽度优先搜索的知识点归纳
- 斐波那契?
- java入门循序渐进
- 实现View滑动的六种方式
- Hibernate
- JavaCore-OOP-5-简易的【学生信息管理系统】
- JS继承的实现
- Android关于startActivityForResult的一切
- zTree树实现用户权限管理
- urllib基础练习1
- FCN-阅读笔记-理解
- 内部类、匿名类、Lambda表达式
- 【bzoj 1982】Moving Pebbles(博弈论)