基于jsp的物流管理系统,java专业毕业设计

基于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_opt(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	optName varchar(100) comment '操作员名称',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	gh varchar(100) comment '工号',
	qx varchar(100) comment '是否有权限'
) comment '操作员';

订单表创建语句如下:


create table t_order(
	id int primary key auto_increment comment '主键',
	orderNum varchar(100) comment '订单编号',
	v1 varchar(100) comment '接收人',
	v2 varchar(100) comment '电话',
	v3 varchar(100) comment '地址',
	v4 varchar(100) comment '区域',
	v5 varchar(100) comment '配送时间',
	sendId varchar(100) comment '配送人',
	optId varchar(100) comment '操作员',
	status varchar(100) comment '状态'
) comment '订单';

送货员表创建语句如下:


create table t_send(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	sendName varchar(100) comment '送货员名称',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	gh varchar(100) comment '工号',
	qy varchar(100) comment '区域',
	qx varchar(100) comment '是否有权限'
) comment '送货员';

系统公告表创建语句如下:


create table t_xtgg(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	content varchar(100) comment '内容'
) 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_opt(
	id integer,
	username varchar(100),
	password varchar(100),
	optName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	gh varchar(100),
	qx varchar(100)
);
--操作员字段加注释
comment on column t_opt.id is '主键';
comment on column t_opt.username is '账号';
comment on column t_opt.password is '密码';
comment on column t_opt.optName is '操作员名称';
comment on column t_opt.age is '年龄';
comment on column t_opt.sex is '性别';
comment on column t_opt.phone is '电话';
comment on column t_opt.gh is '工号';
comment on column t_opt.qx is '是否有权限';
--操作员表加注释
comment on table t_opt is '操作员';

订单表创建语句如下:


create table t_order(
	id integer,
	orderNum varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	sendId varchar(100),
	optId varchar(100),
	status varchar(100)
);
--订单字段加注释
comment on column t_order.id is '主键';
comment on column t_order.orderNum is '订单编号';
comment on column t_order.v1 is '接收人';
comment on column t_order.v2 is '电话';
comment on column t_order.v3 is '地址';
comment on column t_order.v4 is '区域';
comment on column t_order.v5 is '配送时间';
comment on column t_order.sendId is '配送人';
comment on column t_order.optId is '操作员';
comment on column t_order.status is '状态';
--订单表加注释
comment on table t_order is '订单';

送货员表创建语句如下:


create table t_send(
	id integer,
	username varchar(100),
	password varchar(100),
	sendName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	gh varchar(100),
	qy varchar(100),
	qx varchar(100)
);
--送货员字段加注释
comment on column t_send.id is '主键';
comment on column t_send.username is '账号';
comment on column t_send.password is '密码';
comment on column t_send.sendName is '送货员名称';
comment on column t_send.age is '年龄';
comment on column t_send.sex is '性别';
comment on column t_send.phone is '电话';
comment on column t_send.gh is '工号';
comment on column t_send.qy is '区域';
comment on column t_send.qx is '是否有权限';
--送货员表加注释
comment on table t_send is '送货员';

系统公告表创建语句如下:


create table t_xtgg(
	id integer,
	title varchar(100),
	pic varchar(100),
	content varchar(100)
);
--系统公告字段加注释
comment on column t_xtgg.id is '主键';
comment on column t_xtgg.title is '标题';
comment on column t_xtgg.pic is '图片';
comment on column t_xtgg.content is '内容';
--系统公告表加注释
comment on table t_xtgg is '系统公告';

oracle特有,对应序列如下:


create sequence s_t_opt;
create sequence s_t_order;
create sequence s_t_send;
create sequence s_t_xtgg;

基于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_opt(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	optName varchar(100),--操作员名称
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	gh varchar(100),--工号
	qx varchar(100)--是否有权限
);

订单表创建语句如下:


--订单表注释
create table t_order(
	id int identity(1,1) primary key not null,--主键
	orderNum varchar(100),--订单编号
	v1 varchar(100),--接收人
	v2 varchar(100),--电话
	v3 varchar(100),--地址
	v4 varchar(100),--区域
	v5 varchar(100),--配送时间
	sendId varchar(100),--配送人
	optId varchar(100),--操作员
	status varchar(100)--状态
);

送货员表创建语句如下:


--送货员表注释
create table t_send(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	sendName varchar(100),--送货员名称
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	gh varchar(100),--工号
	qy varchar(100),--区域
	qx varchar(100)--是否有权限
);

系统公告表创建语句如下:


--系统公告表注释
create table t_xtgg(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	pic varchar(100),--图片
	content varchar(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_opt")
public class Opt {
//主键
@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 optName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//工号
private String gh;
//是否有权限
private String qx;
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 getOptName() {return optName;}
public void setOptName(String optName) {this.optName = optName;}
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}

订单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 String orderNum;
//接收人
private String v1;
//电话
private String v2;
//地址
private String v3;
//区域
private String v4;
//配送时间
private String v5;
//配送人
private String sendId;
//操作员
private String optId;
//状态
private String status;
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getSendId() {return sendId;}
public void setSendId(String sendId) {this.sendId = sendId;}
public String getOptId() {return optId;}
public void setOptId(String optId) {this.optId = optId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

送货员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_send")
public class Send {
//主键
@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 sendName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//工号
private String gh;
//区域
private String qy;
//是否有权限
private String qx;
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 getSendName() {return sendName;}
public void setSendName(String sendName) {this.sendName = sendName;}
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getQy() {return qy;}
public void setQy(String qy) {this.qy = qy;}
public String getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}

系统公告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_xtgg")
public class Xtgg {
//主键
@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 title;
//图片
private String pic;
//内容
private String content;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

基于jsp的物流管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

操作员javaBean创建语句如下:


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

//操作员
public class Opt  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 optName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//工号
private String gh;
//是否有权限
private String qx;
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 getOptName() {return optName;}
public void setOptName(String optName) {this.optName = optName;}
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}

订单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 String orderNum;
//接收人
private String v1;
//电话
private String v2;
//地址
private String v3;
//区域
private String v4;
//配送时间
private String v5;
//配送人
private String sendId;
//操作员
private String optId;
//状态
private String status;
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getSendId() {return sendId;}
public void setSendId(String sendId) {this.sendId = sendId;}
public String getOptId() {return optId;}
public void setOptId(String optId) {this.optId = optId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

送货员javaBean创建语句如下:


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

//送货员
public class Send  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 sendName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//工号
private String gh;
//区域
private String qy;
//是否有权限
private String qx;
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 getSendName() {return sendName;}
public void setSendName(String sendName) {this.sendName = sendName;}
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getQy() {return qy;}
public void setQy(String qy) {this.qy = qy;}
public String getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}

系统公告javaBean创建语句如下:


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

//系统公告
public class Xtgg  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//内容
private String content;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

源代码下载点这里

评论