JAVA試驗JDBC數(shù)據(jù)庫編程-報告

信息工程學(xué)院1《Java語言程序設(shè)計》實驗報告成績:學(xué)院： 班級： 姓名： 學(xué)號成績:、實習(xí)目標(biāo)(1)掌握使用Navicat建立數(shù)據(jù)庫和表；(2)對MySQL數(shù)據(jù)庫實現(xiàn)增、刪、改、查操作。二、實驗過程任務(wù)一：Jdbc編程。應(yīng)用navicat簡歷test數(shù)據(jù)庫，在該數(shù)據(jù)庫中，建一個表employee，通過JDBC完成如下操作：.執(zhí)行sql語句在表中添加如下記錄；.將表中數(shù)據(jù)讀出并將每人工資加1500后存入原表。Navicat建表：篦NavicatforMySQL文件㈤意看國)收藏夫血工具CD南匚血I都助血謝 管理用戶視圄沁嚏I函數(shù)事件15employee■e-mployee?test[user]id5employee■e-mployee?test[user]idnamesexsalary》1002Tornmal^6001003Maryf&rnale12001004Petermale30001005JohnmaIe70001006PaulmalefiOOO文件躥苴看葡匚幫助”■導(dǎo)人向?qū)?3導(dǎo)口向?qū)ぃ黄x向拿y■-_user\??… informstion_schema-i;my&ql\??…\i.performanGe_5Ghema\…Eys*即test5已表-F,employee視圖函數(shù)代碼截圖:EC類：實驗報告的內(nèi)容與格式按任課教師的要求書寫。

