JAVA试验JDBC数据库编程-报告

信息工程学院1《Java语言程序设计》实验报告成绩:学院： 班级： 姓名： 学号成绩:、实习目标(1)掌握使用Navicat建立数据库和表；(2)对MySQL数据库实现增、删、改、查操作。二、实验过程任务一：Jdbc编程。应用navicat简历test数据库，在该数据库中，建一个表employee，通过JDBC完成如下操作：.执行sql语句在表中添加如下记录；.将表中数据读出并将每人工资加1500后存入原表。Navicat建表：篦NavicatforMySQL文件㈤意看国)收藏夫血工具CD南匚血I都助血谢 管理用户视圄沁嚏I函数事件15employee■e-mployee©test[user]id5employee■e-mployee©test[user]idnamesexsalary》1002Tornmal^6001003Maryf&rnale12001004Petermale30001005JohnmaIe70001006PaulmalefiOOO文件蹿苴看葡匚帮助”■导人向导13导口向寻；篇选向拿y■-_user\•・… informstion_schema-i;my&ql\•・…\i.performanGe_5Ghema\…Eys*即test5已表-F,employee视图函数代码截图:EC类：实验报告的内容与格式按任课教师的要求书写。

团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”哪寸已签建避了总总,这里便用默认无密码//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("执4647484g505152545658System.out-println{"执行更新操作失败”);e_printStackTr,ace();)//关闭数据库七广V(cor.closeO;System.out-println("关闭成功")；}catch(SQLExceptione){printStackTrace();System.口”4.ppintl门1"关闭失败"执行结果:iaProblems次Javadoc匣，De<laratac<lermirated>EC[JavaApplication]D:\Ja躯动加载成功直接成功成功生成5七日七emen七时象凯行更新操作成功美团成功■&mpl&yee©test(u&er)文件渠辑查看葡匚藉助".寻A向寻房寻匚向导7鼐选向寻idnamesexsalary1052Tommale21001003Mary■female27001004Petermale45001005Johnmale8500100&Paulmale9500任务二：在Mysql数据库中建立汽车产品信息表(product)Navicat建表：已打开表匕设计表J塞新建表J常删除表J二导人向导O等口向导v--user@employee-informationschema__:二：二du匚mysql■performance_schemaV卸tEltIMpreduct@test(user)XV-I_表文件菜境登着窗匚 帮助h-Eemployeeproduct一导人向导B寻=,向导 繇选向导 H网格宜着且声若萱看 上…石视图 ；productID name price datefti函数-®w•・晒查u…量㈱ ，…限kA001 BMW3202&0000201411-03B002 Eenz200 340000200912-09COOS AudiAS 3500002014-09-10D004 Volkswag.270000201101-09代码截图：FrameOperation类：这个类来处理界面，使用JFrame框架，先将所有对象创建好，然后对“查询”和“清除”事件进行设置。0fran^eOperationjava区_二一一：>.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 //标签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)■//查询结果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类：这个类用来进行数据库的相关操作，包括加载驱动，链接账号，生成对象，执行查询操作，并用字符串数组的形式返回查询结果给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产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