Java程序设计实验报告6

textField_5 = new JTextField(); textField_5.setColumns(10); textField_5.setBounds(501, 242, 96, 27); getContentPane().add(textField_5); JLabel label_1 = new JLabel(\性别：\ label_1.setFont(font); label_1.setBounds(437, 203, 63, 21); getContentPane().add(label_1); JLabel label_2 = new JLabel(\年龄：\ label_2.setFont(font); label_2.setBounds(35, 243, 61, 21); getContentPane().add(label_2); JLabel label_3 = new JLabel(\专业：\ label_3.setFont(font); label_3.setBounds(240, 243, 63, 21); getContentPane().add(label_3); JLabel label_4 = new JLabel(\班主任：\ label_4.setFont(font); label_4.setBounds(419, 243, 81, 21); getContentPane().add(label_4); JButton btnNewButton_1 = new JButton(\添加\ btnNewButton_1.setFont(font); btnNewButton_1.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String number=new String(textField.getText()); String name=new String(textField_1.getText()); String sex=new String(textField_2.getText()); String age=new String(textField_3.getText()); String zhuanye=new String(textField_4.getText()); String teacher=new String(textField_5.getText()); JOptionPane.showMessageDialog(getContentPane(),add.addRecord(number, name, sex, age, zhuanye, teacher)); textField.setText(\ textField_1.setText(\ textField_2.setText(\ textField_3.setText(\ textField_4.setText(\ textField_5.setText(\ } }); btnNewButton_1.setBounds(256, 287, 123, 29); getContentPane().add(btnNewButton_1); textField_6 = new JTextField(); textField_6.setBounds(96, 333, 96, 27); getContentPane().add(textField_6); textField_6.setColumns(10); textField_7 = new JTextField(); textField_7.setColumns(10); textField_7.setBounds(308, 333, 96, 27); getContentPane().add(textField_7); textField_8 = new JTextField(); textField_8.setColumns(10); textField_8.setBounds(501, 333, 96, 27); getContentPane().add(textField_8); textField_9 = new JTextField(); textField_9.setColumns(10); textField_9.setBounds(96, 375, 96, 27); getContentPane().add(textField_9); textField_10 = new JTextField(); textField_10.setColumns(10); textField_10.setBounds(308, 375, 96, 27); getContentPane().add(textField_10); textField_11 = new JTextField(); textField_11.setColumns(10); textField_11.setBounds(501, 375, 96, 27); getContentPane().add(textField_11); JLabel label_5 = new JLabel(\学号：\label_5.setFont(font); label_5.setBounds(36, 336, 60, 21); getContentPane().add(label_5); JLabel label_6 = new JLabel(\年龄：\ label_6.setFont(font); label_6.setBounds(36, 378, 60, 21); getContentPane().add(label_6); JLabel label_7 = new JLabel(\姓名：\ label_7.setFont(font); label_7.setBounds(227, 336, 67, 21); getContentPane().add(label_7); JLabel label_8 = new JLabel(\性别：\ label_8.setFont(font); label_8.setBounds(432, 336, 68, 21); getContentPane().add(label_8); JLabel label_9 = new JLabel(\专业：\ label_9.setFont(font); label_9.setBounds(227, 378, 76, 21); getContentPane().add(label_9); JLabel label_10 = new JLabel(\班主任：\ label_10.setFont(font); label_10.setBounds(431, 378, 81, 21); getContentPane().add(label_10); JButton btnNewButton_2 = new JButton(\修改\ btnNewButton_2.setFont(font); btnNewButton_2.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String number=new String(textField_6.getText()); String name=new String(textField_7.getText()); String sex=new String(textField_8.getText()); String age=new String(textField_9.getText()); String zhuanye=new String(textField_10.getText()); String teacher=new String(textField_11.getText()); JOptionPane.showMessageDialog(getContentPane(),modify.modifyRecord(number, name, sex, age, zhuanye, teacher)); textField_6.setText(\ textField_7.setText(\ textField_8.setText(\ textField_9.setText(\ \ textField_10.setText(\ textField_11.setText(\ } }); btnNewButton_2.setBounds(256, 429, 123, 29); getContentPane().add(btnNewButton_2); JLabel lblNewLabel_1 = new JLabel(\学号：\ lblNewLabel_1.setFont(font); lblNewLabel_1.setBounds(96, 493, 60, 21); getContentPane().add(lblNewLabel_1); textField_12 = new JTextField(); textField_12.setBounds(166, 489, 96, 27); getContentPane().add(textField_12); textField_12.setColumns(10); JButton btnNewButton_3 = new JButton(\删除\ btnNewButton_3.setFont(font); btnNewButton_3.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String s=textField_12.getText(); if(s.equals(\ JOptionPane.showMessageDialog(getContentPane(), \请输入学号 else { delete.deleteRecord(s); JOptionPane.showMessageDialog(getContentPane(),\删除成功\ textField_12.setText(\ } } }); btnNewButton_3.setBounds(364, 488, 123, 29); getContentPane().add(btnNewButton_3); JLabel label_11 = new JLabel(\软件171 201707152 杜江\ label_11.setFont(font); label_11.setBounds(126, 559, 319, 29); getContentPane().add(label_11); setVisible(true); setBounds(100,100,700,700); } } Add.java package shiyan6; import java.sql.*; public class add { static String addRecord(String number,String name,String sex,String age,String zhuanye,String teacher) { String ss=null; } else { sql.setString(1, number); sql.setString(2, name); sql.setString(3, sex); sql.setInt(4, Integer.parseInt(age)); sql.setString(5, zhuanye); sql.setString(6, teacher); sql.executeUpdate(); ss=\添加成功!\; try { } catch(ClassNotFoundException e){ } try { String database=\; String table=\; String url=\+database; String id=\; String password=\; Connection con=DriverManager.getConnection(url, id, String s=\+table+\; PreparedStatement sql=con.prepareStatement(s); if(number.equals(\)) { ss=\学号不能为空！！\; System.out.println(e); Class.forName(\); password);