MyBatis(六):配置之类型别名优化
一、为什么要进行类型别名优化
首先我们来看一下前面写的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"> <!-- 命名空间namespace对应Mapper接口 --> <mapper namespace="com.jms.dao.UserMapper"> <!-- id对应接口中的方法 --> <select id="getUsers" resultType="com.jms.pojo.User"> select * from mybaties.user </select> <select id="getUserbyid" parameterType="int" resultType="com.jms.pojo.User"> select * from mybaties.user where id=#{id} </select> <insert id="addUser" parameterType="com.jms.pojo.User"> insert mybaties.user value(#{id},#{username},#{password}) </insert> <update id="UpdateUser" parameterType="com.jms.pojo.User"> update mybaties.user set username=#{username},password=#{password} where id=#{id} </update> <delete id="DeleteUser" parameterType="int"> delete from mybaties.user where id=#{id} </delete> </mapper>