hibernate5 增加、修改、删除和执行SQL

一、环境

1、hibernate 5.3.1.Final

 Maven POM格式

<!-- hibernate -->
    <dependency>
      <groupId>org.hibernate</groupId>
      <artifactId>hibernate-core</artifactId>
      <version>5.3.1.Final</version>
    </dependency>

2、IDE IntelliJ IDEA 2020

版本很关键，不写版本号发技术文章就是耍流氓

二、新增、修改、删除和执行SQL语句

2.1 User实体类，使用注解就可以了不用创建表对应的*.hbm.xml文件了。减少维护和出错率。使用

Lombok减少代码量，Lombok的POM格式
  

<!-- lombok from repository 简化实体类代码-->
    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
    </dependency>
package com.yadinghao.entity.po;
 
import lombok.Data;
import javax.persistence.Entity;
import javax.persistence.Id;
 
@Data
@Entity(name = "user")
public class User {
    public  String age;
    @Id
    public String name;
}

2.2 实际代码

package com.yadinghao.demo;
 
import com.yadinghao.entity.po.User;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
import org.hibernate.query.NativeQuery;
import org.hibernate.query.Query;
import org.hibernate.service.ServiceRegistry;
 
import javax.jws.soap.SOAPBinding;
import java.sql.SQLException;
import java.util.List;
 
public class hibernatedemo {
    //POJO 创建数据库表
    public static void main(String[] args) {
        Configuration config = new Configuration();
        //config.configure("hibernate.cfg.xml");
        // 创建工厂
        ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder().configure("hibernate.cfg.xml").build();
        SessionFactory sessionFactory = config.buildSessionFactory(serviceRegistry);
        // creating session object
        Session session = sessionFactory.openSession();
 
        User user= new User();
        user.setAge("41");
        user.setName("张渔歌");
        session.beginTransaction();
        session.save(user); //新增
        session.update(user);//修改
        session.delete(user);//删除
        session.getTransaction().commit();
 
        String sql = "select name,age from user";
 
        Query<User> query = session.createNativeQuery(sql,User.class);
 
        //session.get("name");
        // 3）获得结果
        List<User> list = query.list();
        System.out.println(list.size());
        for(User u : list){
            System.out.println(u.getName()+":"+u.getAge());
        }
    }
 
}

session.save(user); //新增
session.update(user);//修改
session.delete(user);//删除

这组方法应该通用

执行SQL语句就不通用了。之前的SQLQuery、addEntity都废弃了。

好了就写到这吧