mybatis 基本配置

最新推荐文章于 2025-12-02 18:57:44 发布

最新推荐文章于 2025-12-02 18:57:44 发布 · 61 阅读

文章标签：

#java

props.properties

是一个jdbc的属性文件，内容略

配置文件

<?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> <properties resource="props.properties"></properties> <environments default="development"> <environment id="development"> <transactionManager type="JDBC" /> <dataSource type="POOLED"> <property name="driver" value="${jdbc.driverClassName}" /> <property name="url" value="${jdbc.url}" /> <property name="username" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> </dataSource> </environment> </environments> <mappers> <mapper resource="cn/ibatis/UserMapper.xml" /> </mappers> </configuration>

映射文件

<?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="cn.ibatis.User"> <select id="selectUser" parameterType="int" resultType="cn.ibatis.User"> select * from t_user where id = #{id} </select> </mapper>

测试

package cn.ibatis; import java.io.IOException; import java.io.Reader; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; public class UserDemo { public static void main(String[] args) throws IOException { String resource = "SqlMapConfig.xml"; Reader reader = Resources.getResourceAsReader(resource); SqlSessionFactory sqlMapper = new SqlSessionFactoryBuilder().build(reader); SqlSession session = sqlMapper.openSession(); User user = (User) session.selectOne("cn.ibatis.User.selectUser", 1); System.out.println(user.getUsername()); } }

注释略

。。。。。。。。。。。。。。。。。。