1.23 mybatis入门

MyBatis 是一款优秀的持久层框架，它支持自定义 SQL、存储过程以及高级映射。
MyBatis 免除了几乎所有的 JDBC 代码以及设置参数和获取结果集的工作。MyBatis 可以通过简单的 XML 或注解来配置和映射原始类型、接口和 Java POJO（Plain Old Java Objects，普通老式 Java 对象）为数据库中的记录。

装服务端：

装客户端：12:59
右击此处，编辑属性

第一次打开是这样一个结构：

左侧是管理数据库的，而我们使用的话
用这个：

右键，select可以查看数据

17.01配置字体

18.00全部装好了


CRUD即增删改查

30.10
导入包：

导入以后
在application.properties进行配置：

# DataSourceProperties 连接池
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver 
spring.datasource.url=jdbc:mysql://localhost:3306/community?characterEncoding=utf-8&useSSL=false&serverTimezone=Hongkong 
spring.datasource.username=root
spring.datasource.password=zhangzhen
spring.datasource.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.hikari.maximum-pool-size=15
spring.datasource.hikari.minimum-idle=5
spring.datasource.hikari.idle-timeout=30000

# MybatisProperties
mybatis.mapper-locations=classpath:mapper/*.xml
mybatis.type-aliases-package=com.nowcoder.community.entity
mybatis.configuration.useGeneratedKeys=true
mybatis.configuration.mapUnderscoreToCamelCase=true

接下来编写实体类：
package com.nowcoder.community.entity;

import java.util.Date;

public class User {

private int id;
private String username;
private String password;
private String salt;
private String email;
private int type;
private int status;
private String activationCode;
private String headerUrl;
private Date createTime;

public int getId() {
    return id;
}

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

public String getUsername() {
    return username;
}

public void setUsername(String username) {
    this.username = username;
}

public String getPassword() {
    return password;
}

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

public String getSalt() {
    return salt;
}

public void setSalt(String salt) {
    this.salt = salt;
}

public String getEmail() {
    return email;
}

public void setEmail(String email) {
    this.email = email;
}

public int getType() {
    return type;
}

public void setType(int type) {
    this.type = type;
}

public int getStatus() {
    return status;
}

public void setStatus(int status) {
    this.status = status;
}

public String getActivationCode() {
    return activationCode;
}

public void setActivationCode(String activationCode) {
    this.activationCode = activationCode;
}

public String getHeaderUrl() {
    return headerUrl;
}

public void setHeaderUrl(String headerUrl) {
    this.headerUrl = headerUrl;
}

public Date getCreateTime() {
    return createTime;
}

public void setCreateTime(Date createTime) {
    this.createTime = createTime;
}

@Override // alt+insert 快捷键，tostring方法，打印的时候方便检查
public String toString() {
    return "User{" +
            "id=" + id +
            ", username='" + username + '\'' +
            ", password='" + password + '\'' +
            ", salt='" + salt + '\'' +
            ", email='" + email + '\'' +
            ", type=" + type +
            ", status=" + status +
            ", activationCode='" + activationCode + '\'' +
            ", headerUrl='" + headerUrl + '\'' +
            ", createTime=" + createTime +
            '}';
}

}
数据访问组件，一般叫什么mapper

package com.nowcoder.community.dao;

import com.nowcoder.community.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;


@Repository//dao层一般用Repository，加此注解才能让spring容器装配这个bean
//mybatis特有的注解 mapper，与Repository功能一样
public interface UserMapper {//声明如下方法：

    User selectById(int id);//User为返回类型

    User selectByName(String username);

    User selectByEmail(String email);

    int insertUser(User user);//返回插入数据的行数

    int updateStatus(int id, int status);//返回修改的条数，status为最新的状态

    int updateHeader(int id, String headerUrl);

    int updatePassword(int id, String password);

}

为了实现，接下来需要写配置文件，写每个方法对应的sql，mybatis底层自动帮我们实现

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.nowcoder.community.dao.UserMapper"><!--表明该配置文件为哪个mapper服务-->

    <sql id="insertFields"><!--每个标签对应一个接口中的方法-->
        username, password, salt, email, type, status, activation_code, header_url, create_time
    </sql>
    <!--sql是什么意思-->
    <sql id="selectFields"> <!--设置待查询的字段-->
        id, username, password, salt, email, type, status, activation_code, header_url, create_time<!--单词容易写错-->
    </sql>

    <!--select标签，实现查询；id里面是方法名；返回类型是User-->
    <select id="selectById" resultType="User">
        select <include refid="selectFields"></include><!--表示引用的是selectFields中的id-->
        from user<!--表示从user中查询-->
        where id = #{id}<!--#{id}表示要引用方法的参数名id，其余id是字段-->
    </select>

    <select id="selectByName" resultType="User">
        select <include refid="selectFields"></include>
        from user
        where username = #{username}
    </select>

    <select id="selectByEmail" resultType="User">
        select <include refid="selectFields"></include>
        from user
        where email = #{email}
    </select>

    <insert id="insertUser" parameterType="User" keyProperty="id">
        insert into user (<include refid="insertFields"></include>)
        values(#{username}, #{password}, #{salt}, #{email}, #{type}, #{status}, #{activationCode}, #{headerUrl}, #{createTime})
    </insert>

    <update id="updateStatus">
        update user set status = #{status} where id = #{id}
    </update>

    <update id="updateHeader">
        update user set header_url = #{headerUrl} where id = #{id}
    </update>

    <update id="updatePassword">
        update user set password = #{password} where id = #{id}
    </update>

</mapper>