軸承振動加速度檢測伺服器程式設計

軸承振動加速度檢測伺服器程式設計

• 軸承振動加速度檢測伺服器程式設計mysql資料庫建立語句
• 軸承振動加速度檢測伺服器程式設計oracle資料庫建立語句
• 軸承振動加速度檢測伺服器程式設計sqlserver資料庫建立語句
• 軸承振動加速度檢測伺服器程式設計spring springMVC hibernate框架物件(javaBean,pojo)設計
• 軸承振動加速度檢測伺服器程式設計spring springMVC mybatis框架物件(javaBean,pojo)設計

軸承振動加速度檢測伺服器程式設計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_gzxx(
	id int primary key auto_increment comment '主鍵',
	KIND varchar(100) comment '故障型別',
	D_value varchar(100) comment '故障狀態',
	D_time varchar(100) comment '故障日期',
	T_time varchar(100) comment '故障時間',
	demo varchar(100) comment '是否通知',
	suggest varchar(100) comment '建議',
	Z_value varchar(100) comment '故障值'
) comment '故障型別';

使用者表建立語句如下：

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 '電話',
	pic 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_gzxx(
	id integer,
	KIND varchar(100),
	D_value varchar(100),
	D_time varchar(100),
	T_time varchar(100),
	demo varchar(100),
	suggest varchar(100),
	Z_value varchar(100)
);
--故障型別欄位加註釋
comment on column t_gzxx.id is '主鍵';
comment on column t_gzxx.KIND is '故障型別';
comment on column t_gzxx.D_value is '故障狀態';
comment on column t_gzxx.D_time is '故障日期';
comment on column t_gzxx.T_time is '故障時間';
comment on column t_gzxx.demo is '是否通知';
comment on column t_gzxx.suggest is '建議';
comment on column t_gzxx.Z_value is '故障值';
--故障型別表加註釋
comment on table t_gzxx is '故障型別';

使用者表建立語句如下：

create table t_ptadmin(
	id integer,
	username varchar(100),
	password varchar(100),
	ptadminName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	pic 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 column t_ptadmin.pic is '頭像';
--使用者表加註釋
comment on table t_ptadmin is '使用者';

oracle特有，對應序列如下：

create sequence s_t_gzxx;
create sequence s_t_ptadmin;

軸承振動加速度檢測伺服器程式設計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_gzxx(
	id int identity(1,1) primary key not null,--主鍵
	KIND varchar(100),--故障型別
	D_value varchar(100),--故障狀態
	D_time varchar(100),--故障日期
	T_time varchar(100),--故障時間
	demo varchar(100),--是否通知
	suggest varchar(100),--建議
	Z_value varchar(100)--故障值
);

使用者表建立語句如下：

--使用者表註釋
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),--電話
	pic 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_gzxx")
public class Gzxx {
//主鍵
@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 KIND;
//故障狀態
private String D_value;
//故障日期
private String D_time;
//故障時間
private String T_time;
//是否通知
private String demo;
//建議
private String suggest;
//故障值
private String Z_value;
public String getKIND() {return KIND;}
public void setKIND(String KIND) {this.KIND = KIND;}
public String getD_value() {return D_value;}
public void setD_value(String D_value) {this.D_value = D_value;}
public String getD_time() {return D_time;}
public void setD_time(String D_time) {this.D_time = D_time;}
public String getT_time() {return T_time;}
public void setT_time(String T_time) {this.T_time = T_time;}
public String getDemo() {return demo;}
public void setDemo(String demo) {this.demo = demo;}
public String getSuggest() {return suggest;}
public void setSuggest(String suggest) {this.suggest = suggest;}
public String getZ_value() {return Z_value;}
public void setZ_value(String Z_value) {this.Z_value = Z_value;}
}

使用者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;
//頭像
private String pic;
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;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

軸承振動加速度檢測伺服器程式設計spring springMVC mybatis框架物件(javaBean,pojo)設計：

故障型別javaBean建立語句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//故障型別
public class Gzxx  extends BaseBean{
//主鍵
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//故障型別
private String KIND;
//故障狀態
private String D_value;
//故障日期
private String D_time;
//故障時間
private String T_time;
//是否通知
private String demo;
//建議
private String suggest;
//故障值
private String Z_value;
public String getKIND() {return KIND;}
public void setKIND(String KIND) {this.KIND = KIND;}
public String getD_value() {return D_value;}
public void setD_value(String D_value) {this.D_value = D_value;}
public String getD_time() {return D_time;}
public void setD_time(String D_time) {this.D_time = D_time;}
public String getT_time() {return T_time;}
public void setT_time(String T_time) {this.T_time = T_time;}
public String getDemo() {return demo;}
public void setDemo(String demo) {this.demo = demo;}
public String getSuggest() {return suggest;}
public void setSuggest(String suggest) {this.suggest = suggest;}
public String getZ_value() {return Z_value;}
public void setZ_value(String Z_value) {this.Z_value = Z_value;}
}

使用者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;
//頭像
private String pic;
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;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}