1.创建一个web工程:
结构如下:
Test类如下:
package com.my.test;
public class Test {
private String name;
private int age;
public String getName(){
return this.name;
}
public int age(){
return this.age;
}
public void setName(String name){
this.name=name;
}
public void setAge(int age){
this.age=age;
}
public String toString(){
return "name="+name+","+"age="+age;
}
}
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>
<!-- 配置开发环境,可以配置多个,在具体用时再做切换 -->
<environments default="test">
<environment id="test">
<transactionManager type="JDBC"></transactionManager> <!-- 事务管理类型:JDBC、MANAGED -->
<dataSource type="POOLED"> <!-- 数据源类型:POOLED、 UNPOOLED、JNDI -->
<property name="driver" value="com.mysql.cj.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/test? characterEncoding=utf-8&serverTimezone=UTC" />
<property name="username" value="root" />
<property name="password" value="123" />
</dataSource>
</environment>
</environments>
<!-- 加载映射文件 mapper -->
<mappers>
<!-- 路径用 斜线(/) 分割,而不是用 点(.) -->
<mapper resource="com/my/mapper/UserMapper.xml"></mapper>
</mappers>
</configuration>
userMapper.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.my/mapper.UserMapper"> <!-- 命名空间,名字可以随意起,只要不冲突即可 -->
<!-- 对象映射,可以不写 -->
<!-- 查询功能,resultType 设置返回值类型 -->
<select id="findAll" resultType="com.my.test.Test"> <!-- 书写 SQL 语句 -->
SELECT * FROM person
</select>
</mapper>
一个测试类Cresh:
package com.my.test;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class Cresh {
public static void main(String[] args) throws IOException{
String resource="sqlMapConfig.xml";
InputStream inputStream= Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession=sqlSessionFactory.openSession();
List<Test> person=sqlSession.selectList("com.my/mapper.UserMapper.findAll");
for (Test p:person){
System.out.println(p.toString());
}
}
}
数据库创一个test数据库,建立一张person数据表