实验名称：实验5：综合性程序设计—简单学生信息管理系统班级：***** 姓名：Zzz 学号：20151601****一、实验目的二、实验内容与结果（1）任务描述(1.3与1.4二选一，建议选择1.4）利用课程所学知识，设计并实现一个简单学生信息管理系统，要求如下：1.1 声明Student类，该类实现Serializable接口以表明该类可以进行序列化。
该类有姓名、学号（long），math、os、java用来存放对应的成绩，在构造方法中进行姓名、学号、课程成绩的赋值。
Override由Object继承来的toString方法以便以友好格式显示自己的属性，格式为：张三12 os:90 java:90 math: 90。
1.2 建立一个类，利用数据库来存储多个Student，写完一个方法在main中写一段测试代码，运行以保证目前所做工作的正确性。
有以下方法：add(Student stu)：可以增加新的学生，并保存在数据库中。
update(Student stu)：可以修改特定的学生，并保存在数据库中。
dispAll()：可以显示所有的学生信息。
findById(long id)：可以按照学号来查找，并显示符合条件的学生信息，查无该人的话显示错误信息。
findByName(String name)：可以按照姓名查找学生，找到后显示其信息，查无此人显示错误信息。
delById(long id)：可以按照id删除学生的信息，然后显示找到该人。
若查无此人，显示相应的错误信息。
1.3 （控制台方式）完善应用程序，实现相应的功能如下：添加学生信息、修改指定学号的学生信息、显示所有学生信息、按学号查找、按姓名查找、按学号删除、按成绩排序和退出。
1.4 （Swing窗体方式）完善应用程序，实现相应的功能如下：添加学生信息、修改指定学号的学生信息、显示所有学生信息、按学号查找、按姓名查找、按学号删除、按成绩排序和退出。
（2）处理思路及关键技术说明（3）程序完整源码（要求格式规范，适当注释）（4）运行结果截图（按每个操作分别截图）（2）处理思路及关键技术说明分三个模块：一是 jdbc的代码，另一个是 Swing和AWT的代码，剩下是Student类。
Jdbc 一共有两个类：DBUtil（连接工具类）和Sql类（处理jdbc功能的静态方法）Swing 和AWT一个有两个类：MyJFrame构建总窗口，MyJPanel 对窗口内的面板行修饰。
然后就是Student类和Main主方法类。
关键部分：1）在主窗体中add三个Jpanel，底层和第二层左右三个，右边的Jpanel实现cardLayout 布局，左边的Jpanel添加按钮并添加ActionListener来实现对象的card切换达到不同按钮进入不同功能面板的目的。
2）在MyJPanel类中，所有的init方法均传递参数JPanel p，对传递过来的Panel进行加工修饰，并且调用Sql里面对应功能的方法。
3）Sql中的显示全部信息的方法中使用了ArrayList来存储从studenttbl中读取的对象信息，存储之后为了按照String的方式显示在JtextArea中，又用了listToString方法，通过for循环并追加回车，使每个对象都转化为String并在后面加上了回车（separator），4）在Sql中的查找，删除，添加都使用了jdbc中的预处理PreparedStatement在操作完毕后执行sts.executeUpdate();5）在Sql排序方法中，把所有的信息都存储到list中以后，调用工具类Collections.sort:根据指定比较器产生的顺序对指定列表进行排序。
（3）程序完整源码（要求格式规范，适当注释）class DBUtilpackage test;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class DBUtil {private static String driver;private static String url;private static String username;private static String password;static {driver="com.mysql.jdbc.Driver";url="jdbc:mysql://localhost:3306/mydb";username="root";password="123456";}public static Connection open(){try {Class.forName(driver);return DriverManager.getConnection(url,username,password);}catch (Exception e) {e.printStackTrace();}return null;}public static void close(Connection conn){if(conn!=null){try {conn.close();} catch (SQLException e) {e.printStackTrace();}}}}class Sqlpackage test;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import java.util.Collections;import parator;import java.util.List;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JTextArea;public class Sql {public static String listToString(List<Student> list, char separator) {//使list返回String类型并加入控制符（换行）StringBuilder sb = new StringBuilder();for (int i = 0; i < list.size(); i++) {sb.append(list.get(i)).append(separator); }return sb.toString().substring(0,sb.toString().length()-1);}public static List<Student> disAll() {//打印显示所有信息//查询Connection conn=DBUtil.open();String sql="select id,name,frctionJava,fractionMath,fractionOS from studentTbl";Statement stmt;try {stmt = conn.createStatement();ResultSet rs=stmt.executeQuery(sql);List<Student> list=new ArrayList<Student>();//遍历操作while(rs.next()){int id=rs.getInt(1);String name=rs.getString(2);double a=rs.getDouble(3);double b=rs.getDouble(4);double c=rs.getDouble(5);Student u=new Student();u.setId(id);u.setName(name);u.setFractionJava(a);u.setFractionMath(b);u.setFractionOS(c);list.add(u);}conn.close();return list;} catch (SQLException e) {e.printStackTrace();}return null;}public static void FindByID(long id ,JLabel lblNewLabel ){//按ID查找Connection conn=DBUtil.open();ResultSet rs = null;try {String sql="select * from StudentTbl where id=?";PreparedStatement sts=conn.prepareStatement(sql);sts.setLong(1, id);rs=sts.executeQuery();while(rs.next()){int i=rs.getInt(1);String name=rs.getString(2);double a=rs.getDouble(3);double b=rs.getDouble(4);double c=rs.getDouble(5);lblNewLabel.setText(" | "+i+" | "+name+" | "+a+" | "+b+" | "+c);}}catch(Exception e) {e.printStackTrace();}finally{try {if(rs.first()!=true)lblNewLabel.setText("~~~~~~~查无此人！~~~~~~~~");} catch (SQLException e) {e.printStackTrace();}}}public static void FindByName(String s, JLabel lblNewLabel) {//按Name查找Connection conn=DBUtil.open();ResultSet rs = null;try {String sql="select * from StudentTbl where name=?";PreparedStatement sts=conn.prepareStatement(sql);sts.setString(1, s);rs=sts.executeQuery();while(rs.next()){int id=rs.getInt(1);String name=rs.getString(2);double a=rs.getDouble(3);double b=rs.getDouble(4);double c=rs.getDouble(5);lblNewLabel.setText(" | "+id+" | "+name+" | "+a+" | "+b+" | "+c);}}catch(Exception e) {e.printStackTrace();}finally{try{if(rs.first()!=true)lblNewLabel.setText("~~~~~~~查无此人！~~~~~~~~");} catch (SQLException e){e.printStackTrace();}}}public static void DeleteByID(long id){//删除Connection conn=DBUtil.open();PreparedStatement sts=null;int a=0;try {sts=conn.prepareStatement("delete from StudentTbl where id=?");sts.setLong(1, id);a=sts.executeUpdate();if(a>0)JOptionPane.showMessageDialog(null, "删除成功！", "WO", RMATION_MESSAGE);if(a==0)JOptionPane.showMessageDialog(null, "无此人！", "WO", RMATION_MESSAGE);}catch(Exception e) {e.printStackTrace();}DBUtil.close(conn);}public static void Sort(JTextArea ta,int index) {//排序//查询Connection conn=DBUtil.open();String sql="select id,name,frctionJava,fractionMath,fractionOS from studentTbl";Statement stmt;try {stmt = conn.createStatement();ResultSet rs=stmt.executeQuery(sql);List<Student> list=new ArrayList<Student>();//遍历操作while(rs.next()){int id=rs.getInt(1);String name=rs.getString(2);double a=rs.getDouble(3);double b=rs.getDouble(4);double c=rs.getDouble(5);Student u=new Student();u.setId(id);u.setName(name);u.setFractionJava(a);u.setFractionMath(b);u.setFractionOS(c);list.add(u);}Collections.sort(list,new Comparator<Student>(){public int compare(Student o1, Student o2){int i = 1 ;if(index==1){i= (int) (o2.getFractionJava() -o1.getFractionJava()); }if(index==2){i = (int) (o2.getFractionMath() -o1.getFractionMath());}if(index==3){i = (int) (o2.getFractionOS() -o1.getFractionOS());}return i;}});String s=listToString(list, '\n');ta.setText(s);} catch (SQLException e) {e.printStackTrace();}DBUtil.close(conn);}public static void add(Student stu) {//添加Connection conn=DBUtil.open();PreparedStatement sts;try {sts = conn.prepareStatement("insert into StudentTbl values(?,?,?,?,?)");sts.setLong(1, stu.getId());sts.setString(2, stu.getName());sts.setDouble(3, stu.getFractionJava());sts.setDouble(4, stu.getFractionMath());sts.setDouble(5, stu.getFractionOS());sts.executeUpdate();} catch (SQLException e) {e.printStackTrace();}DBUtil.close(conn);}public static void UpdateStudent(Student stu){//更新Connection conn=DBUtil.open();try {String sql="update studenttbl set name='"+stu.getName()+"',FrctionJava='"+stu.getFractionJava()+"',FractionMath='"+stu.getFractionMath()+"',FractionOS='"+stu.getFractionOS()+"' where id='"+stu.getId()+"'";PreparedStatement sts=conn.prepareStatement(sql);sts.executeUpdate();}catch(Exception e) {e.printStackTrace();}}}class Studentpackage test;import java.io.Serializable;public class Student implements Serializable{private static final long serialVersionUID =4558876142427402513L;private String name;private long id;private double fractionOS;private double fractionJava;private double fractionMath;public String getName() {return name;}public void setName(String name) { = name;}public long getId() {return id;}public void setId(long id) {this.id = id;}public double getFractionOS() {return fractionOS;}public void setFractionOS(double fractionOS) {this.fractionOS = fractionOS;}public double getFractionJava() {return fractionJava;}public void setFractionJava(double fractionJava) {this.fractionJava = fractionJava;}public double getFractionMath() {return fractionMath;}public void setFractionMath(double fractionMath) {this.fractionMath = fractionMath;}public String toString() {return (name+" "+id+" Java:"+fractionJava+" Math:"+fractionMath+" OS:"+fractionOS);}}class MyJFramepackage test;import javax.swing.JFrame;import javax.swing.JPanel;import java.awt.BorderLayout;import java.awt.CardLayout;import java.awt.Insets;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JButton;import java.awt.Color;import javax.swing.SwingConstants;import javax.swing.JLabel;import java.awt.Font;public class MyJFrame {JFrame frame=new JFrame("Demo");;/*** @wbp.parser.entryPoint*/public void init() {frame.setVisible(true);frame.setBounds(100, 100, 570, 474);//JPanelJPanel panel = new JPanel();panel.setBackground(new Color(153, 204, 255));frame.getContentPane().add(panel, BorderLayout.CENTER);panel.setLayout(null);//Panel X YJPanel panel_x = new JPanel();panel_x.setBackground(new Color(153, 204, 255));panel_x.setBounds(0, 0, 141, 435);panel.add(panel_x);panel_x.setLayout(null);JPanel panel_y = new JPanel();panel_y.setBackground(new Color(255, 255, 255));panel_y.setBounds(140, 0, 414, 435);panel.add(panel_y);//功能按钮//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++JButton b0 = new JButton("Home");b0.setHorizontalAlignment(SwingConstants.LEADING);b0.setBackground(new Color(255, 255, 255));b0.setBounds(34, 21, 66, 23);panel_x.add(b0);JButton b1 = new JButton("\u663E\u793A");b1.setBackground(new Color(255, 255, 255));b1.setBounds(22, 66, 93, 23);panel_x.add(b1);JButton b2 = new JButton("\u67E5\u627E(ID)");b2.setBackground(new Color(255, 255, 255));b2.setBounds(22, 112, 93, 23);b2.setMargin(new Insets(0, 0, 0, 0));panel_x.add(b2);JButton b3 = new JButton("\u67E5\u627E(Name)");b3.setBackground(new Color(255, 255, 255));b3.setBounds(22, 157, 93, 23);b3.setMargin(new Insets(0, 0, 0, 0));panel_x.add(b3);JButton b4 = new JButton("\u5220\u9664");b4.setBackground(new Color(255, 255, 255));b4.setBounds(22, 200, 93, 23);panel_x.add(b4);JButton b5 = new JButton("\u6392\u5E8F");b5.setBounds(22, 243, 93, 23);b5.setBackground(new Color(255, 255, 255));panel_x.add(b5);JButton b6 = new JButton("\u6DFB\u52A0");b6.setBounds(22, 290, 93, 23);b6.setBackground(new Color(255, 255, 255));panel_x.add(b6);JButton b7 = new JButton("\u66F4\u65B0");b7.setBounds(22, 334, 93, 23);b7.setBackground(new Color(255, 255, 255));panel_x.add(b7);JButton bExit = new JButton("\u9000\u51FA");bExit.setBounds(22, 378, 93, 23);bExit.setBackground(new Color(255, 255, 255));panel_x.add(bExit);//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++//============================================================= CardLayout cl_panel_y=new CardLayout();//卡片JPanelpanel_y.setLayout(cl_panel_y);JPanel panel_0 = new JPanel();//欢迎界面panel_0.setBackground(new Color(153, 204, 255));panel_y.add(panel_0, "c0");panel_0.setLayout(null);JLabel l1 = new JLabel("\u6B22\u8FCE\u4F7F\u7528\u5B66\u751F\u4FE1\u606F\u7BA1\u7406\u7A 0B\u5E8F");l1.setFont(new Font("宋体", Font.PLAIN, 16));l1.setHorizontalAlignment(SwingConstants.CENTER);l1.setBounds(37, 33, 317, 66);panel_0.add(l1);JPanel panel_1 = new JPanel();//显示panel_y.add(panel_1, "c1");JPanel panel_2 = new JPanel();//查找panel_y.add(panel_2, "c2");JPanel panel_3 = new JPanel();//查找panel_y.add(panel_3, "c3");//MyJPanel.init3(panel_3);JPanel panel_4 = new JPanel();//删除panel_y.add(panel_4, "c4");//MyJPanel.init4(panel_4);JPanel panel_5 = new JPanel();//排序panel_y.add(panel_5, "c5");//MyJPanel.init5(panel_5);JPanel panel_6 = new JPanel();//添加panel_y.add(panel_6, "c6");JPanel panel_7 = new JPanel();panel_y.add(panel_7, "c7");//MyJPanel.init6(panel_6);//============================================================== //按钮事件//============================================================== b0.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {cl_panel_y.show(panel_y, "c0");}});b1.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {MyJPanel.init1(panel_1);cl_panel_y.show(panel_y, "c1");}});b2.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {MyJPanel.init2(panel_2);cl_panel_y.show(panel_y, "c2");}});b3.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {MyJPanel.init3(panel_3);cl_panel_y.show(panel_y, "c3");}});b4.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {MyJPanel.init4(panel_4);cl_panel_y.show(panel_y, "c4");}});b5.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {MyJPanel.init5(panel_5);cl_panel_y.show(panel_y, "c5");}});b6.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {MyJPanel.init6(panel_6);cl_panel_y.show(panel_y, "c6");}});b7.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {MyJPanel.init7(panel_7);cl_panel_y.show(panel_y, "c7");}});bExit.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {System.exit(0);}});}}class MyJPanelpackage test;import java.awt.CardLayout;import java.awt.Font;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.util.ArrayList;import java.util.List;import javax.swing.JButton;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JTextArea;import javax.swing.JTextField;import javax.swing.SwingConstants;import java.awt.Color;class MyJPanel{//显示static void init1(JPanel panel){//JPanel panel=new JPanel();panel.setBackground(new Color(255, 255, 255));panel.setBounds(0, 0, 373, 382);panel.setLayout(null);JLabel l = new JLabel(" ===\u4E0B\u5217\u662F\u6240\u6709\u67E5\u770B\u7684\u6240\u6709\u6570\ u636E\u4FE1\u606F===");//Labell.setFont(new Font("宋体", Font.PLAIN, 14));l.setBounds(15, 10, 336, 29);panel.add(l);JTextArea textArea = new JTextArea();//TextAreatextArea.setFont(new Font("Monospaced", Font.PLAIN, 15));textArea.setBackground(new Color(255, 255, 255));textArea.setBounds(25, 49, 326, 311);List<Student> list=new ArrayList<Student>();//转换为Stringlist=Sql.disAll();textArea.append(Sql.listToString(list,'\n'));panel.add(textArea);panel.repaint();}//查找IDstatic void init2(JPanel panel){//JPanel panel=new JPanel();panel.setBackground(new Color(255, 255, 255));panel.setBounds(0, 0, 373, 202);panel.setLayout(null);JLabel l1 = new JLabel("输入查找的ID:");l1.setBounds(15, 39, 201, 35);l1.setFont(new Font("宋体", Font.PLAIN, 15));panel.add(l1);JLabel l2=new JLabel("学号姓名Java Math OS");l2.setBounds(47, 80, 290, 31);l2.setFont(new Font("宋体", Font.PLAIN, 15));panel.add(l2);JTextField textField = new JTextField();textField.setBounds(208, 39, 72, 35);textField.setColumns(10);panel.add(textField);JLabel l0 = new JLabel();l0.setFont(new Font("宋体", Font.PLAIN, 14));l0.setBounds(21, 120, 331, 35);JButton b = new JButton("Y");b.setFont(new Font("宋体", Font.PLAIN, 10));b.setHorizontalAlignment(SwingConstants.LEFT);b.setBackground(new Color(255, 255, 255));b.setBounds(301, 39, 45, 35);b.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent arg0){String s=textField.getText();long id=Long.parseLong(s);Sql.FindByID(id,l0);}});panel.add(b);panel.add(l0);}//查找Namestatic void init3(JPanel panel) {panel.setBounds(0, 0, 373, 202);panel.setBackground(new Color(255, 255, 255));panel.setLayout(null);JLabel l1 = new JLabel("输入要查找的姓名:");l1.setBounds(15, 39, 201, 35);l1.setFont(new Font("宋体", Font.PLAIN, 15));panel.add(l1);JLabel l2=new JLabel("学号姓名Java Math OS");l2.setBounds(47, 80, 290, 31);l2.setFont(new Font("宋体", Font.PLAIN, 15));panel.add(l2);JTextField textField = new JTextField();textField.setBounds(208, 39, 72, 35);textField.setColumns(10);panel.add(textField);JLabel l0 = new JLabel();l0.setFont(new Font("宋体", Font.PLAIN, 14));l0.setBounds(21, 120, 331, 35);panel.add(l0);JButton b = new JButton("Y");b.setBounds(301, 39, 45, 35);b.setBackground(new Color(255, 255, 255));b.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent arg0){String s=textField.getText();Sql.FindByName(s,l0);}});panel.add(b);}//删除static void init4(JPanel panel) {panel.setBounds(0, 0, 373, 202);panel.setBackground(new Color(255, 255, 255));panel.setLayout(null);JLabel l1 = new JLabel("请输入你要删除的ID:");l1.setBounds(15, 39, 201, 35);l1.setFont(new Font("宋体", Font.PLAIN, 15));panel.add(l1);JTextField textField = new JTextField();textField.setBounds(95, 84, 72, 35);textField.setColumns(10);panel.add(textField);JLabel l0 = new JLabel();l0.setFont(new Font("宋体", Font.PLAIN, 14));l0.setBounds(15, 137, 331, 35);panel.add(l0);JButton b = new JButton("Y");b.setBackground(new Color(255, 255, 255));b.setHorizontalAlignment(SwingConstants.LEFT);b.setBounds(199, 84, 62, 35);b.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent arg0){String s=textField.getText();long id=Long.parseLong(s);Sql.DeleteByID(id);}});panel.add(b);}//排序static void init5(JPanel p){//JPanel p = new JPanel();p.setBackground(new Color(255, 255, 255));JTextArea a1= new JTextArea();a1.setFont(new Font("Monospaced", Font.PLAIN, 15));JTextArea a2= new JTextArea();a2.setFont(new Font("Monospaced", Font.PLAIN, 15));JTextArea a3= new JTextArea();a3.setFont(new Font("Monospaced", Font.PLAIN, 15));CardLayout card = new CardLayout(3,3);JPanel pane = new JPanel(card);pane.setBackground(new Color(255, 255, 255));pane.setBounds(45, 65, 360, 500);JButton b1_1;JButton b2_1;JButton b3_1;b1_1 = new JButton("按Java排序");b1_1.setBackground(new Color(255, 255, 255)); b1_1.setBounds(84, 20, 93, 35);b2_1 = new JButton("按Math排序");b2_1.setBackground(new Color(255, 255, 255)); b2_1.setBounds(172, 20, 93, 35);b3_1 = new JButton("按OS排序");b3_1.setBackground(new Color(255, 255, 255)); b3_1.setBounds(264, 20, 87, 35);p.setLayout(null);p.add(b1_1);p.add(b2_1);p.add(b3_1);p.add(pane);pane.add(a1,"p1");pane.add(a2,"p2");pane.add(a3,"p3");b1_1.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) {Sql.Sort(a1,1);card.show(pane,"p1");}});b2_1.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) {Sql.Sort(a2,2);card.show(pane,"p2");}});b3_1.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) {Sql.Sort(a3,3);card.show(pane,"p3");}});}//添加static void init6(JPanel p){//JPanel p=new JPanel();p.setBackground(new Color(255, 255, 255));JLabel l0,l1,l2,l3,l4,l5;//输入姓名id java math O s JTextField t1,t2,t3,t4,t5;//姓名id java math O sJButton b=new JButton("Y");//确认p.setLayout(null);l0=new JLabel("请输入相关信息:");l0.setFont(new Font("宋体", Font.PLAIN, 14));l0.setBounds(0,0,126,30);l1=new JLabel("Name:");l1.setFont(new Font("宋体", Font.PLAIN, 14));l1.setHorizontalAlignment(SwingConstants.CENTER);l1.setBounds(30,30,80,30);t1=new JTextField();//namet1.setBounds(144,30,80,30);l2=new JLabel(" ID:");l2.setFont(new Font("宋体", Font.PLAIN, 14));l2.setHorizontalAlignment(SwingConstants.CENTER);l2.setBounds(30,70,80,30);t2=new JTextField();//idt2.setBounds(144,70,80,30);l3=new JLabel(" Java:");l3.setFont(new Font("宋体", Font.PLAIN, 14));l3.setHorizontalAlignment(SwingConstants.CENTER);l3.setBounds(30,110,80,30);t3=new JTextField();//idt3.setBounds(144,110,80,30);l4=new JLabel(" Math:");l4.setFont(new Font("宋体", Font.PLAIN, 14));l4.setHorizontalAlignment(SwingConstants.CENTER);l4.setBounds(30,150,80,30);t4=new JTextField();//idt4.setBounds(144,150,80,30);l5=new JLabel(" OS:");l5.setFont(new Font("宋体", Font.PLAIN, 14));l5.setHorizontalAlignment(SwingConstants.CENTER);l5.setBounds(30,190,80,30);t5=new JTextField();//idt5.setBounds(144,190,80,30);b.setBounds(300,260,50,30);b.setBackground(new Color(255, 255, 255));b.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent arg0) {String n,id,j,m,o;id=t2.getText();long id1 = (long)Integer.parseInt(id);//把String 转化成I n tn=t1.getText();j=t3.getText();double j1 =(double) Integer.parseInt(j);//把String 转化成I n tm=t4.getText();double m1 =(double) Integer.parseInt(m);o=t5.getText();double o1 =(double) Integer.parseInt(o);Student stu=new Student();stu.setId(id1);stu.setName(n);stu.setFractionJava(j1);stu.setFractionMath(m1);stu.setFractionOS(o1);Sql.add(stu);JOptionPane.showMessageDialog(null, "添加成功！", "WO", RMATION_MESSAGE);}});p.add(l0);p.add(l1);p.add(t1);p.add(l2);p.add(t2);p.add(l3);p.add(t3);p.add(l4);p.add(t4);p.add(l5);p.add(t5);p.add(b);}// 更新static void init7(JPanel panel){//JPanel p=new JPanel();//JPanel panel = new JPanel();panel.setBounds(0, 0, 373, 202);panel.setBackground(new Color(255, 255, 255));//frame.getContentPane().add(panel);panel.setLayout(null);JLabel lblNewLabel_1 = new JLabel("请输入你要更改学生的ID:");lblNewLabel_1.setBounds(15, 39, 201, 35);lblNewLabel_1.setFont(new Font("宋体", Font.PLAIN, 15));panel.add(lblNewLabel_1);JTextField textField = new JTextField();textField.setBounds(208, 39, 72, 35);textField.setColumns(10);panel.add(textField);JTextField textField_1 = new JTextField();textField_1.setBounds(15, 149, 55, 35);panel.add(textField_1);textField_1.setColumns(10);JTextField textField_2 = new JTextField();textField_2.setBounds(80, 149, 45, 35);panel.add(textField_2);textField_2.setColumns(10);JTextField textField_3 = new JTextField();textField_3.setBounds(136, 149, 45, 35);panel.add(textField_3);textField_3.setColumns(10);JTextField textField_4 = new JTextField();textField_4.setBounds(194, 149, 45, 35);panel.add(textField_4);textField_4.setColumns(10);JLabel lblNewLabel = new JLabel();lblNewLabel.setFont(new Font("宋体", Font.PLAIN, 14));lblNewLabel.setBounds(15, 94, 331, 35);panel.add(lblNewLabel);JButton Find = new JButton("Y");Find.setBackground(new Color(255, 255, 255));Find.setBounds(301, 39, 45, 35);panel.add(Find);JButton Sure = new JButton("Y");Sure.setBounds(291, 148, 55, 36);panel.add(Sure);Sure.setBackground(new Color(255, 255, 255));Find.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent arg0){String s=textField.getText();long id=Long.parseLong(s);Sql.FindByID(id,lblNewLabel);if(lblNewLabel.getText().equals("~~~~~~~查无此人！~~~~~~~~")){lblNewLabel.setText("这是个错误的ID！！！");}elselblNewLabel.setText("请依次输Name FractionJava FractionMath FractionOS");}});Sure.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {Student stu=new Student();stu.setId(Long.parseLong(textField.getText()));stu.setName(textField_1.getText());stu.setFractionJava(Double.valueOf(textField_2.getText()).doubleValue());stu.setFractionMath(Double.valueOf(textField_3.getText()).doubleValue());stu.setFractionOS(Double.valueOf(textField_4.getText()).doubleValue());Sql.UpdateStudent(stu);JOptionPane.showMessageDialog(null, "修改成功！", "WO", RMATION_MESSAGE);}});}}class Mainpackage test;public class Main {public static void main(String[] args) {new MyJFrame().init();}}（4）运行结果截图（按每个操作分别截图）。
