持久层框架hibernate

作者: Java成长记_Camel | 来源:发表于2019-01-11 13:24 被阅读20次

JAVAEE框架学习——Hibernate——Hibernate
JAVAEE框架学习——Hibernate——持久化
持久层框架hibernate
Hibernate入门（一）之基本配置
Java mac idea hibernate的使用01
hibernate (持久层框架)
SSH框架
重拾Java EE——Hibernate（1）基础篇
Hibernate 的基于XML与基于注解的使用
JAEE学习笔记（28）Hibernate（1）

接Spring MVC框架（1）的方法

Hibernate:持久层全自动化的框架
hibernate 用的少了因为现在mybatis用的多
接下来 hibernate框架要链接数据库blog

/*
Navicat MySQL Data Transfer

Source Server         : springdemo
Source Server Version : 50713
Source Host           : localhost:3306
Source Database       : blog

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

Date: 2019-01-02 10:40:09
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for blog
-- ----------------------------
DROP TABLE IF EXISTS `blog`;
CREATE TABLE `blog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `content` varchar(255) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `pub_date` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id_idx` (`user_id`),
  CONSTRAINT `FKpxk2jtysqn41oop7lvxcp6dqq` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
  CONSTRAINT `user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of blog
-- ----------------------------
INSERT INTO `blog` VALUES ('1', 'SpringMVC', '这是SpringMVC的真的很简单。TEST TEST TEST', '2', '2015-03-18');
INSERT INTO `blog` VALUES ('5', 'zjjlive', 'asdf', '2', '2017-08-13');

数据库user

/*
Navicat MySQL Data Transfer

Source Server         : springdemo
Source Server Version : 50713
Source Host           : localhost:3306
Source Database       : blog

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

Date: 2019-01-02 10:40:19
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nickname` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  `first_name` varchar(45) DEFAULT NULL,
  `last_name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'Steve1234', 'gaussic2', 'Steve', 'NoJob');
INSERT INTO `user` VALUES ('2', 'Bill', '111111', 'Bill', 'Gates');
INSERT INTO `user` VALUES ('3', 'Mark', '22222', 'Mark', 'Zuckerberg');
INSERT INTO `user` VALUES ('4', 'gauss', '11111111', 'Gaussic', 'D');
INSERT INTO `user` VALUES ('6', '全民编程123', '111111', 'asdf123', 'fff123');
INSERT INTO `user` VALUES ('7', 'zjjlive_test', '123456', 'zjj123', 'live');

2.然后写bean
BlogEntity.java

package com.foreknow.model;



import javax.persistence.*;
import java.sql.Date;

@Entity
@Table(name = "blog", schema = "blog", catalog = "")
public class BlogEntity {
    private int id;
    private String title;
    private String content;
    private Date pubDate;
    private UserEntity userByUserId;

    @Id
    @Column(name = "id", nullable = false)
    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    @Basic
    @Column(name = "title", nullable = false, length = 100)
    public String getTitle() {
        return title;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    @Basic
    @Column(name = "content", nullable = true, length = 255)
    public String getContent() {
        return content;
    }

    public void setContent(String content) {
        this.content = content;
    }

    @Basic
    @Column(name = "pub_date", nullable = false)
    public Date getPubDate() {
        return pubDate;
    }

    public void setPubDate(Date pubDate) {
        this.pubDate = pubDate;
    }

    @Override
    public boolean equals(Object o) {
        if (this == o) return true;
        if (o == null || getClass() != o.getClass()) return false;

        BlogEntity that = (BlogEntity) o;

        if (id != that.id) return false;
        if (title != null ? !title.equals(that.title) : that.title != null) return false;
        if (content != null ? !content.equals(that.content) : that.content != null) return false;
        if (pubDate != null ? !pubDate.equals(that.pubDate) : that.pubDate != null) return false;

        return true;
    }

    @Override
    public int hashCode() {
        int result = id;
        result = 31 * result + (title != null ? title.hashCode() : 0);
        result = 31 * result + (content != null ? content.hashCode() : 0);
        result = 31 * result + (pubDate != null ? pubDate.hashCode() : 0);
        return result;
    }

    @ManyToOne
    @JoinColumn(name = "user_id", referencedColumnName = "id", nullable = false)
    public UserEntity getUserByUserId() {
        return userByUserId;
    }

    public void setUserByUserId(UserEntity userByUserId) {
        this.userByUserId = userByUserId;
    }
}

UserEntity.java

package com.foreknow.model;




import javax.persistence.*;
import java.util.Collection;

@Entity
@Table(name = "user", schema = "blog", catalog = "")
public class UserEntity {
    private int id;
    private String nickname;
    private String password;
    private String firstName;
    private String lastName;
    private Collection<BlogEntity> blogsById;

    @Id
    @Column(name = "id", nullable = false)
    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    @Basic
    @Column(name = "nickname", nullable = false, length = 45)
    public String getNickname() {
        return nickname;
    }

    public void setNickname(String nickname) {
        this.nickname = nickname;
    }

    @Basic
    @Column(name = "password", nullable = false, length = 45)
    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Basic
    @Column(name = "first_name", nullable = true, length = 45)
    public String getFirstName() {
        return firstName;
    }

    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }

    @Basic
    @Column(name = "last_name", nullable = true, length = 45)
    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    @Override
    public boolean equals(Object o) {
        if (this == o) return true;
        if (o == null || getClass() != o.getClass()) return false;

        UserEntity that = (UserEntity) o;

        if (id != that.id) return false;
        if (nickname != null ? !nickname.equals(that.nickname) : that.nickname != null) return false;
        if (password != null ? !password.equals(that.password) : that.password != null) return false;
        if (firstName != null ? !firstName.equals(that.firstName) : that.firstName != null) return false;
        if (lastName != null ? !lastName.equals(that.lastName) : that.lastName != null) return false;

        return true;
    }

    @Override
    public int hashCode() {
        int result = id;
        result = 31 * result + (nickname != null ? nickname.hashCode() : 0);
        result = 31 * result + (password != null ? password.hashCode() : 0);
        result = 31 * result + (firstName != null ? firstName.hashCode() : 0);
        result = 31 * result + (lastName != null ? lastName.hashCode() : 0);
        return result;
    }

    @OneToMany(mappedBy = "userByUserId")
    public Collection<BlogEntity> getBlogsById() {
        return blogsById;
    }

    public void setBlogsById(Collection<BlogEntity> blogsById) {
        this.blogsById = blogsById;
    }
}

导入之后的话报错是因为没有hibernate 的库需要导入库 pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.neusoft.maven_springmvchibernate</groupId>
  <artifactId>springmvc_hibernate</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>war</packaging>
  
    <properties>
        <spring.version>4.2.6.RELEASE</spring.version>
        <hibernate.version>5.1.0.Final</hibernate.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>3.8.1</version>
            <scope>test</scope>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.springframework/spring-core -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-core</artifactId>
            <version>4.2.5.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>4.2.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>${spring.version}</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.data</groupId>
            <artifactId>spring-data-jpa</artifactId>
            <version>1.10.1.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-entitymanager</artifactId>
            <version>${hibernate.version}</version>
        </dependency>

        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-c3p0</artifactId>
            <version>${hibernate.version}</version>
        </dependency>

        <dependency>
            <groupId>com.mchange</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.5.2</version>
        </dependency>

        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.39</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
            <scope>provided</scope>
        </dependency>
    </dependencies>
</project>

然后写Dao层
1.BlogRepository.java

package com.foreknow.repository;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

import com.foreknow.model.BlogEntity;
@Repository
public interface BlogRepository extends JpaRepository<BlogEntity, Integer> {
     
}

2.bean UserRepository.java

package com.foreknow.repository;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import com.foreknow.model.UserEntity;
@Repository
public interface UserRepository extends JpaRepository<UserEntity, Integer> {
     @Modifying      // 说明该方法是修改操作
     @Transactional  // 说明该方法是事务性操作
        //Hibernate是完全面向对象来操作数据库的
        //所有的操作都是面向POJO来编程的
        //:qNickname占位符
        //定义查询
        //@Param注解用于提取参数
        //HQL ：Hibernate中的查询方式
        @Query("update UserEntity us " +
                "set us.nickname=:qNickname, us.firstName=:qFirstName, " +
                "us.lastName=:qLastName, us.password=:qPassword where us.id=:qId")
        public void updateUser
                (@Param("qNickname") String nickname, @Param("qFirstName") String firstName,
                 @Param("qLastName") String qLastName, @Param("qPassword") String password, @Param("qId") Integer id);

}

其中注解@Repository
直接继承于 JpaRepository<UserEntity, Integer> 的接口指向JAVA bean的一张表，第二个参数是类型
实现类不用写只要是继承然后你就不用写增删改查的方法直接在接口用调用简单的SQL就可以
如果要是复杂的SQL 就要用到 HQL语音编写SQL 没有mybatis中对于SQL语言原生的方便
所以现在公司用的mybatis多

注意

1.bean 和数据库中的表的属性名必须一样

问题

hibernate这个是怎么自动生成的？

JAVAEE框架学习——Hibernate——Hibernate
Hibernate概述 Hibernate是什么 Hibernate是当今主流的java持久层框架。具有简单易学、...
JAVAEE框架学习——Hibernate——持久化
Hibernate持久化类的编写规则持久化类 Hibernate是持久层的ORM映射框架，专注于数据的持久化操作...
持久层框架hibernate
接Spring MVC框架（1）的方法 Hibernate:持久层全自动化的框架hibernate 用的少了 ...
Hibernate入门（一）之基本配置
Hibernate是什么? Hibernate是一个开源的持久层ORM(对象关系映射)框架. Hibernate能...
Java mac idea hibernate的使用01
1. hibernate简介 1.1 什么是hibernate？ hibernate是一个持久层的ORM框架ORM...
hibernate (持久层框架)
1.主键关联--在同一张表中出现建表语句 2.外键关联（需要再建另一张表存放用户的身份证信息）用户与身份证信息...
SSH框架
1.概述 SSH框架：Struts框架，基于MVC模式的应用层框架技术。Hibernate: 基于持久层的框架（数...
重拾Java EE——Hibernate（1）基础篇
1.框架体系结构 2.hibernate入门 2.1 ORM框架 Hibernate是一个数据持久化层的ORM框架...
Hibernate 的基于XML与基于注解的使用
1. Hibernate简介 Hibernate 是一个持久层的 ORM 框架。ORM映射：Object Rela...
JAEE学习笔记（28）Hibernate（1）
Hibernate 2017/6/6 23:55:09内容总结: Hibernate框架: 就是一个持久层的ORM...