使用MyBatis的XML方式实现增删改查

项目GitHub地址：https://github.com/XiuerJava/mybatis02

项目结构

UserMapper.java

package com.test.mapper;

import com.test.pojo.User;

import java.util.List;

public interface UserMapper {

    //添加user
    int addUser(User user);
    //修改user
    int updateUser(User user);
    //删除user
    boolean deleteUser(int userId);
    //查询user
    List<User> selectUser();

}

User.java

package com.test.pojo;

public class User {

    private Integer userId;

    private String userName;

    private String passWord;

    public User(){}

    public User(Integer userId, String userName, String passWord) {
        this.userId = userId;
        this.userName = userName;
        this.passWord = passWord;
    }

    public Integer getUserId() {
        return userId;
    }

    public void setUserId(Integer userId) {
        this.userId = userId;
    }

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

}

UserMain.java

package com.test.test;

import com.test.pojo.User;

import java.text.ParseException;
import java.util.List;

public class UserMain {
    public static void main(String[] args) throws ParseException {
        User user = new User(2,"wefef","123789");

        User user2 = new User(2,"cvf","284651");
        int i = UserTest.insertUser(user);
        if (i>0){
            System.out.println("插入成功");
        }else{
            System.out.println("插入失败");
        }
        int i1 = UserTest.updateUser(user2);
        if (i1>0){
            System.out.println("修改成功");
        }else{
            System.out.println("修改失败");
        }
        boolean b =  UserTest.deleteUser(5);
        if (b==true){
            System.out.println("删除成功");
        }else{
            System.out.println("删除失败");
        }
        List<User> users = UserTest.selectUser();
        for (User user3:users) {
            System.out.println("userId:"+user3.getUserId()+",userName:"+user3.getUserName()+",passWord:"+user3.getPassWord());
        }
    }
}

UserTest.java

package com.test.test;

import com.test.mapper.UserMapper;
import com.test.pojo.User;
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.Reader;
import java.util.List;

public class UserTest {

    private static SqlSessionFactory sqlSessionFactory;
    //初始化
    public static void init() {
        try {
            //读取MyBatis核心配置文件
            Reader reader = Resources.getResourceAsReader("mybatis_config.xml");
            //通过reader实例化sqlSessionFactory对象
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    //添加数据
    public static int insertUser(User user) {
        init();
        SqlSession sqlSession = null;
        int i = 0;
        try {
            //获取sqlSession
            sqlSession =sqlSessionFactory.openSession();
            //查找到mapper.xml中id="addUser"的方法执行SQL
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            i = mapper.addUser(user);
            //提交事务
            sqlSession.commit();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (sqlSession != null) {
                sqlSession.close();
            }
        }
        return i;
    }

    //修改数据
    public static int updateUser(User user) {
        init();
        SqlSession sqlSession = null;
        int u = 0;
        try {
            sqlSession =sqlSessionFactory.openSession();
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            u = mapper.updateUser(user);
            sqlSession.commit();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (sqlSession != null) {
                sqlSession.close();
            }
        }
        return u;
    }

    //删除数据
    public static boolean deleteUser(int userId) {
        init();
        SqlSession sqlSession = null;
        boolean b = false;
        try {
            sqlSession =sqlSessionFactory.openSession();
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            b = mapper.deleteUser(userId);
            sqlSession.commit();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (sqlSession != null) {
                sqlSession.close();
            }
        }
        return b;
    }

    //查询数据
    public static List<User> selectUser() {
        init();
        SqlSession sqlSession = null;
        List<User> userList = null;
        try {
            sqlSession =sqlSessionFactory.openSession();
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            userList = mapper.selectUser();
            sqlSession.commit();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (sqlSession != null) {
                sqlSession.close();
            }
        }
        return userList;
    }

}

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.com.test.mapper.UserMapper">
    <!-- 添加user方法 -->
    <insert id="addUser" parameterType="User" useGeneratedKeys="true" keyProperty="id">
        insert into t_user (userName,passWord)
        values (#{userName},#{passWord})
    </insert>
    <!-- 修改user方法 -->
    <update id="updateUser" parameterType="User">
        update t_user set
            userName=#{userName},
            passWord=#{passWord}
        where userId=#{userId}
    </update>
    <!-- 删除方法 -->
    <delete id="deleteUser" parameterType="int">
        delete from t_user where userId=#{userId}
    </delete>
    <!-- 查询方法 -->
    <select id="selectUser" resultType="User">
        select * from t_user
    </select>
</mapper>

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>
    <!-- 配置了一个包的别名，之后在使用类的时候不需要写包名的部分，只使用User即可。 -->
    <typeAliases>
        <package name="com.test.pojo"/>
    </typeAliases>
    <!--配置数据库连接环境-->
    <environments default="development">
        <environment id="development">
            <!-- 使用JDBC事务管理 -->
            <transactionManager type="JDBC"/>
            <!-- 数据库连接池 -->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mydb?useUnicode=true&amp;characterEncoding=utf8&amp;serverTimezone=GMT%2B8&amp;useSSL=false"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <!-- 加载映射文件(xml文件) -->
    <mappers>
        <mapper resource="mapper/UserMapper.xml"/>
    </mappers>
</configuration>

pom.xml

<?xml version="1.0" encoding="UTF-8"?>

<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>com.test</groupId>
  <artifactId>mybatis02</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>mybatis02 Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

    <properties>
      <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
      <java.version>1.8</java.version>
    </properties>

    <!-- 依赖包集合 -->

    <dependencies>
      <!--MyBatis依赖-->
      <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.4.6</version>
      </dependency>
      <!--数据库相关依赖-->
      <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.12</version>
        <scope>runtime</scope>
      </dependency>
      <!--日志相关依赖 -->
      <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.17</version>
      </dependency>
      <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>1.7.12</version>
      </dependency>
      <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-log4j12</artifactId>
        <version>1.7.12</version>
      </dependency>
      <!--junit -->
      <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.12</version>
        <scope>test</scope>
      </dependency>
      <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.12</version>
        <scope>compile</scope>
      </dependency>
    </dependencies>

    <build>
      <plugins>

        <plugin>
          <groupId>org.apache.maven.plugins</groupId>
          <artifactId>maven-dependency-plugin</artifactId>
          <executions>
            <execution>
              <id>copy</id>
              <phase>compile</phase>
              <goals>
                <goal>copy-dependencies</goal>
              </goals>
              <configuration>
                <outputDirectory>${project.build.directory}/lib</outputDirectory>
              </configuration>
            </execution>
          </executions>
        </plugin>

      </plugins>
    </build>


  </project>

mydb.sql

-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `userId` int(8) NOT NULL AUTO_INCREMENT,
  `userName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `passWord` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('5', 'delete', '123123');

运行结果：