本章学习目标:
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();
}