基于netbeans的团员信息管理系统

package mypackage; import java.awt.*; import java.awt.event.*; import java.sql.*; import java.util.*; import javax.swing.*; public class SearchFrame { public static void main(String args[]) { SearchBox ss=new SearchBox("查询信息"); } } class SearchBox extends Frame implements ActionListener,ItemListener { Choice choice; Label show; TextField information; Button ok,cancel; Connection con; Statement stmt; ResultSet rs; TextArea info; String name; int index; SearchBox(String s) { setLayout(new FlowLayout()); setTitle(s); setBackground(Color.gray); choice=new Choice(); choice.add("编号"); choice.add("学院"); choice.add("班级"); choice.add("学号"); choice.add("姓名"); choice.add("性别"); choice.add("年龄"); choice.add("入团时间"); show=new Label("请输入关键信息："); information=new TextField(20); ok=new Button("确定"); cancel=new Button("取消"); choice.addItemListener(this); ok.addActionListener(this); cancel.addActionListener(this); add(choice); add(show); add(information); add(ok); add(cancel); info=new TextArea(); add(info); info.append("编号 "+"学院 "+" 班级 "+" 学号 "+" 姓名 "+"性别 "+"年龄 "+"入团时间"+"\n"); setSize(500,300); setVisible(true); addWindowListener(new WindowAdapter() { public void windowClosing(WindowEvent e) { dispose(); } }); validate(); } public void itemStateChanged(ItemEvent e) { name=choice.getSelectedItem(); index=choice.getSelectedIndex(); } public void actionPerformed(ActionEvent e) { if(e.getSource()==cancel) { System.exit(0); } else if(e.getSource()==ok) { try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException ex) {} try { con=DriverManager.getConnection("jdbc:odbc:moon","",""); //stmt=con.createStatement(); stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); switch(index) { case 0: { rs=stmt.executeQuery("select * from Student where 编号='"+information.getText()+"'"); while(rs.next()) { info.append(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+" "+rs.getString(6)+" "+rs.getInt(7)+" "+rs.getString(8)+"\n"); } } case 1: { rs=stmt.executeQuery("select * from Student where 学院='"+information.getText()+"'"); while(rs.next()) { info.append(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+" "+rs.getString(6)+" "+rs.getInt(7)+" "+rs.getString(8)+"\n"); } } case 2: { rs=stmt.executeQuery("select * from Student where 班级='"+information.getText()+"'"); while(rs.next()) { info.append(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+" "+rs.getString(6)+" "+rs.getInt(7)+" "+rs.getString(8)+"\n"); } } case 3: { rs=stmt.executeQuery("select * from Student where 学号='"+information.getText()+"'"); while(rs.next()) { info.append(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+" "+rs.getString(6)+" "+rs.getInt(7)+" "+rs.getString(8)+"\n"); } } case 4: { rs=stmt.executeQuery("select * from Student where 姓名='"+information.getText()+"'"); while(rs.next()) { info.append(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+" "+rs.getString(6)+" "+rs.getInt(7)+" "+rs.getString(8)+"\n"); } } case 5: { rs=stmt.executeQuery("select * from Student where 性别='"+information.getText()+"'"); while(rs.next()) { info.append(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+" "+rs.getString(6)+" "+rs.getInt(7)+" "+rs.getString(8)+"\n"); } } case 6: { rs=stmt.executeQuery("select * from Student where 年龄='"+information.getText()+"'"); while(rs.next()) { info.append(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+" "+rs.getString(6)+" "+rs.getInt(7)+" "+rs.getString(8)+"\n"); } } case 7: { rs=stmt.executeQuery("select * from Student where 入团时间='"+information.getText()+"'"); while(rs.next()) { info.append(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+" "+rs.getString(6)+" "+rs.getInt(7)+" "+rs.getString(8)+"\n"); } } } con.close(); stmt.close(); } catch(SQLException ex) { System.out.print(ex.toString()); } } } }