一、准备工作
1、创建一个Maven工程(这里以IDEA为例)
2、在pom.xml文件中配置:打包方式、导入Mybatis依赖、 MySQL依赖、log4j日志依赖、junit单元测试依赖,加入如下xml代码
<!-- 打包方式(jar包) -->
<packaging>jar</packaging>
<dependencies>
<!-- 导入Mybatis依赖 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.5</version>
</dependency>
<!-- 导入MySQL依赖 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.20</version>
</dependency>
<!-- 导入log4j日志依赖 -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!-- 导入单元测试依赖 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.10</version>
<scope>test</scope>
</dependency>
</dependencies>
3、新建一张user表(建表SQL语句如下)
CREATE TABLE `user` (
`id` INT(11) NOT NULL auto_increment,
`username` VARCHAR(32) NOT NULL COMMENT '用户名称',
`sex` CHAR(6) DEFAULT NULL COMMENT '性别',
`birthday` datetime DEFAULT NULL COMMENT '生日',
`address` VARCHAR(256) DEFAULT NULL COMMENT '地址',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4、插入一些测试数据
INSERT INTO `user` VALUES (1, '张三', '男', '2020-09-14 15:21:50', '遵义市-红花岗区');
INSERT INTO `user` VALUES (2, '李四', '男', '2020-09-14 15:23:58', '遵义市-汇川区');
INSERT INTO `user` VALUES (3, '丽丽', '女', '2020-09-14 15:25:48', '遵义市-播州区');
INSERT INTO `user` VALUES (4, '王五', '男', '2020-09-14 15:26:29', '贵阳市-南明区');
INSERT INTO `user` VALUES (5, '小红', '女', '2020-09-14 15:27:11', '贵阳市-观山湖区');
二、编写业务逻辑代码及做好相关配置
1、创建实体类User并实现Serializable接口,创建user表中的所有属性并生成他们的Getter() and Setter()方法与toString()方法
package com.demo.domain;
import java.io.Serializable;
import java.util.Date;
public class User implements Serializable {
private Integer id;
private String username;
private String sex;
private Date birthday;
private String address;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.<