基于java的理科迷资料管理系统设计和实现

基于java的理科迷资料管理系统设计和实现登录注册界面

基于java的理科迷资料管理系统设计和实现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 '姓名',
	sex varchar(100) comment '性别',
	xl varchar(100) comment '学历',
	phone varchar(100) comment '手机',
	address varchar(100) comment '地址',
	pic varchar(100) comment '头像',
	birthday varchar(100) comment '生日'
) comment '科学家';

文件表创建语句如下:


create table t_wj(
	id int primary key auto_increment comment '主键',
	wjbh varchar(100) comment '文件编号',
	wjName varchar(100) comment '文件名称',
	num int comment '数量',
	xkId int comment '学科',
	types varchar(100) comment '文件类型',
	insertDate datetime comment '上传时间',
	wjurl varchar(100) comment '文件',
	remark varchar(100) comment '描述'
) comment '文件';

学科表创建语句如下:


create table t_xk(
	id int primary key auto_increment comment '主键',
	xkName varchar(100) comment '学科'
) comment '学科';

基于java的理科迷资料管理系统设计和实现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),
	sex varchar(100),
	xl varchar(100),
	phone varchar(100),
	address varchar(100),
	pic varchar(100),
	birthday 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.sex is '性别';
comment on column t_customer.xl is '学历';
comment on column t_customer.phone is '手机';
comment on column t_customer.address is '地址';
comment on column t_customer.pic is '头像';
comment on column t_customer.birthday is '生日';
--科学家表加注释
comment on table t_customer is '科学家';

文件表创建语句如下:


create table t_wj(
	id integer,
	wjbh varchar(100),
	wjName varchar(100),
	num int,
	xkId int,
	types varchar(100),
	insertDate datetime,
	wjurl varchar(100),
	remark varchar(100)
);
--文件字段加注释
comment on column t_wj.id is '主键';
comment on column t_wj.wjbh is '文件编号';
comment on column t_wj.wjName is '文件名称';
comment on column t_wj.num is '数量';
comment on column t_wj.xkId is '学科';
comment on column t_wj.types is '文件类型';
comment on column t_wj.insertDate is '上传时间';
comment on column t_wj.wjurl is '文件';
comment on column t_wj.remark is '描述';
--文件表加注释
comment on table t_wj is '文件';

学科表创建语句如下:


create table t_xk(
	id integer,
	xkName varchar(100)
);
--学科字段加注释
comment on column t_xk.id is '主键';
comment on column t_xk.xkName is '学科';
--学科表加注释
comment on table t_xk is '学科';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_wj;
create sequence s_t_xk;

基于java的理科迷资料管理系统设计和实现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),--姓名
	sex varchar(100),--性别
	xl varchar(100),--学历
	phone varchar(100),--手机
	address varchar(100),--地址
	pic varchar(100),--头像
	birthday varchar(100)--生日
);

文件表创建语句如下:


--文件表注释
create table t_wj(
	id int identity(1,1) primary key not null,--主键
	wjbh varchar(100),--文件编号
	wjName varchar(100),--文件名称
	num int,--数量
	xkId int,--学科
	types varchar(100),--文件类型
	insertDate datetime,--上传时间
	wjurl varchar(100),--文件
	remark varchar(100)--描述
);

学科表创建语句如下:


--学科表注释
create table t_xk(
	id int identity(1,1) primary key not null,--主键
	xkName varchar(100)--学科
);

基于java的理科迷资料管理系统设计和实现登录后主页

基于java的理科迷资料管理系统设计和实现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 sex;
//学历
private String xl;
//手机
private String phone;
//地址
private String address;
//头像
private String pic;
//生日
private String birthday;
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getXl() {return xl;}
public void setXl(String xl) {this.xl = xl;}
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;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getBirthday() {return birthday;}
public void setBirthday(String birthday) {this.birthday = birthday;}
}

文件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_wj")
public class Wj {
//主键
@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 wjbh;
//文件名称
private String wjName;
//数量
private Integer num;
//学科
private Integer xkId;
//文件类型
private String types;
//上传时间
private Date insertDate;
//文件
private String wjurl;
//描述
private String remark;
public String getWjbh() {return wjbh;}
public void setWjbh(String wjbh) {this.wjbh = wjbh;}
public String getWjName() {return wjName;}
public void setWjName(String wjName) {this.wjName = wjName;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public Integer getXkId() {return xkId;}
public void setXkId(Integer xkId) {this.xkId = xkId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getWjurl() {return wjurl;}
public void setWjurl(String wjurl) {this.wjurl = wjurl;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

学科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_xk")
public class Xk {
//主键
@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 xkName;
public String getXkName() {return xkName;}
public void setXkName(String xkName) {this.xkName = xkName;}
}

基于java的理科迷资料管理系统设计和实现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 sex;
//学历
private String xl;
//手机
private String phone;
//地址
private String address;
//头像
private String pic;
//生日
private String birthday;
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getXl() {return xl;}
public void setXl(String xl) {this.xl = xl;}
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;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getBirthday() {return birthday;}
public void setBirthday(String birthday) {this.birthday = birthday;}
}

文件javaBean创建语句如下:


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

//文件
public class Wj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//文件编号
private String wjbh;
//文件名称
private String wjName;
//数量
private Integer num;
//学科
private Integer xkId;
//文件类型
private String types;
//上传时间
private Date insertDate;
//文件
private String wjurl;
//描述
private String remark;
public String getWjbh() {return wjbh;}
public void setWjbh(String wjbh) {this.wjbh = wjbh;}
public String getWjName() {return wjName;}
public void setWjName(String wjName) {this.wjName = wjName;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public Integer getXkId() {return xkId;}
public void setXkId(Integer xkId) {this.xkId = xkId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getWjurl() {return wjurl;}
public void setWjurl(String wjurl) {this.wjurl = wjurl;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

学科javaBean创建语句如下:


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

//学科
public class Xk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学科
private String xkName;
public String getXkName() {return xkName;}
public void setXkName(String xkName) {this.xkName = xkName;}
}

源代码下载点这里

评论