mybatis初步应用

在maven项目的基础上，加入mybatis的依赖包

mybatis基础包和logback_classic日志依赖包

<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.5.6</version>
</dependency>
<!-- https://mvnrepository.com/artifact/ch.qos.logback/logback-classic -->
<dependency>
    <groupId>ch.qos.logback</groupId>
    <artifactId>logback-classic</artifactId>
    <version>1.3.0-alpha5</version>
    <scope>test</scope>
</dependency>

以上是mybatis需要的架包。libraries中出现包名是导入成功。

 

在resources包下创建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>
    <!-- 环境变量 -->
    <environments default="development">
        <environment id="development">
            <!-- 事务管理器 -->
            <transactionManager type="JDBC"/>
            <!-- 数据源 -->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis_demo?useSSL=false"/>
                <property name="username" value="root"/>
                <property name="password" value="1958410771"></property>
            </dataSource>
        </environment>
    </environments>

</configuration>

新建StartWithXml.java文件，代码如下：

public class StartWithXml {
    public static void main(String[] args) throws IOException, SQLException {
        //读取配置文件mybatis-config.xml
        InputStream configuration = Resources.getResourceAsStream("mybatis-config.xml");


        //得到SqlSessionFactory核心类
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);

        //开始一个sql会话
        SqlSession session = sqlSessionFactory.openSession();

        //得到sql连接并运行sql语句
        PreparedStatement preStatement = session.getConnection().prepareStatement("SELECT* FROM user where id =?");
        preStatement.setInt(1,1);
        ResultSet result = preStatement.executeQuery();

        //验证结果
        while(result.next()){
            System.out.println("username:" + result.getString("username"));
            System.out.println("age:" + result.getString("age") );
        }

        //关闭会话
        session.close();

    }
}

详细介绍看注释。

运行main方法：

通过mybatis查询到了数据库中的信息。