mybatis

MyBatis基础

1、MyBatis使用

注意事项
1.导入依赖（mybatis驱动，mybatis)
2.设置资源路径(resource)
3.编写mybatis-config.xml配置文件
4.编写实体类，编写接口，测试
5.增删改需要提交事务(Transaction)

导入依赖

<!--        mybatis驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.19</version>
        </dependency>
        <!--        mybatis-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
        </dependency>

        <!--        日志-->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>


		<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>

2、第一个MyBatis程序

//Mapper接口
public interface UserMapper {
   
    //查询全部用户
    List<User> getUserList();

    //根据id查询
    User getUserById(int id);

    //insert一个用户
    int addUser(User user);

    //update一个用户
    int updateUser(User user);

    //delete一个用户
    int deleteUser(int id);
}

//工具类
public class MybatisUtils {
   

    private static SqlSessionFactory sqlSessionFactory;

    static {
   
        try {
   
            String resource = "mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
   
            e.printStackTrace();
        }
    }

    public static SqlSession getSqlSession() {
   
        return sqlSessionFactory.openSession();
    }
}

//测试类
 @Test
    public void getUserById(){
   
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User userById = mapper.getUserById(1);
        System.out.println(userById