Pom:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>mybatis</artifactId>
<version>1.0-SNAPSHOT</version>
<!--打包方式-->
<packaging>jar</packaging>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
</properties>
<!--引入相关依赖-->
<dependencies>
<!--MyBatis依赖包-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<!--MySQL驱动包-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
<scope>runtime</scope>
</dependency>
<!--日志包-->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.12</version>
</dependency>
<!--测试包-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
</dependencies>
</project>
log:
log4j.rootLogger=DEBUG,Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.logger.org.apache=INFO
sql.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="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/pinyougoudb?characterEncoding=utf-8"/>
<property name="username" value="root"/>
<property name="password" value=""/>
</dataSource>
</environment>
</environments>
<!--加载映射文件-->
<mappers>
<mapper resource="com/test/mapper/TbUserMapper.xml"/>
</mappers>
</configuration>
TbUser.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.test.mapper.TbUserMapper">
<!--findAll-->
<select id="findAll" resultType="com.test.entity.TbUser">
SELECT * FROM tb_user
</select>
</mapper>
User:
private Long id;
private String username;
/**
* 密码,加密存储
*/
private String password;
/**
* 注册手机号
*/
private String phone;
/**
* 注册邮箱
*/
private String email;
/**
* 创建时间
*/
private Date created;
private Date updated;
/**
* 会员来源:1:PC,2:H5,3:Android,4:IOS,5:WeChat
*/
private String sourceType;
/**
* 昵称
*/
private String nickName;
/**
* 真实姓名
*/
private String name;
/**
* 使用状态(Y正常 N非正常)
*/
private String status;
/**
* 头像地址
*/
private String headPic;
/**
* QQ号码
*/
private String qq;
/**
* 账户余额
*/
private Long accountBalance;
/**
* 手机是否验证 (0否 1是)
*/
private String isMobileCheck;
/**
* 邮箱是否检测(0否 1是)
*/
private String isEmailCheck;
/**
* 性别,1男,2女
*/
private String sex;
/**
* 会员等级
*/
private Integer userLevel;
/**
* 积分
*/
private Integer points;
/**
* 经验值
*/
private Integer experienceValue;
/**
* 生日
*/
private Date birthday;
/**
* 最后登录时间
*/
private Date lastLoginTime;
private static final long serialVersionUID = 1L;
MyTest:
public class MyTest {
@Test
public void testFindAll() throws IOException {
//读取配置文件
InputStream is = Resources.getResourceAsStream("SqlMapConfig.xml");
//创建SqlSessionFactoryBuilder对象
SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
//通过SqlSessionBuilder对象构建一个SqlSessionFactory
SqlSessionFactory sqlSessionFactory = builder.build(is);
//通过SqlSessionFactory构建一个SqlSession
SqlSession session = sqlSessionFactory.openSession();
//通过SqlSession实现增删改查
TbUserMapper userMapper = session.getMapper(TbUserMapper.class);
List<TbUser> users = userMapper.findAll();
//打印输出
for (TbUser user : users) {
System.out.println(user);
}
//关闭资源
session.close();
is.close();
}
}