infoframe.java

学生信息管理系统,实现学生信息的录入、查询、修改、删除等功能

                    record.addElement(rs.getString("name"));
                    record.addElement(rs.getString("sex"));
                    record.addElement(rs.getString("addr"));
                    record.addElement(rs.getString("tel"));
                    vec.addElement(record);
                }
                     infolist.setListData(vec);
                      rs.close();
                      pstmt.close();

            } catch (Exception exception) {
                exception.printStackTrace();
            }

    }
//-------------------------------搜索性别-----------------------------------
    public void searchsex(String key) throws Error {
try {
              con = DriverManager.getConnection(madguy + "src/data.mdb");
               con.setAutoCommit(true);
            String sexSQL = "SELECT * FROM students WHERE sex=?";
            PreparedStatement pstmt = con.prepareStatement("" +sexSQL);
            pstmt.setString(1, key);
            ResultSet rs = pstmt.executeQuery();

               while(rs.next()) {
                Vector record = new Vector();
                record.addElement(rs.getString("num"));
                record.addElement(rs.getString("name"));
                record.addElement(rs.getString("sex"));
                record.addElement(rs.getString("addr"));
                record.addElement(rs.getString("tel"));
                vec.addElement(record);
            }

                 infolist.setListData(vec);
                  rs.close();
                  pstmt.close();

        } catch (Exception exception) {
            exception.printStackTrace();
        }

    }
//--------------------------------搜索地址---------------------------------
    public void searchaddr(String key) throws Error {
try {
            con = DriverManager.getConnection(madguy + "src/data.mdb");
             con.setAutoCommit(true);
            String addrSQL = "SELECT * FROM students WHERE addr=?";

            PreparedStatement pstmt = con.prepareStatement("" + addrSQL);
            pstmt.setString(1, key);
            ResultSet rs = pstmt.executeQuery();

               while(rs.next()) {
                Vector record = new Vector();
                record.addElement(rs.getString("name"));
                record.addElement(rs.getString("num"));
                record.addElement(rs.getString("sex"));
                record.addElement(rs.getString("addr"));
                record.addElement(rs.getString("tel"));
                vec.addElement(record);
            }
                 infolist.setListData(vec);
                  rs.close();
                  pstmt.close();

        } catch (Exception exception) {
            exception.printStackTrace();
        }

    }
//----------------------------搜索电话-----------------------------------------
    public void searchtel(String key) throws Error {
try {
              con = DriverManager.getConnection(madguy + "src/data.mdb");
               con.setAutoCommit(true);
            String telSQL = "SELECT * FROM students WHERE tel=?";

            PreparedStatement pstmt = con.prepareStatement("" + telSQL);
            pstmt.setString(1, key);
            ResultSet rs = pstmt.executeQuery();

               while(rs.next()) {
                Vector record = new Vector();
                record.addElement(rs.getString("num"));
                record.addElement(rs.getString("name"));
                record.addElement(rs.getString("sex"));
                record.addElement(rs.getString("addr"));
                record.addElement(rs.getString("tel"));
                vec.addElement(record);
            }
                 infolist.setListData(vec);
                  rs.close();
                  pstmt.close();

        } catch (Exception exception) {
            exception.printStackTrace();
        }

    }
//---------------------------------------搜索结束------------------------------


//---------退出按钮监听----------
    public void exitB_mouseClicked(MouseEvent e) {
        this.dispose();
    }
//---------录入按钮监听----------
    public void newB_mouseClicked(MouseEvent e) {
        regFrame lalala=new regFrame();
        lalala.setVisible(true);
    }
//---------搜索按钮监听----------
    public void searchB_mouseClicked(MouseEvent e) {
       String keys=searchT.getText();
       vec.removeAllElements();
       search(keys);
    }
//---------刷新按钮监听----------
    public void freshB_mouseClicked(MouseEvent e) {
       prepare_connect();
    }
//-------删除按钮监听------------
    public void delB_mouseClicked(MouseEvent e) {
     String stuinfo=infolist.getSelectedValue().toString();
     String number=stuinfo.substring(1,9);//获得选择的行的学号
     useData db = new Data(new File("src/data.mdb"));
     //连接数据库
      if(db.delete(number)==1){
      ErrBox succ=new ErrBox();
      succ.setVisible(true);
      succ.errinfo.setText("信息删除成功，请按刷新按钮刷新");
      succ.errinfoE.setText("删除项的学号为"+number);
       }else{
      ErrBox succ=new ErrBox();
      succ.setVisible(true);
      succ.errinfo.setText("错啦！！");
      succ.errinfoE.setText("unsuccessfully");

       }
    }
//----------修改按钮监听---------
    public void changeB_mouseClicked(MouseEvent e) {
     String stuinfo=infolist.getSelectedValue().toString();
     String number=stuinfo.substring(1,9);//获得选择的行的学号
     edit(number);
    }
}


class infoFrame_changeB_mouseAdapter extends MouseAdapter {
    private infoFrame adaptee;
    infoFrame_changeB_mouseAdapter(infoFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.changeB_mouseClicked(e);
    }
}


class infoFrame_delB_mouseAdapter extends MouseAdapter {
    private infoFrame adaptee;
    infoFrame_delB_mouseAdapter(infoFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.delB_mouseClicked(e);
    }
}


class infoFrame_freshB_mouseAdapter extends MouseAdapter {
    private infoFrame adaptee;
    infoFrame_freshB_mouseAdapter(infoFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.freshB_mouseClicked(e);
    }
}


class infoFrame_searchB_mouseAdapter extends MouseAdapter {
    private infoFrame adaptee;
    infoFrame_searchB_mouseAdapter(infoFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.searchB_mouseClicked(e);
    }
}


class infoFrame_newB_mouseAdapter extends MouseAdapter {
    private infoFrame adaptee;
    infoFrame_newB_mouseAdapter(infoFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.newB_mouseClicked(e);
    }
}


class infoFame_exitB_mouseAdapter extends MouseAdapter {
    private infoFrame adaptee;
    infoFame_exitB_mouseAdapter(infoFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.exitB_mouseClicked(e);
    }
}