Java学生信息管理(Swing窗体)

/实验名称：实验5：综合性程序设计—简单学生信息管理系统班级：*****姓名：Zzz学号：20151601****一、实验目的二、实验内容与结果〔1任务描述<1.3与1.4二选一,建议选择1.4利用课程所学知识,设计并实现一个简单学生信息管理系统,要求如下：1.1声明Student类,该类实现Serializable接口以表明该类可以进行序列化。该类有姓名、学号〔long,math、os、java用来存放对应的成绩,在构造方法中进行姓名、学号、课程成绩的赋值。Override由Object继承来的toString方法以便以友好格式显示自己的属性,格式为：张三12os:90java:90math:90。1.2建立一个类,利用数据库来存储多个Student,写完一个方法在main中写一段测试代码,运行以保证目前所做工作的正确性。有以下方法：add<Studentstu>：可以增加新的学生,并保存在数据库中。update<Studentstu>：可以修改特定的学生,并保存在数据库中。dispAll<>：可以显示所有的学生信息。findById<longid>：可以按照学号来查找,并显示符合条件的学生信息,查无该人的话显示错误信息。findByName<Stringname>：可以按照姓名查找学生,找到后显示其信息,查无此人显示错误信息。delById<longid>：可以按照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方法均传递参数JPanelp,对传递过来的Panel进行加工修饰,并且调用Sql里面对应功能的方法。3Sql中的显示全部信息的方法中使用了ArrayList来存储从studenttbl中读取的对象信息,存储之后为了按照String的方式显示在JtextArea中,又用了listToString方法,通过for循环并追加回车,使每个对象都转化为String并在后面加上了回车〔separator,4在Sql中的查找,删除,添加都使用了jdbc中的预处理PreparedStatement在操作完毕后执行sts.executeUpdate<>;5在Sql排序方法中,把所有的信息都存储到list中以后,调用工具类Collections.sort:根据指定比较器产生的顺序对指定列表进行排序。〔3程序完整源码〔要求格式规范,适当注释classDBUtilpackagetest;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;publicclassDBUtil{ privatestaticStringdriver; privatestaticStringurl; privatestaticStringusername; privatestaticStringpassword; static{ driver="com.mysql.jdbc.Driver"; url="jdbc:mysql://localhost:3306/mydb"; username="root"; password="123456"; } publicstaticConnectionopen<>{ try{ Class.forName<driver>; returnDriverManager.getConnection<url,username,password>; }catch<Exceptione>{ e.printStackTrace<>; } returnnull; } publicstaticvoidclose<Connectionconn>{ if<conn!=null>{ try{ conn.close<>; }catch<SQLExceptione>{ e.printStackTrace<>; } } }}classSqlpackagetest;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjava.util.ArrayList;importjava.util.Collections;importjava.util.Comparator;importjava.util.List;importjavax.swing.JLabel;importjavax.swing.JOptionPane;importjavax.swing.JTextArea;publicclassSql{ publicstaticStringlistToString<List<Student>list,charseparator>{//使list返回String类型并加入控制符〔换行 StringBuildersb=newStringBuilder<>; for<inti=0;i<list.size<>;i++>{ sb.append<list.get<i>>.append<separator>;} returnsb.toString<>.substring<0,sb.toString<>.length<>-1>;} publicstaticList<Student>disAll<>{//打印显示所有信息 //查询 Connectionconn=DBUtil.open<>; Stringsql="selectid,name,frctionJava,fractionMath,fractionOSfromstudentTbl"; Statementstmt; try{ stmt=conn.createStatement<>; ResultSetrs=stmt.executeQuery<sql>; List<Student>list=newArrayList<Student><>; //遍历操作 while<rs.next<>>{ intid=rs.getInt<1>; Stringname=rs.getString<2>; doublea=rs.getDouble<3>; doubleb=rs.getDouble<4>; doublec=rs.getDouble<5>; Studentu=newStudent<>; u.setId<id>; u.setName<name>; u.setFractionJava<a>; u.setFractionMath<b>; u.setFractionOS<c>; list.add<u>; } conn.close<>; returnlist; }catch<SQLExceptione>{ e.printStackTrace<>; } returnnull; } publicstaticvoidFindByID<longid,JLabellblNewLabel>{//按ID查找 Connectionconn=DBUtil.open<>; ResultSetrs=null; try{ Stringsql="select*fromStudentTblwhereid=?"; PreparedStatementsts=conn.prepareStatement<sql>; sts.setLong<1,id>; rs=sts.executeQuery<>; while<rs.next<>>{ inti=rs.getInt<1>; Stringname=rs.getString<2>; doublea=rs.getDouble<3>; doubleb=rs.getDouble<4>; doublec=rs.getDouble<5>; lblNewLabel.setText<"|"+i+"|"+name+"|"+a+"|"+b+"|"+c>; } }catch<Exceptione>{ e.printStackTrace<>; }finally{ try{ if<rs.first<>!=true> lblNewLabel.setText<"~~~~~~~查无此人！~~~~~~~~">; }catch<SQLExceptione>{ e.printStackTrace<>; } } } publicstaticvoidFindByName<Strings,JLabellblNewLabel>{//按Name查找 Connectionconn=DBUtil.open<>; ResultSetrs=null; try{ Stringsql="select*fromStudentTblwherename=?"; PreparedStatementsts=conn.prepareStatement<sql>; sts.setString<1,s>; rs=sts.executeQuery<>; while<rs.next<>> { intid=rs.getInt<1>; Stringname=rs.getString<2>; doublea=rs.getDouble<3>; doubleb=rs.getDouble<4>; doublec=rs.getDouble<5>; lblNewLabel.setText<"|"+id+"|"+name+"|"+a+"|"+b+"|"+c>; } }catch<Exceptione>{ e.printStackTrace<>; }finally{ try{ if<rs.first<>!=true> lblNewLabel.setText<"~~~~~~~查无此人！~~~~~~~~">; }catch<SQLExceptione> { e.printStackTrace<>; } } } publicstaticvoidDeleteByID<longid>{//删除 Connectionconn=DBUtil.open<>; PreparedStatementsts=null; inta=0; try{ sts=conn.prepareStatement<"deletefromStudentTblwhereid=?">; sts.setLong<1,id>; a=sts.executeUpdate<>; if<a>0> JOptionPane.showMessageDialog<null,"删除成功！","WO",JOptionPane.INFORMATION_MESSAGE>; if<a==0> JOptionPane.showMessageDialog<null,"无此人！","WO",JOptionPane.INFORMATION_MESSAGE>; }catch<Exceptione>{ e.printStackTrace<>; } DBUtil.close<conn>; } publicstaticvoidSort<JTextAreata,intindex>{//排序 //查询 Connectionconn=DBUtil.open<>; Stringsql="selectid,name,frctionJava,fractionMath,fractionOSfromstudentTbl"; Statementstmt; try{ stmt=conn.createStatement<>; ResultSetrs=stmt.executeQuery<sql>; List<Student>list=newArrayList<Student><>; //遍历操作 while<rs.next<>>{ intid=rs.getInt<1>; Stringname=rs.getString<2>; doublea=rs.getDouble<3>; doubleb=rs.getDouble<4>; doublec=rs.getDouble<5>; Studentu=newStudent<>; u.setId<id>; u.setName<name>; u.setFractionJava<a>; u.setFractionMath<b>; u.setFractionOS<c>; list.add<u>; } Collections.sort<list,newComparator<Student><> { publicintcompare<Studento1,Studento2> { inti=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<>>; } returni; } }>; Strings=listToString<list,'\n'>; ta.setText<s>; }catch<SQLExceptione>{ e.printStackTrace<>; } DBUtil.close<conn>; } publicstaticvoidadd<Studentstu>{//添加 Connectionconn=DBUtil.open<>; PreparedStatementsts; try{ sts=conn.prepareStatement<"insertintoStudentTblvalues<?,?,?,?,?>">; 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<SQLExceptione>{ e.printStackTrace<>; } DBUtil.close<conn>;}publicstaticvoidUpdateStudent<Studentstu>{//更新Connectionconn=DBUtil.open<>; try{ Stringsql="updatestudenttblsetname='"+stu.getName<>+"',FrctionJava='"+stu.getFractionJava<>+"',FractionMath='"+stu.getFractionMath<>+"',FractionOS='"+stu.getFractionOS<>+"'whereid='"+stu.getId<>+"'"; PreparedStatementsts=conn.prepareStatement<sql>; sts.executeUpdate<>;}catch<Exceptione>{ e.printStackTrace<>; } }} classStudentpackagetest;importjava.io.Serializable;publicclassStudentimplementsSerializable{ privateStringname; privatelongid; privatedoublefractionOS; privatedoublefractionJava; privatedoublefractionMath; publicStringgetName<>{ returnname; } publicvoidsetName<Stringname>{ =name; } publiclonggetId<>{ returnid; } publicvoidsetId<longid>{ this.id=id; } publicdoublegetFractionOS<>{ returnfractionOS; } publicvoidsetFractionOS<doublefractionOS>{ this.fractionOS=fractionOS; } publicdoublegetFractionJava<>{ returnfractionJava; } publicvoidsetFractionJava<doublefractionJava>{ this.fractionJava=fractionJava; } publicdoublegetFractionMath<>{ returnfractionMath; } publicvoidsetFractionMath<doublefractionMath>{ this.fractionMath=fractionMath; } publicStringtoString<>{ return<name+""+id+"Java:"+fractionJava+ "Math:"+fractionMath+"OS:"+fractionOS>; }}classMyJFramepackagetest;importjavax.swing.JFrame;importjavax.swing.JPanel;importjava.awt.BorderLayout;importjava.awt.CardLayout;importjava.awt.Insets;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjavax.swing.JButton;importjava.awt.Color;importjavax.swing.SwingConstants;importjavax.swing.JLabel;importjava.awt.Font;publicclassMyJFrame{ JFrameframe=newJFrame<"Demo">;; /** */ publicvoidinit<>{ frame.setVisible<true>; frame.setBounds<100,100,570,474>; //JPanel JPanelpanel=newJPanel<>; panel.setBackground<newColor<153,204,255>>; frame.getContentPane<>.add<panel,BorderLayout.CENTER>; panel.setLayout<null>; //PanelXY JPanelpanel_x=newJPanel<>; panel_x.setBackground<newColor<153,204,255>>; panel_x.setBounds<0,0,141,435>; panel.add<panel_x>; panel_x.setLayout<null>; JPanelpanel_y=newJPanel<>; panel_y.setBackground<newColor<255,255,255>>; panel_y.setBounds<140,0,414,435>; panel.add<panel_y>; //功能按钮//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ JButtonb0=newJButton<"Home">; b0.setHorizontalAlignment<SwingConstants.LEADING>; b0.setBackground<newColor<255,255,255>>; b0.setBounds<34,21,66,23>; panel_x.add<b0>; JButtonb1=newJButton<"\u663E\u793A">; b1.setBackground<newColor<255,255,255>>; b1.setBounds<22,66,93,23>; panel_x.add<b1>; JButtonb2=newJButton<"\u67E5\u627E<ID>">; b2.setBackground<newColor<255,255,255>>; b2.setBounds<22,112,93,23>; b2.setMargin<newInsets<0,0,0,0>>; panel_x.add<b2>; JButtonb3=newJButton<"\u67E5\u627E<Name>">; b3.setBackground<newColor<255,255,255>>; b3.setBounds<22,157,93,23>; b3.setMargin<newInsets<0,0,0,0>>; panel_x.add<b3>; JButtonb4=newJButton<"\u5220\u9664">; b4.setBackground<newColor<255,255,255>>; b4.setBounds<22,200,93,23>; panel_x.add<b4>; JButtonb5=newJButton<"\u6392\u5E8F">; b5.setBounds<22,243,93,23>; b5.setBackground<newColor<255,255,255>>; panel_x.add<b5>; JButtonb6=newJButton<"\u6DFB\u52A0">; b6.setBounds<22,290,93,23>; b6.setBackground<newColor<255,255,255>>; panel_x.add<b6>; JButtonb7=newJButton<"\u66F4\u65B0">; b7.setBounds<22,334,93,23>; b7.setBackground<newColor<255,255,255>>; panel_x.add<b7>; JButtonbExit=newJButton<"\u9000\u51FA">; bExit.setBounds<22,378,93,23>; bExit.setBackground<newColor<255,255,255>>; panel_x.add<bExit>;//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++//============================================================= CardLayoutcl_panel_y=newCardLayout<>;//卡片JPanel panel_y.setLayout<cl_panel_y>; JPanelpanel_0=newJPanel<>;//欢迎界面 panel_0.setBackground<newColor<153,204,255>>; panel_y.add<panel_0,"c0">; panel_0.setLayout<null>; JLabell1=newJLabel<"\u6B22\u8FCE\u4F7F\u7528\u5B66\u751F\u4FE1\u606F\u7BA1\u7406\u7A0B\u5E8F">; l1.setFont<newFont<"宋体",Font.PLAIN,16>>; l1.setHorizontalAlignment<SwingConstants.CENTER>; l1.setBounds<37,33,317,66>; panel_0.add<l1>; JPanelpanel_1=newJPanel<>;//显示 panel_y.add<panel_1,"c1">; JPanelpanel_2=newJPanel<>;//查找 panel_y.add<panel_2,"c2">; JPanelpanel_3=newJPanel<>;//查找 panel_y.add<panel_3,"c3">; //MyJPanel.init3<panel_3>; JPanelpanel_4=newJPanel<>;//删除 panel_y.add<panel_4,"c4">; // MyJPanel.init4<panel_4>; JPanelpanel_5=newJPanel<>;//排序 panel_y.add<panel_5,"c5">; //MyJPanel.init5<panel_5>; JPanelpanel_6=newJPanel<>;//添加 panel_y.add<panel_6,"c6">; JPanelpanel_7=newJPanel<>; panel_y.add<panel_7,"c7">; //MyJPanel.init6<panel_6>;//============================================================== //按钮事件//============================================================== b0.addActionListener<newActionListener<>{ publicvoidactionPerformed<ActionEvente>{ cl_panel_y.show<panel_y,"c0">; } }>; b1.addActionListener<newActionListener<>{ @Override publicvoidactionPerformed<ActionEvente>{ MyJPanel.init1<panel_1>; cl_panel_y.show<panel_y,"c1">; } }>; b2.addActionListener<newActionListener<>{ @Override publicvoidactionPerformed<ActionEvente>{ MyJPanel.init2<panel_2>; cl_panel_y.show<panel_y,"c2">; } }>; b3.addActionListener<newActionListener<>{ @Override publicvoidactionPerformed<ActionEvente>{ MyJPanel.init3<panel_3>; cl_panel_y.show<panel_y,"c3">; } }>; b4.addActionListener<newActionListener<>{ @Override publicvoidactionPerformed<ActionEvente>{ MyJPanel.init4<panel_4>; cl_panel_y.show<panel_y,"c4">; } }>; b5.addActionListener<newActionListener<>{ @Override publicvoidactionPerformed<ActionEvente>{ MyJPanel.init5<panel_5>; cl_panel_y.show<panel_y,"c5">; } }>; b6.addActionListener<newActionListener<>{ @Override publicvoidactionPerformed<ActionEvente>{ MyJPanel.init6<panel_6>; cl_panel_y.show<panel_y,"c6">; } }>; b7.addActionListener<newActionListener<>{ @Override publicvoidactionPerformed<ActionEvente>{ MyJPanel.init7<panel_7>; cl_panel_y.show<panel_y,"c7">; } }>; bExit.addActionListener<newActionListener<>{ @Override publicvoidactionPerformed<ActionEvente>{ System.exit<0>; } }>; }}classMyJPanelpackagetest;importjava.awt.CardLayout;importjava.awt.Font;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.util.ArrayList;importjava.util.List;importjavax.swing.JButton;importjavax.swing.JLabel;importjavax.swing.JOptionPane;importjavax.swing.JPanel;importjavax.swing.JTextArea;importjavax.swing.JTextField;importjavax.swing.SwingConstants;importjava.awt.Color;classMyJPanel{// 显示 staticvoidinit1<JPanelpanel>{ //JPanelpanel=newJPanel<>; panel.setBackground<newColor<255,255,255>>; panel.setBounds<0,0,373,382>; panel.setLayout<null>; JLabell=newJLabel<"===\u4E0B\u5217\u662F\u6240\u6709\u67E5\u770B\u7684\u6240\u6709\u6570\u636E\u4FE1\u606F===">;//Label l.setFont<newFont<"宋体",Font.PLAIN,14>>; l.setBounds<15,10,336,29>; panel.add<l>; JTextAreatextArea=newJTextArea<>;//TextArea textArea.setFont<newFont<"Monospaced",Font.PLAIN,15>>; textArea.setBackground<newColor<255,255,255>>; textArea.setBounds<25,49,326,311>; List<Student>list=newArrayList<Student><>;//转换为String list=Sql.disAll<>; textArea.append<Sql.listToString<list,'\n'>>; panel.add<textArea>; panel.repaint<>; }// 查找ID staticvoidinit2<JPanelpanel>{ // JPanelpanel=newJPanel<>; panel.setBackground<newColor<255,255,255>>; panel.setBounds<0,0,373,202>; panel.setLayout<null>; JLabell1=newJLabel<"输入查找的ID:">; l1.setBounds<15,39,201,35>; l1.setFont<newFont<"宋体",Font.PLAIN,15>>; panel.add<l1>; JLabell2=newJLabel<"学号姓名JavaMathOS">; l2.setBounds<47,80,290,31>; l2.setFont<newFont<"宋体",Font.PLAIN,15>>; panel.add<l2>; JTextFieldtextField=newJTextField<>; textField.setBounds<208,39,72,35>; textField.setColumns<10>; panel.add<textField>; JLabell0=newJLabel<>; l0.setFont<newFont<"宋体",Font.PLAIN,14>>; l0.setBounds<21,120,331,35>; JButtonb=newJButton<"Y">; b.setFont<newFont<"宋体",Font.PLAIN,10>>; b.setHorizontalAlignment<SwingConstants.LEFT>; b.setBackground<newColor<255,255,255>>; b.setBounds<301,39,45,35>; b.addActionListener<newActionListener<>{ publicvoidactionPerformed<ActionEventarg0>{ Strings=textField.getText<>; longid=Long.parseLong<s>; Sql.FindByID<id,l0>; } }>; panel.add<b>; panel.add<l0>; }// 查找Name staticvoidinit3<JPanelpanel>{ panel.setBounds<0,0,373,202>; panel.setBackground<newColor<255,255,255>>; panel.setLayout<null>; JLabell1=newJLabel<"输入要查找的姓名:">; l1.setBounds<15,39,201,35>; l1.setFont<newFont<"宋体",Font.PLAIN,15>>; panel.add<l1>; JLabell2=newJLabel<"学号姓名JavaMathOS">; l2.setBounds<47,80,290,31>; l2.setFont<newFont<"宋体",Font.PLAIN,15>>; panel.add<l2>; JTextFieldtextField=newJTextField<>; textField.setBounds<208,39,72,35>; textField.setColumns<10>; panel.add<textField>; JLabell0=newJLabel<>; l0.setFont<newFont<"宋体",Font.PLAIN,14>>; l0.setBounds<21,120,331,35>; panel.add<l0>; JButtonb=newJButton<"Y">; b.setBounds<301,39,45,35>; b.setBackground<newColor<255,255,255>>; b.addActionListener<newActionListener<>{ publicvoidactionPerformed<ActionEventarg0>{ Strings=textField.getText<>; Sql.FindByName<s,l0>; } }>; panel.add<b>; }// 删除 staticvoidinit4<JPanelpanel>{ panel.setBounds<0,0,373,202>; panel.setBackground<newColor<255,255,255>>; panel.setLayout<null>; JLabell1=newJLabel<"请输入你要删除的ID:">; l1.setBounds<15,39,201,35>; l1.setFont<newFont<"宋体",Font.PLAIN,15>>; panel.add<l1>; JTextFieldtextField=newJTextField<>; textField.setBounds<95,84,72,35>; textField.setColumns<10>; panel.add<textField>; JLabell0=newJLabel<>; l0.setFont<newFont<"宋体",Font.PLAIN,14>>; l0.setBounds<15,137,331,35>; panel.add<l0>; JButtonb=newJButton<"Y">; b.setBackground<newColor<255,255,255>>; b.setHorizontalAlignment<SwingConstants.LEFT>; b.setBounds<199,84,62,35>; b.addActionListener<newActionListener<>{ publicvoidactionPerformed<ActionEventarg0>{ Strings=textField.getText<>; longid=Long.parseLong<s>; Sql.DeleteByID<id>; } }>; panel.add<b>; }// 排序 staticvoidinit5<JPanelp>{ //JPanelp=newJPanel<>; p.setBackground<newColor<255,255,255>>; JTextAreaa1=newJTextArea<>; a1.setFont<newFont<"Monospaced",Font.PLAIN,15>>; JTextAreaa2=newJTextArea<>; a2.setFont<newFont<"Monospaced",Font.PLAIN,15>>; JTextAreaa3=newJTextArea<>; a3.setFont<newFont<"Monospaced",Font.PLAIN,15>>;CardLayoutcard=newCardLayout<3,3>;JPanelpane=newJPanel<card>;pane.setBackground<newColor<255,255,255>>;pane.setBounds<45,65,360,500>;JButtonb1_1;JButtonb2_1;JButtonb3_1;b1_1=newJButton<"按Java排序">;b1_1.setBackground<newColor<255,255,255>>;b1_1.setBounds<84,20,93,35>;b2_1=newJButton<"按Math排序">;b2_1.setBackground<newColor<255,255,255>>;b2_1.setBounds<172,20,93,35>;b3_1=newJButton<"按OS排序">;b3_1.setBackground<newColor<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<newActionListener<>{publicvoidactionPerformed<ActionEvente>{ Sql.Sort<a1,1>; card.show<pane,"p1">;}}>;b2_1.addActionListener<newActionListener<>{publicvoidactionPerformed<ActionEvente>{ Sql.Sort<a2,2>; card.show<pane,"p2">;}}>;b3_1.addActionListener<newActionListener<>{publicvoidactionPerformed<ActionEvente>{ Sql.Sort<a3,3>;card.show<pane,"p3">;}}>; }// 添加 staticvoidinit6<JPanelp>{ //JPanelp=newJPanel<>; p.setBackground<newColor<255,255,255>>; JLabell0,l1,l2,l3,l4,l5;//输入姓名idjavamathOs JTextFieldt1,t2,t3,t4,t5;//姓名idjavamathOs JButtonb=newJButton<"Y">;//确认 p.setLayout<null>; l0=newJLabel<"请输入相关信息:">; l0.setFont<newFont<"宋体",Font.PLAIN,14>>; l0.setBounds<0,0,126,30>; l1=newJLabel<"Name:">; l1.setFont<newFont<"宋体",Font.PLAIN,14>>; l1.setHorizontalAlignment<SwingConstants.CENTER>; l1.setBounds<30,30,80,30>; t1=newJTextField<>;//name t1.setBounds<144,30,80,30>; l2=newJLabel<"ID:">; l2.setFont<newFont<"宋体",Font.PLAIN,14>>; l2.setHorizontalAlignment<SwingConstants.CENTER>; l2.setBounds<30,70,80,30>; t2=newJTextField<>;//id t2.setBounds<144,70,80,30>; l3=newJLabel<"Java:">; l3.setFont<newFont<"宋体",Font.PLAIN,14>>; l3.setHorizontalAlignment<SwingConstants.CENTER>; l3.setBounds<30,110,80,30>; t3=newJTextField<>;//id t3.setBounds<144,110,80,30>; l4=newJLabel<"Math:">; l4.setFont<newFont<"宋体",Font.PLAIN,14>>; l4.setHorizontalAlignment<SwingConstants.CENTER>; l4.setBounds<30,150,80,30>; t4=newJTextField<>;//id t4.setBounds<144,150,80,30>; l5=newJLabel<"OS:">; l5.setFont<newFont<"宋体",Font.PLAIN,14>>; l5.setHorizontalAlignment<SwingConstants.CENTER>; l5.setBounds<30,190,80,30>; t5=newJTextField<>;//id t5.setBounds<144,190,80,30>; b.setBounds<300,260,50,30>; b.setBackground<newColor<255,255,255>>; b.addActionListener<newActionListener<>{ publicvoidactionPerformed<ActionEventarg0>{ Stringn,id,j,m,o; id=t2.getText<>;longid1=<long>Integer.parseInt<id>;//把String转化成Int n=t1.getText<>; j=t3.getText<>;doublej1=<double>Integer.parseInt<j>;//把String转化成Int m=t4.getText<>;doublem1=<double>Integer.parseInt<m>; o=t5.getText<>;doubleo1=<double>Integer.parseInt<o>; Studentstu=newStudent<>; stu.setId<id1>; stu.setName<n>; stu.setFractionJava<j1>; stu.setFractionMath<m1>; stu.setFractionOS<o1>; Sql.add<stu>; JOptionPane.showMessageDialog<null,"添加成功！","WO",JOptionPane.INFORMATION_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>; }//更新 staticvoidinit7<JPanelpanel>{ //JPanelp=newJPanel<>; //JPanelpanel=newJPanel<>; panel.setBounds<0,0,