Mybatis配置資料庫連線

首先resources下的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.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/ssms?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="cn/zmxy/dao/UsersMapper.xml"/>
    </mappers>
</configuration>

pojo實現類層的Java類(對應資料庫表),比如Users表

public class Users {
  private int id;
  private String name;
  private String pwd;

  public Users(){}

}

dao層的對映xml和Interface介面

UsersMapper.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 名稱空間 保定一個對應的dao/mapper介面-->
<mapper namespace="cn.zmxy.dao.UsersMapper">
 <select id="getUserList" resultType="cn.zmxy.pojo.Users">
  SELECT * FROM ssms.users
    </select>
 <select id="getUserById" resultType="cn.zmxy.pojo.Users" parameterType="int">
  SELECT * FROM ssms.users WHERE id = #{id}
  </select>
 <insert id="addUser" parameterType="cn.zmxy.pojo.Users">
  INSERT INTO ssms.users (id, name, pwd) VALUES (#{id}, #{name}, #{pwd})
    </insert>
 <update id="updateUser" parameterType="cn.zmxy.pojo.Users">
  UPDATE ssms.users SET name = #{name}, pwd = #{pwd} WHERE id = #{id}
  </update>
 <delete id="deleteUser" parameterType="int">
  DELETE FROM ssms.users WHERE id = #{id}
  </delete>
</mapper>

UsersMapper.java

package cn.zmxy.dao;
import cn.zmxy.pojo.Users;
import java.util.List;

public interface UsersMapper {

  // 查詢全部使用者
  public List<Users> getUserList();

  // 根據ID查詢使用者
  public Users getUserById(int id);

  // 新增使用者
  public int addUser(Users user);

  // 修改使用者
  public int updateUser(Users user);

  // 刪除使用者
  public int deleteUser(int id);
}

寫一個utils類，獲取SqlSession

MyBatisUtils.java

package cn.zmxy.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 {
  String resource = "mybatis-config.xml";
  InputStream is = Resources.getResourceAsStream(resource);
  sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
 } catch (IOException e) {
  e.printStackTrace();
 } }
  public static SqlSession getSqlSession()
 {  return sqlSessionFactory.openSession();
 }}

最後就可以呼叫了，寫一個test類

UserMapperTest.java

package cn.zmxy.dao;
import cn.zmxy.pojo.Users;
import cn.zmxy.utils.MyBatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import java.util.List;

public class UserDaoTest {
  @Test
  public void test()
 {  // 第一步，獲取SqlSession物件
  SqlSession sqlSession = MyBatisUtils.getSqlSession();
  // 第二步，執行SQL
  UsersMapper usersMapper = sqlSession.getMapper(UsersMapper.class);
  List<Users> userList = usersMapper.getUserList();

  // 列印users
  for (Users users : userList) {
  System.out.println(users);
 }  // 關閉SqlSession
  sqlSession.close();
 }
  @Test
  public void getUserById()
 {  // 第一步，獲取SqlSession物件
  SqlSession sqlSession = MyBatisUtils.getSqlSession();
  UsersMapper mapper = sqlSession.getMapper(UsersMapper.class);

  Users user = mapper.getUserById(1);
  System.out.println(user);
  // 關閉SqlSession
  sqlSession.close();
 }
  @Test
  public void addUser()
 {  // 第一步，獲取SqlSession物件
  SqlSession sqlSession = MyBatisUtils.getSqlSession();
  UsersMapper mapper = sqlSession.getMapper(UsersMapper.class);

  int num = mapper.addUser(new Users(0, "露露", "1234"));
  System.out.println("受影響行數：" + num);
  sqlSession.commit();
  // 關閉SqlSession
  sqlSession.close();
 }
  @Test
  public void updateUser()
 {  // 第一步，獲取SqlSession物件
  SqlSession sqlSession = MyBatisUtils.getSqlSession();
  UsersMapper mapper = sqlSession.getMapper(UsersMapper.class);

  int num = mapper.updateUser(new Users(3, "露露", "1234"));
  System.out.println("受影響行數：" + num);
  sqlSession.commit();
  // 關閉SqlSession
  sqlSession.close();
 }
  @Test
  public void deleteUser()
 {  // 第一步，獲取SqlSession物件
  SqlSession sqlSession = MyBatisUtils.getSqlSession();
  UsersMapper mapper = sqlSession.getMapper(UsersMapper.class);

  int num = mapper.deleteUser(11);
  System.out.println("受影響行數：" + num);
  sqlSession.commit();
  // 關閉SqlSession
  sqlSession.close();
 }
}

本作品採用《CC 協議》，轉載必須註明作者和本文連結