Mybatis完整版crud

Mybatis完整版crud

1、新建maven项目，依赖导入pom

 <dependencies>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.21</version>
        </dependency>
          <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.16</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13.1</version>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
        </resources>
    </build>

2、核心配置文件mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
    <properties resource="log4j.properties"/>
    <typeAliases>
        <typeAlias type="com.sailor.entity.User" alias="User"/>
    </typeAliases>
    <environments default="dev">
        <environment id="dev">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/ssm?serverTimezone=UTC&amp;useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
                <property name="username" value="hlm"/>
                <property name="password" value="hlm200266"/>
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <mapper class="com.sailor.mapper.UserMapper"/>
    </mappers>

</configuration>

3、实体类

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {
    private int id;
    private String name;
    private String gender;
    private String password;
}

4、session工具类

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;

public class MybatisUtil {
    //定义SqlSession工厂
    private static SqlSessionFactory sqlSessionFactory;
    static{
        try {
            //引入核心配置文件
            String resource = "mybatis-config.xml";
            //将配置文件转成流
            InputStream inputStream = Resources.getResourceAsStream(resource);
            //将流传给工厂,创建SqlSession
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    /**
     * 获取SqlSession连接
     */
    public static SqlSession getSession(){
        return sqlSessionFactory.openSession();
    }

    //关闭session的方法
    public void close(){
       SqlSession session = sqlSessionFactory.openSession();
        if (session != null) {
            session.close();
        }
    }
}

5、mapper接口

import org.apache.ibatis.annotations.*;

import java.util.List;

public interface UserMapper {
    //1、查询所有的用户
    @Select("select * from t_user")
    List<User> allaUsers();

    //2、根据id查询用户
    @Select("select * from t_user where id = #{sid}")
    User queryById(@Param("sid") int id);

    //3、增加用户
    @Insert("insert into t_user(id,name,gender,password) values (#{id},#{name},#{gender},#{password})")
    int add(User user);

    //4、修改用户
    @Update("update t_user set name = #{name},gender = #{gender},password = #{password} where id = #{id}")
    int update(User user);

    //5、根据id删除用户
    @Delete("delete from t_user where id = #{sid}")
    int delete(@Param("sid") int id);

}

6、测试

import com.sailor.entity.User;
import com.sailor.mapper.UserMapper;
import com.sailor.utils.MybatisUtil;
import org.apache.ibatis.session.SqlSession;

import java.util.List;

public class Test {

    SqlSession session = MybatisUtil.getSession();
    UserMapper mapper = session.getMapper(UserMapper.class);

    //1、查询所有用户
    @org.junit.Test
    public void testAll(){
        List<User> list = mapper.allaUsers();
        for (User user:list) {
            System.out.println(user);
        }
        session.close();
    }


    //2、根据id查询
    @org.junit.Test
    public void queryById(){
        User user = mapper.queryById(101);
        System.out.println(user);
        session.close();
    }

    //3、增加一个用户
    @org.junit.Test
    public void add(){
        User user = new User(159,"刘翠骏","男","lcj");
        int flag = mapper.add(user);
        System.out.println(flag);
        session.commit();
        session.close();
    }

    //4、修改用户
    @org.junit.Test
    public void update(){
        User user = new User(159,"刘翠骏","女","lcj");
        int flag = mapper.update(user);
        System.out.println(flag);
        session.commit();
        session.close();

    }

    //5、删除用户
    @org.junit.Test
    public void delete(){
        int flag = mapper.delete(158);
        System.out.println(flag);
        session.commit();
        session.close();
    }

}