Mybatis简单入门开发记录

259 阅读1分钟

注意点:

  • 注意IDEA社区版与IDEA企业版之间的区别,一开始使用IDEA社区版使用Mybatis配置mybatis-config.xml的时候,报错:“无法解析符号'url'”,也就是说property无法解析标签属性name,但是我看DTD文件,明确有name属性,后面换成IDEA企业版就没有了这个问题。

30c11445e666544d905a401d09c4805.jpg

Mybatis简单目录结构

Mybatis中文网

583bdf1746c4fd395b1427446149ca1.jpg

Mybatis开发步骤

  1. 创建数据库,连接数据库
  2. 配置pom.xml,创建模块,导入坐标
<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>org.example</groupId>
  <artifactId>untitled4</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>jar</packaging>

  <name>untitled4</name>
  <url>http://maven.apache.org</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.46</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.6</version>
    </dependency>

  </dependencies>
</project>
```
```

3、编写Mybatis核心配置文件mybatis-config.xml-->替换连接信息,解决硬编码问题

            <dataSource type="POOLED">
<!--                        数据库信息-->
                <property name="driver" value="com.mysql.jdbc.Driver"/>
<!--                <property name="url" value="jdbc:mysql:///blog?useSSL=false"/>-->
                <property name="url" value="jdbc:mysql://localhost:3306/blog?useSSL=false"></property>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
```
```

4、编写SQL映射文件-统一管理sql语句,解决硬编码问题

5、编码

1.  定义POJO类
2、 加载核心配置文件,获取SqlSessionFactory对象
3、 获取SqlSession对象,执行SQL语句
4、 释放资源

创建一个user对象,用来接受数据

package org.example;

public class user {
    private String username;
    private String password;

    public void setPassword(String password) {
        this.password = password;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public String getUsername() {
        return username;
    }

    @Override
    public String toString() {
        return "user{" +
                "username='" + username + ''' +
                ", password='" + password + ''' +
                '}';
    }
}
```
```

App

public class App 
{
    public static void main( String[] args ) throws Exception {
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        SqlSession sqlSession = sqlSessionFactory.openSession();

        List<user> userList =  sqlSession.selectList("text.selectAll");

        System.out.println(userList);

        sqlSession.close();
    }
}
```
```