我的第一个Mybatis应用程序

最新推荐文章于 2021-06-11 21:30:25 发布

Lkun_99

最新推荐文章于 2021-06-11 21:30:25 发布

阅读量153

点赞数

分类专栏： Mybatis学习文章标签： mybatis maven java jdbc

本文链接：https://blog.csdn.net/qq_38056518/article/details/104382327

版权

Mybatis学习专栏收录该内容

1 篇文章 0 订阅

订阅专栏

我的第一个Mybatis程序

1.使用工具和依赖

Maven + idea
mysql-connector-java + mybatis + junit

2.创建项目

使用idea创建maven项目，然后把src目录删掉，作为父项目，接着新建一个模块
项目截图
$C:\Users\15067\AppData\Roaming\Typora\typora-user-images\image-20200218201751517.png$

pom.xml文件

父项目

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
<!--父工程-->
    <groupId>com.kun.mybatis</groupId>
    <artifactId>mybatis-study</artifactId>
    <packaging>pom</packaging>
    <version>1.0-SNAPSHOT</version>
<!--子模块-->
    <modules>
        <module>mybatis-01</module>
    </modules>

    <dependencies>
        <!--mysql-connector-java-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.29</version>
        </dependency>
        <!--mybatis-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.3</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>
    </dependencies>
    <!--在build中配置resource，防止我们的资源导出失败的问题-->
    <build>
        <resources>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>
</project>

子项目

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <parent>
        <artifactId>mybatis-study</artifactId>
        <groupId>com.kun.mybatis</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>mybatis-01</artifactId>

    <!--在build中配置resource，防止我们的资源导出失败的问题-->
    <build>
        <resources>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>
</project>

3.具体实现

3.1创建mybatis的mybatis-config.xml

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="mysqlconfig.properties"/>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="com/kun/dao/UserMapper.xml"/>
    </mappers>
</configuration>

从配置文件中读取myql的连接配置，mysqlconfig.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/student?useUnicode=true&character=utf8&useSSL=true
username=root
password=123456

3.2创建mybatis的utls工具类

新建代码MybatisUtils,用来获取SqlSession

//SqlSessionFactory-->SqlSession
public class MybatisUtils {
    //全局作用域
    private static SqlSessionFactory sqlSessionFactory;
    //使用了单例
    static{
        try {
            //获取SqlSessionFactory对象
            String resource = "mybatis-config.xml";
            InputStream in = Resources.getResourceAsStream(resource);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(in);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

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


}

3.3编写User实体类

public class User {
    private int id;
    private String userName;
    private String passWord;
    private String realName;

    public User() {
    }

    public User(int id, String userName, String passWord, String realName) {
        this.id = id;
        this.userName = userName;
        this.passWord = passWord;
        this.realName = realName;
    }

    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 getRealName() {
        return realName;
    }

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

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", userName='" + userName + '\'' +
                ", passWord='" + passWord + '\'' +
                ", realName='" + realName + '\'' +
                '}';
    }
}

3.4编写UserMapper和UserMapper.xml

UserMapper

public interface UserMapper {
    List<User> getAllUser();
}

UserMapper.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="com.kun.dao.UserMapper">
    <select id="getAllUser" resultType="com.kun.pojo.User">
    select * from user
  </select>
</mapper>

4. 测试运行

在test文件下新建测试文件，测试文件最好是和src/main/java下一样的目录结构

代码：

public class UserDaoTest {
    @Test
    public void getUserListTest(){
        //获取SqlSession对象
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        //执行SQL
        //获取到SQL语句
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<User> allUser = mapper.getAllUser();
        for (User user : allUser){
            System.out.println(user);
        }
        //关闭sqlSession
        sqlSession.close();
    }
}

5. 项目完整截图

在这里插入图片描述

Lkun_99

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
我的第一个Mybatis应用程序

我的第一个Mybatis程序1.使用工具和依赖Maven + ideamysql-connector-java + mybatis + junit2.创建项目使用idea创建maven项目，然后把src目录删掉，作为父项目，接着新建一个模块项目截图pom.xml文件父项目<?xml version="1.0" encoding="UTF-8"?>...
复制链接

扫一扫