Java核心代码Java核心代码.doc

public void actionPerformed(ActionEvent e) { Connection con; Statement sql; ResultSet rs; Boolean bool = false; int num = 0; try{ con = DriverManager.getConnection(jdbc:odbc:myData, , ); sql = con.createStatement(); rs = sql.executeQuery(SELECT * FROM Student ); num=Integer.parseInt(DeleteWindow.number.getText()); while(rs.next())//java.sql.ResultSet中方法，包括getString、getInt { int num1 =rs.getInt(1);//获取表中学号信息,参数为第几列的值 String name1=rs.getString(2); if (num==num1) { bool=true; break; } } } catch(Exception ee){ System.out.print(ee); } try{ if(bool==false) { textshow.append(学号不存在，请重新输入！！\n); } else{ ModifyTable modify=new ModifyTable(); modify.setDatasourceName(myData); String s2=String.format(delete from Student where number=%d,num); modify.setSQL(s2); String backMess=modify.modifyRecord(); System.out.println(backMess); textshow.append(操作成功！！\n); } } catch(Exception exp){ textshow.append(请输入正确学号！！\n); } } JTextArea textShow; public void actionPerformed(ActionEvent e) { DeleteWindow dele=new DeleteWindow(); dele.setBounds(600,250,300,300); dele.setTitle(删除学生信息); } } //插入窗口布局 class DeleteWindow extends JFrame{ static JTextField number; JButton button1,button2; DeleteListener delete; JTextArea textshow; public DeleteWindow() { init(); setVisible(true); setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); } void init() { setLayout(new FlowLayout()); number=new JTextField(8); button1=new JButton(确定); button2=new JButton(取消); delete=new DeleteListener();//监听器 textshow=new JTextArea(4,20); delete.setJTextArea(textshow); add(new JLabel(——————输入要删除的学生学号——————)); add(new JLabel(学号：)); add(number); add(new JLabel(————————————————————)); add(button1); add(button2); button1.addActionListener(delete); //一下代码为点击“取消按钮退出输入窗口” button2.addActionListener(n