1 持久化数据库

[mysql]

<用户信息表>

create table OBO_TABLE_USER
(
    u_id        bigint not null primary key AUTO_INCREMENT, 
    u_name      VARCHAR(32) not null, 
    password    VARCHAR(32) not null, 
    phone       VARCHAR(11) not null, 
    createtime  timestamp not NULL DEFAULT CURRENT_TIMESTAMP, 
    email       VARCHAR(64), 
    id_card     VARCHAR(18) not null,
    driver      VARCHAR(6) not NULL DEFAULT "no"
    constraint uq_u_name unique(u_name), constraint uq_id_card unique(id_card)
);

+------------+-------------+------+-----+-------------------+----------------+
| Field      | Type        | Null | Key | Default           | Extra          |
+------------+-------------+------+-----+-------------------+----------------+
| u_id       | bigint(20)  | NO   | PRI | NULL              | auto_increment |
| u_name     | varchar(32) | NO   | UNI | NULL              |                |
| password   | varchar(32) | NO   |     | NULL              |                |
| phone      | varchar(11) | NO   |     | NULL              |                |
| createtime | timestamp   | NO   |     | CURRENT_TIMESTAMP |                |
| email      | varchar(64) | YES  |     | NULL              |                |
| id_card    | varchar(18) | NO   | UNI | NULL              |                |
| driver     | varchar(6)  | NO   |     | no                |                |
+------------+-------------+------+-----+-------------------+----------------+

插入数据sql例子:

insert into OBO_TABLE_USER 
(u_name, password, phone, email, id_card, driver) 
values 
("gailun", "123123","133333333","[email protected]",
"210303198932831123", "yes");

<订单表>

create table OBO_TABLE_ORDER
(
    orderid                 VARCHAR(64) not null primary key, 
    passenger_username      VARCHAR(32), 
    driver_usrename         VARCHAR(32), 

    create_order_time       timestamp not NULL DEFAULT CURRENT_TIMESTAMP, 
    start_order_time        timestamp not NULL, 
    end_time                timestamp not NULL, 

    src_address             VARCHAR(256), 
    dst_address             VARCHAR(256), 
    src_longitude           VARCHAR(64), 
    src_latitude            VARCHAR(64), 
    dst_longitude           VARCHAR(64), 
    dst_latitude            VARCHAR(64), 

    src_address_real        VARCHAR(256), 
    dst_address_real        VARCHAR(256), 
    src_longitude_real      VARCHAR(64), 
    src_latitude_real       VARCHAR(64), 
    dst_longitude_real      VARCHAR(64), 
    dst_latitude_real       VARCHAR(64), 

    RMB                     VARCHAR(32)
);

+--------------------+--------------+------+-----+---------------------+-------+
| Field              | Type         | Null | Key | Default             | Extra |
+--------------------+--------------+------+-----+---------------------+-------+
| orderid            | varchar(64)  | NO   | PRI | NULL                |       |
| passenger_username | varchar(32)  | YES  |     | NULL                |       |
| driver_usrename    | varchar(32)  | YES  |     | NULL                |       |
| create_order_time  | timestamp    | NO   |     | CURRENT_TIMESTAMP   |       |
| start_order_time   | timestamp    | NO   |     | 0000-00-00 00:00:00 |       |
| end_time           | timestamp    | NO   |     | 0000-00-00 00:00:00 |       |
| src_address        | varchar(256) | YES  |     | NULL                |       |
| dst_address        | varchar(256) | YES  |     | NULL                |       |
| src_longitude      | varchar(64)  | YES  |     | NULL                |       |
| src_latitude       | varchar(64)  | YES  |     | NULL                |       |
| dst_longitude      | varchar(64)  | YES  |     | NULL                |       |
| dst_latitude       | varchar(64)  | YES  |     | NULL                |       |
| src_address_real   | varchar(256) | YES  |     | NULL                |       |
| dst_address_real   | varchar(256) | YES  |     | NULL                |       |
| src_longitude_real | varchar(64)  | YES  |     | NULL                |       |
| src_latitude_real  | varchar(64)  | YES  |     | NULL                |       |
| dst_longitude_real | varchar(64)  | YES  |     | NULL                |       |
| dst_latitude_real  | varchar(64)  | YES  |     | NULL                |       |
| RMB                | varchar(32)  | YES  |     | NULL                |       |
+--------------------+--------------+------+-----+---------------------+-------+

插入数据sql例子:

insert into OBO_TABLE_USER 
(u_name, password, phone, email, id_card, driver) 
values 
("gailun", "123123","133333333","[email protected]",
"210303198932831123", "yes");