📄 住宿统计.java
字号:
package 客房管理系统3;
import java.sql.SQLException;
import javax.swing.JOptionPane;
public class 住宿统计 extends javax.swing.JFrame {
/**
* Creates new form 订阅统计
*/
public 住宿统计() {
initComponents();
}
private void initComponents() {
jTabbedPane1 = new javax.swing.JTabbedPane();
jScrollPane3 = new javax.swing.JScrollPane();
jScrollPane1 = new javax.swing.JScrollPane();
jScrollPane2 = new javax.swing.JScrollPane();
jPanel1 = new javax.swing.JPanel();
jButton1 = new javax.swing.JButton();
jLabel1 = new javax.swing.JLabel();
jTextField1 = new javax.swing.JTextField();
defaultModel1 = new javax.swing.table.DefaultTableModel();
defaultModel2 = new javax.swing.table.DefaultTableModel();
defaultModel3 = new javax.swing.table.DefaultTableModel();
defaultModel1.setDataVector(a1,colname1);
defaultModel2.setDataVector(a2,colname2);
defaultModel3.setDataVector(a3,colname3);
jTable3 = new javax.swing.JTable(defaultModel3);
jTable2 = new javax.swing.JTable(defaultModel2);
jTable1 = new javax.swing.JTable(defaultModel1);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){
System.out.println(e);
}
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setTitle("住宿统计");
setAlwaysOnTop(true);
setBackground(javax.swing.UIManager.getDefaults().getColor("InternalFrame.activeTitleGradient"));
setForeground(javax.swing.UIManager.getDefaults().getColor("InternalFrame.activeTitleGradient"));
jTabbedPane1.setBackground(javax.swing.UIManager.getDefaults().getColor("InternalFrame.activeTitleGradient"));
jTabbedPane1.setTabLayoutPolicy(javax.swing.JTabbedPane.SCROLL_TAB_LAYOUT);
jTabbedPane1.setTabPlacement(javax.swing.JTabbedPane.LEFT);
jTabbedPane1.setAutoscrolls(true);
jTabbedPane1.setDebugGraphicsOptions(javax.swing.DebugGraphics.NONE_OPTION);
jTabbedPane1.setFont(new java.awt.Font("仿宋", 1, 18));
jTabbedPane1.setInheritsPopupMenu(true);
jTabbedPane1.setName("\u6309\u62a5\u520a");
jScrollPane3.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS);
jScrollPane3.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS);
jTable3.setBorder(javax.swing.BorderFactory.createMatteBorder(1, 1, 1, 1, new java.awt.Color(204, 204, 255)));
jScrollPane3.setViewportView(jTable3);
this.显示1();
this.显示2();
this.显示3();
jTabbedPane1.addTab("会员", jScrollPane3);
jScrollPane1.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS);
jScrollPane1.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS);
jScrollPane1.setAutoscrolls(true);
jTable1.setAutoCreateRowSorter(true);
jTable1.setBorder(javax.swing.BorderFactory.createMatteBorder(1, 1, 1, 1, new java.awt.Color(204, 204, 255)));
jScrollPane1.setViewportView(jTable1);
jTabbedPane1.addTab("客房", jScrollPane1);
jScrollPane2.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS);
jScrollPane2.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS);
jTable2.setBorder(javax.swing.BorderFactory.createMatteBorder(1, 1, 1, 1, javax.swing.UIManager.getDefaults().getColor("InternalFrame.activeTitleGradient")));
jTable2.setFont(new java.awt.Font("宋体", 0, 14));
jScrollPane2.setViewportView(jTable2);
jTabbedPane1.addTab("客户", jScrollPane2);
jPanel1.setBackground(javax.swing.UIManager.getDefaults().getColor("InternalFrame.activeTitleGradient"));
jPanel1.setBorder(javax.swing.BorderFactory.createMatteBorder(1, 1, 1, 1, javax.swing.UIManager.getDefaults().getColor("InternalFrame.activeTitleGradient")));
jPanel1.setForeground(javax.swing.UIManager.getDefaults().getColor("InternalFrame.activeTitleGradient"));
jButton1.setText("\u9000\u51fa");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jLabel1.setFont(new java.awt.Font("宋体", 0, 14));
jLabel1.setText("\u7edf\u8ba1\u4fe1\u606f\uff1a");
jTextField1.setEditable(false);
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 71, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(22, 22, 22)
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 200, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(108, Short.MAX_VALUE))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
.addContainerGap(322, Short.MAX_VALUE)
.addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 79, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTextField1, javax.swing.GroupLayout.DEFAULT_SIZE, 30, Short.MAX_VALUE)
.addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, 30, Short.MAX_VALUE))
.addGap(16, 16, 16)
.addComponent(jButton1))
);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 413, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 401, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
);
pack();
}// </editor-fold>
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
this.dispose();
主操作 ma =new 主操作();
ma.setVisible(true);
}
public void 显示1(){
try {
int i = 0;
con = java.sql.DriverManager.getConnection("jdbc:odbc:keith","","");
stm = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE);
rs1 = stm.executeQuery("select m_name,count(*) from 住宿 O,客户 S,会员 D,客房 M where O.m_id=M.m_id and O.s_id=S.s_id and S.d_id=D.d_id GROUP BY m_name;");
while(rs1.next()){
m_name = rs1.getString(1);
m_n = rs1.getString(2);
a1[i][0] = m_name;
a1[i][1] = m_n;
i++;
}
pack();
defaultModel1.setDataVector(a1,colname1);
jTable1.updateUI();
}
catch (SQLException ex) {
JOptionPane.showMessageDialog(null,ex);
}
}
public void 显示2(){
try {
int i = 0;
con = java.sql.DriverManager.getConnection("jdbc:odbc:keith","","");
stm = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE);
rs2 = stm.executeQuery("select s_name,count(*) from 住宿 O,客户 S,会员 D,客房 M where O.m_id=M.m_id and O.s_id=S.s_id and S.d_id=D.D_id group by s_name;");
while(rs2.next()){
s_name = rs2.getString(1);
s_n = rs2.getString(2);
a2[i][0] = s_name;
a2[i][1] = s_n;
i++;
}
pack();
defaultModel2.setDataVector(a2,colname2);
jTable2.updateUI();
}
catch (SQLException ex) {
JOptionPane.showMessageDialog(null,ex);
}
}
public void 显示3(){
try {
int i = 0;
con = java.sql.DriverManager.getConnection("jdbc:odbc:keith","","");
stm = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE);
rs3 = stm.executeQuery("select d_name,count(*) from 住宿 O,客户 S,会员 D,客房 M where O.m_id=M.m_id and O.s_id=S.s_id and S.d_id=D.d_id GROUP BY d_name;");
while(rs3.next()){
d_name = rs3.getString(1);
d_n = rs3.getString(2);
a3[i][0] = d_name;
a3[i][1] = d_n;
i++;
}
pack();
defaultModel3.setDataVector(a3,colname3);
stm.close();
con.close();
jTable3.updateUI();
}
catch (SQLException ex) {
JOptionPane.showMessageDialog(null,ex);
}
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new 住宿统计().setVisible(true);
}
});
}
// 变量声明 - 不进行修改
private javax.swing.JButton jButton1;
private javax.swing.JLabel jLabel1;
private javax.swing.JPanel jPanel1;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JScrollPane jScrollPane3;
private javax.swing.JTabbedPane jTabbedPane1;
private javax.swing.JTable jTable1;
private javax.swing.JTable jTable2;
private javax.swing.JTable jTable3;
private javax.swing.JTextField jTextField1;
private javax.swing.table.DefaultTableModel defaultModel1;
private javax.swing.table.DefaultTableModel defaultModel2;
private javax.swing.table.DefaultTableModel defaultModel3;
private java.sql.Connection con;
private java.sql.Statement stm;
private java.sql.ResultSet rs1,rs2,rs3;
private Object colname3[]= {"会员级别", "住宿天数"};
private Object colname1[]= {"房间类型", "住宿天数"};
private Object colname2[]= {"客户姓名", "住宿天数"};
//private int ;
private String m_n,d_n,s_n,d_name,m_name,s_name;
private Object a1[][]= new Object[24][2];
private Object a2[][]= new Object[24][2];
private Object a3[][]= new Object[24][2];
// 变量声明结束
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -