药品管理系统
药品管理系统mysql数据库创建语句

药品管理系统oracle数据库创建语句

药品管理系统sqlserver数据库创建语句

药品管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计

药品管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计

药品管理系统登录注册界面

高质量编程视频：shangyepingtai.xin

药品管理系统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’);

SQLCopy

厂家表创建语句如下：
create table t_cj(

id int primary key auto_increment comment ‘主键’,

cjName varchar(100) comment ‘类型名称’,

lxdh varchar(100) comment ‘联系电话’

) comment ‘厂家’;

SQLCopy

出入库表创建语句如下：
create table t_crk(

id int primary key auto_increment comment ‘主键’,

ypId int comment ‘药品’,

crk varchar(100) comment ‘出库入库’,

num int comment ‘数量’

) comment ‘出入库’;

SQLCopy

用户表创建语句如下：
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 ‘用户’;

SQLCopy

供货商表创建语句如下：
create table t_ghs(

id int primary key auto_increment comment ‘主键’,

ghsName varchar(100) comment ‘供货商名称’,

lxdh varchar(100) comment ‘联系电话’

) comment ‘供货商’;

SQLCopy

科室表创建语句如下：
create table t_ks(

id int primary key auto_increment comment ‘主键’,

ksName varchar(100) comment ‘供货商名称’,

lxdh varchar(100) comment ‘联系电话’

) comment ‘科室’;

SQLCopy

普通管理员表创建语句如下：
create table t_ptadmin(

id int primary key auto_increment comment ‘主键’,

username varchar(100) comment ‘账号’,

password varchar(100) comment ‘密码’,

ptadminName varchar(100) comment ‘姓名’,

age varchar(100) comment ‘年龄’,

sex varchar(100) comment ‘性别’,

phone varchar(100) comment ‘电话’

) comment ‘普通管理员’;

SQLCopy

分类表创建语句如下：
create table t_types(

id int primary key auto_increment comment ‘主键’,

typesName varchar(100) comment ‘类型名称’

) comment ‘分类’;

SQLCopy

药品表创建语句如下：
create table t_yp(

id int primary key auto_increment comment ‘主键’,

ypName varchar(100) comment ‘药品名称’,

typesId int comment ‘分类’,

cjId int comment ‘厂家’,

ksId int comment ‘科室’,

ghsId int comment ‘供货商’,

gg varchar(100) comment ‘规格’,

yl varchar(100) comment ‘用量’,

pic varchar(100) comment ‘图片’,

yxq datetime comment ‘有效期’,

aqz int comment ‘安全值’,

num int comment ‘数量’

) comment ‘药品’;

SQLCopy

药品管理系统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 ‘超级管理员’;

SQLCopy

厂家表创建语句如下：
create table t_cj(

id integer,

cjName varchar(100),

lxdh varchar(100)

);

–厂家字段加注释

comment on column t_cj.id is ‘主键’;

comment on column t_cj.cjName is ‘类型名称’;

comment on column t_cj.lxdh is ‘联系电话’;

–厂家表加注释

comment on table t_cj is ‘厂家’;

SQLCopy

出入库表创建语句如下：
create table t_crk(

id integer,

ypId int,

crk varchar(100),

num int

);

–出入库字段加注释

comment on column t_crk.id is ‘主键’;

comment on column t_crk.ypId is ‘药品’;

comment on column t_crk.crk is ‘出库入库’;

comment on column t_crk.num is ‘数量’;

–出入库表加注释

comment on table t_crk is ‘出入库’;

SQLCopy

用户表创建语句如下：
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 ‘用户’;

SQLCopy

供货商表创建语句如下：
create table t_ghs(

id integer,

ghsName varchar(100),

lxdh varchar(100)

);

–供货商字段加注释

comment on column t_ghs.id is ‘主键’;

comment on column t_ghs.ghsName is ‘供货商名称’;

comment on column t_ghs.lxdh is ‘联系电话’;

–供货商表加注释

comment on table t_ghs is ‘供货商’;

SQLCopy

科室表创建语句如下：
create table t_ks(

id integer,

ksName varchar(100),

lxdh varchar(100)

);

–科室字段加注释

comment on column t_ks.id is ‘主键’;

comment on column t_ks.ksName is ‘供货商名称’;

comment on column t_ks.lxdh is ‘联系电话’;

–科室表加注释

comment on table t_ks is ‘科室’;

SQLCopy

普通管理员表创建语句如下：
create table t_ptadmin(

id integer,

username varchar(100),

password varchar(100),

ptadminName varchar(100),

age varchar(100),

sex varchar(100),

phone varchar(100)

);

–普通管理员字段加注释

comment on column t_ptadmin.id is ‘主键’;

comment on column t_ptadmin.username is ‘账号’;

comment on column t_ptadmin.password is ‘密码’;

comment on column t_ptadmin.ptadminName is ‘姓名’;

comment on column t_ptadmin.age is ‘年龄’;

comment on column t_ptadmin.sex is ‘性别’;

comment on column t_ptadmin.phone is ‘电话’;

–普通管理员表加注释

comment on table t_ptadmin is ‘普通管理员’;

SQLCopy

分类表创建语句如下：
create table t_types(

id integer,

typesName varchar(100)

);

–分类字段加注释

comment on column t_types.id is ‘主键’;

comment on column t_types.typesName is ‘类型名称’;

–分类表加注释

comment on table t_types is ‘分类’;

SQLCopy

药品表创建语句如下：
create table t_yp(

id integer,

ypName varchar(100),

typesId int,

cjId int,

ksId int,

ghsId int,

gg varchar(100),

yl varchar(100),

pic varchar(100),

yxq datetime,

aqz int,

num int

);

–药品字段加注释

comment on column t_yp.id is ‘主键’;

comment on column t_yp.ypName is ‘药品名称’;

comment on column t_yp.typesId is ‘分类’;

comment on column t_yp.cjId is ‘厂家’;

comment on column t_yp.ksId is ‘科室’;

comment on column t_yp.ghsId is ‘供货商’;

comment on column t_yp.gg is ‘规格’;

comment on column t_yp.yl is ‘用量’;

comment on column t_yp.pic is ‘图片’;

comment on column t_yp.yxq is ‘有效期’;

comment on column t_yp.aqz is ‘安全值’;

comment on column t_yp.num is ‘数量’;

–药品表加注释

comment on table t_yp is ‘药品’;

SQLCopy

oracle特有，对应序列如下：
create sequence s_t_cj;

create sequence s_t_crk;

create sequence s_t_customer;

create sequence s_t_ghs;

create sequence s_t_ks;

create sequence s_t_ptadmin;

create sequence s_t_types;

create sequence s_t_yp;

SQLCopy

药品管理系统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’);

