创建第一个mybatis项目

创建第一个mybatis项目

搭建环境>导入mybatis>编写代码>测试

1. 搭建环境 搭建数据库

CREATE DATABASE mybatis;

USE mybatis;

CREATE TABLE `user`(
`id` INT(20) NOT NULL PRIMARY KEY,
`name` VARCHAR(20) DEFAULT NULL,
`password` VARCHAR(20) DEFAULT NULL
)ENGINE INNODB CHARSET = utf8;

INSERT INTO `user`(id,NAME,PASSWORD) VALUE
(1,'zs','123456'),
(NULL,'ls','123456'),
(NULL,'ww','123456')

• 创建项目
  
• 配置xml
  
• 再创建一个manven项目继承pom.xml
  
• 再创建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>
   <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 = true&amp;useUnicode = true&amp;characterEn"/>
               <property name="username" value="root"/>
               <property name="password" value="root"/>
           </dataSource>
       </environment>
   </environments>
   <mappers>
       <mapper resource="com/lin/Dao/UserMapper.xml"/>
   </mappers>
</configuration>

• 定义mybatis一个工具类

package com.lin.utils;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;

public class mybatisUtils {
    private static SqlSessionFactory sqlSessionFactory;
    static {
        try {
            //获取SqlSessionFactory对象
            String resource = "mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
             sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
        //从sqlsessionfactory中获取selSession
        public static SqlSession getSqlSession(){
            return sqlSessionFactory.openSession();

        }
}

• 编写代码
  • 实体类

package com.lin.pojo;

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 + '\'' +
               '}';
  	 }
}

• mapper接口

	package com.lin.dao;

	import com.lin.pojo.User;

	import java.util.List;

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

• 接口类实现

<?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.lin.dao.UserDao">
    <select id="getUserList" resultType="com.lin.pojo.User">
        select * from mybatis.user;
    </select>
</mapper>

• 测试
  • junit测试

package com.lin.dao;

import com.lin.Dao.UserDao;
import com.lin.pojo.User;
import com.lin.utils.mybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class UserDaotest<userList> {
    @Test
    public void test(){
        //获取sqlsession
        SqlSession sqlSession = mybatisUtils.getSqlSession();
        //getMapper
        UserDao userdao = sqlSession.getMapper(UserDao.class);
        List<User> userList = userdao.getUserList();
        for (User user : userList) {
            System.out.println(user);
        }
        sqlSession.close();
    }


}

• 解决报错pom.xml添加

 <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>

• 修改 mybatis-config.xml 中的

<mappers>
       <mapper resource="com/lin/Dao/UserMapper.xml"/>
</mappers>

• 输出结果
  

mybatis 的CRUD

• namespace
  namespace中的包名要和Mapper 接口的一致
• 增加
  UserMapper增加

package com.lin.Dao;

import com.lin.pojo.User;

import java.util.List;

public interface UserMapper {
    //查询全部信息
    List<User> getUserList();
    //根据id查询
    User getUserByID(int id);
    //插入数据
    int addUser(User user);
    //修改数据
    int updateUser(User user);
    //删除数据
    int deleteUser(int id);
}

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.lin.Dao.UserMapper">
    <select id="getUserList" resultType="com.lin.pojo.User">
        select * from mybatis.user
    </select>
    <select id="getUserByID" parameterType="int" resultType="com.lin.pojo.User">
        select *  from mybatis.user where id = #{id}
    </select>
    <insert id="addUser">
        insert into mybatis.user value(#{id},#{name},#{pwd});
    </insert>
    <update id="updateUser">
        update user set name = #{name},pwd = #{pwd} where id = #{id}
    </update>
    <delete id="deleteUser">
        delete from user where id = #{id}
    </delete>
</mapper>

测试

package com.lin.dao;

import com.lin.Dao.UserMapper;
import com.lin.pojo.User;
import com.lin.utils.mybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class UserDaotest<userList> {
    @Test
    public void test(){
        //获取sqlsession
        SqlSession sqlSession = mybatisUtils.getSqlSession();
        //getMapper
        UserMapper usermapper = sqlSession.getMapper(UserMapper.class);
        List<User> userList = usermapper.getUserList();
        for (User user : userList) {
            System.out.println(user);
        }
        sqlSession.close();
    }
@Test
    public void getUserByID(){
        SqlSession sqlSession = mybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User user = mapper.getUserByID(2);
        System.out.println(user);
        sqlSession.close();
    }
@Test
    public void addUser(){
        SqlSession sqlSession = mybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        int i = mapper.addUser(new User(7,"wh","123456"));

        sqlSession.commit();
        sqlSession.close();
    }
@Test
    public void updateUser(){
    SqlSession sqlSession = mybatisUtils.getSqlSession();
    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    mapper.updateUser(new User(4,"cc","2580"));
    sqlSession.commit();
    sqlSession.close();
}
@Test
    public void deleteUser(){
    SqlSession sqlSession = mybatisUtils.getSqlSession();
    UserMapper mapper = sqlSession.getMapper(UserMapper.class);

    mapper.deleteUser(7);
    sqlSession.commit();
    sqlSession.close();
}
}