package org.apache.ibatis.example.mapper;import org.apache.ibatis.example.pojo.User;publicinterfaceUserMapper{public User getUser(int id);}
<?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"><mappernamespace="org.apache.ibatis.example.mapper.UserMapper"><selectid="getUser"parameterType="int"resultType="org.apache.ibatis.example.pojo.User">
select name as username from user where id = #{id}
</select></mapper>
配置文件
<?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><environmentsdefault="development"><environmentid="development"><transactionManagertype="JDBC"/><dataSourcetype="POOLED"><propertyname="driver"value="com.mysql.jdbc.Driver"/><propertyname="url"value="jdbc:mysql://127.0.0.1:3306/test?useUnicode=true"/><propertyname="username"value="root"/><propertyname="password"value="123456"/></dataSource></environment></environments><mappers><mapperresource="org/apache/ibatis/example/mapper/UserMapper.xml"/></mappers></configuration>