手机店库存管理系统

手机店库存管理系统登录注册界面

手机店库存管理系统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_cellphone(
	id int primary key auto_increment comment '主键',
	cellphoneName varchar(100) comment '名称',
	xh varchar(100) comment '型号',
	typesId int comment '类别',
	je int comment '单价',
	num int comment '数量',
	pic varchar(100) comment '图片'
) comment '手机';

员工表创建语句如下:


create table t_emp(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	empName varchar(100) comment '姓名',
	sex varchar(100) comment '性别',
	age varchar(100) comment '年龄',
	phone varchar(100) comment '电话',
	headPic varchar(100) comment '头像'
) comment '员工';

手机表创建语句如下:


create table t_jch(
	id int primary key auto_increment comment '主键',
	cellphoneId int comment '手机',
	sl int comment '数量',
	lx varchar(100) comment '进货还是出货',
	insertDate datetime comment '日期',
	czr varchar(100) comment '操作人'
) comment '手机';

手机类别表创建语句如下:


create table t_types(
	id int primary key auto_increment comment '主键',
	typesName varchar(100) 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_cellphone(
	id integer,
	cellphoneName varchar(100),
	xh varchar(100),
	typesId int,
	je int,
	num int,
	pic varchar(100)
);
--手机字段加注释
comment on column t_cellphone.id is '主键';
comment on column t_cellphone.cellphoneName is '名称';
comment on column t_cellphone.xh is '型号';
comment on column t_cellphone.typesId is '类别';
comment on column t_cellphone.je is '单价';
comment on column t_cellphone.num is '数量';
comment on column t_cellphone.pic is '图片';
--手机表加注释
comment on table t_cellphone is '手机';

员工表创建语句如下:


create table t_emp(
	id integer,
	username varchar(100),
	password varchar(100),
	empName varchar(100),
	sex varchar(100),
	age varchar(100),
	phone varchar(100),
	headPic varchar(100)
);
--员工字段加注释
comment on column t_emp.id is '主键';
comment on column t_emp.username is '账号';
comment on column t_emp.password is '密码';
comment on column t_emp.empName is '姓名';
comment on column t_emp.sex is '性别';
comment on column t_emp.age is '年龄';
comment on column t_emp.phone is '电话';
comment on column t_emp.headPic is '头像';
--员工表加注释
comment on table t_emp is '员工';

手机表创建语句如下:


create table t_jch(
	id integer,
	cellphoneId int,
	sl int,
	lx varchar(100),
	insertDate datetime,
	czr varchar(100)
);
--手机字段加注释
comment on column t_jch.id is '主键';
comment on column t_jch.cellphoneId is '手机';
comment on column t_jch.sl is '数量';
comment on column t_jch.lx is '进货还是出货';
comment on column t_jch.insertDate is '日期';
comment on column t_jch.czr is '操作人';
--手机表加注释
comment on table t_jch is '手机';

手机类别表创建语句如下:


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 '手机类别';

oracle特有,对应序列如下:


create sequence s_t_cellphone;
create sequence s_t_emp;
create sequence s_t_jch;
create sequence s_t_types;

手机店库存管理系统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_cellphone(
	id int identity(1,1) primary key not null,--主键
	cellphoneName varchar(100),--名称
	xh varchar(100),--型号
	typesId int,--类别
	je int,--单价
	num int,--数量
	pic varchar(100)--图片
);

员工表创建语句如下:


--员工表注释
create table t_emp(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	empName varchar(100),--姓名
	sex varchar(100),--性别
	age varchar(100),--年龄
	phone varchar(100),--电话
	headPic varchar(100)--头像
);

手机表创建语句如下:


--手机表注释
create table t_jch(
	id int identity(1,1) primary key not null,--主键
	cellphoneId int,--手机
	sl int,--数量
	lx varchar(100),--进货还是出货
	insertDate datetime,--日期
	czr varchar(100)--操作人
);

手机类别表创建语句如下:


--手机类别表注释
create table t_types(
	id int identity(1,1) primary key not null,--主键
	typesName varchar(100)--类别
);

手机店库存管理系统登录后主页

手机店库存管理系统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_cellphone")
public class Cellphone {
//主键
@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 cellphoneName;
//型号
private String xh;
//类别
private Integer typesId;
//单价
private Integer je;
//数量
private Integer num;
//图片
private String pic;
public String getCellphoneName() {return cellphoneName;}
public void setCellphoneName(String cellphoneName) {this.cellphoneName = cellphoneName;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public Integer getJe() {return je;}
public void setJe(Integer je) {this.je = je;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

员工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_emp")
public class Emp {
//主键
@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 empName;
//性别
private String sex;
//年龄
private String age;
//电话
private String phone;
//头像
private String headPic;
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 getEmpName() {return empName;}
public void setEmpName(String empName) {this.empName = empName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
}

手机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_jch")
public class Jch {
//主键
@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 cellphoneId;
//数量
private Integer sl;
//进货还是出货
private String lx;
//日期
private Date insertDate;
//操作人
private String czr;
public Integer getCellphoneId() {return cellphoneId;}
public void setCellphoneId(Integer cellphoneId) {this.cellphoneId = cellphoneId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
}

手机类别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;}
}

手机店库存管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

手机javaBean创建语句如下:


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

//手机
public class Cellphone  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//名称
private String cellphoneName;
//型号
private String xh;
//类别
private Integer typesId;
//单价
private Integer je;
//数量
private Integer num;
//图片
private String pic;
public String getCellphoneName() {return cellphoneName;}
public void setCellphoneName(String cellphoneName) {this.cellphoneName = cellphoneName;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public Integer getJe() {return je;}
public void setJe(Integer je) {this.je = je;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

员工javaBean创建语句如下:


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

//员工
public class Emp  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 empName;
//性别
private String sex;
//年龄
private String age;
//电话
private String phone;
//头像
private String headPic;
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 getEmpName() {return empName;}
public void setEmpName(String empName) {this.empName = empName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
}

手机javaBean创建语句如下:


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

//手机
public class Jch  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//手机
private Integer cellphoneId;
//数量
private Integer sl;
//进货还是出货
private String lx;
//日期
private Date insertDate;
//操作人
private String czr;
public Integer getCellphoneId() {return cellphoneId;}
public void setCellphoneId(Integer cellphoneId) {this.cellphoneId = cellphoneId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
}

手机类别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;}
}

源代码下载点这里

评论