报告-实验九-通过JDBC方式操作数据库

实验九通过JDBC方式操作数据库1．实验目的〔1〕掌握通过JDBC方式操作数据库的根本步骤。〔2〕掌握增、删、改记录的方法。〔3〕掌握查询记录以及遍历查询结果的方法。2．实验内容实验题1学生信息管理函数。数据库中的信息参考Exp9.1.txt，这些命令用来创立student表，包含学生的学号、姓名、年龄信息。①根据学号，可以查询到学生的姓名和年龄；②给定学生的学号、姓名、年龄，在表中追加一行信息；③给定学生的学号，可以从表中删除该学生的信息；[根本要求]对上面的每一个功能编写相应的函数，并测试。运行结果：源代码：import;import;import;import;import;import;import;classQuery{ Scannerreader=newScanner(System.in); Connectioncon; sql; publicQuery(){ try{ Class.forName(""); } catch(ClassNotFoundExceptione){ (e); } } publicvoidselect(){ StringSNO; ("请输入要查询的学号："); SNO=reader.next(); StringURL="jdbc:mysql://localhost:3306/mysql"; Stringuser="root"; Stringpassword=""; ResultSetRS; try{ con=DriverManager.getConnection(URL,user,password); }catch(SQLExceptione){ (e); } try{ sql=con.prepareStatement("select*fromstudentwhereSno=?"); sql.setString(1,SNO); RS=sql.executeQuery(); while(RS.next()){ System.out.println(RS.getString(1)+'\t'+RS.getString(2)+'\t'+RS.getString(3)); } con.close(); }catch(SQLExceptione){ (e); } } publicvoidinsert(){ StringSNO,SNAME,AGE; ("请输入要插入的信息："); SNO=reader.next(); SNAME=reader.next(); AGE=reader.next(); StringURL="jdbc:mysql://localhost:3306/mysql?Unicode=true&characterEncoding=GBK"; Stringuser="root"; Stringpassword=""; ResultSetRS; try{ con=DriverManager.getConnection(URL,user,password); }catch(SQLExceptione){ (e); } try{ sql=con.prepareStatement("insertintostudentvalues(?,?,?)"); sql.setString(1,SNO); sql.setString(2,SNAME); sql.setString(3,AGE); intm=sql.executeUpdate(); if(m!=0){ ("添加成功！运行结果："); } else("添加失败！运行结果："); /*查询插入后结果*/ sql=con.prepareStatement("select*fromstudent"); RS=sql.executeQuery(); while(RS.next()){ System.out.println(RS.getString(1)+'\t'+RS.getString(2)+'\t'+RS.getString(3)); } con.close(); }catch(Exceptione){ (e); } } publicvoiddelete(){ StringSNO; ("请输入要删除信息的学号："); SNO=reader.next(); StringURL="jdbc:mysql://localhost:3306/mysql"; Stringuser="root"; Stringpassword=""; ResultSetRS; try{ con=DriverManager.getConnection(URL,user,password); }catch(SQLExceptione){ (e); } try{ sql=con.prepareStatement("deletefromstudentwhereSno=?"); sql.setString(1,SNO); intm=sql.executeUpdate(); if(m!=0){ ("删除成功！运行结果："); } else("删除失败！运行结果："); /*查询删除后结果*/ sql=con.prepareStatement("select*fromstudent"); RS=sql.executeQuery(); while(RS.next()){ System.out.println(RS.getString(1)+'\t'+RS.getString(2)+'\t'+RS.getString(3)); } con.close(); }catch(SQLExceptione){ (e); } } }publicclassExperiment_9_JDBC{ publicstaticvoidmain(finalString[]args){ Queryquery=newQuery(); query.select();//查询 query.insert();//插入 query.delete();//删除 }}实验题2学生信息管理系统。 学号：学号：姓名：年龄：查询追加删除状态：图3.10学生信息管理系统界面①点击“追加”按钮，可以追加一个学生信息；②点击“查询”按钮和“删除”按钮，可以按照学号查询或者删除一个学生信息；[技术提示]可以使用上一题开发的函数。运行结果：添加记录成功后，再次查询，结果如下：然后按学号删除：检验是否删除成功：可知是删除成功的。代码参考：packageJDBC_Experiment;import;import;import;import;import;import;import;import;import;import;import;import;import;import;classQuery{ Scannerreader=newScanner(System.in); Connectioncon; sql; publicQuery(){ try{ Class.forName(""); } catch(ClassNotFoundExceptione){ System.out.println(e); } } publicvoidselect(Texttext1,Texttext2,Texttext3,Texttext4){ text2.setText(""); text3.setText(""); text4.setText(""); text4.setText("请输入要查询的学号"); StringSNO=text1.getText(); StringURL="jdbc:mysql://localhost:3306/mysql"; Stringuser="root"; Stringpassword=""; ResultSetRS; try{ con=DriverManager.getConnection(URL,user,password); }catch(SQLExceptione){ System.out.println(e); } try{ sql=con.prepareStatement("select*fromstudentwhereSno=?"); sql.setString(1,SNO); RS=sql.executeQuery(); if(RS.next()){ text2.setText(RS.getString(2)); text3.setText(RS.getString(3)); text4.setText("查询成功！"); } else{ text4.setText("查无此人！"); } con.close(); }catch(SQLExceptione){ System.out.println(e); } } publicvoidinsert(Texttext1,Texttext2,Texttext3,Texttext4){ text4.setText(""); StringSNO,SNAME,AGE; text4.setText("请输入要插入的信息"); SNO=text1.getText(); SNAME=text2.getText(); AGE=text3.getText(); StringURL="jdbc:mysql://localhost:3306/mysql?Unicode=true&characterEncoding=GBK"; Stringuser="root"; Stringpassword=""; ResultSetRS; try{ con=DriverManager.getConnection(URL,user,password); }catch(SQLExceptione){ System.out.println(e); } try{ sql=con.prepareStatement("insertintostudentvalues(?,?,?)"); sql.setString(1,SNO); sql.setString(2,SNAME); sql.setString(3,AGE); intm=sql.executeUpdate(); if(m!=0){ text4.setText("添加成功！"); } elsetext4.setText("添加失败！"); con.close(); }catch(Exceptione){ System.out.println(e); } } publicvoiddelete(Texttext1,Texttext2,Texttext3,Texttext4){ text2.setText(""); text3.setText(""); text4.setText(""); StringSNO; text4.setText("请输入要删除信息的学号："); SNO=text1.getText(); StringURL="jdbc:mysql://localhost:3306/mysql"; Stringuser="root"; Stringpassword=""; ResultSetRS; try{ con=DriverManager.getConnection(URL,user,password); }catch(SQLExceptione){ System.out.println(e); } try{ sql=con.prepareStatement("deletefromstudentwhereSno=?"); sql.setString(1,SNO); intm=sql.executeUpdate(); if(m!=0){ text4.setText("删除成功！"); } elsetext4.setText("删除失败！"); con.close(); }catch(SQLExceptione){ System.out.println(e); } } }publicclassJDBC_UI{ protectedShellshell; privateTexttext; privateTexttext_1; privateTexttext_2; privateTexttext_3; /** *Launchtheapplication. *@paramargs */ publicstaticvoidmain(String[]args){ try{ JDBC_UIwindow=newJDBC_UI(); window.open(); }catch(Exceptione){ e.printStackTrace(); } } /** *Openthewindow. */ publicvoidopen(){ Displaydisplay=Display.getDefault(); createContents(); shell.open(); shell.layout(); while(!shell.isDisposed()){ if(!display.readAndDispatch()){ display.sleep(); } } } /** *Createcontentsofthewindow. */ protectedvoidcreateContents(){ finalQueryquery=newQuery(); shell=newShell(); shell.setSize(450,300); shell.setText("\u5B66\u751F\u4FE1\u606F\u7BA1\u7406\u7CFB\u7EDF"); LabellblNewLabel=newLabel(shell,SWT.NONE); lblNewLabel.setFont(SWTResourceManager.getFont("微软雅黑",12,SWT.NORMAL)); lblNewLabel.setBounds(26,42,48,21); lblNewLabel.setText("\u5B66\u53F7\uFF1A"); LabellblNewLabel_1=newLabel(shell,SWT.NONE); lblNewLabel_1.setFont(SWTResourceManager.getFont("微软雅黑",12,SWT.NORMAL)); lblNewLabel_1.setBounds(26,78,48,21); lblNewLabel_1.setText("\u59D3\u540D\uFF1A"); LabellblNewLabel_2=newLabel(shell,SWT.NONE); lblNewLabel_2.setFont(SWTResourceManager.getFont("微软雅黑",12,SWT.NORMAL)); lblNewLabel_2.setBounds(26,116,48,21); lblNewLabel_2.setText("\u5E74\u9F84\uFF1A"); LabellblNewLabel_3=newLabel(shell,SWT.NONE); lblNewLabel_3.setFont(SWTResourceManager.getFont("微软雅黑",12,SWT.NORMAL)); lblNewLabel_3.setBounds(26,179,48,21); lblNewLabel_3.setText("\u72B6\u6001\uFF1A"); text=newText(shell,SWT.BORDER); text.setBounds(80,42,104,23); text_1=newText(shell,SWT.BORDER); text_1.setBounds(80,78,104,23); text_2=newText(shell,SWT.BORDER); text_2.setBounds(80,114,104,23); text_3=newText(shell,SWT.BORDER); text_3.setEditable(false); text_3.setBounds(80,177,274,23); Buttonbutton=newButton(shell,