SQLCopy

厂家表创建语句如下：
–厂家表注释

create table t_cj(

id int identity(1,1) primary key not null,–主键

cjName varchar(100),–类型名称

lxdh varchar(100)–联系电话

);

SQLCopy

出入库表创建语句如下：
–出入库表注释

create table t_crk(

id int identity(1,1) primary key not null,–主键

ypId int,–药品

crk varchar(100),–出库入库

num int–数量

);

SQLCopy

用户表创建语句如下：
–用户表注释

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)–电话

);

SQLCopy

供货商表创建语句如下：
–供货商表注释

create table t_ghs(

id int identity(1,1) primary key not null,–主键

ghsName varchar(100),–供货商名称

lxdh varchar(100)–联系电话

);

SQLCopy

科室表创建语句如下：
–科室表注释

create table t_ks(

id int identity(1,1) primary key not null,–主键

ksName varchar(100),–供货商名称

lxdh varchar(100)–联系电话

);

SQLCopy

普通管理员表创建语句如下：
–普通管理员表注释

create table t_ptadmin(

id int identity(1,1) primary key not null,–主键

username varchar(100),–账号

password varchar(100),–密码

ptadminName varchar(100),–姓名

age varchar(100),–年龄

sex varchar(100),–性别

phone varchar(100)–电话

);

SQLCopy

分类表创建语句如下：
–分类表注释

create table t_types(

id int identity(1,1) primary key not null,–主键

typesName varchar(100)–类型名称

);

SQLCopy

药品表创建语句如下：
–药品表注释

create table t_yp(

id int identity(1,1) primary key not null,–主键

ypName varchar(100),–药品名称

typesId int,–分类

cjId int,–厂家

ksId int,–科室

ghsId int,–供货商

gg varchar(100),–规格

yl varchar(100),–用量

pic varchar(100),–图片

yxq datetime,–有效期

aqz int,–安全值

num int–数量

);

SQLCopy

药品管理系统登录后主页

药品管理系统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_cj”)

public class Cj {

//主键

@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 cjName;

//联系电话

private String lxdh;

public String getCjName() {return cjName;}

public void setCjName(String cjName) {this.cjName = cjName;}

public String getLxdh() {return lxdh;}

public void setLxdh(String lxdh) {this.lxdh = lxdh;}

}

JavaCopy

出入库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_crk”)

public class Crk {

//主键

@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 ypId;

//出库入库

private String crk;

//数量

private Integer num;

public Integer getYpId() {return ypId;}

public void setYpId(Integer ypId) {this.ypId = ypId;}

public String getCrk() {return crk;}

public void setCrk(String crk) {this.crk = crk;}

public Integer getNum() {return num;}

public void setNum(Integer num) {this.num = num;}

}

JavaCopy

用户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;}

}

JavaCopy

供货商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_ghs”)

public class Ghs {

//主键

@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 ghsName;

//联系电话

private String lxdh;

public String getGhsName() {return ghsName;}

public void setGhsName(String ghsName) {this.ghsName = ghsName;}

public String getLxdh() {return lxdh;}

public void setLxdh(String lxdh) {this.lxdh = lxdh;}

}

JavaCopy

科室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_ks”)

public class Ks {

//主键

@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 ksName;

//联系电话

private String lxdh;

public String getKsName() {return ksName;}

public void setKsName(String ksName) {this.ksName = ksName;}

public String getLxdh() {return lxdh;}

public void setLxdh(String lxdh) {this.lxdh = lxdh;}

}

JavaCopy

普通管理员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_ptadmin”)

public class Ptadmin {

//主键

@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 ptadminName;

//年龄

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 getPtadminName() {return ptadminName;}

public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}

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

}

JavaCopy

分类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_types”)

public class Types {

//主键

@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 typesName;

public String getTypesName() {return typesName;}

public void setTypesName(String typesName) {this.typesName = typesName;}

}

JavaCopy

药品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_yp”)

public class Yp {

//主键

@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 ypName;

//分类

private Integer typesId;

//厂家

private Integer cjId;

//科室

private Integer ksId;

//供货商

private Integer ghsId;

//规格

private String gg;

//用量

private String yl;

//图片

private String pic;

//有效期

private Date yxq;

//安全值

private Integer aqz;

//数量

private Integer num;

public String getYpName() {return ypName;}

public void setYpName(String ypName) {this.ypName = ypName;}

public Integer getTypesId() {return typesId;}

public void setTypesId(Integer typesId) {this.typesId = typesId;}

public Integer getCjId() {return cjId;}

public void setCjId(Integer cjId) {this.cjId = cjId;}

public Integer getKsId() {return ksId;}

public void setKsId(Integer ksId) {this.ksId = ksId;}

public Integer getGhsId() {return ghsId;}

public void setGhsId(Integer ghsId) {this.ghsId = ghsId;}

public String getGg() {return gg;}

public void setGg(String gg) {this.gg = gg;}

public String getYl() {return yl;}

public void setYl(String yl) {this.yl = yl;}

public String getPic() {return pic;}

public void setPic(String pic) {this.pic = pic;}

public Date getYxq() {return yxq;}

public void setYxq(Date yxq) {this.yxq = yxq;}

public Integer getAqz() {return aqz;}

public void setAqz(Integer aqz) {this.aqz = aqz;}

public Integer getNum() {return num;}

public void setNum(Integer num) {this.num = num;}

}

JavaCopy

药品管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

厂家javaBean创建语句如下：
package project.model;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;
//厂家

public class Cj  extends BaseBean{

//主键

private Integer id;

public Integer getId() {return id;}

public void setId(Integer id) {this.id = id;}

//类型名称

private String cjName;

//联系电话

private String lxdh;

public String getCjName() {return cjName;}

public void setCjName(String cjName) {this.cjName = cjName;}

public String getLxdh() {return lxdh;}

public void setLxdh(String lxdh) {this.lxdh = lxdh;}

}

JavaCopy

出入库javaBean创建语句如下：
package project.model;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;
//出入库

public class Crk  extends BaseBean{

//主键

private Integer id;

public Integer getId() {return id;}

public void setId(Integer id) {this.id = id;}

//药品

private Integer ypId;

//出库入库

private String crk;

//数量

private Integer num;

public Integer getYpId() {return ypId;}

public void setYpId(Integer ypId) {this.ypId = ypId;}

public String getCrk() {return crk;}

public void setCrk(String crk) {this.crk = crk;}

public Integer getNum() {return num;}

public void setNum(Integer num) {this.num = num;}

}

JavaCopy

用户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;}

}

JavaCopy

供货商javaBean创建语句如下：
package project.model;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;
//供货商

