SqlMapConfig.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 的环境 -->
<environments default="mysql">
<!-- 配置 mysql 的环境 -->
<environment id="mysql">
<!--配置事务的类型-->
<transactionManager type="JDBC"></transactionManager>
<!--配置连接数据库的信息:用的是数据源连接池-->
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/bank"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<!--告知mybatis映射配置的位置-->
<mappers>
<!--<mapper resource="com/itcast/IUserDao.xml"/>--> --xml方式
<mapper class="com.itcast.IUserDao"/> --注解方式
</mappers>
</configuration>
如果是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="com.itcast.IUserDao">
<!-- 配置查询所有操作 -->
<select id="findAll" resultType="com.itcast.User" >
select * from account
</select>
</mapper>