mybatis单独使用

本章学习目标：
mybatis单独使用
网盘代码：https://pan.baidu.com/s/1ZXnj3aux_EaiN1Dw29AFUw

项目目录结构

实体类user

private String username;
private Date birthday;
private String sex;
private String addres;

接口UserMapper

public interface UserMapper {
	//添加客户
	public void saveUser(User user);
}

mybatis的配置文件

<!--文件名：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>
	<typeAliases>
		<typeAlias type="com.imooc.po.User" alias="user"/>
	</typeAliases>
	<!-- 和spring整合后 environments配置将废除-->
	<environments default="development">
		<environment id="development">
		<!-- 使用jdbc事务管理-->
			<transactionManager type="JDBC" />
		<!-- 数据库连接池-->
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver" />
				<property name="url" value="jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8" />
				<property name="username" value="root" />
				<property name="password" value="root" />
			</dataSource>
		</environment>
	</environments>
	
	<mappers>
		<mapper resource="mapper/UserMapper.xml"/>
	</mappers>
	
</configuration>

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.imooc.dao.UserMapper">
	
	<!-- 添加用户 -->
	<insert id="saveUser" parameterType="com.imooc.po.User">
		INSERT INTO `mybatis`.`user` (
		  `username`,
		  `birthday`,
		  `sex`,
		  `address`
		)
		VALUES
		  (
		    #{username},
		    #{birthday},
		    #{sex},
		    #{addres}
		  );

	</insert>
	
</mapper>

测试类

	@Test
	public void test01() throws IOException {
		SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
		
		InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
		
		SqlSessionFactory sqlSessionFactory = builder.build(is);
		
		SqlSession session = sqlSessionFactory.openSession();	
		
		UserMapper mapper = session.getMapper(UserMapper.class);
		
		User user = new User();
		user.setAddres("兰州");
		user.setBirthday(new Date());
		user.setSex("男");
		user.setUsername("冯绍峰");
		
		mapper.saveUser(user);
		
		//提交事务
		session.commit();
		
		//关闭资源
		session.close();
		
	}