电力缴费系统-台区同期线损管理系统(xaa18)_mysql

电力缴费系统-台区同期线损管理系统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_tq(
	id int primary key auto_increment comment '主键',
	tqName varchar(100) comment '台区名称',
	bh varchar(100) comment '编号',
	fzr varchar(100) comment '负责人',
	lxfs varchar(100) comment '联系方式',
	v1 varchar(100) comment '备注1',
	v2 varchar(100) comment '备注2',
	v3 varchar(100) comment '备注3',
	v4 varchar(100) comment '备注4',
	v5 varchar(100) comment '备注5',
	v6 varchar(100) comment '备注6',
	v7 varchar(100) comment '备注7'
) comment '台区';

台区日损表创建语句如下：


create table t_tqrs(
	id int primary key auto_increment comment '主键',
	tqId int comment '台区',
	gdl int comment '供电量',
	sdl int comment '售电量',
	sddl int comment '损失电量',
	xsl int comment '线损率',
	showDate datetime comment '记录日期',
	v1 varchar(100) comment '备注a',
	v2 varchar(100) comment '备注b',
	v3 varchar(100) comment '备注c',
	v4 varchar(100) comment '备注d',
	v5 varchar(100) comment '备注e',
	v6 varchar(100) comment '备注f',
	v7 varchar(100) comment '备注g'
) 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_tq(
	id integer,
	tqName varchar(100),
	bh varchar(100),
	fzr varchar(100),
	lxfs varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100),
	v7 varchar(100)
);
--台区字段加注释
comment on column t_tq.id is '主键';
comment on column t_tq.tqName is '台区名称';
comment on column t_tq.bh is '编号';
comment on column t_tq.fzr is '负责人';
comment on column t_tq.lxfs is '联系方式';
comment on column t_tq.v1 is '备注1';
comment on column t_tq.v2 is '备注2';
comment on column t_tq.v3 is '备注3';
comment on column t_tq.v4 is '备注4';
comment on column t_tq.v5 is '备注5';
comment on column t_tq.v6 is '备注6';
comment on column t_tq.v7 is '备注7';
--台区表加注释
comment on table t_tq is '台区';

台区日损表创建语句如下：


create table t_tqrs(
	id integer,
	tqId int,
	gdl int,
	sdl int,
	sddl int,
	xsl int,
	showDate datetime,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100),
	v7 varchar(100)
);
--台区日损字段加注释
comment on column t_tqrs.id is '主键';
comment on column t_tqrs.tqId is '台区';
comment on column t_tqrs.gdl is '供电量';
comment on column t_tqrs.sdl is '售电量';
comment on column t_tqrs.sddl is '损失电量';
comment on column t_tqrs.xsl is '线损率';
comment on column t_tqrs.showDate is '记录日期';
comment on column t_tqrs.v1 is '备注a';
comment on column t_tqrs.v2 is '备注b';
comment on column t_tqrs.v3 is '备注c';
comment on column t_tqrs.v4 is '备注d';
comment on column t_tqrs.v5 is '备注e';
comment on column t_tqrs.v6 is '备注f';
comment on column t_tqrs.v7 is '备注g';
--台区日损表加注释
comment on table t_tqrs is '台区日损';

oracle特有，对应序列如下：


create sequence s_t_tq;
create sequence s_t_tqrs;

电力缴费系统-台区同期线损管理系统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_tq(
	id int identity(1,1) primary key not null,--主键
	tqName varchar(100),--台区名称
	bh varchar(100),--编号
	fzr varchar(100),--负责人
	lxfs varchar(100),--联系方式
	v1 varchar(100),--备注1
	v2 varchar(100),--备注2
	v3 varchar(100),--备注3
	v4 varchar(100),--备注4
	v5 varchar(100),--备注5
	v6 varchar(100),--备注6
	v7 varchar(100)--备注7
);

台区日损表创建语句如下：