public class Ghs  extends BaseBean{

//主键

private Integer id;

public Integer getId() {return id;}

public void setId(Integer id) {this.id = id;}

//供货商名称

private String ghsName;

//联系电话

private String lxdh;

public String getGhsName() {return ghsName;}

public void setGhsName(String ghsName) {this.ghsName = ghsName;}

public String getLxdh() {return lxdh;}

public void setLxdh(String lxdh) {this.lxdh = lxdh;}

}

JavaCopy

科室javaBean创建语句如下：
package project.model;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;
//科室

public class Ks  extends BaseBean{

//主键

private Integer id;

public Integer getId() {return id;}

public void setId(Integer id) {this.id = id;}

//供货商名称

private String ksName;

//联系电话

private String lxdh;

public String getKsName() {return ksName;}

public void setKsName(String ksName) {this.ksName = ksName;}

public String getLxdh() {return lxdh;}

public void setLxdh(String lxdh) {this.lxdh = lxdh;}

}

JavaCopy

普通管理员javaBean创建语句如下：
package project.model;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;
//普通管理员

public class Ptadmin  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 ptadminName;

//年龄

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 getPtadminName() {return ptadminName;}

public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}

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

}

JavaCopy

分类javaBean创建语句如下：
package project.model;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;
//分类

public class Types  extends BaseBean{

//主键

private Integer id;

public Integer getId() {return id;}

public void setId(Integer id) {this.id = id;}

//类型名称

private String typesName;

public String getTypesName() {return typesName;}

public void setTypesName(String typesName) {this.typesName = typesName;}

}

JavaCopy

药品javaBean创建语句如下：
package project.model;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;
//药品

public class Yp  extends BaseBean{

//主键

private Integer id;

public Integer getId() {return id;}

public void setId(Integer id) {this.id = id;}

//药品名称

private String ypName;

//分类

private Integer typesId;

//厂家

private Integer cjId;

//科室

private Integer ksId;

//供货商

private Integer ghsId;

//规格

private String gg;

//用量

private String yl;

//图片

private String pic;

//有效期

private Date yxq;

//安全值

private Integer aqz;

//数量

private Integer num;

public String getYpName() {return ypName;}

public void setYpName(String ypName) {this.ypName = ypName;}

public Integer getTypesId() {return typesId;}

public void setTypesId(Integer typesId) {this.typesId = typesId;}

public Integer getCjId() {return cjId;}

public void setCjId(Integer cjId) {this.cjId = cjId;}

public Integer getKsId() {return ksId;}

public void setKsId(Integer ksId) {this.ksId = ksId;}

public Integer getGhsId() {return ghsId;}

public void setGhsId(Integer ghsId) {this.ghsId = ghsId;}

public String getGg() {return gg;}

public void setGg(String gg) {this.gg = gg;}

public String getYl() {return yl;}

public void setYl(String yl) {this.yl = yl;}

public String getPic() {return pic;}

public void setPic(String pic) {this.pic = pic;}

public Date getYxq() {return yxq;}

public void setYxq(Date yxq) {this.yxq = yxq;}

public Integer getAqz() {return aqz;}

public void setAqz(Integer aqz) {this.aqz = aqz;}

public Integer getNum() {return num;}

public void setNum(Integer num) {this.num = num;}

}

JavaCopy

介绍：

技术：java、jsp

数据库：mysql

web服务器：Tomcat

集成开发工具：myeclipse
截图：














