输入映射parameterType的使用
1、输入简单的类型
(1)映射配置语句:
<select id="getUserById" parameterType="int" resultType="user">
SELECT
`id`,
`username`,
`birthday`,
`sex`,
`address`
FROM `user`
WHERE id = #{id}
</select>
(2)测试程序:
@Test
public void testGetUserById() {
SqlSession sqlSession = SqlSessionFactoryUtils.getSqlSessionFactory().openSession();
//获取接口的代理实现类
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
User user = userMapper.getUserById(1);
System.out.println(user); // User [id=1, username=王五, sex=2, birthday=null, address=null, uuid2=null]
sqlSession.close();
}
2、输入pojo对象类型
(1)映射配置语句:
<insert id="insertUser" parameterType="user" useGeneratedKeys="true" keyProperty="id">
INSERT INTO `user`(`username`,`birthday`,`sex`,`address`)
VALUES (#{username},#{birthday},#{sex},#{address});
</insert>
(2)测试程序:
@Test
public void testInsertUser() {
SqlSession sqlSession = SqlSessionFactoryUtils.getSqlSessionFactory(