快速創建簡單的mybatis應用

<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.5.4</version>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.47</version>
		</dependency>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>4.9</version>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-log4j12</artifactId>
			<version>1.7.9</version>
		</dependency>
		
</dependencies>

<?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>
  <properties resource="jdbc.properties">
  </properties>
  <typeAliases>
      <package name="com.mhys.bean" />
  </typeAliases>
  
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="https://www.cnblogs.com/eafkng/archive/2022/04/19/${driverClassName}"/>
        <property name="url" value="https://www.cnblogs.com/eafkng/archive/2022/04/19/${url}"/>
        <property name="username" value="https://www.cnblogs.com/eafkng/archive/2022/04/19/${username}"/>
        <property name="password" value="https://www.cnblogs.com/eafkng/archive/2022/04/19/${password}"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <package name="com.mhys.mapper"/>
  </mappers>
</configuration>

@Test
	public void testSelect() {
		try {
			InputStream is=Resources.getResourceAsStream("mybatis-config.xml");
			SqlSessionFactory sf=new SqlSessionFactoryBuilder().build(is);
			SqlSession session=sf.openSession();//創建一次對話(類似于mysql的對話=connection)
			AdminMapper am=session.getMapper(AdminMapper.class);
			List<Admin> list=am.findAdmin();
			System.out.println(list.toString());
			session.commit();
			session.close();
			is.close();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	@Test
	public void testDelete() {
		try {
			InputStream is=Resources.getResourceAsStream("mybatis-config.xml");
			SqlSessionFactory sf=new SqlSessionFactoryBuilder().build(is);
			SqlSession session=sf.openSession();//創建一次對話(類似于mysql的對話=connection)
			AdminMapper am=session.getMapper(AdminMapper.class);
			int num=am.deleteAdmin("4");
			System.out.println(num);
			session.commit();
			session.close();
			is.close();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	@Test
	public void testAdd() {
		try {
			InputStream is=Resources.getResourceAsStream("mybatis-config.xml");
			SqlSessionFactory sf=new SqlSessionFactoryBuilder().build(is);
			SqlSession session=sf.openSession();//創建一次對話(類似于mysql的對話=connection)
			AdminMapper am=session.getMapper(AdminMapper.class);
			int num=am.addAdmin(new Admin(null, "增加", "李四", "超級管理員", 0));
			System.out.println(num);
			session.commit();
			session.close();
			is.close();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	@Test
	public void testupdate() {
		try {
			InputStream is=Resources.getResourceAsStream("mybatis-config.xml");
			SqlSessionFactory sf=new SqlSessionFactoryBuilder().build(is);
			SqlSession session=sf.openSession();//創建一次對話(類似于mysql的對話=connection)
			AdminMapper am=session.getMapper(AdminMapper.class);
			int num= am.updateAdmin(new Admin(14, "呆瓜", "呆瓜", "老六", 0));
			System.out.println(num);
			session.commit();
			session.close();
			is.close();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}