数据库表：
CREATE TABLE admin (

id int(4) NOT NULL auto_increment,

name varchar(50) NOT NULL,

pwd varchar(50) default NULL,

quanxian int(4) default NULL,

PRIMARY KEY  (name),

UNIQUE KEY id (id)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;
/*Data for the table admin */
insert  into admin(id,name,pwd,quanxian) values (2,‘111’,‘111’,-1),(1,‘admin’,‘024admin’,-1);
/*Table structure for table dingdan */
DROP TABLE IF EXISTS dingdan;
CREATE TABLE dingdan (

id int(4) NOT NULL auto_increment,

supplierid varchar(50) default NULL,

zuangtai int(4) default ‘0’,

times varchar(50) default ‘2008-5-20’,

UNIQUE KEY id (id)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312;
/*Data for the table dingdan */
insert  into dingdan(id,supplierid,zuangtai,times) values (1,‘3’,0,‘2008-5-20’),(2,‘3’,1,‘2008-5-20’),(3,‘2’,0,‘2008-5-20’);
/*Table structure for table leibie */
DROP TABLE IF EXISTS leibie;
CREATE TABLE leibie (

id int(4) NOT NULL auto_increment,

leibie varchar(50) NOT NULL,

PRIMARY KEY  (leibie),

UNIQUE KEY id (id)

) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;
/*Data for the table leibie */
insert  into leibie(id,leibie) values (1,‘方便面类’),(2,‘服装类’),(3,‘玻璃产品类’),(4,‘qq’),(5,‘aa’),(6,‘2222’);
/*Table structure for table sandd */
DROP TABLE IF EXISTS sandd;
CREATE TABLE sandd (

id int(4) NOT NULL auto_increment,

dingdanid int(4) default NULL,

shangpinid int(4) default NULL,

sums int(4) default NULL,

UNIQUE KEY id (id)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;
源码下载地址：http://www.bycxy123.com/

基于ssm药品管理系统mysql数据库创建语句

基于ssm药品管理系统oracle数据库创建语句

基于ssm药品管理系统sqlserver数据库创建语句

基于ssm药品管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计

基于ssm药品管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计

基于ssm药品管理系统登录注册界面

基于ssm药品管理系统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’);

SQLCopy

药品出库入库表创建语句如下：

create table t_ckrk(

id int primary key auto_increment comment ‘主键’,

yaopinId int comment ‘药品’,

sl int comment ‘数量’,

types varchar(100) comment ‘类型’,

content varchar(100) comment ‘详细记录’,

insertDate datetime comment ‘日期’

) comment ‘药品出库入库’;

SQLCopy

销售表创建语句如下：

create table t_customer(

id int primary key auto_increment comment ‘主键’,

username varchar(100) comment ‘账号’,

password varchar(100) comment ‘密码’,

customerName varchar(100) comment ‘姓名’,

gh varchar(100) comment ‘工号’,

phone varchar(100) comment ‘电话’,

age varchar(100) comment ‘年龄’,

sex varchar(100) comment ‘性别’

) comment ‘销售’;

SQLCopy

医生表创建语句如下：

create table t_doctor(

id int primary key auto_increment comment ‘主键’,

username varchar(100) comment ‘账号’,

password varchar(100) comment ‘密码’,

doctorName varchar(100) comment ‘姓名’,

phone varchar(100) comment ‘电话’,

age varchar(100) comment ‘年龄’,

sex varchar(100) comment ‘性别’,

ks varchar(100) comment ‘科室’,

gh varchar(100) comment ‘工号’,

zc varchar(100) comment ‘职称’

) comment ‘医生’;

SQLCopy

公告表创建语句如下：

create table t_gg(

id int primary key auto_increment comment ‘主键’,

v1 varchar(100) comment ‘标题’,

pic varchar(100) comment ‘图片’,

showDate datetime comment ‘日期’,

v3 varchar(100) comment ‘内容’

) comment ‘公告’;

SQLCopy

供应商表创建语句如下：

create table t_gys(

id int primary key auto_increment comment ‘主键’,

gysName varchar(100) comment ‘供应商名称’,

address varchar(100) comment ‘地址’,

lxr varchar(100) comment ‘供应商联系人’,

phone varchar(100) comment ‘联系人电话’,

yp varchar(100) comment ‘主营药品’

) comment ‘供应商’;

SQLCopy

患者表创建语句如下：

create table t_hz(

id int primary key auto_increment comment ‘主键’,

username varchar(100) comment ‘账号’,

password varchar(100) comment ‘密码’,

hzName varchar(100) comment ‘姓名’,

phone varchar(100) comment ‘电话’,

age varchar(100) comment ‘年龄’,

sex varchar(100) comment ‘性别’,

bs varchar(100) comment ‘病史’,

sfz varchar(100) comment ‘身份证’,

ybk varchar(100) comment ‘医保卡’

) comment ‘患者’;

SQLCopy

库存管理员表创建语句如下：

create table t_kcadmin(

id int primary key auto_increment comment ‘主键’,

username varchar(100) comment ‘账号’,

password varchar(100) comment ‘密码’,

kcadminName varchar(100) comment ‘姓名’,

gh varchar(100) comment ‘工号’,

phone varchar(100) comment ‘电话’,

age varchar(100) comment ‘年龄’,

sex varchar(100) comment ‘性别’

) comment ‘库存管理员’;

SQLCopy

药品订单表创建语句如下：

create table t_order(

id int primary key auto_increment comment ‘主键’,

doctorId int comment ‘医生’,

ddbh varchar(100) comment ‘订单编号’,

hzId int comment ‘患者’,

fee int comment ‘总金额’,

ypqd varchar(100) comment ‘药品清单’,

showDate datetime comment ‘日期’,

status varchar(100) comment ‘状态’

) comment ‘药品订单’;

SQLCopy

药品退货表创建语句如下：

create table t_th(

id int primary key auto_increment comment ‘主键’,

hzId int comment ‘患者’,

ypqd varchar(100) comment ‘退货药品’,

insertDate datetime comment ‘退货日期’,

status varchar(100) comment ‘状态’

) comment ‘药品退货’;

SQLCopy

药品销售表创建语句如下：

create table t_xiaoshou(

id int primary key auto_increment comment ‘主键’,

customerId int comment ‘销售’,

yaopinId int comment ‘药品’,

sl int comment ‘数量’,

showDate datetime comment ‘销售日期’,

kh varchar(100) comment ‘客户’,

zje int comment ‘总金额’

) comment ‘药品销售’;

SQLCopy

药品表创建语句如下：

create table t_yaopin(

id int primary key auto_increment comment ‘主键’,

gysId int comment ‘供应商’,

yaopinName varchar(100) comment ‘药品’,

gg varchar(100) comment ‘规格’,

zy varchar(100) comment ‘作用’,

content varchar(100) comment ‘详细说明’,

pic varchar(100) comment ‘图片’,

kc int comment ‘库存’,

dj int comment ‘单价’

) comment ‘药品’;

SQLCopy

基于ssm药品管理系统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 ‘超级管理员’;

SQLCopy

药品出库入库表创建语句如下：

create table t_ckrk(

id integer,

yaopinId int,

sl int,

types varchar(100),

content varchar(100),

insertDate datetime

);

–药品出库入库字段加注释

comment on column t_ckrk.id is ‘主键’;

comment on column t_ckrk.yaopinId is ‘药品’;

comment on column t_ckrk.sl is ‘数量’;

comment on column t_ckrk.types is ‘类型’;

comment on column t_ckrk.content is ‘详细记录’;

comment on column t_ckrk.insertDate is ‘日期’;

–药品出库入库表加注释

comment on table t_ckrk is ‘药品出库入库’;

SQLCopy

销售表创建语句如下：

create table t_customer(

id integer,

username varchar(100),

password varchar(100),

customerName varchar(100),

gh varchar(100),

phone varchar(100),

age varchar(100),

sex 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.gh is ‘工号’;

comment on column t_customer.phone is ‘电话’;

comment on column t_customer.age is ‘年龄’;

comment on column t_customer.sex is ‘性别’;

–销售表加注释

comment on table t_customer is ‘销售’;

SQLCopy

医生表创建语句如下：

create table t_doctor(

id integer,

username varchar(100),

password varchar(100),

doctorName varchar(100),

phone varchar(100),

age varchar(100),

sex varchar(100),

ks varchar(100),

gh varchar(100),

zc varchar(100)

);

–医生字段加注释

comment on column t_doctor.id is ‘主键’;

comment on column t_doctor.username is ‘账号’;

comment on column t_doctor.password is ‘密码’;

comment on column t_doctor.doctorName is ‘姓名’;

comment on column t_doctor.phone is ‘电话’;

comment on column t_doctor.age is ‘年龄’;

comment on column t_doctor.sex is ‘性别’;

comment on column t_doctor.ks is ‘科室’;

comment on column t_doctor.gh is ‘工号’;

comment on column t_doctor.zc is ‘职称’;

–医生表加注释

comment on table t_doctor is ‘医生’;

SQLCopy

公告表创建语句如下：

create table t_gg(

id integer,

v1 varchar(100),

pic varchar(100),

showDate datetime,

v3 varchar(100)

);

–公告字段加注释

comment on column t_gg.id is ‘主键’;

comment on column t_gg.v1 is ‘标题’;

comment on column t_gg.pic is ‘图片’;

comment on column t_gg.showDate is ‘日期’;

comment on column t_gg.v3 is ‘内容’;

–公告表加注释

comment on table t_gg is ‘公告’;

SQLCopy

供应商表创建语句如下：

create table t_gys(

id integer,

gysName varchar(100),

address varchar(100),

lxr varchar(100),

phone varchar(100),

yp varchar(100)

);

–供应商字段加注释

comment on column t_gys.id is ‘主键’;

comment on column t_gys.gysName is ‘供应商名称’;

comment on column t_gys.address is ‘地址’;

comment on column t_gys.lxr is ‘供应商联系人’;

comment on column t_gys.phone is ‘联系人电话’;

comment on column t_gys.yp is ‘主营药品’;

–供应商表加注释

comment on table t_gys is ‘供应商’;

SQLCopy

患者表创建语句如下：

create table t_hz(

id integer,

username varchar(100),

password varchar(100),

hzName varchar(100),

phone varchar(100),

age varchar(100),

sex varchar(100),

bs varchar(100),

sfz varchar(100),

ybk varchar(100)

);

–患者字段加注释

comment on column t_hz.id is ‘主键’;

comment on column t_hz.username is ‘账号’;

comment on column t_hz.password is ‘密码’;

comment on column t_hz.hzName is ‘姓名’;

comment on column t_hz.phone is ‘电话’;

comment on column t_hz.age is ‘年龄’;

comment on column t_hz.sex is ‘性别’;

comment on column t_hz.bs is ‘病史’;

comment on column t_hz.sfz is ‘身份证’;

comment on column t_hz.ybk is ‘医保卡’;

–患者表加注释

comment on table t_hz is ‘患者’;

SQLCopy

库存管理员表创建语句如下：

create table t_kcadmin(

id integer,

username varchar(100),

password varchar(100),

kcadminName varchar(100),

gh varchar(100),

phone varchar(100),

age varchar(100),

sex varchar(100)

);

–库存管理员字段加注释

comment on column t_kcadmin.id is ‘主键’;

comment on column t_kcadmin.username is ‘账号’;

comment on column t_kcadmin.password is ‘密码’;

comment on column t_kcadmin.kcadminName is ‘姓名’;

comment on column t_kcadmin.gh is ‘工号’;

comment on column t_kcadmin.phone is ‘电话’;

comment on column t_kcadmin.age is ‘年龄’;

comment on column t_kcadmin.sex is ‘性别’;

–库存管理员表加注释

comment on table t_kcadmin is ‘库存管理员’;

SQLCopy

药品订单表创建语句如下：

create table t_order(

id integer,

doctorId int,

ddbh varchar(100),

hzId int,

fee int,

ypqd varchar(100),

showDate datetime,

status varchar(100)

);

–药品订单字段加注释

comment on column t_order.id is ‘主键’;

comment on column t_order.doctorId is ‘医生’;

comment on column t_order.ddbh is ‘订单编号’;

comment on column t_order.hzId is ‘患者’;

comment on column t_order.fee is ‘总金额’;

comment on column t_order.ypqd is ‘药品清单’;

comment on column t_order.showDate is ‘日期’;

comment on column t_order.status is ‘状态’;

–药品订单表加注释

comment on table t_order is ‘药品订单’;

SQLCopy

药品退货表创建语句如下：

create table t_th(

id integer,

hzId int,

ypqd varchar(100),

insertDate datetime,

status varchar(100)

);

–药品退货字段加注释

comment on column t_th.id is ‘主键’;

comment on column t_th.hzId is ‘患者’;

comment on column t_th.ypqd is ‘退货药品’;

comment on column t_th.insertDate is ‘退货日期’;

comment on column t_th.status is ‘状态’;

–药品退货表加注释

comment on table t_th is ‘药品退货’;

SQLCopy

药品销售表创建语句如下：

create table t_xiaoshou(

id integer,

customerId int,

yaopinId int,

sl int,

showDate datetime,

kh varchar(100),

zje int

);

–药品销售字段加注释

comment on column t_xiaoshou.id is ‘主键’;

comment on column t_xiaoshou.customerId is ‘销售’;

comment on column t_xiaoshou.yaopinId is ‘药品’;

comment on column t_xiaoshou.sl is ‘数量’;

comment on column t_xiaoshou.showDate is ‘销售日期’;

comment on column t_xiaoshou.kh is ‘客户’;

comment on column t_xiaoshou.zje is ‘总金额’;

–药品销售表加注释

comment on table t_xiaoshou is ‘药品销售’;

SQLCopy

药品表创建语句如下：

create table t_yaopin(

id integer,

gysId int,

yaopinName varchar(100),

gg varchar(100),

zy varchar(100),

content varchar(100),

pic varchar(100),

kc int,

dj int

);

–药品字段加注释

comment on column t_yaopin.id is ‘主键’;

comment on column t_yaopin.gysId is ‘供应商’;

comment on column t_yaopin.yaopinName is ‘药品’;

comment on column t_yaopin.gg is ‘规格’;

comment on column t_yaopin.zy is ‘作用’;

comment on column t_yaopin.content is ‘详细说明’;

comment on column t_yaopin.pic is ‘图片’;

comment on column t_yaopin.kc is ‘库存’;

comment on column t_yaopin.dj is ‘单价’;

–药品表加注释

comment on table t_yaopin is ‘药品’;

SQLCopy

oracle特有，对应序列如下：

create sequence s_t_ckrk;

create sequence s_t_customer;

create sequence s_t_doctor;

create sequence s_t_gg;

create sequence s_t_gys;

create sequence s_t_hz;

create sequence s_t_kcadmin;

create sequence s_t_order;

create sequence s_t_th;

create sequence s_t_xiaoshou;

create sequence s_t_yaopin;

SQLCopy

基于ssm药品管理系统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’);

SQLCopy

药品出库入库表创建语句如下：

–药品出库入库表注释

create table t_ckrk(

id int identity(1,1) primary key not null,–主键

yaopinId int,–药品

sl int,–数量

types varchar(100),–类型

content varchar(100),–详细记录

insertDate datetime–日期

);

SQLCopy

销售表创建语句如下：

–销售表注释

create table t_customer(

id int identity(1,1) primary key not null,–主键

username varchar(100),–账号

password varchar(100),–密码

customerName varchar(100),–姓名

gh varchar(100),–工号

phone varchar(100),–电话

age varchar(100),–年龄

sex varchar(100)–性别

);

SQLCopy

医生表创建语句如下：

–医生表注释

create table t_doctor(

id int identity(1,1) primary key not null,–主键

username varchar(100),–账号

password varchar(100),–密码

doctorName varchar(100),–姓名

phone varchar(100),–电话

age varchar(100),–年龄

sex varchar(100),–性别

ks varchar(100),–科室

gh varchar(100),–工号

zc varchar(100)–职称

);

SQLCopy

公告表创建语句如下：

–公告表注释

create table t_gg(

id int identity(1,1) primary key not null,–主键

v1 varchar(100),–标题

pic varchar(100),–图片

showDate datetime,–日期

v3 varchar(100)–内容

);

SQLCopy

供应商表创建语句如下：

–供应商表注释

create table t_gys(

id int identity(1,1) primary key not null,–主键

gysName varchar(100),–供应商名称

address varchar(100),–地址

lxr varchar(100),–供应商联系人

phone varchar(100),–联系人电话

yp varchar(100)–主营药品

);

SQLCopy

患者表创建语句如下：

–患者表注释

create table t_hz(

id int identity(1,1) primary key not null,–主键

username varchar(100),–账号

password varchar(100),–密码

hzName varchar(100),–姓名

phone varchar(100),–电话

age varchar(100),–年龄

sex varchar(100),–性别

bs varchar(100),–病史

sfz varchar(100),–身份证

ybk varchar(100)–医保卡

);

SQLCopy

库存管理员表创建语句如下：

–库存管理员表注释

create table t_kcadmin(

id int identity(1,1) primary key not null,–主键

username varchar(100),–账号

password varchar(100),–密码

kcadminName varchar(100),–姓名

gh varchar(100),–工号

phone varchar(100),–电话

age varchar(100),–年龄

sex varchar(100)–性别

);

SQLCopy

药品订单表创建语句如下：

–药品订单表注释

create table t_order(

id int identity(1,1) primary key not null,–主键

doctorId int,–医生

ddbh varchar(100),–订单编号

hzId int,–患者

fee int,–总金额

ypqd varchar(100),–药品清单

showDate datetime,–日期

status varchar(100)–状态

);

SQLCopy

药品退货表创建语句如下：

–药品退货表注释

create table t_th(

id int identity(1,1) primary key not null,–主键

hzId int,–患者

ypqd varchar(100),–退货药品

insertDate datetime,–退货日期

status varchar(100)–状态

);

SQLCopy

药品销售表创建语句如下：

–药品销售表注释

create table t_xiaoshou(

id int identity(1,1) primary key not null,–主键

customerId int,–销售

yaopinId int,–药品

sl int,–数量

showDate datetime,–销售日期

kh varchar(100),–客户

zje int–总金额

);

SQLCopy

药品表创建语句如下：

–药品表注释

create table t_yaopin(

id int identity(1,1) primary key not null,–主键

gysId int,–供应商

yaopinName varchar(100),–药品

gg varchar(100),–规格

zy varchar(100),–作用

content varchar(100),–详细说明

pic varchar(100),–图片

kc int,–库存

dj int–单价

);

SQLCopy

基于ssm药品管理系统登录后主页

基于ssm药品管理系统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_ckrk”)

public class Ckrk {

//主键

@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 yaopinId;

//数量

private Integer sl;

//类型

private String types;

//详细记录

private String content;

//日期

private Date insertDate;

public Integer getYaopinId() {return yaopinId;}

public void setYaopinId(Integer yaopinId) {this.yaopinId = yaopinId;}

public Integer getSl() {return sl;}

public void setSl(Integer sl) {this.sl = sl;}

public String getTypes() {return types;}

public void setTypes(String types) {this.types = types;}

public String getContent() {return content;}

public void setContent(String content) {this.content = content;}

public Date getInsertDate() {return insertDate;}

public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}

}

