package com.sanqing.data;
import java.awt.Container;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JTextField;
import com.sanqing.util.DBConnection;
public class HistoryData extends JFrame {
private GridBagConstraints c;
private Insets inset;
private GridBagLayout gridbag;
private String uptown_name[], uptown_id[], building_id[], room_id[],
date[];
private int indate;
private JButton button3, button4;
private JComboBox uptownbox, buildingbox, roombox, datebox;
private JLabel uptownLabel, buildingLabel, roomLabel, dateLabel;
private String inuptownid, inuptownname, inbuilding, inroom;
private String water, gas, sec, ele, lift, light;
private String waters[], gass[], eles[], lifts[], lights[], dates[],
secs[];
private int k, t;
public HistoryData(int tt) { //根据参数执行不同的方法
t = 0;
if (tt == 1) {
uptowndata();
}
if (tt == 2) {
buildingdata();
}
if (tt == 3) {
roomdata();
}
}
public HistoryData(int tt, String uptown, String uptownname) {
System.out.println("init 2");
String id, name;
t = 0;
id = new String(uptown);
name = new String(uptownname);
if (tt == 1) {
uptowndata(id, name);
}
if (tt == 2) {
buildingdata(id, name);
}
if (tt == 3) { //业主费用查询
roomdata(id, name);
}
}
public HistoryData(int tt, String uptown, String uptownname, String building) {
System.out.println("init 3");
String id1, id2, name;
t = 0;
id1 = new String(uptown);
id2 = new String(building);
name = new String(uptownname);
if (tt == 2) {
buildingdata(id1, id2, name);
}
if (tt == 3) {
roomdata(id1, id2, name);
}
}
public HistoryData(int tt, String uptown, String uptownname,
String building, String room) {
System.out.println("init 4");
String id1, id2, id3, name;
id1 = new String(uptown);
id2 = new String(building);
id3 = new String(room);
name = new String(uptownname);
System.out.println("id3 =" + id3);
roomdata(id1, id2, id3, name);
}
public HistoryData(String id, String name) // 查询小区全部记录
{
super("查询小区");
JLabel titleLabel, dateLabel[], waterLabel[], eleLabel[], secLabel[];
JTextField waterField[], eleField[], secField[];
JButton button1, button2;
int y;
Container panelin = getContentPane();
gridbag = new GridBagLayout();
panelin.setLayout(gridbag);
waters = new String[3];
eles = new String[3];
secs = new String[3];
dates = new String[3];
dateLabel = new JLabel[3];
waterLabel = new JLabel[3];
eleLabel = new JLabel[3];
secLabel = new JLabel[3];
waterField = new JTextField[3];
eleField = new JTextField[3];
secField = new JTextField[3];
try {
Connection connection4 = DBConnection.getConnection(); //
Statement stmt4 = connection4.createStatement();
String sqlLastData = "SELECT tot_water_reading, tot_elec_reading, sec_supply_reading, date FROM district_reading WHERE district_id="
+ id;
ResultSet rsLastData = stmt4.executeQuery(sqlLastData);
k = 0;
while (rsLastData.next()) {
waters[k] = rsLastData.getString("tot_water_reading");
eles[k] = rsLastData.getString("tot_elec_reading");
secs[k] = rsLastData.getString("sec_supply_reading");
dates[k] = rsLastData.getString("date");
k++;
}
rsLastData.close();
connection4.close();
}
catch (Exception ex) {
System.out.println(ex);
}
titleLabel = new JLabel(name + "最近三个月的水，电与供水用电读数");
inset = new Insets(5, 5, 5, 5);
c = new GridBagConstraints(2, 1, 3, 1, 0, 0, 10, 0, inset, 0, 0);
gridbag.setConstraints(titleLabel, c);
panelin.add(titleLabel);
System.out.println(dates[0]);
System.out.println(dates[1]);
System.out.println(dates[2]);
System.out.println(k);
y = 4;
for (int j = 0; j < k; j++) {
dateLabel[j] = new JLabel(dates[j]);
c = new GridBagConstraints(2, y, 1, 1, 0, 0, 10, 0, inset, 0, 0);
gridbag.setConstraints(dateLabel[j], c);
panelin.add(dateLabel[j]);
waterLabel[j] = new JLabel("用水");
c = new GridBagConstraints(4, y, 1, 1, 0, 0, 10, 0, inset, 0, 0);
gridbag.setConstraints(waterLabel[j], c);
panelin.add(waterLabel[j]);
waterField[j] = new JTextField(waters[j], 7);
waterField[j].setEditable(false);
c = new GridBagConstraints(6, y, 1, 1, 0, 0, 10, 0, inset, 0, 0);
gridbag.setConstraints(waterField[j], c);
panelin.add(waterField[j]);
eleLabel[j] = new JLabel("用电");
c = new GridBagConstraints(8, y, 1, 1, 0, 0, 10, 0, inset, 0, 0);
gridbag.setConstraints(eleLabel[j], c);
panelin.add(eleLabel[j]);
eleField[j] = new JTextField(eles[j], 7);
eleField[j].setEditable(false);
c = new GridBagConstraints(10, y, 1, 1, 0, 0, 10, 0, inset, 0, 0);
gridbag.setConstraints(eleField[j], c);
panelin.add(eleField[j]);
secLabel[j] = new JLabel("二次供水用电");
c = new GridBagConstraints(12, y, 1, 1, 0, 0, 10, 0, inset, 0, 0);
gridbag.setConstraints(secLabel[j], c);
panelin.add(secLabel[j]);
secField[j] = new JTextField(secs[j], 7);
secField[j].setEditable(false);
c = new GridBagConstraints(14, y, 1, 1, 0, 0, 10, 0, inset, 0, 0);
gridbag.setConstraints(secField[j], c);
panelin.add(secField[j]);
y += 5;
}
y += 4;
button1 = new JButton("继续查询");
button1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent event) {
HistoryData rdif = new HistoryData(1);
HistoryData.this.setVisible(false);
}
});
c = new GridBagConstraints(7, y, 2, 2, 0, 0, 10, 0, inset, 0, 0);
gridbag.setConstraints(button1, c);
panelin.add(button1);
button2 = new JButton("返回");
button2.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent event) {
HistoryData.this.setVisible(false);
}
});
c = new GridBagConstraints(10, y, 2, 2, 0, 0, 10, 0, inset, 0, 0);
gridbag.setConstraints(button2, c);
panelin.add(button2);
setSize(800, 300);
setVisible(true);
}
public HistoryData(String id, String name, int date)// 查询特定时期小区记录
{
super("查询小区");
// String water, ele, sec;
System.out.println("init 6");
JLabel titleLabel, dateLabel, waterLabel, eleLabel, secLabel;
JTextField waterField, eleField, secField;
JButton button1, button2;
Container panelin = getContentPane();
gridbag = new GridBagLayout();
panelin.setLayout(gridbag);
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url4 = "jdbc:odbc:estate";
Connection connection4 = DriverManager.getConnection(url4);
Statement stmt4 = connection4.createStatement();
String sqlLastData = "SELECT tot_water_reading, tot_elec_reading, sec_supply_reading FROM district_reading WHERE district_id="
+ id + "AND date=" + date;
ResultSet rsLastData = stmt4.executeQuery(sqlLastData);
while (rsLastData.next()) {
water = rsLastData.getString("tot_water_reading");
ele = rsLastData.getString("tot_elec_reading");
sec = rsLastData.getString("sec_supply_reading");
}
rsLastData.close();
connection4.close();
}
catch (Exception ex) {
System.out.println(ex);
}
titleLabel = new JLabel(name + "在" + date + "的水，电和二次供水用电读数");
inset = new Insets(5, 5, 5, 5);
c = new GridBagConstraints(2, 1, 3, 1, 0, 0, 10, 0, inset, 0, 0);
gridbag.setConstraints(titleLabel, c);
panelin.a
小区物业管理系统 （含 数据库） （186个子文件） 
HistoryData.class 33KB DateHistorySearch.class 19KB UserInfo.class 14KB LouYuinfo.class 13KB MonthDataInputFrame.class 13KB XiaoQuinfo.class 11KB PublicDataInputFrame.class 11KB PublicMonthDataOperate.class 10KB InterfaceStyle.class 9KB MonthDataOperate.class 8KB MonthDataInputBuilding.class 7KB ChargeReport.class 7KB PriceChange.class 6KB MonthDataInputBuilding$2.class 6KB MonthDataInputBuilding$1.class 5KB UptownBuildingRoomShow.class 5KB UptownRoomShow.class 5KB UptownShow.class 4KB Login.class 4KB UptownBuildingShow.class 4KB InfoMaintain.class 4KB InfoMaintain$SelectDistrict.class 3KB Login$LoginCheck.class 3KB MonthDataInputBuilding$1$1.class 3KB MonthDataInputBuilding$2$2.class 3KB PublicDataInputFrame$4.class 3KB MonthDataInputBuilding$2$1.class 3KB Shoufei.class 3KB MonthDataInputFrame$7.class 2KB HistoryData$36.class 2KB InterfaceStyle$UserHandler.class 2KB HistoryData$40.class 2KB HistoryData$29.class 2KB DBConnection.class 2KB DateHistorySearch$19.class 2KB DateHistorySearch$20.class 2KB DateHistorySearch$18.class 2KB HistoryData$38.class 2KB MonthDataInputFrame$5.class 2KB HistoryData$24.class 2KB HistoryData$34.class 2KB ChargeReport$1.class 2KB HistoryData$21.class 2KB XiaoQuinfo$6.class 2KB HistoryData$31.class 2KB DateHistorySearch$15.class 2KB LouYuinfo$7.class 2KB UserInfo$7.class 2KB DateHistorySearch$14.class 2KB DateHistorySearch$11.class 2KB DateHistorySearch$4.class 2KB DateHistorySearch$5.class 2KB DateHistorySearch$3.class 2KB DateHistorySearch$8.class 2KB HistoryData$39.class 2KB HistoryData$19.class 2KB HistoryData$25.class 2KB HistoryData$15.class 2KB HistoryData$35.class 2KB DateHistorySearch$21.class 2KB HistoryData$22.class 2KB HistoryData$32.class 2KB HistoryData$13.class 2KB DateHistorySearch$23.class 1KB DateHistorySearch$10.class 1KB MonthDataInputFrame$1.class 1KB DateHistorySearch$13.class 1KB MonthDataInputFrame$3.class 1KB PublicDataInputFrame$1.class 1KB DateHistorySearch$22.class 1KB DateHistorySearch$16.class 1KB DateHistorySearch$12.class 1KB DateHistorySearch$9.class 1KB DateHistorySearch$6.class 1KB DateHistorySearch$17.class 1KB InfoMaintain$SelectDistrict$1.class 1KB DateHistorySearch$7.class 1KB DateHistorySearch$1.class 1KB DateHistorySearch$2.class 1KB HistoryData$42.class 1KB GetSystime.class 1KB PublicDataInputFrame$2.class 1KB HistoryData$41.class 1KB HistoryData$26.class 1KB HistoryData$27.class 1KB HistoryData$16.class 1KB MonthDataInputFrame$4.class 1KB HistoryData$17.class 1KB InterfaceStyle$16.class 962B InterfaceStyle$LoadHandler.class 955B MonthDataInputBuilding$1$2.class 953B MonthDataInputBuilding$2$3.class 953B HistoryData$11.class 864B HistoryData$9.class 861B MonthDataInputFrame$8.class 858B MonthDataInputFrame$6.class 841B InterfaceStyle$11.class 837B InterfaceStyle$8.class 837B InterfaceStyle$10.class 837B InterfaceStyle$9.class 835B共 186 条
- 1
- 2
资源评论
xi0514642013-12-11还好啦，太简单
ValiZ
- 粉丝: 18
- 资源: 68
最新资源
- 基于蒙特卡洛抽样的电动汽车充电负荷计算(matlab代码版) 主要内容：代码主要主要研究的的是大规模电动汽车的蒙特卡洛模拟，包括电动汽车起始充电时间以及每日行使里程的概率密度分布，在此基础上，进一步计
- MATLAB代码：基于粒子群算法的含风光燃储微网优化调度 关键词：微网优化调度 粒子群算法 风光燃储 参考文档：《基于多目标粒子群算法的微电网优化调度-王金全》仅参考部分模型，非完全复现 优势：代码
- kmeans聚类，肘部法确定聚类个数 代码对数据先进行归一化然后聚类 可设定聚类个数范围，根据肘部法选择合适的聚类个数 可求得每类的具体数据 matlab代码，备注清楚，更改为自己的数据和要求即可
- 同步机VSG DFIG双馈风电机组同步机控制，并网端电源分为理想电源或同步发电机 机组1.5MW，采用控制策略如图片所示 （附赠同步机简易模型）
- P3分布参数拟合与ks检验，累计概率密度画图 对数据进行3参数拟合（形状、尺度、位置参数），可设置ks检验的显著性水平 matlab代码，备注清楚，更改为自己的数据即可
- FLAC3D水力压裂例子，可以拿来参考，有单孔和双孔
- 基于高频脉振电压注入的PMSM无传感器控制 无感控制，高频电压注入 1.包括位置观测器构成是带通滤波器加低通滤波器，采用PLL锁相环，是离散模型 2.也有连续模型，用的是龙贝格观测器提取转子位置和转速
- 拉锥光纤，镀膜、耦合、光栅…… Rsoft beamprop,光纤仿真，光子晶体光纤仿真
- 基于floyd算法的路径规划算法matlab代码，求解常见的路径规划问题 内含算法的注释，模块化编程，新手小白可快速入门 佛洛依德算法，路径规划算法，栅格地图
- 二维互相关随机场模拟实践，保姆级教程 基于matlab与flac6.0的乔列斯基分解的中点法模拟岩土体互相关随机场 自相关函数可以选择：指数型、高斯型、二阶自回归型、指数余弦型、三角型自相关函数 案例
- STM32环形串口队列程序 大数据串口收发 实时不丢包 串口程序平常产品开发中编写或移植的程序并亲自测试通过，均为工程文件格式，可直接编译使用 该程序为大数据量吞吐的串口收发例程，中断接收，边收边
- MCGS与三菱变频器通讯基于MODBUS-RTU程序 ~ 可以通过触摸屏控制变频器正反转，运行停止，还能监视变频器的运行频率，输出频率，输出电压，输出电流以及转速 MCGS嵌入版7.7软件打开
- svr支持向量机回归预测 案例提供数据进行归一化处理，对训练数据训练，对测试集预测，并计算mae、rmse、R2、mre等误差指标 matlab代码，备注详细，根据自己需要修改案例数据即可
- pytho面试资源库（含基础题和面试真题带答案）
- stm32低压无感BLDC方波控制方案 MCU是ST32M0核 负载的ADC反电动势采样 1.启动传统三段式，强拖的步数少，启动快，任意电机基本可以顺利启动切闭环； 2.配有英非凌电感法入算法； 3
- 永磁同步电机滑模控制的直接转矩控制的matlab仿真 SMC DTC直接转矩控制加滑膜控制 转速环调节器 磁链和转矩调节器 磁链和转矩的计算SVPWM矢量控制 含有报告
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
