客房查询.java

该源码为酒店等使用的源码

    private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
    	this.查询3();
    }

    private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
    	this.查询2();
    }

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                         
    	this.显示();
    }                                        

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                         
    	this.dispose();
    	主操作 ma =new 主操作();
		ma.setVisible(true);
    }                                        

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        this.查询1();
    }                                                                      
    
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new 客房查询().setVisible(true);
            }
        });
    }
    public void 显示(){
    	try { 
	        int i = 0;
	        jTable1.removeAll();
	        jTable1.updateUI();
	    	con = java.sql.DriverManager.getConnection("jdbc:odbc:keith","","");
	    	stm = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE);
	    	rs = stm.executeQuery("select o_id,s_name,d_name,o_data,m_name,o_year 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");
	    	while(rs.next()){
	    		o_id = rs.getInt(1);
	    		s_name = rs.getString(2);
	    		d_name = rs.getString(3);
	    		o_date = rs.getString(4);
	    		m_name = rs.getString(5);
	    		o_year = rs.getString(6);
	    	a[i][0] = String.valueOf(o_id);
	    	a[i][1] = s_name;
	    	a[i][2] = d_name;
	    	a[i][3] = o_date;
	    	a[i][4] = m_name;
	    	a[i][5] = o_year;
	    	i++;
	    	}
	    	pack();
	    	defaultModel.setDataVector(a,colname);
	    	stm.close();
	    	con.close();
	    	jTable1.updateUI(); 
    	 }
    	 catch (SQLException ex) {
    		 JOptionPane.showMessageDialog(null,ex);
    	 }
    }
    public void 查询1(){
    	try {
    		jTable1.removeAll();
	        jTable1.updateUI();
    		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);
	    		String temp ="select o_id,s_name,d_name,o_data,m_name,o_year 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 "+"and M.M_name='"+jTextField2.getText()+"'";
	    		rs = stm.executeQuery(temp);
	    		while(rs.next()){
		    		o_id = rs.getInt(1);
		    		s_name = rs.getString(2);
		    		d_name = rs.getString(3);
		    		o_date = rs.getString(4);
		    		m_name = rs.getString(5);
		    		o_year = rs.getString(6);
		    	a[i][0] = String.valueOf(o_id);
		    	a[i][1] = s_name;
		    	a[i][2] = d_name;
		    	a[i][3] = o_date;
		    	a[i][4] = m_name;
		    	a[i][5] = o_year;
		    	i++;
		    	}
		    	pack();
		    	defaultModel.setDataVector(a,colname);
		    	stm.close();
		    	con.close();
		    	jTable1.updateUI();
	    	//String temp ="select o_id,s_name,d_name,o_data,m_name,o_year from m_order O,student S,department D,magazine M where O.s_id=M.m_id and O.s_id=S.s_id and S.d_id=D.d_id";
	    	
    	}
    	catch (SQLException ex) {
   		 JOptionPane.showMessageDialog(null,ex);
   	 }
    }
    public void 查询2(){
    	try {
    		jTable1.removeAll();
	        jTable1.updateUI();
    		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);
	    		String temp ="select o_id,s_name,d_name,o_data,m_name,o_year 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 "+"and S.S_name='"+jTextField1.getText()+"'";
	    		rs = stm.executeQuery(temp);
	    		while(rs.next()){
		    		o_id = rs.getInt(1);
		    		s_name = rs.getString(2);
		    		d_name = rs.getString(3);
		    		o_date = rs.getString(4);
		    		m_name = rs.getString(5);
		    		o_year = rs.getString(6);
		    	a[i][0] = String.valueOf(o_id);
		    	a[i][1] = s_name;
		    	a[i][2] = d_name;
		    	a[i][3] = o_date;
		    	a[i][4] = m_name;
		    	a[i][5] = o_year;
		    	i++;
		    	}
		    	pack();
		    	defaultModel.setDataVector(a,colname);
		    	stm.close();
		    	con.close();
		    	jTable1.updateUI();
	    	//String temp ="select o_id,s_name,d_name,o_data,m_name,o_year from m_order O,student S,department D,magazine M where O.s_id=M.m_id and O.s_id=S.s_id and S.d_id=D.d_id";
	    	
    	}
    	catch (SQLException ex) {
   		 JOptionPane.showMessageDialog(null,ex);
   	 }
    }
    public void 查询3(){
    	try {
    		jTable1.removeAll();
	        jTable1.updateUI();
    		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);
	    		String temp ="select o_id,s_name,d_name,o_data,m_name,o_year 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 "+"and D.d_name='"+jTextField3.getText()+"'";
	    		rs = stm.executeQuery(temp);
	    		while(rs.next()){
		    		o_id = rs.getInt(1);
		    		s_name = rs.getString(2);
		    		d_name = rs.getString(3);
		    		o_date = rs.getString(4);
		    		m_name = rs.getString(5);
		    		o_year = rs.getString(6);
		    	a[i][0] = String.valueOf(o_id);
		    	a[i][1] = s_name;
		    	a[i][2] = d_name;
		    	a[i][3] = o_date;
		    	a[i][4] = m_name;
		    	a[i][5] = o_year;
		    	i++;
		    	}
		    	pack();
		    	defaultModel.setDataVector(a,colname);
		    	stm.close();
		    	con.close();
		    	jTable1.updateUI();
	    	//String temp ="select o_id,s_name,d_name,o_data,m_name,o_year from m_order O,student S,department D,magazine M where O.s_id=M.m_id and O.s_id=S.s_id and S.d_id=D.d_id";
	    	
    	}
    	catch (SQLException ex) {
   		 JOptionPane.showMessageDialog(null,ex);
   	 }
    }
    // 变量声明 - 不进行修改
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton3;
    private javax.swing.JButton jButton4;
    private javax.swing.JButton jButton5;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTable jTable1;
    private javax.swing.JTextField jTextField1;
    private javax.swing.JTextField jTextField2;
    private javax.swing.JTextField jTextField3;
    private javax.swing.JTextField jTextField5;
    private javax.swing.table.DefaultTableModel defaultModel;
    private java.sql.Connection con;
    private java.sql.Statement stm;
    private java.sql.ResultSet rs;
    Object colname[]= {"预订号", "客户姓名", "会员级别", "预订日期", "房间类型", "住宿天数"};
    int o_id;
    String m_name,d_name,s_name,o_date,o_year;
    Object a[][]= new Object[24][6];
    // 变量声明结束
}