SSM框架整合进阶版MySql数据库操作（协同版

mysql所有数据库建表、插入数据操作，id均使用自增长，并且为int类型，实体类中创建为String去使用没有任何关系。

SHOW DATABASES;
CREATE DATABASE heima_ssm;
USE heima_ssm;
SHOW DATABASES;
SELECT DATABASE();
CREATE TABLE product
(
    id INT PRIMARY KEY AUTO_INCREMENT,
    productNum VARCHAR(50) UNIQUE NOT NULL,
    productName VARCHAR(50),
    cityName VARCHAR(50),
    DepartureTime TIMESTAMP,
    productPrice DOUBLE,
    productDesc VARCHAR(500),
    productStatus INT
);
INSERT INTO PRODUCT (id, productnum, productname, cityname, departuretime, productprice,
                     productdesc, productstatus)
VALUES (NULL,'itcast-002', '北京三日游', '北京', '20181010101000', 1200, '不错的旅行', 1);
INSERT INTO PRODUCT (id, productnum, productname, cityname, departuretime, productprice,
                     productdesc, productstatus)
VALUES (NULL, 'itcast-003', '上海五日游', '上海', '20180425143000', 1800, '魔都我来了', 0);
INSERT INTO PRODUCT (id, productnum, productname, cityname, departuretime, productprice,
                     productdesc, productstatus)
VALUES (NULL, 'itcast-001', '北京三日游', '北京', '20181010101000', 1200, '不错的旅行', 1);

CREATE TABLE member(
       id INT PRIMARY KEY AUTO_INCREMENT,
       NAME VARCHAR(20),
       nickname VARCHAR(20),
       phoneNum VARCHAR(20),
       email VARCHAR(20)