--台区日损表注释
create table t_tqrs(
	id int identity(1,1) primary key not null,--主键
	tqId int,--台区
	gdl int,--供电量
	sdl int,--售电量
	sddl int,--损失电量
	xsl int,--线损率
	showDate datetime,--记录日期
	v1 varchar(100),--备注a
	v2 varchar(100),--备注b
	v3 varchar(100),--备注c
	v4 varchar(100),--备注d
	v5 varchar(100),--备注e
	v6 varchar(100),--备注f
	v7 varchar(100)--备注g
);

电力缴费系统-台区同期线损管理系统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_tq")
public class Tq {
//主键
@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 tqName;
//编号
private String bh;
//负责人
private String fzr;
//联系方式
private String lxfs;
//备注1
private String v1;
//备注2
private String v2;
//备注3
private String v3;
//备注4
private String v4;
//备注5
private String v5;
//备注6
private String v6;
//备注7
private String v7;
public String getTqName() {return tqName;}
public void setTqName(String tqName) {this.tqName = tqName;}
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getLxfs() {return lxfs;}
public void setLxfs(String lxfs) {this.lxfs = lxfs;}
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}

台区日损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_tqrs")
public class Tqrs {
//主键
@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 Long tqId;
//供电量
private Integer gdl;
//售电量
private Integer sdl;
//损失电量
private Integer sddl;
//线损率
private Integer xsl;
//记录日期
private Date showDate;
//备注a
private String v1;
//备注b
private String v2;
//备注c
private String v3;
//备注d
private String v4;
//备注e
private String v5;
//备注f
private String v6;
//备注g
private String v7;
public Long getTqId() {return tqId;}
public void setTqId(Long tqId) {this.tqId = tqId;}
public Integer getGdl() {return gdl;}
public void setGdl(Integer gdl) {this.gdl = gdl;}
public Integer getSdl() {return sdl;}
public void setSdl(Integer sdl) {this.sdl = sdl;}
public Integer getSddl() {return sddl;}
public void setSddl(Integer sddl) {this.sddl = sddl;}
public Integer getXsl() {return xsl;}
public void setXsl(Integer xsl) {this.xsl = xsl;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}

电力缴费系统-台区同期线损管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

台区javaBean创建语句如下：


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

//台区
public class Tq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//台区名称
private String tqName;
//编号
private String bh;
//负责人
private String fzr;
//联系方式
private String lxfs;
//备注1
private String v1;
//备注2
private String v2;
//备注3
private String v3;
//备注4
private String v4;
//备注5
private String v5;
//备注6
private String v6;
//备注7
private String v7;
public String getTqName() {return tqName;}
public void setTqName(String tqName) {this.tqName = tqName;}
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getLxfs() {return lxfs;}
public void setLxfs(String lxfs) {this.lxfs = lxfs;}
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}

台区日损javaBean创建语句如下：


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

//台区日损
public class Tqrs  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//台区
private Long tqId;
//供电量
private Integer gdl;
//售电量
private Integer sdl;
//损失电量
private Integer sddl;
//线损率
private Integer xsl;
//记录日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//备注a
private String v1;
//备注b
private String v2;
//备注c
private String v3;
//备注d
private String v4;
//备注e
private String v5;
//备注f
private String v6;
//备注g
private String v7;
public Long getTqId() {return tqId;}
public void setTqId(Long tqId) {this.tqId = tqId;}
public Integer getGdl() {return gdl;}
public void setGdl(Integer gdl) {this.gdl = gdl;}
public Integer getSdl() {return sdl;}
public void setSdl(Integer sdl) {this.sdl = sdl;}
public Integer getSddl() {return sddl;}
public void setSddl(Integer sddl) {this.sddl = sddl;}
public Integer getXsl() {return xsl;}
public void setXsl(Integer xsl) {this.xsl = xsl;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}

电力缴费系统-台区同期线损管理系统(xaa18)_mysql_oracle代码分享

电力缴费系统-台区同期线损管理系统mysql数据库版本源码：

电力缴费系统-台区同期线损管理系统oracle数据库版本源码：

电力缴费系统-台区同期线损管理系统sqlserver数据库版本源码：

电力缴费系统-台区同期线损管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计：

电力缴费系统-台区同期线损管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

相关毕业设计源码

评论