基于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_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 '电话'
) comment '用户';

车位物业费表创建语句如下:


create table t_cw(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	v1 varchar(100) comment '车位物业费',
	v2 varchar(100) comment '收取日期',
	v3 varchar(100) comment '备注',
	v4 varchar(100) comment '收取人'
) comment '车位物业费';

电梯广告收入表创建语句如下:


create table t_dtgg(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '电梯广告收入',
	v2 varchar(100) comment '收取日期',
	v3 varchar(100) comment '备注',
	v4 varchar(100) comment '收取人'
) comment '电梯广告收入';

房屋物业费表创建语句如下:


create table t_fw(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	v1 varchar(100) comment '房屋物业费',
	v2 varchar(100) comment '收取日期',
	v3 varchar(100) comment '备注',
	v4 varchar(100) comment '收取人'
) comment '房屋物业费';

欠费温馨提醒表创建语句如下:


create table t_qftx(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	v1 varchar(100) comment '标题',
	v2 varchar(100) comment '内容',
	v3 varchar(100) comment '日期'
) comment '欠费温馨提醒';

租赁车位服务费和物业费表创建语句如下:


create table t_zl(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	v1 varchar(100) comment '租赁车位服务费和物业费',
	v2 varchar(100) comment '收取日期',
	v3 varchar(100) comment '备注',
	v4 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_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone 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 table t_customer is '用户';

车位物业费表创建语句如下:


create table t_cw(
	id integer,
	customerId int,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100)
);
--车位物业费字段加注释
comment on column t_cw.id is '主键';
comment on column t_cw.customerId is '用户';
comment on column t_cw.v1 is '车位物业费';
comment on column t_cw.v2 is '收取日期';
comment on column t_cw.v3 is '备注';
comment on column t_cw.v4 is '收取人';
--车位物业费表加注释
comment on table t_cw is '车位物业费';

电梯广告收入表创建语句如下:


create table t_dtgg(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100)
);
--电梯广告收入字段加注释
comment on column t_dtgg.id is '主键';
comment on column t_dtgg.v1 is '电梯广告收入';
comment on column t_dtgg.v2 is '收取日期';
comment on column t_dtgg.v3 is '备注';
comment on column t_dtgg.v4 is '收取人';
--电梯广告收入表加注释
comment on table t_dtgg is '电梯广告收入';

房屋物业费表创建语句如下:


create table t_fw(
	id integer,
	customerId int,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100)
);
--房屋物业费字段加注释
comment on column t_fw.id is '主键';
comment on column t_fw.customerId is '用户';
comment on column t_fw.v1 is '房屋物业费';
comment on column t_fw.v2 is '收取日期';
comment on column t_fw.v3 is '备注';
comment on column t_fw.v4 is '收取人';
--房屋物业费表加注释
comment on table t_fw is '房屋物业费';

欠费温馨提醒表创建语句如下:


create table t_qftx(
	id integer,
	customerId int,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100)
);
--欠费温馨提醒字段加注释
comment on column t_qftx.id is '主键';
comment on column t_qftx.customerId is '用户';
comment on column t_qftx.v1 is '标题';
comment on column t_qftx.v2 is '内容';
comment on column t_qftx.v3 is '日期';
--欠费温馨提醒表加注释
comment on table t_qftx is '欠费温馨提醒';

租赁车位服务费和物业费表创建语句如下:


create table t_zl(
	id integer,
	customerId int,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100)
);
--租赁车位服务费和物业费字段加注释
comment on column t_zl.id is '主键';
comment on column t_zl.customerId is '用户';
comment on column t_zl.v1 is '租赁车位服务费和物业费';
comment on column t_zl.v2 is '收取日期';
comment on column t_zl.v3 is '备注';
comment on column t_zl.v4 is '收取人';
--租赁车位服务费和物业费表加注释
comment on table t_zl is '租赁车位服务费和物业费';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_cw;
create sequence s_t_dtgg;
create sequence s_t_fw;
create sequence s_t_qftx;
create sequence s_t_zl;

基于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)--电话
);

车位物业费表创建语句如下:


--车位物业费表注释
create table t_cw(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	v1 varchar(100),--车位物业费
	v2 varchar(100),--收取日期
	v3 varchar(100),--备注
	v4 varchar(100)--收取人
);

电梯广告收入表创建语句如下:


--电梯广告收入表注释
create table t_dtgg(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--电梯广告收入
	v2 varchar(100),--收取日期
	v3 varchar(100),--备注
	v4 varchar(100)--收取人
);

房屋物业费表创建语句如下:


--房屋物业费表注释
create table t_fw(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	v1 varchar(100),--房屋物业费
	v2 varchar(100),--收取日期
	v3 varchar(100),--备注
	v4 varchar(100)--收取人
);

欠费温馨提醒表创建语句如下:


--欠费温馨提醒表注释
create table t_qftx(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	v1 varchar(100),--标题
	v2 varchar(100),--内容
	v3 varchar(100)--日期
);

租赁车位服务费和物业费表创建语句如下:


--租赁车位服务费和物业费表注释
create table t_zl(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	v1 varchar(100),--租赁车位服务费和物业费
	v2 varchar(100),--收取日期
	v3 varchar(100),--备注
	v4 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_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;
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;}
}

车位物业费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_cw")
public class Cw {
//主键
@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 v1;
//收取日期
private String v2;
//备注
private String v3;
//收取人
private String v4;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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;}
}

电梯广告收入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_dtgg")
public class Dtgg {
//主键
@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 v1;
//收取日期
private String v2;
//备注
private String v3;
//收取人
private String v4;
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;}
}

房屋物业费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_fw")
public class Fw {
//主键
@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 v1;
//收取日期
private String v2;
//备注
private String v3;
//收取人
private String v4;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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;}
}

欠费温馨提醒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_qftx")
public class Qftx {
//主键
@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 v1;
//内容
private String v2;
//日期
private String v3;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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;}
}

租赁车位服务费和物业费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_zl")
public class Zl {
//主键
@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 v1;
//收取日期
private String v2;
//备注
private String v3;
//收取人
private String v4;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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;}
}

基于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;
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;}
}

车位物业费javaBean创建语句如下:


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

//车位物业费
public class Cw  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//车位物业费
private String v1;
//收取日期
private String v2;
//备注
private String v3;
//收取人
private String v4;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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;}
}

电梯广告收入javaBean创建语句如下:


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

//电梯广告收入
public class Dtgg  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//电梯广告收入
private String v1;
//收取日期
private String v2;
//备注
private String v3;
//收取人
private String v4;
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;}
}

房屋物业费javaBean创建语句如下:


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

//房屋物业费
public class Fw  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//房屋物业费
private String v1;
//收取日期
private String v2;
//备注
private String v3;
//收取人
private String v4;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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;}
}

欠费温馨提醒javaBean创建语句如下:


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

//欠费温馨提醒
public class Qftx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//标题
private String v1;
//内容
private String v2;
//日期
private String v3;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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;}
}

租赁车位服务费和物业费javaBean创建语句如下:


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

//租赁车位服务费和物业费
public class Zl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//租赁车位服务费和物业费
private String v1;
//收取日期
private String v2;
//备注
private String v3;
//收取人
private String v4;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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;}
}

评论