searchstaffinfo.java

一个简单的银行管理系统

        int rowCount = staffModel.getRowCount();
        for(int i=rowCount-1;i>=0;i--)
        {
            staffModel.removeRow(i);
        }
        try
        {
            tableStaff.setModel(staffModel);
            String sql = "Select * from Staff where name like '%"+name+"%'";
            Statement stat = searchStaff.createStatement();
            ResultSet result = stat.executeQuery(sql);
            while(result.next())
            {   
                staffID = result.getString("staffID");
                name = result.getString("name");
                sex = result.getString("sex");
                salary = result.getString("salary");
                date = result.getString("dateJoined");
                         
                String[] info ={staffID,name,sex,date,salary};
                staffModel.addRow(info);                     
            }
            searchStaff.close();
        }
        catch(Exception selectStaffException)
        {
            selectStaffException.printStackTrace();
        }
        this.dispose();
    }//GEN-LAST:event_searchButton3ActionPerformed

    //组合查询响应代码  
    private void searchButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_searchButton2ActionPerformed
 // TODO 将在此处添加您的处理代码：
        String name = nameField1.getText();
        String sex = (sexComboBox.getSelectedItem()).toString();
        int salaryLow = 0;
        int salaryHigh = 0;
        switch(salaryComboBox.getSelectedIndex())
        {
            case 0:
                {
                    salaryLow = 0;
                    salaryHigh = 1000;
                    break;
                }
            case 1:
                {
                    salaryLow = 1000;
                    salaryHigh = 2000;
                    break;
                }
            case 2:
                {
                    salaryLow = 2000;
                    salaryHigh = 3000;
                    break;
                }
            case 3:
                {
                    salaryLow = 3000;
                    salaryHigh = 4000;
                    break;
                }
            case 4:
                {
                    salaryLow = 4000;
                    salaryHigh = 5000;
                    break;
                }
            case 5:
                {
                    salaryLow = 5000;
                    salaryHigh = 9999;
                }

        }
       
        String staffID = "";
        String salary = "";
        String date = "";
        
        int rowCount = staffModel.getRowCount();
        for(int i=rowCount-1;i>=0;i--)
        {
            staffModel.removeRow(i);
        }
        try
        {
            tableStaff.setModel(staffModel);
            String sql = "Select staffID,salary,dateJoined from Staff where name = '"+name+"' and sex = '"+sex+"' and salary between "+salaryLow+" and "+salaryHigh;
            Statement stat = searchStaff.createStatement();
            ResultSet result = stat.executeQuery(sql);
            while(result.next())
            {   
                staffID = result.getString("staffID");
                salary = result.getString("salary");
                date = result.getString("dateJoined");                
                    
                String[] info ={staffID,name,sex,date,salary};
                staffModel.addRow(info);                     
            }
            searchStaff.close();
        }
        catch(Exception selectStaffException)
        {
            selectStaffException.printStackTrace();
        }
        this.dispose();        
    }//GEN-LAST:event_searchButton2ActionPerformed

    //根据员工号精确查询
    private void searchButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_searchButton1ActionPerformed
// TODO 将在此处添加您的处理代码：
        String staffID = " "+IDField.getText();
        String name = "";
        String sex = "";
        String date;
        String salary;
        
        int rowCount = staffModel.getRowCount();
        for(int i=rowCount-1;i>=0;i--)
        {
            staffModel.removeRow(i);
        }
        try
        {
            tableStaff.setModel(staffModel);
            String sql = "Select * from Staff where StaffID = '"+staffID+"'";
            Statement stat = searchStaff.createStatement();
            ResultSet result = stat.executeQuery(sql);
            while(result.next())
            {   
                name = result.getString("name");
                sex = result.getString("sex");
                salary = result.getString("salary");
                date = result.getString("dateJoined");                
                    
                String[] info ={staffID,name,sex,date,salary};
                staffModel.addRow(info);                     
            }
            searchStaff.close();
        }
        catch(Exception selectStaffException)
        {
            selectStaffException.printStackTrace();
        }
        this.dispose();
    }//GEN-LAST:event_searchButton1ActionPerformed
    
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new SearchStaffInfo(null,null).setVisible(true);
            }
        });
    }
     //连接数据库操作－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
    public void connectDB()
    {
        String dbUrl = "jdbc:odbc:afei";
        String user = "scott";
        String password = "tiger";
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            searchStaff = DriverManager.getConnection(dbUrl,user,password);
        }
        catch(Exception connectException)
        {
            connectException.printStackTrace();
        }
    }
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JTextField IDField;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JTextField nameField1;
    private javax.swing.JTextField nameField2;
    private javax.swing.JComboBox salaryComboBox;
    private javax.swing.JButton searchButton1;
    private javax.swing.JButton searchButton2;
    private javax.swing.JButton searchButton3;
    private javax.swing.JComboBox sexComboBox;
    // 变量声明结束//GEN-END:variables
    private Connection searchStaff;
}