Mybatis

全局配置文件:
<?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>
<environments default="development">
<environment id="development">
<!--JDBC事务-->
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="oracle.jdbc.driver.OracleDriver"/>
<property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:ORCL"/>
<property name="username" value="xx"/>
<property name="password" value="xx"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="sqlmapper/UserMapper.xml"/>
</mappers>
</configuration>
Mapper配置文件
<mapper namespace="namespacetest">
<select id="selectById" parameterType="String" resultType="cn.mybatis.po.User" >
select * from stu where id = #{id}
</select>
</mapper>
注意事项:
1.mapper以一个属性为namespace,切记不要写成id
2.如果参数类型为基本类型可以为任意,不必写为id