jpa初学 hibernate学习

目前很火的一款跟数据库打交道的框架hebernate，这款框架在国外很欢迎，开发确实非常的方便简洁，走一波教程！
看完就会！！！

实体类manager

package cn.com.zzn.model;

import javax.persistence.*;
import java.sql.Timestamp;
import java.util.Objects;

@Entity(name = "manager")  //对应表名
public class Manager {
    private int id;
    private String loginId;
    private String realName;
    private String pwd;
    private Integer loginCount;
    private Timestamp lastLoginDt;

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)//自增
    @Column(name = "id", nullable = false)
    public int getId() {
        return id;
    }

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

    @Basic
    @Column(name = "loginId", nullable = false, length = 20)
    public String getLoginId() {
        return loginId;
    }

    public void setLoginId(String loginId) {
        this.loginId = loginId;
    }

    @Basic
    @Column(name = "realName", nullable = true, length = 10)
    public String getRealName() {
        return realName;
    }

    public void setRealName(String realName) {
        this.realName = realName;
    }

    @Basic
    @Column(name = "pwd", nullable = true, length = 200)
    public String getPwd() {
        return pwd;
    }

    public void setPwd(String pwd) {
        this.pwd = pwd;
    }

    @Basic
    @Column(name = "loginCount", nullable = true)
    public Integer getLoginCount() {
        return loginCount;
    }

    public void setLoginCount(Integer loginCount) {
        this.loginCount = loginCount;
    }

    @Basic
    @Column(name = "lastLoginDt", nullable = true)
    public Timestamp getLastLoginDt() {
        return lastLoginDt;
    }

    public void setLastLoginDt(Timestamp lastLoginDt) {
        this.lastLoginDt = lastLoginDt;
    }

    @Override
    public boolean equals(Object o) {
        if (this == o) return true;
        if (o == null || getClass() != o.getClass()) return false;
        Manager manager = (Manager) o;
        return Objects.equals(id, manager.id) && Objects.equals(loginId, manager.loginId) && Objects.equals(realName, manager.realName) && Objects.equals(pwd, manager.pwd) && Objects.equals(loginCount, manager.loginCount) && Objects.equals(lastLoginDt, manager.lastLoginDt);
    }

    @Override
    public int hashCode() {
        return Objects.hash(id, loginId, realName, pwd, loginCount, lastLoginDt);
    }
}

接口文件(ManagerDao)

package cn.com.zzn.until;

import cn.com.zzn.model.Manager;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

@Repository //库 springboot自动托管的
//CrudRepository<Manager,Integer> 第一个参数实体类第二个参数主键类型
public interface ManagerDao extends CrudRepository<Manager,Integer> {
    //sqlserver没有limit要用top1    //查询登录次数最大的一个数
    @Query(value = "select * from manager order by loginCount desc limit 1",nativeQuery = true)
    public Manager findByMaxLoginCount();

//
@Query(value = "select loginCount from manager order by loginCount desc limit 1",nativeQuery = true)
public Integer findByMaxLoginCount2();


    //查询范围数字
    @Query(value = "select loginId,realName from manager where id >:min and id<:max ",nativeQuery = true)
    public List<Map<String,String>> findByLoginIdRealNameById(Integer min, Integer max);

    //根据loginId查数据
    public Manager findByLoginId(String loginId);

    //只查loginId + realName
//    @Query(value = "select loginId,realName from manager where  ")
//    public Map<Integer,String> findByLoginIdRealName();

    }

application.properties文件

spring.datasource.url=jdbc:mysql://localhost:3306/travelmanage?userUnicode=true&characterEncoding=UTF-8
spring.datasource.username=travelmanage
spring.datasource.password=travelmanage
#hebernate字段设置
spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
#根据实体类的表创建表 危险 会删除以前的表重新创建会清空数据，切记他会删除所有的数据库表再创建
#spring.jpa.hibernate.ddl-auto=create

#更新
spring.jpa.hibernate.ddl-auto=update

#打印日志
spring.jpa.show-sql=true