Java数据库的基本操作

解答：assdocumentTimescore为文本。Numbernameopentime开课时间)为文本。其他未双精度型t功能是什么？画出各类之间的UMLMain.java主类Window.java显示类、等16个类单项码。importjava.sql.*;importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.util.*;importstaticjavax.swing.JFrame.*;publicclassDocumentInputextendsJPanelimplementsActionLi/////////略button.addActionListener(this);}Stringstr1=number.getText();Stringstr2=name.getText();Stringstr3=sex.getText();Stringstr4=grade.getText();Stringstr5=knowhow.getText();Stringstr6=face.getText();exception1.setText(null);exception2.setText(null);try{Class.forName(driverClass);nagergetConnectionurl}nsetText}tionsetText}try{sst=con.createStatement();rtintodocumentvaluesstr+str2+"','"+str3+"','"+str4+"','"+str5+"'sst.close();}}number.setText(null);name.setText(null);sex.setText(null);grade.setText(null);knowhow.setText(null);face.setText(null);}}}importjava.sql.*;importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.util.*;importstaticjavax.swing.JFrame.*;licclassGradeInputextendsJPanelimplementsActionListebutton.addActionListener(this);}Stringstr1=stunumber.getText();Stringstr2=name.getText();Stringstr3=学期.getText();DoubleparseDoublewuligradegetTextDoubleparseDoublejavagradegetTextDoubleparseDoubleframegradegetTextoubleparseDoubleenglishgradegetTextDoubleparseDoublespeedgradegetTextubleparseDoublephysicalgradegetTextDoubleparseDoubleinforgradegetTextbleparseDoublecalculategradegetTextexception1.setText(null);exception2.setText(null);try{Class.forName(driverClass);nagergetConnectionurl}nsetText}tionsetText}try{sst=con.createStatement();rtintogradevaluesstr+str2+"','"+str3+"','"+in1+"','"+in2+"',''"+in5+"','"+in6+"','"+in7+"','"+in8+"')");sst.close();}}stunumber.setText(null);name.setText(null);学期.setText(null);wuligrade.setText(null);javagrade.setText(null);framegrade.setText(null);englishgrade.setText(null);speedgrade.setText(null);physicalgrade.setText(null);inforgrade.setText(null);calculategrade.setText(null);}}}importjava.sql.*;importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.util.*;importstaticjavax.swing.JFrame.*;licclassClassInpputextendsJPanelimplementsActionListbutton.addActionListener(this);}Stringstr1=ClassNumber.getText();Stringstr2=ClassName.getText();oubleparseDoubleClassTimegetTextoubleparseDoubleSubjectScoregetTextStringstr3=SubjectQulity.getText();Stringstr4=SubjectOpenTime.getText();exception1.setText(null);exception2.setText(null);try{Class.forName(driverClass);nagergetConnectionurl}nsetText}tionsetText}try{sst=con.createStatement();rtintoclassvaluesstr+str2+"','"+in+"','"+in1+"','"+str3+"','"+str4+"')");sst.close();}}ClassNumber.setText(null);ClassName.setText(null);ClassTime.setText(null);SubjectQulity.setText(null);SubjectScore.setText(null);SubjectOpenTime.setText(null);}}}类实现的源代码importjava.sql.*;importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.util.*;importstaticjavax.swing.JFrame.*;licclassUpdateDocumentextendsJPanelimplementsActionL略}text1.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);nagergetConnectionurl}nsetText}tionsetText}try{sst=con.createStatement();executeUpdateupdatedocumentsetnametextgetText'wherenumber='"+text.getText()+"'");sst.close();}catch(SQLExceptionex){tionsetText}nsetText}nsetText}}text2.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);}nsetText}try{con=DriverManager.getConnection(url);sst=con.createStatement();executeUpdateupdatedocumentsetwherenumber='"+text.getText()+"'");sst.close();}catch(SQLExceptionex){tionsetText}nsetText}nsetText}}text3.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);}nsetText}try{nagergetConnectionurlsst=con.createStatement();executeUpdateupdatedocumentsetextgetTextwherenumber='"+text.getText()+"'");sst.close();}catch(SQLExceptionex){tionsetText}nsetText}nsetText}}text4.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);}nsetText}try{nagergetConnectionurlsst=con.createStatement();executeUpdateupdatedocumentsettextgetTextwherenumber='"+text.getText()+"'");sst.close();}catch(SQLExceptionex){tionsetText}nsetText}nsetText}}text5.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);}nsetText}try{nagergetConnectionurlsst=con.createStatement();executeUpdateupdatedocumentsetxtgetTextwherenumber='"+text.getText()+"'");sst.close();}catch(SQLExceptionex){tionsetText}nsetText}nsetText}}}}修改成绩源代码：importjava.sql.*;importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.util.*;importstaticjavax.swing.JFrame.*;licclassUpdateGradeextendsJPanelimplementsActionList略}text1.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);nagergetConnectionurl}nsetText}tionsetText}try{sst=con.createStatement();ksstexecuteUpdateupdategradesetnamewherenumber='"+text.getText()+"'");sst.close();}catch(SQLExceptionex){}nsetText}nsetText}}text2.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);}nsetText}try{nagergetConnectionurlsst=con.createStatement();executeUpdateupdategradesettimetextgetTextwherenumber='"+text.getText()+"'");sst.close();}catch(SQLExceptionex){}nsetText}nsetText}}text3.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);}nsetText}try{nagergetConnectionurlsst=con.createStatement();executeUpdateupdategradesetwuligrade"+text3.getText()+"'wherenumber='"+text.getText()+"'");sst.close();}catch(SQLExceptionex){}nsetText}nsetText}}text4.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);}nsetText}try{nagergetConnectionurlsst=con.createStatement();executeUpdateupdategradesetgetTextwherenumber='"+text.getText()+"'");sst.close();}catch(SQLExceptionex){}nsetText}nsetText}}text5.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);}nsetText}try{nagergetConnectionurlsst=con.createStatement();executeUpdateupdategradesetradetextgetTextwherenumber='"+text.getText()+"'");sst.close();}catch(SQLExceptionex){}nsetText}nsetText}}text6.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);}nsetText}try{nagergetConnectionurlsst=con.createStatement();executeUpdateupdategradesetetextgetText+"'wherenumber='"+text.getText()+"'");sst.close();}catch(SQLExceptionex){}nsetText}nsetText}}text7.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);}nsetText}try{nagergetConnectionurlsst=con.createStatement();executeUpdateupdategradesetrategradetextgetText'wherenumber='"+text.getText()+"'");sst.close();}catch(SQLExceptionex){}nsetText}nsetText}}text8.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);}nsetText}try{nagergetConnectionurlsst=con.createStatement();ksstexecuteUpdateupdategradesetgy+twherenumber='"+text.getText()+"'");sst.close();}catch(SQLExceptionex){}nsetText}nsetText}}text9.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);}nsetText}try{con=DriverManager.getConnection(url);sst=con.createStatement();executeUpdateupdategradesetwherenumber='"+text.getText()+"'");sst.close();}catch(SQLExceptionex){}nsetText}nsetText}}text10.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);}nsetText}try{nagergetConnectionurlsst=con.createStatement();executeUpdateupdategradesetwaygrade"+text10.getText()+"'wherenumber='"+text.getText()+"'");sst.close();}catch(SQLExceptionex){}nsetText}nsetText}}}}importjava.sql.*;importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.util.*;importstaticjavax.swing.JFrame.*;licclassUpdateClassextendsJPanelimplementsActionList略}text1.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);nagergetConnectionurl}nsetText}tionsetText}try{sst=con.createStatement();ksstexecuteUpdateupdateclasssetnamewherenumber='"+text.getText()+"'");sst.close();}catch(SQLExceptionex){}nsetText}nsetText}}text2.setEditable(true);exception1.setText(null);exception2.setText(null);}intk=0;try{Class.forName(driverClass);}nsetText}try{nagergetConnectionurlsst=con.createStatement();ksstexecuteUpdateupdateclasssettimewherenumber='"+text.getText()+"'");sst.close();}c