- 动物救助申领管理系统mysql数据库创建语句
- 动物救助申领管理系统oracle数据库创建语句
- 动物救助申领管理系统sqlserver数据库创建语句
- 动物救助申领管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 动物救助申领管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
动物救助申领管理系统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_anl(
id int primary key auto_increment comment '主键',
anlName varchar(100) comment '动物名称(编号)',
anlType varchar(100) comment '动物类型',
inDate datetime comment '救助时间',
inName varchar(100) comment '入库人',
miaoshu text comment '描述',
outDate datetime comment '申领时间',
outName varchar(100) comment '处理名称',
status varchar(100) comment '状态'
) comment '动物';
申领表创建语句如下：
create table t_sl(
id int primary key auto_increment comment '主键',
slName varchar(100) comment '申领人姓名',
slPhone varchar(100) comment '电话',
slAddress text comment '地址',
slCard varchar(100) comment '身份证',
anlName varchar(100) comment '动物编号',
miaoshu text comment '申领理由',
sex varchar(100) comment '性别',
age varchar(100) comment '年龄',
baozheng text comment '申领誓词',
confirmName varchar(100) comment '确定人',
confirmDate datetime comment '确定时间',
insertName varchar(100) comment '代理申请人姓名',
insertDate datetime comment '代理申请时间',
status varchar(100) comment '状态'
) comment '申领';
动物疫苗用药表创建语句如下：
create table t_tables(
id int primary key auto_increment comment '主键',
tablesName varchar(100) comment '药品名称',
anlName varchar(100) comment '动物编号',
miaoshu text comment '用药描述',
insertDate datetime comment '时间',
insertName varchar(100) comment '操作人'
) comment '动物疫苗用药';
动物小百科表创建语句如下：
create table t_xbk(
id int primary key auto_increment comment '主键',
anlName varchar(100) comment '动物名称',
anlUrl varchar(100) comment '照片',
eat text comment '饮食习惯',
life text comment '生活习惯'
) comment '动物小百科';
志愿者表创建语句如下：
create table t_zyz(
id int primary key auto_increment comment '主键',
zyzName varchar(100) comment '志愿者姓名',
sfz varchar(100) comment '身份证',
age varchar(100) comment '年龄',
lastTimeBegin datetime comment '就职开始时间',
lastTimeEnd datetime comment '就职结束时间'
) 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_anl(
id integer,
anlName varchar(100),
anlType varchar(100),
inDate datetime,
inName varchar(100),
miaoshu text,
outDate datetime,
outName varchar(100),
status varchar(100)
);
--动物字段加注释
comment on column t_anl.id is '主键';
comment on column t_anl.anlName is '动物名称(编号)';
comment on column t_anl.anlType is '动物类型';
comment on column t_anl.inDate is '救助时间';
comment on column t_anl.inName is '入库人';
comment on column t_anl.miaoshu is '描述';
comment on column t_anl.outDate is '申领时间';
comment on column t_anl.outName is '处理名称';
comment on column t_anl.status is '状态';
--动物表加注释
comment on table t_anl is '动物';
申领表创建语句如下：
create table t_sl(
id integer,
slName varchar(100),
slPhone varchar(100),
slAddress text,
slCard varchar(100),
anlName varchar(100),
miaoshu text,
sex varchar(100),
age varchar(100),
baozheng text,
confirmName varchar(100),
confirmDate datetime,
insertName varchar(100),
insertDate datetime,
status varchar(100)
);
--申领字段加注释
comment on column t_sl.id is '主键';
comment on column t_sl.slName is '申领人姓名';
comment on column t_sl.slPhone is '电话';
comment on column t_sl.slAddress is '地址';
comment on column t_sl.slCard is '身份证';
comment on column t_sl.anlName is '动物编号';
comment on column t_sl.miaoshu is '申领理由';
comment on column t_sl.sex is '性别';
comment on column t_sl.age is '年龄';
comment on column t_sl.baozheng is '申领誓词';
comment on column t_sl.confirmName is '确定人';
comment on column t_sl.confirmDate is '确定时间';
comment on column t_sl.insertName is '代理申请人姓名';
comment on column t_sl.insertDate is '代理申请时间';
comment on column t_sl.status is '状态';
--申领表加注释
comment on table t_sl is '申领';
动物疫苗用药表创建语句如下：
create table t_tables(
id integer,
tablesName varchar(100),
anlName varchar(100),
miaoshu text,
insertDate datetime,
insertName varchar(100)
);
--动物疫苗用药字段加注释
comment on column t_tables.id is '主键';
comment on column t_tables.tablesName is '药品名称';
comment on column t_tables.anlName is '动物编号';
comment on column t_tables.miaoshu is '用药描述';
comment on column t_tables.insertDate is '时间';
comment on column t_tables.insertName is '操作人';
--动物疫苗用药表加注释
comment on table t_tables is '动物疫苗用药';
动物小百科表创建语句如下：
create table t_xbk(
id integer,
anlName varchar(100),
anlUrl varchar(100),
eat text,
life text
);
--动物小百科字段加注释
comment on column t_xbk.id is '主键';
comment on column t_xbk.anlName is '动物名称';
comment on column t_xbk.anlUrl is '照片';
comment on column t_xbk.eat is '饮食习惯';
comment on column t_xbk.life is '生活习惯';
--动物小百科表加注释
comment on table t_xbk is '动物小百科';
志愿者表创建语句如下：
create table t_zyz(
id integer,
zyzName varchar(100),
sfz varchar(100),
age varchar(100),
lastTimeBegin datetime,
lastTimeEnd datetime
);
--志愿者字段加注释
comment on column t_zyz.id is '主键';
comment on column t_zyz.zyzName is '志愿者姓名';
comment on column t_zyz.sfz is '身份证';
comment on column t_zyz.age is '年龄';
comment on column t_zyz.lastTimeBegin is '就职开始时间';
comment on column t_zyz.lastTimeEnd is '就职结束时间';
--志愿者表加注释
comment on table t_zyz is '志愿者';
oracle特有，对应序列如下：
create sequence s_t_anl;
create sequence s_t_sl;
create sequence s_t_tables;
create sequence s_t_xbk;
create sequence s_t_zyz;
动物救助申领管理系统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_anl(
id int identity(1,1) primary key not null,--主键
anlName varchar(100),--动物名称(编号)
anlType varchar(100),--动物类型
inDate datetime,--救助时间
inName varchar(100),--入库人
miaoshu text,--描述
outDate datetime,--申领时间
outName varchar(100),--处理名称
status varchar(100)--状态
);
申领表创建语句如下：
--申领表注释
create table t_sl(
id int identity(1,1) primary key not null,--主键
slName varchar(100),--申领人姓名
slPhone varchar(100),--电话
slAddress text,--地址
slCard varchar(100),--身份证
anlName varchar(100),--动物编号
miaoshu text,--申领理由
sex varchar(100),--性别
age varchar(100),--年龄
baozheng text,--申领誓词
confirmName varchar(100),--确定人
confirmDate datetime,--确定时间
insertName varchar(100),--代理申请人姓名
insertDate datetime,--代理申请时间
status varchar(100)--状态
);
动物疫苗用药表创建语句如下：
--动物疫苗用药表注释
create table t_tables(
id int identity(1,1) primary key not null,--主键
tablesName varchar(100),--药品名称
anlName varchar(100),--动物编号
miaoshu text,--用药描述
insertDate datetime,--时间
insertName varchar(100)--操作人
);
动物小百科表创建语句如下：
--动物小百科表注释
create table t_xbk(
id int identity(1,1) primary key not null,--主键
anlName varchar(100),--动物名称
anlUrl varchar(100),--照片
eat text,--饮食习惯
life text--生活习惯
);
志愿者表创建语句如下：
--志愿者表注释
create table t_zyz(
id int identity(1,1) primary key not null,--主键
zyzName varchar(100),--志愿者姓名
sfz varchar(100),--身份证
age varchar(100),--年龄
lastTimeBegin datetime,--就职开始时间
lastTimeEnd datetime--就职结束时间
);
登录后主页.jpg?x-oss-process=style/00001)
动物救助申领管理系统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_anl")
public class Anl {
//主键
@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 anlName;
//动物类型
private String anlType;
//救助时间
private Date inDate;
//入库人
private String inName;
//描述
private String miaoshu;
//申领时间
private Date outDate;
//处理名称
private String outName;
//状态
private String status;
public String getAnlName() {return anlName;}
public void setAnlName(String anlName) {this.anlName = anlName;}
public String getAnlType() {return anlType;}
public void setAnlType(String anlType) {this.anlType = anlType;}
public Date getInDate() {return inDate;}
public void setInDate(Date inDate) {this.inDate = inDate;}
public String getInName() {return inName;}
public void setInName(String inName) {this.inName = inName;}
public String getMiaoshu() {return miaoshu;}
public void setMiaoshu(String miaoshu) {this.miaoshu = miaoshu;}
public Date getOutDate() {return outDate;}
public void setOutDate(Date outDate) {this.outDate = outDate;}
public String getOutName() {return outName;}
public void setOutName(String outName) {this.outName = outName;}
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_sl")
public class Sl {
//主键
@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 slName;
//电话
private String slPhone;
//地址
private String slAddress;
//身份证
private String slCard;
//动物编号
private String anlName;
//申领理由
private String miaoshu;
//性别
private String sex;
//年龄
private String age;
//申领誓词
private String baozheng;
//确定人
private String confirmName;
//确定时间
private Date confirmDate;
//代理申请人姓名
private String insertName;
//代理申请时间
private Date insertDate;
//状态
private String status;
public String getSlName() {return slName;}
public void setSlName(String slName) {this.slName = slName;}
public String getSlPhone() {return slPhone;}
public void setSlPhone(String slPhone) {this.slPhone = slPhone;}
public String getSlAddress() {return slAddress;}
public void setSlAddress(String slAddress) {this.slAddress = slAddress;}
public String getSlCard() {return slCard;}
public void setSlCard(String slCard) {this.slCard = slCard;}
public String getAnlName() {return anlName;}
public void setAnlName(String anlName) {this.anlName = anlName;}
public String getMiaoshu() {return miaoshu;}
public void setMiaoshu(String miaoshu) {this.miaoshu = miaoshu;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getBaozheng() {return baozheng;}
public void setBaozheng(String baozheng) {this.baozheng = baozheng;}
public String getConfirmName() {return confirmName;}
public void setConfirmName(String confirmName) {this.confirmName = confirmName;}
public Date getConfirmDate() {return confirmDate;}
public void setConfirmDate(Date confirmDate) {this.confirmDate = confirmDate;}
public String getInsertName() {return insertName;}
public void setInsertName(String insertName) {this.insertName = insertName;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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_tables")
public class Tables {
//主键
@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 tablesName;
//动物编号
private String anlName;
//用药描述
private String miaoshu;
//时间
private Date insertDate;
//操作人
private String insertName;
public String getTablesName() {return tablesName;}
public void setTablesName(String tablesName) {this.tablesName = tablesName;}
public String getAnlName() {return anlName;}
public void setAnlName(String anlName) {this.anlName = anlName;}
public String getMiaoshu() {return miaoshu;}
public void setMiaoshu(String miaoshu) {this.miaoshu = miaoshu;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getInsertName() {return insertName;}
public void setInsertName(String insertName) {this.insertName = insertName;}
}动物小百科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_xbk")
public class Xbk {
//主键
@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 anlName;
//照片
private String anlUrl;
//饮食习惯
private String eat;
//生活习惯
private String life;
public String getAnlName() {return anlName;}
public void setAnlName(String anlName) {this.anlName = anlName;}
public String getAnlUrl() {return anlUrl;}
public void setAnlUrl(String anlUrl) {this.anlUrl = anlUrl;}
public String getEat() {return eat;}
public void setEat(String eat) {this.eat = eat;}
public String getLife() {return life;}
public void setLife(String life) {this.life = life;}
}志愿者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_zyz")
public class Zyz {
//主键
@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 zyzName;
//身份证
private String sfz;
//年龄
private String age;
//就职开始时间
private Date lastTimeBegin;
//就职结束时间
private Date lastTimeEnd;
public String getZyzName() {return zyzName;}
public void setZyzName(String zyzName) {this.zyzName = zyzName;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public Date getLastTimeBegin() {return lastTimeBegin;}
public void setLastTimeBegin(Date lastTimeBegin) {this.lastTimeBegin = lastTimeBegin;}
public Date getLastTimeEnd() {return lastTimeEnd;}
public void setLastTimeEnd(Date lastTimeEnd) {this.lastTimeEnd = lastTimeEnd;}
}动物救助申领管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
动物javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//动物
public class Anl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//动物名称(编号)
private String anlName;
//动物类型
private String anlType;
//救助时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date inDate;
//入库人
private String inName;
//描述
private String miaoshu;
//申领时间
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date outDate;
//处理名称
private String outName;
//状态
private String status;
public String getAnlName() {return anlName;}
public void setAnlName(String anlName) {this.anlName = anlName;}
public String getAnlType() {return anlType;}
public void setAnlType(String anlType) {this.anlType = anlType;}
public Date getInDate() {return inDate;}
public void setInDate(Date inDate) {this.inDate = inDate;}
public String getInName() {return inName;}
public void setInName(String inName) {this.inName = inName;}
public String getMiaoshu() {return miaoshu;}
public void setMiaoshu(String miaoshu) {this.miaoshu = miaoshu;}
public Date getOutDate() {return outDate;}
public void setOutDate(Date outDate) {this.outDate = outDate;}
public String getOutName() {return outName;}
public void setOutName(String outName) {this.outName = outName;}
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 Sl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//申领人姓名
private String slName;
//电话
private String slPhone;
//地址
private String slAddress;
//身份证
private String slCard;
//动物编号
private String anlName;
//申领理由
private String miaoshu;
//性别
private String sex;
//年龄
private String age;
//申领誓词
private String baozheng;
//确定人
private String confirmName;
//确定时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date confirmDate;
//代理申请人姓名
private String insertName;
//代理申请时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date insertDate;
//状态
private String status;
public String getSlName() {return slName;}
public void setSlName(String slName) {this.slName = slName;}
public String getSlPhone() {return slPhone;}
public void setSlPhone(String slPhone) {this.slPhone = slPhone;}
public String getSlAddress() {return slAddress;}
public void setSlAddress(String slAddress) {this.slAddress = slAddress;}
public String getSlCard() {return slCard;}
public void setSlCard(String slCard) {this.slCard = slCard;}
public String getAnlName() {return anlName;}
public void setAnlName(String anlName) {this.anlName = anlName;}
public String getMiaoshu() {return miaoshu;}
public void setMiaoshu(String miaoshu) {this.miaoshu = miaoshu;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getBaozheng() {return baozheng;}
public void setBaozheng(String baozheng) {this.baozheng = baozheng;}
public String getConfirmName() {return confirmName;}
public void setConfirmName(String confirmName) {this.confirmName = confirmName;}
public Date getConfirmDate() {return confirmDate;}
public void setConfirmDate(Date confirmDate) {this.confirmDate = confirmDate;}
public String getInsertName() {return insertName;}
public void setInsertName(String insertName) {this.insertName = insertName;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 Tables extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//药品名称
private String tablesName;
//动物编号
private String anlName;
//用药描述
private String miaoshu;
//时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date insertDate;
//操作人
private String insertName;
public String getTablesName() {return tablesName;}
public void setTablesName(String tablesName) {this.tablesName = tablesName;}
public String getAnlName() {return anlName;}
public void setAnlName(String anlName) {this.anlName = anlName;}
public String getMiaoshu() {return miaoshu;}
public void setMiaoshu(String miaoshu) {this.miaoshu = miaoshu;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getInsertName() {return insertName;}
public void setInsertName(String insertName) {this.insertName = insertName;}
}动物小百科javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//动物小百科
public class Xbk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//动物名称
private String anlName;
//照片
private String anlUrl;
//饮食习惯
private String eat;
//生活习惯
private String life;
public String getAnlName() {return anlName;}
public void setAnlName(String anlName) {this.anlName = anlName;}
public String getAnlUrl() {return anlUrl;}
public void setAnlUrl(String anlUrl) {this.anlUrl = anlUrl;}
public String getEat() {return eat;}
public void setEat(String eat) {this.eat = eat;}
public String getLife() {return life;}
public void setLife(String life) {this.life = life;}
}志愿者javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//志愿者
public class Zyz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//志愿者姓名
private String zyzName;
//身份证
private String sfz;
//年龄
private String age;
//就职开始时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date lastTimeBegin;
//就职结束时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date lastTimeEnd;
public String getZyzName() {return zyzName;}
public void setZyzName(String zyzName) {this.zyzName = zyzName;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public Date getLastTimeBegin() {return lastTimeBegin;}
public void setLastTimeBegin(Date lastTimeBegin) {this.lastTimeBegin = lastTimeBegin;}
public Date getLastTimeEnd() {return lastTimeEnd;}
public void setLastTimeEnd(Date lastTimeEnd) {this.lastTimeEnd = lastTimeEnd;}
}