# MybatisTest

**Repository Path**: wei_dongdong/mybatis-test

## Basic Information

- **Project Name**: MybatisTest
- **Description**: mybatis学习
- **Primary Language**: Java
- **License**: GPL-3.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-08-30
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# MybatisTest

#### 介绍
mybatis学习

#### 软件架构
软件架构说明


#### 安装教程

##### 1、mybatis入门之crud

###### 1、创建普通maven项目添加依赖

```xml
<dependencies>
    <!--mybatis-->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.4</version>
    </dependency>
    <!--mysql-->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.48</version>
    </dependency>
    <!--lombok-->
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.18.12</version>
    </dependency>
    <!--junit-->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.13</version>
        <scope>test</scope>
    </dependency>
    <!--log4j-->
    <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.17</version>
    </dependency>
</dependencies>
```

###### 2、resources目录下创建创建数据库属性文件jdbc-config.properties

```properties
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/myschool?characterEncoding=utf-8
username=root
password=123456
```

###### 3、resources目录下创建mybatis-config.xml文件

```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="jdbc-config.properties"/>
    
   <!--配置别名-->
    <typeAliases>
        <package name="cn.kgc.pojo"/>
    </typeAliases>
    <!-- 配置环境 -->
    <environments default="mysql">
        <!-- 配置mysql环境 -->
        <environment id="mysql">
            <!--配置事务类型 -->
            <transactionManager type="JDBC"></transactionManager>
            <!--配置数据源（连接池）-->
            <dataSource type="POOLED">
                <!--配置连接数据库的4个基本信息-->
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
    <!--配置sql映射文件-->
    <mappers>
        <mapper resource="mappers/UserMapper.xml"></mapper>
    </mappers>
</configuration>
```

###### 3、创建实体类User.java

```java
@Data
public class User {
    private Integer id;
    private String userName;
    private String password;
}
```

###### 4、创建持久化接口UserDao.java

```java
public interface UserDao {
    /**
     * 按照用户名(模糊)和密码查询
     */
    List<User> getUserByCon(@Param("name") String userName,@Param("pass") String password);
    /**
     * 查询所有用户信息
     */
    List<User> getAllUser();
    /**
     * 根据用户名称模糊查询
     */
    List<User> getUserByName(String userName);

    /**
     * 查询总记录数
     */
   Integer getTotalCount();

    /**
     * 添加用户
     */
    Integer addUser(User user);

    /**
     * 更新用户
     */
    Integer updateUser(User user);

    /**
     * 根据id删除用户
     */
    Integer delUser(Integer id);

}
```

###### 5、resources/mappers目录下创建UserMapper.xml

```xml
<?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="cn.kgc.dao.UserDao">
    <!--根据用户名称和密码查询-->
    <select id="getUserByCon" resultType="user">
        select * from user where userName like concat('%',#{name},'%')
         and password like concat('%',#{pass},'%')
    </select>
     <!--查询所有用户信息-->
    <select id="getAllUser" resultType="user">
        select * from user
    </select>
    <!--根据用户名称模糊查询-->
   <select id="getUserByName" parameterType="string" resultType="user">
       select * from user where userName like concat('%',#{userName},'%')
   </select>
    <!--查询总记录数-->
    <select id="getTotalCount" resultType="int">
        select count(1) from user
    </select>
    <!--增加用户-->
    <insert id="addUser" parameterType="user" >
        insert into user(userName, password) values (#{userName},#{password})
    </insert>
    <!--更新-->
    <update id="updateUser" parameterType="user">
        update user set userName=#{userName},password=#{password}
        where id=#{id}
    </update>
    <!--根据id删除用户-->
    <delete id="delUser" parameterType="int">
        delete  from user where id=#{id}
    </delete>
</mapper>
```

###### 6、Mybatis工具类

```java
public class MyBatisUtil {

    private static SqlSessionFactory sqlSessionFactory;

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

    //创建SqlSession
    public static SqlSession createSqlsession() {
        //创建SqlSession对象
        SqlSession sqlSession=sqlSessionFactory.openSession(true);
        return sqlSession;
    }

    //释放资源
    public static void close(SqlSession sqlSession) {
        if (null != sqlSession) {
            sqlSession.close();
        }
    }
}
```

###### 7、测试方法（接口中按Ctrl + Shift +T，选择junit4）

```java
public class UserDaoTest {
    
    SqlSession sqlsession = MyBatisUtil.createSqlsession();
    UserDao userDao = sqlsession.getMapper(UserDao.class);
    
    @Test
    public void getAllUser()  {
        List<User> userList= userDao.getAllUser();
        System.out.println(userList);
        MyBatisUtil.close(sqlsession);
    }
    @Test
    public void deleteById() {
        Integer count = userDao.deleteById(11);
        if (count>0){
            System.out.println("删除成功");
        }else{
            System.out.println("删除失败");
        }
        MyBatisUtil.close(sqlsession);
    }

    @Test
    public void addUser() {
        User user = new User();
        user.setUserName("hello");
        user.setPassword("556677");
        Integer count = userDao.addUser(user);
        if (count>0){
            System.out.println("添加成功");
        }else{
            System.out.println("添加失败");
        }
        MyBatisUtil.close(sqlsession);
    }

    @Test
    public void queryByUserName() {
        List<User> be = userDao.queryByUserName("be");
        System.out.println(be);
    }

    @Test
    public void updateUser() {
        User user = new User();
        user.setId(10);
        user.setUserName("shen");
        user.setPassword("wwe");
        Integer integer = userDao.updateUser(user);
        System.out.println(integer);
        MyBatisUtil.close(sqlsession);
    }

    @Test
    public void queryByCon() {
        String name = "ad";
        String pass = "in";
        List<User> users = userDao.queryByCon(name, pass);
        System.out.println(users);
        MyBatisUtil.close(sqlsession);
    }

    @Test
    public void countTotail() {
        Integer count = userDao.countTotail();
        System.out.println(count);
        MyBatisUtil.close(sqlsession);
    }
}
```

#### 使用说明

1.  xxxx
2.  xxxx
3.  xxxx

#### 参与贡献

1.  Fork 本仓库
2.  新建 Feat_xxx 分支
3.  提交代码
4.  新建 Pull Request


#### 码云特技

1.  使用 Readme\_XXX.md 来支持不同的语言，例如 Readme\_en.md, Readme\_zh.md
2.  码云官方博客 [blog.gitee.com](https://blog.gitee.com)
3.  你可以 [https://gitee.com/explore](https://gitee.com/explore) 这个地址来了解码云上的优秀开源项目
4.  [GVP](https://gitee.com/gvp) 全称是码云最有价值开源项目，是码云综合评定出的优秀开源项目
5.  码云官方提供的使用手册 [https://gitee.com/help](https://gitee.com/help)
6.  码云封面人物是一档用来展示码云会员风采的栏目 [https://gitee.com/gitee-stars/](https://gitee.com/gitee-stars/)