只要配置了如下
<typeAliases>
<typeAlias type="pojo.User" alias="User"/>
</typeAliases>
完整的是這個(gè)
<?xml version="1.0" encoding="UTF-8"?>
<!--xml約束信息-->
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!-- 設(shè)置別名 -->
<typeAliases>
<typeAlias type="pojo.User" alias="User"/>
</typeAliases>
<!-- 配置開(kāi)發(fā)環(huán)境 ,default用來(lái)設(shè)置默認(rèn)的開(kāi)發(fā)環(huán)境-->
<environments default="test">
<!--測(cè)試環(huán)境-->
<environment id="test">
<!--事務(wù)管理器:mybatis的事務(wù)交個(gè)jdbc處理-->
<transactionManager type="jdbc"></transactionManager>
<!--連接池:配置數(shù)據(jù)源熙揍,連接池 -->
<dataSource type="pooled">
<!--數(shù)據(jù)庫(kù)驅(qū)動(dòng)的名字-->
<property name="driver" value="com.mysql.jdbc.Driver"/>
<!-- 數(shù)據(jù)庫(kù)的url地址-->
<property name="url" value="jdbc:mysql:///mybatisdb"/>
<!-- 數(shù)據(jù)庫(kù)的用戶名-->
<property name="username" value="root"/>
<!-- 數(shù)據(jù)庫(kù)的密碼-->
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<!--引入映射文件 -->
<mappers>
<!--引入U(xiǎn)serMapper文件
resource指定文件的位置
-->
<mapper resource="mapper/UserMapper.xml"/>
</mappers>
</configuration>
這個(gè)
<select id="findAll" resultType="pojo.User">
select * from user
</select>
就可以簡(jiǎn)單寫(xiě)成
<select id="findAll" resultType="User">
select * from user
</select>
完整的如下
<?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">
<!--映射文件,寫(xiě)SQL曹铃,namespace唯一標(biāo)識(shí) -->
<mapper namespace="userns">
<!--查詢所有記錄
id唯一標(biāo)識(shí)
resultType把結(jié)果封裝在對(duì)象上重挑,要寫(xiě)類的全路徑-->
<select id="findAll" resultType="User">
select * from user
</select>
<select id="count" resultType="int">
select count(*) from user
</select>
<!--根據(jù)id查詢記錄-->
<select id="findOne" parameterType="int" resultType="User">
select * from user where id=#{id}
</select>
<!--新增一條記錄 -->
<insert id="save" parameterType="User">
insert into user values(null,#{name},#{addr},#{age})
</insert>
<!--修改指定記錄
動(dòng)態(tài)取值:#{age}
age就是user對(duì)象的age屬性
-->
<update id="updateUser" parameterType="User" >
update user set age=#{age} where name=#{name}
</update>
<delete id="deleteUser" parameterType="User">
delete from user where name=#{name}
</delete>
</mapper>