拉链表的使用
一、Java实现拉链表
技术选型:MyBatis
1)mysql建表
create database mydemo;
use mydemo;
create table orders(
orderid int primary key not null auto_increment,
orderno varchar(20),
orderstatus int,
begintime date,
overtime date
);
2)使用Maven的quickstart工程,添加两个依赖
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
3)新建资源文件夹,添加xml配置
①mybatis.cfg.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>
<typeAliases>
<typeAlias type="cn.kgc.dwlearn.mylink.entity.Orders" alias="order"></typeAlias>
</typeAliases>
<environments default="jun">
<environment id="