出行路线规划系统设计与开发

出行路线规划系统设计与开发登录注册界面

出行路线规划系统设计与开发mysql数据库版本源码:

超级管理员表创建语句如下:


create table t_admin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '超级管理员账号',
	password varchar(100) comment '超级管理员密码'
) comment '超级管理员';
insert into t_admin(username,password) values('admin','123456');

用户表创建语句如下:


create table t_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码 ',
	customerName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	address varchar(100) comment '住址'
) comment '用户';

用户路径表创建语句如下:


create table t_lj(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	title varchar(100) comment '路径名称',
	v1 varchar(100) comment '第一点',
	lat1 varchar(100) comment '经纬度1',
	v2 varchar(100) comment '第二点',
	lat2 varchar(100) comment '经纬度2',
	v3 varchar(100) comment '第三点',
	lat3 varchar(100) comment '经纬度3',
	v4 varchar(100) comment '第四点',
	lat4 varchar(100) comment '经纬度4',
	v5 varchar(100) comment '第五点',
	lat5 varchar(100) comment '经纬度5'
) comment '用户路径';

出行路线规划系统设计与开发oracle数据库版本源码:

超级管理员表创建语句如下:


create table t_admin(
	id integer,
	username varchar(100),
	password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';

用户表创建语句如下:


create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	address varchar(100)
);
--用户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '账号';
comment on column t_customer.password is '密码 ';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.phone is '电话';
comment on column t_customer.address is '住址';
--用户表加注释
comment on table t_customer is '用户';

用户路径表创建语句如下:


create table t_lj(
	id integer,
	customerId int,
	title varchar(100),
	v1 varchar(100),
	lat1 varchar(100),
	v2 varchar(100),
	lat2 varchar(100),
	v3 varchar(100),
	lat3 varchar(100),
	v4 varchar(100),
	lat4 varchar(100),
	v5 varchar(100),
	lat5 varchar(100)
);
--用户路径字段加注释
comment on column t_lj.id is '主键';
comment on column t_lj.customerId is '用户';
comment on column t_lj.title is '路径名称';
comment on column t_lj.v1 is '第一点';
comment on column t_lj.lat1 is '经纬度1';
comment on column t_lj.v2 is '第二点';
comment on column t_lj.lat2 is '经纬度2';
comment on column t_lj.v3 is '第三点';
comment on column t_lj.lat3 is '经纬度3';
comment on column t_lj.v4 is '第四点';
comment on column t_lj.lat4 is '经纬度4';
comment on column t_lj.v5 is '第五点';
comment on column t_lj.lat5 is '经纬度5';
--用户路径表加注释
comment on table t_lj is '用户路径';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_lj;

出行路线规划系统设计与开发sqlserver数据库版本源码:

超级管理员表创建语句如下:


--超级管理员
create table t_admin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--超级管理员账号
	password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');

用户表创建语句如下:


--用户表注释
create table t_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	customerName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	address varchar(100)--住址
);

用户路径表创建语句如下:


--用户路径表注释
create table t_lj(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	title varchar(100),--路径名称
	v1 varchar(100),--第一点
	lat1 varchar(100),--经纬度1
	v2 varchar(100),--第二点
	lat2 varchar(100),--经纬度2
	v3 varchar(100),--第三点
	lat3 varchar(100),--经纬度3
	v4 varchar(100),--第四点
	lat4 varchar(100),--经纬度4
	v5 varchar(100),--第五点
	lat5 varchar(100)--经纬度5
);

出行路线规划系统设计与开发登录后主页

出行路线规划系统设计与开发spring+springMVC+hibernate框架对象(javaBean,pojo)设计:

用户javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//用户
@Table(name = "t_customer")
public class Customer {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码 
private String password;
//姓名
private String customerName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//住址
private String address;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}

用户路径javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//用户路径
@Table(name = "t_lj")
public class Lj {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//路径名称
private String title;
//第一点
private String v1;
//经纬度1
private String lat1;
//第二点
private String v2;
//经纬度2
private String lat2;
//第三点
private String v3;
//经纬度3
private String lat3;
//第四点
private String v4;
//经纬度4
private String lat4;
//第五点
private String v5;
//经纬度5
private String lat5;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getLat1() {return lat1;}
public void setLat1(String lat1) {this.lat1 = lat1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getLat2() {return lat2;}
public void setLat2(String lat2) {this.lat2 = lat2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getLat3() {return lat3;}
public void setLat3(String lat3) {this.lat3 = lat3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getLat4() {return lat4;}
public void setLat4(String lat4) {this.lat4 = lat4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getLat5() {return lat5;}
public void setLat5(String lat5) {this.lat5 = lat5;}
}

出行路线规划系统设计与开发spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

用户javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//用户
public class Customer  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码 
private String password;
//姓名
private String customerName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//住址
private String address;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}

用户路径javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//用户路径
public class Lj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//路径名称
private String title;
//第一点
private String v1;
//经纬度1
private String lat1;
//第二点
private String v2;
//经纬度2
private String lat2;
//第三点
private String v3;
//经纬度3
private String lat3;
//第四点
private String v4;
//经纬度4
private String lat4;
//第五点
private String v5;
//经纬度5
private String lat5;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getLat1() {return lat1;}
public void setLat1(String lat1) {this.lat1 = lat1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getLat2() {return lat2;}
public void setLat2(String lat2) {this.lat2 = lat2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getLat3() {return lat3;}
public void setLat3(String lat3) {this.lat3 = lat3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getLat4() {return lat4;}
public void setLat4(String lat4) {this.lat4 = lat4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getLat5() {return lat5;}
public void setLat5(String lat5) {this.lat5 = lat5;}
}

源代码下载点这里

评论