團FC.java注1packagewurkl;3^importj3ua-sq1,Connectian;|_8publicclassEC{publicstaticvoidmain(String.[]args)8publicclassEC{Connectioncon=null;Statementsql=null;//加?見動七「尸;Class.forName(',com.my5q1.jdbc.Driver1');S/tQrl.ou，prirILlrIC"J:i；j卬整成J；-11)；}ca-tch(ClassNatFoundExceptionw){Systeni.out.println(r,l；zntntt±ii?'，5；€.printStackTrace0;)Stringurl="jdbc:my5q_://Localha5t/te5t?u5eSbL=true";Stringuser-"'root"Stringpassword= 看見朝要求為1”哪寸已簽建避了總總,這里便用默認(rèn)無密碼//i車蒼頰怩左“V<con=DriverManager，3etConnecttcin(ur'tuqsr,passwordJsSystem.flwt.printin(ni+^^D--);}catch(SQLExceptiun白){Sy51 ,out.print1n「唯后失位");e.printStackTrace{);H-怦一行語句try{sql-con.createStaternent()\SyEi1en.oui.print1n("Klj生代sintemen\正梟");jcatch(SQLExcepi-ione){Systeni.out.printin("片底二蒙牛i.i7");e-printStackTraceQ-J//出曲約伯String^qlUpdat^-"updatt!^mployeidbtLiiljry-salary-1500"；七「尸;sal.executeUpdarteisqlllpdate):4647484g505152545658System.out.println("執(zhí)4647484g505152545658System.out-println{"執(zhí)行更新操作失敗”);e_printStackTr,ace();)//關(guān)閉數(shù)據(jù)庫七廣V(cor.closeO;System.out-println("關(guān)閉成功")；}catch(SQLExceptione){printStackTrace();System.口”4.ppintl門1"關(guān)閉失敗"執(zhí)行結(jié)果:iaProblems次Javadoc匣，De<laratac<lermirated>EC[JavaApplication]D:\Ja軀動加載成功直接成功成功生成5七日七emen七時象凱行更新操作成功美團成功■&mpl&yee?test(u&er)文件渠輯查看葡匚藉助".尋A向?qū)し繉へ蜗驅(qū)?鼐選向?qū)dnamesexsalary1052Tommale21001003Mary■female27001004Petermale45001005Johnmale8500100&Paulmale9500任務(wù)二：在Mysql數(shù)據(jù)庫中建立汽車產(chǎn)品信息表(product)Navicat建表：已打開表匕設(shè)計表J塞新建表J常刪除表J二導(dǎo)人向?qū)等口向?qū)--user@employee-informationschema__:二：二du匚mysql■performance_schemaV卸tEltIMpreduct@test(user)XV-I_表文件菜境登著窗匚 幫助h-Eemployeeproduct一導(dǎo)人向?qū)尋=,向?qū)?繇選向?qū)?H網(wǎng)格宜著且聲若萱看 上…石視圖 ；productID name price datefti函數(shù)-?w??曬查u…量㈱ ，…限kA001 BMW3202&0000201411-03B002 Eenz200 340000200912-09COOS AudiAS 3500002014-09-10D004 Volkswag.270000201101-09代碼截圖：FrameOperation類：這個類來處理界面，使用JFrame框架，先將所有對象創(chuàng)建好，然后對“查詢”和“清除”事件進行設(shè)置。0fran^eOperationjava區(qū)_二一一：>.1packagework2;3*-importjava.avit.Color;[]13^SuppressWarnings(Mserial")publicclassFrameOperationextendsJFrame{1617181920212223^24252627282930313233。343536373839404142434445privateprivateprivateprivateprivateJPanelcontentPane;ITextFieldHextFieldJTextFieldDTextFieldDBCOperationdbcopidTextField;pnameTextField;ppriceTextField;pdateTextField;:null;publicstaticvoidmain(String[]args){try{UIHanager.settoofe4ndfee￡("corn.sun.java.swing.plaf.windows.WindowsLookAndFeel");}catch(Exceptione){e.printStacklraceO;}FraffleOperationframo=newFrameOperation();fname.setVisible(truo);publicFrameOperation(){dbco=newDBCOperation();setTitle("^C；fiSig")5setDefaultClose0peration(DFr8me.￡XrT_<W-C￡0S￡);setBounds(10G,100,45G,300);contentPane=newJPanel()jcontentPane.setBorder(newEmptyBorder(S,5)5,S));setContentPane(contentPane);contentPane.setLayout(null);contentPane.setBackground(Color.CKAA/);FrameOperationjava笈團DBCOperationjava46 pidTextField=newJTextField();47 pidTextField.s-etBounds(1278)224,23)548 contentPane.add(pidTextField);4-9 pidTextField.&etColumns(10);5051 pnameTextField=new3TextField();52 pnameTextField.setBounds(127j68)224) 23);contentPane.add(pnameTextField);54 pnameTextField.setColumns(10);55ppriceTextField=newJTextField(57 ppriceTextField.setBounds(127?98?224」23);58 contentPane.add(ppriceTextField);59 ppriceTextField.setColumns(10);6061 pdateTextField=newDTextField()j62 pdateTextField.setBounds(127J128, 224」23);63 contentPane.add(pdateTextField);64 pdateTextField.setColumns(10)j6566 //操作67 JButtonselectBtn=new1Button("查詢68 selectBtn.setBounds(63?38》S3,23);69 contentPane.add0selectBtn);7071 JButtonrefleshBtn=new^Button("清空")；72 refleshBtn.setBounds(268z38」93?23);73 contentPane.add(refleshBtn)57475 //標(biāo)簽76 1LabelIblNewLabel=new7Label("商品編號；77 IblNewLabel.setBounds(63^8)54? 15);78 contentPane.add(IblNewLabel);7980 JLabellbll\lewLabel_l=newDLabul，商品名稱：11);81 lblNevx/Label_l.setBoundsCGB^68)54,15”[i]FrameOperationJaivaKs出DBCOpeirationJavacontentPane.add(lblhleiAfLabel_l)■JLabelLblNeirtrLabel_2=new3Label(11伯格：")；lblNeiAfLabel_2.setBounds(63,9S?54?15)二contentPane.add(lbll\lewLabel_2)■JLabelLblNewLabel_3=new71L白bd("出廠日期：");IblhlewLabeld.setBounds(63,128j54T15)；contentPane.add(lbll\lewLabel_3)■//查詢結(jié)果selectBtn.addActionListener(newActionListener()-{publicvoidactionPerformed(ActionEventarg0){Stringid=pidTextField.getText()jStringrc[]=dbco.selectproductlD(id)■Stringname=rc[0]■Stringprice=rc[1]jStringdate=rc[2];pnameTex±F:ield_setTex±(name)■ppriceTextField.setText(price)jpdateTextField_setTex±(date)■}})i//滑空界面refleshBtn.addActionListener(newActionListener(){publicveldactionPeriror,med(ActionEventarg0){pidTextField.setTextC'11);pnameTextField_setTex±(";ppriceTextField.setText("'")"pdateTextField.setText("");}})；DBCOperation類：這個類用來進行數(shù)據(jù)庫的相關(guān)操作，包括加載驅(qū)動，鏈接賬號，生成對象，執(zhí)行查詢操作，并用字符串?dāng)?shù)組的形式返回查詢結(jié)果給FrameOperation類。21011121314rkJ20kk■26K■29卜k|35給k42434且T454￡474B妗5051525354S&56575B59西61626364y團DBCOperation.javaii-S1packagework2;importjava-.Connpction;publicclassDBCOperation{Ccnnertioncon=null;Statementsql-null;ResultSetrs=nullpublicDBCOpera±￡or(){try{C1ass.j-cr'Jlifsjne("cam.myI.jdbr.Driver1');System.out.prantin{"亞動芯期成功”}j}catch(ClassNotFoundExceptione){三ystem.out-print1n("把板嗤上購“)；e.printStackTrace()j}Stringurl-11jdbc:mysql://localhosiz/±est?useSSL-true1;Stringuser="rout"jStringpassword="";?y{con=DriverMariagef.5etConf?ection(uirlfuserjpawword);System.out.口rintlM"：車搏成功");}catch(SQLExcep-tione){System.out.printIn("凝接*膽”)；e.printStackTrace();),try1sql=ccn.createStatement();System*aui.printing”詼由三成占七a七已n+ni:對彖")]}catch(SQLEjcceptione)(System.out.printIn(11 statemenz^^^tjiir");e.print5±ackTrace();nlitwfFpublicString.[]soLqc.tprodur*tID{Stringpidl){String產(chǎn)4]=]"不啟在13帕Tjn不拓Thstringsq1s= naHc-^pricQjdatafroriproductuhsrsproductID=r11+String.uoiuvOf(piud)+try{rc=sql.qxqeutaQuary(eq1^)-if{Irs.nextt)1)freturnre;:System.wt-println("或同底為")：re[O]|-rs.ffetS