分享web开发知识

注册/登录|最近发布|今日推荐

主页 IT知识网页技术软件开发前端开发代码编程运营维护技术分享教程案例
当前位置:首页 > 前端开发

hibernate框架的搭建

发布时间:2023-09-06 01:44责任编辑:蔡小小关键词:暂无标签

1 导入所需的jar包

1 导入hibernate必须的jar包

2 导入驱动包

2 创建数据库,准备表,实体

1 创建hibernate数据库

CREATE DATABASE hibernate;

2 创建cst_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;

3 Customer实体

package www.test.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 + "]"; ???}}

3 书写orm元数据(对象与表的映射配置文件)

<?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="www.test.domain.Customer" table="cst_customer"> ???????<id name="cust_id" column="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>
View Code

1 导入约束

<!DOCTYPE hibernate-mapping PUBLIC ????"-//Hibernate/Hibernate Mapping DTD 3.0//EN" ???"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

2 实体

package www.test.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 + "]"; ???} ???}

3 orm元数据

<!-- 配置表与实体的关系 --><hibernate-mapping> ???<class name="www.test.domain.Customer" table="cst_customer"> ???????<id name="cust_id" column="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>

4.书写主配置文件

<?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> ???????<!-- ????????#hibernate.dialect org.hibernate.dialect.MySQLDialect ???????#hibernate.dialect org.hibernate.dialect.MySQLInnoDBDialect ???????#hibernate.dialect org.hibernate.dialect.MySQLMyISAMDialect ???????#hibernate.connection.driver_class com.mysql.jdbc.Driver ???????#hibernate.connection.url jdbc:mysql:///test ???????#hibernate.connection.username gavin ???????#hibernate.connection.password ????????--> ???????<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> ???????<!-- /// 表示连接本机 --> ???????<property name="hibernate.connection.url">jdbc:mysql:///hibernate</property> ???????<property name="hibernate.connection.username">root</property> ???????<property name="hibernate.connection.password">root</property> ???????<property name="hibernate.dialect">org.hibernate.dialect.MySQLMyISAMDialect</property> ???????????????<!-- ????????#hibernate.show_sql true ?//打印生成的sql ???????#hibernate.format_sql true ?//格式化sql 不格式都会在一行 ????????--> ???????<property name="hibernate.show_sql">true</property> ???????<property name="hibernate.format_sql">true</property> ???????????????<!-- ????????## auto schema export ???????#hibernate.hbm2ddl.auto create-drop ???????#hibernate.hbm2ddl.auto create ???????#hibernate.hbm2ddl.auto update ???????#hibernate.hbm2ddl.auto validate ????????--> ???????<property name="hibernate.hbm2ddl.auto">update</property> ???????????????<mapping resource="www/test/domain/Customer.hbm.xml"/> ???</session-factory></hibernate-configuration>
View Code

1 第一部分

<!-- ????????#hibernate.dialect org.hibernate.dialect.MySQLDialect ???????#hibernate.dialect org.hibernate.dialect.MySQLInnoDBDialect ???????#hibernate.dialect org.hibernate.dialect.MySQLMyISAMDialect ???????#hibernate.connection.driver_class com.mysql.jdbc.Driver ???????#hibernate.connection.url jdbc:mysql:///test ???????#hibernate.connection.username gavin ???????#hibernate.connection.password ????????--> ???????<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> ???????<!-- /// 表示连接本机 --> ???????<property name="hibernate.connection.url">jdbc:mysql:///hibernate</property> ???????<property name="hibernate.connection.username">root</property> ???????<property name="hibernate.connection.password">root</property> ???????<property name="hibernate.dialect">org.hibernate.dialect.MySQLMyISAMDialect</property>

2 第二部分

<!-- ????????#hibernate.show_sql true ?//打印生成的sql ???????#hibernate.format_sql true ?//格式化sql 不格式都会在一行 ????????--> ???????<property name="hibernate.show_sql">true</property> ???????<property name="hibernate.format_sql">true</property> ???????????????<!-- ????????## auto schema export ???????#hibernate.hbm2ddl.auto create-drop ???????#hibernate.hbm2ddl.auto create ???????#hibernate.hbm2ddl.auto update ???????#hibernate.hbm2ddl.auto validate ????????--> ???????<property name="hibernate.hbm2ddl.auto">update</property>

3 第三部分

<mapping resource="www/test/domain/Customer.hbm.xml"/>

5.书写代码测试

package www.test.a_hello;import org.hibernate.Session;import org.hibernate.SessionFactory;import org.hibernate.Transaction;import org.hibernate.cfg.Configuration;import org.junit.Test;import www.test.domain.Customer;// 测试hibernate 框架public class Demo { ???@Test ???//保存客户 ???public void fun1(){ ???????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框架的搭建

原文地址:https://www.cnblogs.com/jepson6669/p/8486056.html

知识推荐

我的编程学习网——分享web前端后端开发技术知识。 垃圾信息处理邮箱 tousu563@163.com 网站地图
icp备案号 闽ICP备2023006418号-8 不良信息举报平台 互联网安全管理备案 Copyright 2023 www.wodecom.cn All Rights Reserved