JavaCopy

销售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 gh;

//电话

private String phone;

//年龄

private String age;

//性别

private String sex;

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 getGh() {return gh;}

public void setGh(String gh) {this.gh = gh;}

public String getPhone() {return phone;}

public void setPhone(String phone) {this.phone = phone;}

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

}

JavaCopy

医生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_doctor”)

public class Doctor {

//主键

@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 doctorName;

//电话

private String phone;

//年龄

private String age;

//性别

private String sex;

//科室

private String ks;

//工号

private String gh;

//职称

private String zc;

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 getDoctorName() {return doctorName;}

public void setDoctorName(String doctorName) {this.doctorName = doctorName;}

public String getPhone() {return phone;}

public void setPhone(String phone) {this.phone = phone;}

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 getKs() {return ks;}

public void setKs(String ks) {this.ks = ks;}

public String getGh() {return gh;}

public void setGh(String gh) {this.gh = gh;}

public String getZc() {return zc;}

public void setZc(String zc) {this.zc = zc;}

}

JavaCopy

公告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_gg”)

public class Gg {

//主键

@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 pic;

//日期

private Date showDate;

//内容

private String v3;

public String getV1() {return v1;}

public void setV1(String v1) {this.v1 = v1;}

public String getPic() {return pic;}

public void setPic(String pic) {this.pic = pic;}

public Date getShowDate() {return showDate;}

public void setShowDate(Date showDate) {this.showDate = showDate;}

public String getV3() {return v3;}

public void setV3(String v3) {this.v3 = v3;}

}

