配置别名
在mybatis核心配置文件中,配置别名标签,注意标签的顺序,一般要放在properties,setting之后
<!--自定义别名-->
<typeAliases>
<typeAlias type="com.itheibai.entity.User" alias="user"></typeAlias>
</typeAliases>
可配置多个,配置完别名后,可将UserMapper.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">
<mapper namespace="userMapper">
<!--查询用户-->
<select id="findAll" resultType="user">
select * from user
</select>
<!--插入用户-->
<insert id="save" parameterType="user">
insert into user values (#{id},#{username},#{password})
</insert>
<!--更新用户-->
<update id="updateById" parameterType="user">
update user set username=#{username},password=#{password} where id=#{id}
</update>
<!--删除用户-->
<delete id="deleteById" parameterType="Integer">
delete from user where id=#{id}
</delete>
</mapper>
评论前必须登录!
注册