報告-實驗九-通過JDBC方式操作數(shù)據(jù)庫

實驗九通過JDBC方式操作數(shù)據(jù)庫1．實驗目的〔1〕掌握通過JDBC方式操作數(shù)據(jù)庫的根本步驟。〔2〕掌握增、刪、改記錄的方法?！?〕掌握查詢記錄以及遍歷查詢結(jié)果的方法。2．實驗內(nèi)容實驗題1學生信息管理函數(shù)。數(shù)據(jù)庫中的信息參考Exp9.1.txt，這些命令用來創(chuàng)立student表，包含學生的學號、姓名、年齡信息。①根據(jù)學號，可以查詢到學生的姓名和年齡；②給定學生的學號、姓名、年齡，在表中追加一行信息；③給定學生的學號，可以從表中刪除該學生的信息；[根本要求]對上面的每一個功能編寫相應的函數(shù)，并測試。運行結(jié)果：源代碼：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){ ("添加成功！運行結(jié)果："); } else("添加失??！運行結(jié)果："); /*查詢插入后結(jié)果*/ 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){ ("刪除成功！運行結(jié)果："); } else("刪除失敗！運行結(jié)果："); /*查詢刪除后結(jié)果*/ 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學生信息管理系統(tǒng)。 學號：學號：姓名：年齡：查詢追加刪除狀態(tài)：圖3.10學生信息管理系統(tǒng)界面①點擊“追加”按鈕，可以追加一個學生信息；②點擊“查詢”按鈕和“刪除”按鈕，可以按照學號查詢或者刪除一個學生信息；[技術提示]可以使用上一題開發(fā)的函數(shù)。運行結(jié)果：添加記錄成功后，再次查詢，結(jié)果如下：然后按學號刪除：檢驗是否刪除成功：可知是刪除成功的。代碼參考：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,