基于jsp拼车自助服务系统的设计与实现

设计并实现一个拼车系统,能够做到针对不同权限人群拥有不同的功能(乘客、司机、管理员),实现叫车、回应、管理等功能,同时为乘客与司机的沟通提供便利。
对于乘客,应实现三个模块的功能:
(1) 叫车:对车辆信息库发送请求
(2) 查询:查询车辆信息以及车主信息
(3) 反馈:对车辆、车主的服务进行系统反馈
对于司机,应实现三个模块的功能:
(1) 应答:对于乘客的叫车请求作出回应
(2) 查询:乘客的位置信息
(3) 完成服务:对完成乘客服务进行确认
对于管理员,应实现三个模块的功能:
(1) 权限管理:对每名成员的权限尽心管理
(2) 整理数据:对于乘客以及车主的信息进行管理
(3) 查询:查询各种信息。
基于jsp拼车自助服务系统的设计与实现登录注册界面

基于jsp拼车自助服务系统的设计与实现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 '电话',
	sfz varchar(100) comment '身份证'
) comment '用户';

司机表创建语句如下:


create table t_driver(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	driverName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	sfz varchar(100) comment '身份证',
	clxh varchar(100) comment '车辆型号',
	cp varchar(100) comment '车牌'
) comment '司机';

订单表创建语句如下:


create table t_order(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	orderNum varchar(100) comment '订单编号',
	insertDate datetime comment '发起日期',
	jwd varchar(100) comment '经纬度',
	driverId int comment '应答司机',
	status varchar(100) comment '状态',
	pj varchar(100) comment '评价',
	pf int comment '评分满分100'
) comment '订单';

基于jsp拼车自助服务系统的设计与实现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),
	sfz 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.sfz is '身份证';
--用户表加注释
comment on table t_customer is '用户';

司机表创建语句如下:


create table t_driver(
	id integer,
	username varchar(100),
	password varchar(100),
	driverName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	sfz varchar(100),
	clxh varchar(100),
	cp varchar(100)
);
--司机字段加注释
comment on column t_driver.id is '主键';
comment on column t_driver.username is '账号';
comment on column t_driver.password is '密码';
comment on column t_driver.driverName is '姓名';
comment on column t_driver.age is '年龄';
comment on column t_driver.sex is '性别';
comment on column t_driver.phone is '电话';
comment on column t_driver.sfz is '身份证';
comment on column t_driver.clxh is '车辆型号';
comment on column t_driver.cp is '车牌';
--司机表加注释
comment on table t_driver is '司机';

订单表创建语句如下:


create table t_order(
	id integer,
	customerId int,
	orderNum varchar(100),
	insertDate datetime,
	jwd varchar(100),
	driverId int,
	status varchar(100),
	pj varchar(100),
	pf int
);
--订单字段加注释
comment on column t_order.id is '主键';
comment on column t_order.customerId is '用户';
comment on column t_order.orderNum is '订单编号';
comment on column t_order.insertDate is '发起日期';
comment on column t_order.jwd is '经纬度';
comment on column t_order.driverId is '应答司机';
comment on column t_order.status is '状态';
comment on column t_order.pj is '评价';
comment on column t_order.pf is '评分满分100';
--订单表加注释
comment on table t_order is '订单';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_driver;
create sequence s_t_order;

基于jsp拼车自助服务系统的设计与实现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),--电话
	sfz varchar(100)--身份证
);

司机表创建语句如下:


--司机表注释
create table t_driver(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	driverName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	sfz varchar(100),--身份证
	clxh varchar(100),--车辆型号
	cp varchar(100)--车牌
);

订单表创建语句如下:


--订单表注释
create table t_order(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	orderNum varchar(100),--订单编号
	insertDate datetime,--发起日期
	jwd varchar(100),--经纬度
	driverId int,--应答司机
	status varchar(100),--状态
	pj varchar(100),--评价
	pf int--评分满分100
);

基于jsp拼车自助服务系统的设计与实现登录后主页

基于jsp拼车自助服务系统的设计与实现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 sfz;
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 getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
}

司机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_driver")
public class Driver {
//主键
@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 driverName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//身份证
private String sfz;
//车辆型号
private String clxh;
//车牌
private String cp;
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 getDriverName() {return driverName;}
public void setDriverName(String driverName) {this.driverName = driverName;}
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 getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getClxh() {return clxh;}
public void setClxh(String clxh) {this.clxh = clxh;}
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
}

订单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_order")
public class Order {
//主键
@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 orderNum;
//发起日期
private Date insertDate;
//经纬度
private String jwd;
//应答司机
private Integer driverId;
//状态
private String status;
//评价
private String pj;
//评分满分100
private Integer pf;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getJwd() {return jwd;}
public void setJwd(String jwd) {this.jwd = jwd;}
public Integer getDriverId() {return driverId;}
public void setDriverId(Integer driverId) {this.driverId = driverId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getPj() {return pj;}
public void setPj(String pj) {this.pj = pj;}
public Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
}

基于jsp拼车自助服务系统的设计与实现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 sfz;
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 getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
}

司机javaBean创建语句如下:


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

//司机
public class Driver  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 driverName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//身份证
private String sfz;
//车辆型号
private String clxh;
//车牌
private String cp;
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 getDriverName() {return driverName;}
public void setDriverName(String driverName) {this.driverName = driverName;}
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 getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getClxh() {return clxh;}
public void setClxh(String clxh) {this.clxh = clxh;}
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
}

订单javaBean创建语句如下:


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

//订单
public class Order  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//订单编号
private String orderNum;
//发起日期
private Date insertDate;
//经纬度
private String jwd;
//应答司机
private Integer driverId;
//状态
private String status;
//评价
private String pj;
//评分满分100
private Integer pf;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getJwd() {return jwd;}
public void setJwd(String jwd) {this.jwd = jwd;}
public Integer getDriverId() {return driverId;}
public void setDriverId(Integer driverId) {this.driverId = driverId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getPj() {return pj;}
public void setPj(String pj) {this.pj = pj;}
public Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
}

源代码下载点这里

评论