JavaCopy

供应商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_gys”)

public class Gys {

//主键

@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 gysName;

//地址

private String address;

//供应商联系人

private String lxr;

//联系人电话

private String phone;

//主营药品

private String yp;

public String getGysName() {return gysName;}

public void setGysName(String gysName) {this.gysName = gysName;}

public String getAddress() {return address;}

public void setAddress(String address) {this.address = address;}

public String getLxr() {return lxr;}

public void setLxr(String lxr) {this.lxr = lxr;}

public String getPhone() {return phone;}

public void setPhone(String phone) {this.phone = phone;}

public String getYp() {return yp;}

public void setYp(String yp) {this.yp = yp;}

}

JavaCopy

患者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_hz”)

public class Hz {

//主键

@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 hzName;

//电话

private String phone;

//年龄

private String age;

//性别

private String sex;

//病史

private String bs;

//身份证

private String sfz;

//医保卡

private String ybk;

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 getHzName() {return hzName;}

public void setHzName(String hzName) {this.hzName = hzName;}

public String getPhone() {return phone;}

public void setPhone(String phone) {this.phone = phone;}

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 getBs() {return bs;}

public void setBs(String bs) {this.bs = bs;}

public String getSfz() {return sfz;}

public void setSfz(String sfz) {this.sfz = sfz;}

public String getYbk() {return ybk;}

public void setYbk(String ybk) {this.ybk = ybk;}

}

JavaCopy

库存管理员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_kcadmin”)

public class Kcadmin {

//主键

@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 kcadminName;

//工号

private String gh;

//电话

private String phone;

//年龄

private String age;

//性别

private String sex;

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 getKcadminName() {return kcadminName;}

public void setKcadminName(String kcadminName) {this.kcadminName = kcadminName;}

public String getGh() {return gh;}

public void setGh(String gh) {this.gh = gh;}

public String getPhone() {return phone;}

public void setPhone(String phone) {this.phone = phone;}

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

}

JavaCopy

药品订单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 doctorId;

//订单编号

private String ddbh;

//患者

private Integer hzId;

//总金额

private Integer fee;

//药品清单

private String ypqd;

//日期

private Date showDate;

//状态

private String status;

public Integer getDoctorId() {return doctorId;}

public void setDoctorId(Integer doctorId) {this.doctorId = doctorId;}

public String getDdbh() {return ddbh;}

public void setDdbh(String ddbh) {this.ddbh = ddbh;}

public Integer getHzId() {return hzId;}

