通过接口直接映射Sql(XML)
接口定义:
package cn.et.lession02.xml;
public interface UserInfoMapper {
public UserInfo selectUserInfo(String id);
}
mybatis.xml内容
<?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>
<!--
mybatis的核心配置文件
1.数据库的连接信息(连接池)
-->
<properties resource="jdbc.properties"></properties>
<environments default="development">
<environment id="development">
<!-- 事务管理器 默认使用jdbc事务 -->
<transactionManager type="JDBC"/>
<!-- 默认连接池 -->
<dataSource type="POOLED">
<property name="driver" value="${driverClass}"/>
<property name="url" value="${url}"/>
<property name="username" value="${userid}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
<!-- 映射sql语句 -->
<mappers>
<mapper resource="cn/et/lession02/xml/UserInfoMapper.xml" />
</mappers>
</configuration>
U