Mybatis基本流程辑器

1.创建数据库及数据

1.创建数据库

create database `mybatis`;
use `mybatis`

2.创建表

create table `user`(
	`id`	INT(20)	NOT NULL PRIMARY KEY,
  `name` 	VARCHAR(30)	DEFAULT NULL,
  `pwd` VARCHAR(30) DEFAULT NULL
)ENGINE=INNODB DEFAULT CHARSET=utf8;

3.插入数据

2.创建项目

2.1搭载环境

创建普通maven项目

删除src目录

导入maven依赖

<!--    导入依赖-->
    <dependencies>
<!--        mysql驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.46</version>
        </dependency>
        <!--mybatis-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.2</version>
        </dependency>
        <!--junit-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>
    </dependencies>

2.2 创建模块

• 编写mybatis的核心配置文件

  

  //连接数据库
  <?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.jdbc.Driver"/>
                  <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=false&amp;useUnicode=true&amp;characterEncodong=UTF-8"/>
                  <property name="username" value="root"/>
                  <property name="password" value="123456"/>
              </dataSource>
          </environment>
      </environments>
  </configuration>
  

2.3 编写代码

• 编写mybatis工具类

  

  public class MybatisUtils {
  /*加载资源
  创建sqlSession对象*/   
  
      private static SqlSessionFactory sqlSessionFactory;
      
      static{
          try {
              //使用mybatis获取sqlsessionFactory对象
              String resource = "mybatis-config.xml";
              InputStream inputStream = Resources.getResourceAsStream(resource);
              sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
          } catch (IOException e) {
              e.printStackTrace();
          }
      }
  
  /*    既然有了 SqlSessionFactory，顾名思义，我们可以从中获得 SqlSession 的实例。SqlSession 提供了在数据库执行 SQL 命令所需的所有方法。
      你可以通过 SqlSession 实例来直接执行已映射的 SQL 语句。*/
      public static SqlSession getSqlSession(){
          SqlSession sqlSession = sqlSessionFactory.openSession();
          return sqlSession;
      }
  }
  

  2.3编写代码

• 实体类

  创建工具类

  

  //实体类
  public class User {
      private int id;
      private String name;
      private String pwd;
  
      public User() {
      }
  
      public User(int id, String name, String pwd) {
          this.id = id;
          this.name = name;
          this.pwd = pwd;
      }
  
      public int getId() {
          return id;
      }
  
      public String getName() {
          return name;
      }
  
      public String getPwd() {
          return pwd;
      }
  
      public void setId(int id) {
          this.id = id;
      }
  
      public void setName(String name) {
          this.name = name;
      }
  
      public void setPwd(String pwd) {
          this.pwd = pwd;
      }
  
      @Override
      public String toString() {
          return "User{" +
                  "id=" + id +
                  ", name='" + name + '\'' +
                  ", pwd='" + pwd + '\'' +
                  '}';
      }
  }
  

• Dao接口

public interface UserDao{
	List<User> getUserList();
}

• 接口的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.hgh.dao.UserMapper">
    <select id="getUserList" resultType="User">
        select * from user
    </select>

    <insert id="addUser" parameterType="com.hgh.pojo.User">
        insert into mybatis.user (id, name, pwd) values (#{id},#{name},#{pwd});
    </insert>

    <insert id="addUser1" parameterType="map">
        insert into user(id,pwd) values (#{userid},#{userpwd})
    </insert>

    <update id="updateUser" parameterType="int">
        update mybatis.user set name=#{name},pwd=#{pwd} where id=#{id}
    </update>

    <delete id="deleteUser" parameterType="int">
        delete from user where id=#{id}
    </delete>

</mapper>

2.4测试类

//测试类
    @Test
    public void inserUser1(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        HashMap<String, Object> map = new HashMap<String, Object>();
        map.put("userid",'9');
        map.put("userpwd","123");
        int i = mapper.addUser1(map);
        sqlSession.commit();
        sqlSession.close();
    }