public void setHzId(Integer hzId) {this.hzId = hzId;}

public Integer getFee() {return fee;}

public void setFee(Integer fee) {this.fee = fee;}

public String getYpqd() {return ypqd;}

public void setYpqd(String ypqd) {this.ypqd = ypqd;}

public Date getShowDate() {return showDate;}

public void setShowDate(Date showDate) {this.showDate = showDate;}

public String getStatus() {return status;}

public void setStatus(String status) {this.status = status;}

}

JavaCopy

药品退货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_th”)

public class Th {

//主键

@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 hzId;

//退货药品

private String ypqd;

//退货日期

private Date insertDate;

//状态

private String status;

public Integer getHzId() {return hzId;}

public void setHzId(Integer hzId) {this.hzId = hzId;}

public String getYpqd() {return ypqd;}

public void setYpqd(String ypqd) {this.ypqd = ypqd;}

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

}

JavaCopy

药品销售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_xiaoshou”)

public class Xiaoshou {

//主键

@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 Integer yaopinId;

//数量

private Integer sl;

//销售日期

private Date showDate;

//客户

private String kh;

//总金额

private Integer zje;

public Integer getCustomerId() {return customerId;}

public void setCustomerId(Integer customerId) {this.customerId = customerId;}

public Integer getYaopinId() {return yaopinId;}

public void setYaopinId(Integer yaopinId) {this.yaopinId = yaopinId;}

public Integer getSl() {return sl;}

public void setSl(Integer sl) {this.sl = sl;}

public Date getShowDate() {return showDate;}

public void setShowDate(Date showDate) {this.showDate = showDate;}

public String getKh() {return kh;}

public void setKh(String kh) {this.kh = kh;}

public Integer getZje() {return zje;}

public void setZje(Integer zje) {this.zje = zje;}

}

JavaCopy

药品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_yaopin”)

public class Yaopin {

//主键

@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 gysId;

//药品

private String yaopinName;

//规格

private String gg;

//作用

private String zy;

//详细说明

private String content;

//图片

private String pic;

//库存

private Integer kc;

//单价

private Integer dj;

public Integer getGysId() {return gysId;}

public void setGysId(Integer gysId) {this.gysId = gysId;}

public String getYaopinName() {return yaopinName;}

public void setYaopinName(String yaopinName) {this.yaopinName = yaopinName;}

public String getGg() {return gg;}

public void setGg(String gg) {this.gg = gg;}

public String getZy() {return zy;}

public void setZy(String zy) {this.zy = zy;}

public String getContent() {return content;}

public void setContent(String content) {this.content = content;}

public String getPic() {return pic;}

public void setPic(String pic) {this.pic = pic;}

public Integer getKc() {return kc;}

public void setKc(Integer kc) {this.kc = kc;}

public Integer getDj() {return dj;}

public void setDj(Integer dj) {this.dj = dj;}

}

JavaCopy

基于ssm药品管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

药品出库入库javaBean创建语句如下：

package project.model;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

//药品出库入库

public class Ckrk extends BaseBean{

//主键

private Integer id;

public Integer getId() {return id;}

public void setId(Integer id) {this.id = id;}

//药品

private Integer yaopinId;

//数量

private Integer sl;

//类型

private String types;

//详细记录

private String content;

//日期

private Date insertDate;

public Integer getYaopinId() {return yaopinId;}

public void setYaopinId(Integer yaopinId) {this.yaopinId = yaopinId;}

public Integer getSl() {return sl;}

public void setSl(Integer sl) {this.sl = sl;}

public String getTypes() {return types;}

public void setTypes(String types) {this.types = types;}

public String getContent() {return content;}

public void setContent(String content) {this.content = content;}

public Date getInsertDate() {return insertDate;}

public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}

}

JavaCopy

销售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 gh;

//电话

private String phone;

//年龄

private String age;

//性别

private String sex;

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 getGh() {return gh;}

public void setGh(String gh) {this.gh = gh;}

public String getPhone() {return phone;}

public void setPhone(String phone) {this.phone = phone;}

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

}

JavaCopy

医生javaBean创建语句如下：

package project.model;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

//医生

public class Doctor 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 doctorName;

//电话

private String phone;

//年龄

private String age;

//性别

private String sex;

//科室

private String ks;

//工号

private String gh;

//职称

private String zc;

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 getDoctorName() {return doctorName;}

public void setDoctorName(String doctorName) {this.doctorName = doctorName;}

public String getPhone() {return phone;}

public void setPhone(String phone) {this.phone = phone;}

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 getKs() {return ks;}

public void setKs(String ks) {this.ks = ks;}

public String getGh() {return gh;}

public void setGh(String gh) {this.gh = gh;}

public String getZc() {return zc;}

public void setZc(String zc) {this.zc = zc;}

}

JavaCopy

公告javaBean创建语句如下：

package project.model;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

//公告

public class Gg extends BaseBean{

//主键

private Integer id;

public Integer getId() {return id;}

public void setId(Integer id) {this.id = id;}

//标题

private String v1;

//图片

private String pic;

//日期

private Date showDate;

//内容

private String v3;

public String getV1() {return v1;}

public void setV1(String v1) {this.v1 = v1;}

public String getPic() {return pic;}

public void setPic(String pic) {this.pic = pic;}

public Date getShowDate() {return showDate;}

public void setShowDate(Date showDate) {this.showDate = showDate;}

public String getV3() {return v3;}

public void setV3(String v3) {this.v3 = v3;}

}

JavaCopy

供应商javaBean创建语句如下：

package project.model;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

//供应商

public class Gys extends BaseBean{

//主键

private Integer id;

public Integer getId() {return id;}

public void setId(Integer id) {this.id = id;}

//供应商名称

private String gysName;

//地址

private String address;

//供应商联系人

private String lxr;

//联系人电话

private String phone;

//主营药品

private String yp;

public String getGysName() {return gysName;}

public void setGysName(String gysName) {this.gysName = gysName;}

public String getAddress() {return address;}

public void setAddress(String address) {this.address = address;}

public String getLxr() {return lxr;}

public void setLxr(String lxr) {this.lxr = lxr;}

public String getPhone() {return phone;}

public void setPhone(String phone) {this.phone = phone;}

public String getYp() {return yp;}

public void setYp(String yp) {this.yp = yp;}

}

JavaCopy

患者javaBean创建语句如下：

package project.model;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

//患者

public class Hz 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 hzName;

//电话

private String phone;

//年龄

private String age;

//性别

private String sex;

//病史

private String bs;

//身份证

private String sfz;

//医保卡

private String ybk;

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 getHzName() {return hzName;}

public void setHzName(String hzName) {this.hzName = hzName;}

public String getPhone() {return phone;}

