【练习】Spring+SQL

新建表

DROP TABLE IF EXISTS schedule_task;

CREATE TABLE schedule_task
(
    taskid  int    auto_increment   COMMENT '任务ID1',
    taskname VARCHAR(30) NULL DEFAULT NULL COMMENT '任务名称',
    Label VARCHAR(30) NULL DEFAULT NULL COMMENT '标签',
    way VARCHAR(30) NULL DEFAULT NULL COMMENT '执行方式',
    tasktime TIMESTAMP(6) NULL DEFAULT NULL COMMENT '任务节点',
    state VARCHAR(30) NULL DEFAULT NULL COMMENT '状态',
    PRIMARY KEY (taskid)
);
INSERT INTO schedule_task  VALUES
(1, 'Jone', '1', '1','1970-01-01 00:00:01', 'haha'),
(2, 'Jack', '2','1', '1970-01-01 00:00:01', 'kaka'),
(3, 'Tom', '3', '1','1970-01-01 00:00:01', 'fafa'),
(4, 'Sandy', '4', '1','1970-01-01 00:00:01', 'gaga'),
(5, 'Billie', '5','1', '1970-01-01 00:00:01', 'xaxa'),
(6, 'hedy', '4', '1','1970-01-01 00:00:01', 'gaga'),
(7, 'Sam', '4', '1','1970-01-01 00:00:01', 'gaga');

 idea中新建spring項目

 添加依赖（还需要 mysql,lomck,freemake,generator）并执行 load maven changes. 

<dependency>
   <groupId>com.baomidou</groupId>
   <artifactId>mybatis-plus-boot-starter</artifactId>
   <version>3.4.3.1</version>
</dependency>
<dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <scope>runtime</scope>
</dependency>
<dependency>
   <groupId>com.baomidou</groupId>
   <artifactId>mybatis-plus-generator</artifactId>
   <version>3.4.1</version>
</dependency>
<dependency>
   <groupId>org.freemarker</groupId>
   <artifactId>freemarker</artifactId>
   <ve