mybatis基础

创建测试的数据库

#判断存在即删除数据库
drop database if exists mydb;
#创建数据库
create database mydb;
#使用数据库
use mydb;
 
 
#创建表
create table t_user
(
    uid int primary key auto_increment,
    username varchar(20),
    password varchar(20),
    phone varchar(11),
    address varchar(50)
);
 
 
insert into t_user(username,password,phone,address) values('张三','666','18965423548','南阳');
insert into t_user(username,password,phone,address) values('李四','333','18754263548','许昌');
insert into t_user(username,password,phone,address) values('小美','123','18565234759','信阳');

创建一个Java项目并导入mybatis框架的jar包

创建包分类

创建跟表对应的实体类

User

package com.chen.bean;

public class User {
    private Integer uid;
    private String username;
    private String password;
    private String phone;
    private String address;

    public Integer getUid() {
        return uid;
    }

    public void setUid(Integer uid) {
        this.uid = uid;
    }

    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 getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    @Override
    public String toString() {
        return "User{" +
                "uid=" + uid +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", phone='" + phone + '\'' +
                ", address='" + address + '\'' +
                '}';
    }
}

创建针对表操作的接口类

UserDao

package com.chen.dao;

import com.chen.bean.User;

import java.util.List;

public interface UserDao {
    /**
     * 查询所有用户信息
     * @return
     */
    //全查
    List<User> selectAll();
    //单查
    User selectByUid(int uid);
    //添加
    int add(User user);
    int delete(int uid);
    int update(User user);
}

在接口的包中创建对应的mapper映射配置文件

UserDao.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">
<!--namespace：把配置文件和接口进行映射-->
<mapper namespace="com.chen.dao.UserDao">
    <!--通过select标签进行查询
    id:映射接口的方法名
    parameterType:指定参数的类型(如果是集合类型只需要指定集合元素的类型即可)
    resultType:指定返回值的类型
    -->
    <select id="selectAll" resultType="com.chen.bean.User">
        select * from t_user;
    </select>
    <select id="selectByuid" parameterType="int" resultType="com.chen.bean.User">
        select * from t_user where vid=#{uid}
    </select>
    <insert id="add" parameterType="com.chen.bean.User">
        insert into t_user(username,password,phone,address) value (#{username},#{password},#{phone},#{address});
    </insert>
    <delete id="delete" parameterType="int">
        delete from t_user where uid=#{uid}
    </delete>
    <update id="update" parameterType="com.chen.bean.User">
        update t_user set username=#{username},password=#{password},phone=#{phone},address=#{address}
    </update>
</mapper>

在src目录中创建mybatis框架的核心配置文件

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>
    <!--配置环境信息===就是配置连接数据库的参数
    default：指定配置的环境信息的id，表示默认连接该环境
    -->
    <environments default="mysql">
        <environment id="mysql">
            <!--配置事务的处理方式：模式使用JDBC的事务处理-->
            <transactionManager type="jdbc"></transactionManager>
            <!--数据源的默认type设置为pooled，表示使用连接池-->
            <dataSource type="pooled">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mydb"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
        <environment id="oracle">
            <transactionManager type=""></transactionManager>
            <dataSource type=""></dataSource>
        </environment>
    </environments>
    <!--加载mapper配置文件-->
    <mappers>
        <mapper class="com.chen.dao.UserDao" />
    </mappers>
</configuration>

在测试类中进行测试

UserTest

package com.chen.test;

import com.chen.bean.User;
import com.chen.dao.UserDao;
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 org.junit.After;
import org.junit.Before;
import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class UserTest {
    InputStream stream =null;
    SqlSessionFactoryBuilder builder=null;
    SqlSessionFactory factory=null;
    SqlSession sqlSession=null;
    UserDao userDao=null;

    @Before
    public void init() throws IOException{
        stream = Resources.getResourceAsStream("mybatis.xml");
        builder=new SqlSessionFactoryBuilder();
        factory=builder.build(stream);
        sqlSession=factory.openSession();
        userDao=sqlSession.getMapper(UserDao.class);
    }
    @Test
    public void testSelectAll() throws IOException {
        List<User> userList= userDao.selectAll();
        for (User user : userList) {
            System.out.println(user);
        }
    }
    @Test
    public void testAdd(){
        User user=new User();
        user.setUsername("mybatis");
        user.setPassword("333");
        user.setPhone("110");
        user.setAddress("github");
        int n=userDao.add(user);
        if(n>0){
            System.out.println("add success");
        }
    }
    @Test
    public void testUpdate(){
        //1.数据库回显
        User oldUser=userDao.selectByUid(16);
        System.out.println("修改前:"+oldUser);
        //2.根据需要修改字段值
        oldUser.setUsername("修改测试");
        oldUser.setAddress("河南郑州");
        //3.执行数据库更新
        userDao.update(oldUser);
        //4.再次查询
        User newUser=userDao.selectByUid(16);
        System.out.println("修改后:"+newUser);
    }
    @Test
    public void testSelectByUid(){
        User user=userDao.selectByUid(1);
        System.out.println(user);
    }
    @Test
    public  void testDelete(){
        int n=userDao.delete(6);
        if (n>0){
            System.out.println("delete success");
        }
    }
    @After
    public void distroy() throws IOException{
        sqlSession.commit();
        sqlSession.close();
        stream.close();
    }
}

结果如下：