public void setPhone(String phone) {this.phone = phone;}

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 getBs() {return bs;}

public void setBs(String bs) {this.bs = bs;}

public String getSfz() {return sfz;}

public void setSfz(String sfz) {this.sfz = sfz;}

public String getYbk() {return ybk;}

public void setYbk(String ybk) {this.ybk = ybk;}

}

JavaCopy

库存管理员javaBean创建语句如下：

package project.model;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

//库存管理员

public class Kcadmin 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 kcadminName;

//工号

private String gh;

//电话

private String phone;

//年龄

private String age;

//性别

private String sex;

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 getKcadminName() {return kcadminName;}

public void setKcadminName(String kcadminName) {this.kcadminName = kcadminName;}

public String getGh() {return gh;}

public void setGh(String gh) {this.gh = gh;}

public String getPhone() {return phone;}

public void setPhone(String phone) {this.phone = phone;}

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

}

JavaCopy

药品订单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 doctorId;

//订单编号

private String ddbh;

//患者

private Integer hzId;

//总金额

private Integer fee;

//药品清单

private String ypqd;

//日期

private Date showDate;

//状态

private String status;

public Integer getDoctorId() {return doctorId;}

public void setDoctorId(Integer doctorId) {this.doctorId = doctorId;}

public String getDdbh() {return ddbh;}

public void setDdbh(String ddbh) {this.ddbh = ddbh;}

public Integer getHzId() {return hzId;}

public void setHzId(Integer hzId) {this.hzId = hzId;}

public Integer getFee() {return fee;}

public void setFee(Integer fee) {this.fee = fee;}

public String getYpqd() {return ypqd;}

public void setYpqd(String ypqd) {this.ypqd = ypqd;}

public Date getShowDate() {return showDate;}

public void setShowDate(Date showDate) {this.showDate = showDate;}

public String getStatus() {return status;}

public void setStatus(String status) {this.status = status;}

}

JavaCopy

药品退货javaBean创建语句如下：

package project.model;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

//药品退货

public class Th extends BaseBean{

//主键

private Integer id;

public Integer getId() {return id;}

public void setId(Integer id) {this.id = id;}

//患者

private Integer hzId;

//退货药品

private String ypqd;

//退货日期

private Date insertDate;

//状态

private String status;

public Integer getHzId() {return hzId;}

public void setHzId(Integer hzId) {this.hzId = hzId;}

public String getYpqd() {return ypqd;}

public void setYpqd(String ypqd) {this.ypqd = ypqd;}

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

}

JavaCopy

药品销售javaBean创建语句如下：

package project.model;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

//药品销售

public class Xiaoshou extends BaseBean{

//主键

private Integer id;

public Integer getId() {return id;}

public void setId(Integer id) {this.id = id;}

//销售

private Integer customerId;

//药品

private Integer yaopinId;

//数量

private Integer sl;

//销售日期

private Date showDate;

//客户

private String kh;

//总金额

private Integer zje;

public Integer getCustomerId() {return customerId;}

public void setCustomerId(Integer customerId) {this.customerId = customerId;}

public Integer getYaopinId() {return yaopinId;}

public void setYaopinId(Integer yaopinId) {this.yaopinId = yaopinId;}

public Integer getSl() {return sl;}

public void setSl(Integer sl) {this.sl = sl;}

public Date getShowDate() {return showDate;}

public void setShowDate(Date showDate) {this.showDate = showDate;}

public String getKh() {return kh;}

public void setKh(String kh) {this.kh = kh;}

public Integer getZje() {return zje;}

public void setZje(Integer zje) {this.zje = zje;}

}

JavaCopy

药品javaBean创建语句如下：

package project.model;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

//药品

public class Yaopin extends BaseBean{

//主键

private Integer id;

public Integer getId() {return id;}

public void setId(Integer id) {this.id = id;}

//供应商

private Integer gysId;

//药品

private String yaopinName;

//规格

private String gg;

//作用

private String zy;

//详细说明

private String content;

//图片

private String pic;

//库存

private Integer kc;

//单价

private Integer dj;

public Integer getGysId() {return gysId;}

public void setGysId(Integer gysId) {this.gysId = gysId;}

public String getYaopinName() {return yaopinName;}

public void setYaopinName(String yaopinName) {this.yaopinName = yaopinName;}

public String getGg() {return gg;}

public void setGg(String gg) {this.gg = gg;}

public String getZy() {return zy;}

public void setZy(String zy) {this.zy = zy;}

public String getContent() {return content;}

public void setContent(String content) {this.content = content;}

public String getPic() {return pic;}

public void setPic(String pic) {this.pic = pic;}

public Integer getKc() {return kc;}

public void setKc(Integer kc) {this.kc = kc;}

public Integer getDj() {return dj;}

public void setDj(Integer dj) {this.dj = dj;}

}

 

介绍：

技术：java、jsp

数据库：mysql

web服务器：Tomcat

集成开发工具：myeclipse

截图：











数据库表：

CREATE TABLE admin (
id int(4) NOT NULL auto_increment,
name varchar(50) NOT NULL,
pwd varchar(50) default NULL,
quanxian int(4) default NULL,

PRIMARY KEY (name),

UNIQUE KEY id (id)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;

/*Data for the table admin */

insert into admin(id,name,pwd,quanxian) values (2,‘111’,‘111’,-1),(1,‘admin’,‘024admin’,-1);

/*Table structure for table dingdan */

DROP TABLE IF EXISTS dingdan;

CREATE TABLE dingdan (
id int(4) NOT NULL auto_increment,
supplierid varchar(50) default NULL,
zuangtai int(4) default ‘0’,
times varchar(50) default ‘2008-5-20’,

UNIQUE KEY id (id)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312;

/*Data for the table dingdan */

insert into dingdan(id,supplierid,zuangtai,times) values (1,‘3’,0,‘2008-5-20’),(2,‘3’,1,‘2008-5-20’),(3,‘2’,0,‘2008-5-20’);

/*Table structure for table leibie */

DROP TABLE IF EXISTS leibie;

CREATE TABLE leibie (
id int(4) NOT NULL auto_increment,
leibie varchar(50) NOT NULL,

PRIMARY KEY (leibie),

UNIQUE KEY id (id)

) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;

/*Data for the table leibie */

insert into leibie(id,leibie) values (1,‘方便面类’),(2,‘服装类’),(3,‘玻璃产品类’),(4,‘qq’),(5,‘aa’),(6,‘2222’);

/*Table structure for table sandd */

DROP TABLE IF EXISTS sandd;

CREATE TABLE sandd (
id int(4) NOT NULL auto_increment,
dingdanid int(4) default NULL,
shangpinid int(4) default NULL,
sums int(4) default NULL,

UNIQUE KEY id (id)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;