用mybatis完成表格的单查和修改

1.创建连接测试数据库

#判断存在即删除数据库
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','木屋');
 
select * from t_user;

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

3.创建和表对应的实体类

package com.gao.bean;
 
public class User {
        private Integer uid;
        private String username;
        private String password;
        private String phone;
        private String address;
 
        @Override
        public String toString() {
            return "User{" +
                    "uid=" + uid +
                    ", username='" + username + '\'' +
                    ", password='" + password + '\'' +
                    ", phone='" + phone + '\'' +
                    ", address='" + 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;
        }
    }
 

4.创建针对表操作的接口类

（单查）

package com.gao.dao;

import com.gao.bean.User;

import java.util.List;

public interface UserDao {
  
   //单查
    User sellectById(int uid);
   
}

（修改）

package com.gao.dao;

import com.gao.bean.User;

import java.util.List;

public interface UserDao {
        
    //修改
    int update(User user);
}

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

<?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.gao.dao.UserDao">

    <select id="sellectById"  resultType="com.gao.bean.User">
        select * from t_user where uid=#{uid}
    </select>

</mapper>

6.在src目录中创建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://127.0.0.1:3306/mydb"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
    <!--加载mapper配置文件-->
    <mappers>
        <mapper class="com.gao.dao.UserDao"/>
    </mappers>
</configuration>

7.在测试类中进行测试

（测试）

package com.gao.test;


import com.gao.bean.User;
import com.gao.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 TestSellectById(){
        User user = userDao.sellectById(3);
        System.out.println(user);
    }
    
    @After
    public void distory() throws IOException {
        sqlSession.commit();
        sqlSession.close();
        stream.close();
    }
}

（修改）

package com.gao.test;


import com.gao.bean.User;
import com.gao.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 TestUpdate(){
        //1.数据回显
        User oldUser=userDao.sellectById(6);
        System.out.println("修改前"+oldUser);
        //2.根据需要修改字段值
        oldUser.setUsername("修改");
        oldUser.setAddress("aaaaaa");
        //3.执行数据库更新
        userDao.update(oldUser);
        //4.再次查询
        User newUser=userDao.sellectById(6);
        System.out.println("修改后"+newUser);
    }
    @After
    public void distory() throws IOException {
        sqlSession.commit();
        sqlSession.close();
        stream.close();
    }
}