- 基于Java语言的轴承查询软件mysql数据库创建语句
- 基于Java语言的轴承查询软件oracle数据库创建语句
- 基于Java语言的轴承查询软件sqlserver数据库创建语句
- 基于Java语言的轴承查询软件spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于Java语言的轴承查询软件spring+springMVC+mybatis框架对象(javaBean,pojo)设计
![基于Java语言的轴承查询软件登录注册界面](https://img.javabysj.cn/upload/20201227/基于Java语言的轴承查询软件(xfa106)登录注册界面.jpg?x-oss-process=style/00001)
基于Java语言的轴承查询软件mysql数据库版本源码:
超级管理员表创建语句如下:
create table t_admin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '超级管理员账号',
password varchar(100) comment '超级管理员密码'
) comment '超级管理员';
insert into t_admin(username,password) values('admin','123456');
轴承型号表创建语句如下:
create table t_zcxh(
id int primary key auto_increment comment '主键',
lx varchar(100) comment '',
v1 varchar(100) comment '国内新型号',
v2 varchar(100) comment '国内旧型号',
nj int comment '内径(mm)',
wj int comment '外径(mm)',
kd int comment '宽度(mm)',
cr double comment 'Cr(kN)',
cor double comment 'Cor(kN)',
zs1 int comment '脂润滑转速(r/min)',
zs2 int comment '油润滑转速(r/min)',
zl double comment '重量'
) comment '轴承型号';
基于Java语言的轴承查询软件oracle数据库版本源码:
超级管理员表创建语句如下:
create table t_admin(
id integer,
username varchar(100),
password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';
轴承型号表创建语句如下:
create table t_zcxh(
id integer,
lx varchar(100),
v1 varchar(100),
v2 varchar(100),
nj int,
wj int,
kd int,
cr double,
cor double,
zs1 int,
zs2 int,
zl double
);
--轴承型号字段加注释
comment on column t_zcxh.id is '主键';
comment on column t_zcxh.lx is '';
comment on column t_zcxh.v1 is '国内新型号';
comment on column t_zcxh.v2 is '国内旧型号';
comment on column t_zcxh.nj is '内径(mm)';
comment on column t_zcxh.wj is '外径(mm)';
comment on column t_zcxh.kd is '宽度(mm)';
comment on column t_zcxh.cr is 'Cr(kN)';
comment on column t_zcxh.cor is 'Cor(kN)';
comment on column t_zcxh.zs1 is '脂润滑转速(r/min)';
comment on column t_zcxh.zs2 is '油润滑转速(r/min)';
comment on column t_zcxh.zl is '重量';
--轴承型号表加注释
comment on table t_zcxh is '轴承型号';
oracle特有,对应序列如下:
create sequence s_t_zcxh;
基于Java语言的轴承查询软件sqlserver数据库版本源码:
超级管理员表创建语句如下:
--超级管理员
create table t_admin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--超级管理员账号
password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');
轴承型号表创建语句如下:
--轴承型号表注释
create table t_zcxh(
id int identity(1,1) primary key not null,--主键
lx varchar(100),--
v1 varchar(100),--国内新型号
v2 varchar(100),--国内旧型号
nj int,--内径(mm)
wj int,--外径(mm)
kd int,--宽度(mm)
cr double,--Cr(kN)
cor double,--Cor(kN)
zs1 int,--脂润滑转速(r/min)
zs2 int,--油润滑转速(r/min)
zl double--重量
);
![基于Java语言的轴承查询软件登录后主页](https://img.javabysj.cn/upload/20201227/基于Java语言的轴承查询软件(xfa106)登录后主页.jpg?x-oss-process=style/00001)
基于Java语言的轴承查询软件spring+springMVC+hibernate框架对象(javaBean,pojo)设计:
轴承型号javaBean创建语句如下:
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//轴承型号
@Table(name = "t_zcxh")
public class Zcxh {
//主键
@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 lx;
//国内新型号
private String v1;
//国内旧型号
private String v2;
//内径(mm)
private Integer nj;
//外径(mm)
private Integer wj;
//宽度(mm)
private Integer kd;
//Cr(kN)
private Double cr;
//Cor(kN)
private Double cor;
//脂润滑转速(r/min)
private Integer zs1;
//油润滑转速(r/min)
private Integer zs2;
//重量
private Double zl;
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public Integer getNj() {return nj;}
public void setNj(Integer nj) {this.nj = nj;}
public Integer getWj() {return wj;}
public void setWj(Integer wj) {this.wj = wj;}
public Integer getKd() {return kd;}
public void setKd(Integer kd) {this.kd = kd;}
public Double getCr() {return cr;}
public void setCr(Double cr) {this.cr = cr;}
public Double getCor() {return cor;}
public void setCor(Double cor) {this.cor = cor;}
public Integer getZs1() {return zs1;}
public void setZs1(Integer zs1) {this.zs1 = zs1;}
public Integer getZs2() {return zs2;}
public void setZs2(Integer zs2) {this.zs2 = zs2;}
public Double getZl() {return zl;}
public void setZl(Double zl) {this.zl = zl;}
}
基于Java语言的轴承查询软件spring+springMVC+mybatis框架对象(javaBean,pojo)设计:
轴承型号javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//轴承型号
public class Zcxh extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String lx;
//国内新型号
private String v1;
//国内旧型号
private String v2;
//内径(mm)
private Integer nj;
//外径(mm)
private Integer wj;
//宽度(mm)
private Integer kd;
//Cr(kN)
private Double cr;
//Cor(kN)
private Double cor;
//脂润滑转速(r/min)
private Integer zs1;
//油润滑转速(r/min)
private Integer zs2;
//重量
private Double zl;
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public Integer getNj() {return nj;}
public void setNj(Integer nj) {this.nj = nj;}
public Integer getWj() {return wj;}
public void setWj(Integer wj) {this.wj = wj;}
public Integer getKd() {return kd;}
public void setKd(Integer kd) {this.kd = kd;}
public Double getCr() {return cr;}
public void setCr(Double cr) {this.cr = cr;}
public Double getCor() {return cor;}
public void setCor(Double cor) {this.cor = cor;}
public Integer getZs1() {return zs1;}
public void setZs1(Integer zs1) {this.zs1 = zs1;}
public Integer getZs2() {return zs2;}
public void setZs2(Integer zs2) {this.zs2 = zs2;}
public Double getZl() {return zl;}
public void setZl(Double zl) {this.zl = zl;}
}