办公室日常信息管理系统数据库课程设计报告

1、办公室日常信息管理系统1需求分析：1.1业务流程分析：系统管理员的功能包括如下几个方面：文件信息管理、考勤信息管理、会议记录管理、 通知公告管理办公管理系统的数据库功能主要体现在对各种信息的提供、包括通知公告信息，文件信息。时间，姓名，性别，出勤情况会议时间，参会人，记录人，会议内容通知公告：公告编号,内容，通知人，公告时间用户管理：用户以合法身份登入系统后，管理员可以进行系统用户的添加 密码的修改操作。文件信息管理：办公室管理员可以在 文件信息管理模块对办公室线路信息进 行管理。管理员首先建立办公室 文件信息数据库，输入原始的文件信息，当有新 的文件需要添加或者需要对已有的 文件信息进行修改

2、，删除的时候，管理员就可 以进行相应的操作。管理员也可以通过本模块查询到所有需要查询的文件的详细 信息。考勤信息管理：管理员可以在考勤信息管理模块实现对考勤信息的管理。管 理员首先应该建立考勤信息数据库，输入原始的数据信息，当有新的考勤信息的 时候或者管理员需要修改某个 考勤的相关信息以及想要删除某个 考勤信息的时候，就可以完成相应的操作。管理员也可以在整个数据库中查寻相关考勤信息。会议记录管理：管理员可以在 会议记录管理模块实现对 会议记录信息的管 理。管理员根据相应的 会议记录来设置相应的会议记录详细信息。当有新的会议 记录添加的时候，要把相应的会议记录信息添加到数据库中，管理员还可以对某

3、 条会议记录信息进行修改，删除和查询操作。通知公告管理：管理员可以在通知公告管理模块实现对 通知公告信息的管 理。管理员根据相应的 通知公告来设置相应的通知公告详细信息。当有新的通知 公告添加的时候，要把相应的通知公告信息添加到数据库中，管理员还可以对某 条通知公告信息进行修改，删除和查询操作。1.2功能分析：程序分为登陆界面，选择界面，文件信息界面，考勤信息界面，会议记录信 息，通知公告信息用户注册界面这几个主体界面。使用时应先知道管理员帐号和 密码，登陆进入系统主菜单界面，里面包括文件信息，考勤信息，会议记录信息, 通知公告，用户注册，退出程序菜单选项。需要特别说明的是，当对数据进行操 作

4、时，在查询框内输入提示数据内容，对话框的表中和提示栏中都会出现所查询 的数据，我们可以在提示栏中对数据进行删除和修改操作。文件信息：文件编号,文件名称，文件类型，存储位置保存、更新和查询的操作上,考勤信息：员工编号,会议记录：会议编号,图1:办公室日常管理系统功能模块图1.3数据流图和数据字典1.3.1数据流图数据流图就是从数据的角度描述系统的组成及组成之间的联系，将业务工作 流程以一种明确而又易于理解的形式表示出来。数据流图有四个基本构成成分:数据流：即流动的数据，代表信息流过的通道。用带箭头的直线 表示，直线上方表明数据流的名称，箭头代表数据流流动方向。加工或处理：处理是对进入的数据流进行

5、特定加工的过程，数据流被处理后将产生新的数据流。用圆圈表示，圆圈内注明处理的 名称。文件或数据存储： 数据流图中的文件代表一种数据的暂存场所，可对其进行存取操作。用一侧带有双线的方框表示，并在其内注 明文件或数据存储的名称。外部实体：用以说明数据的来源和归宿，即表示数据的原点和终 点。用方框表示，并在其内注明相应的名称。1.3.2数据字典数据字典表达了数据和处理过程的关系。在SA方法中，处理过程的处理活动常常借助于判定表或判定树来描述。系统中的数据则借助数据字典来描述。数据字典是系统中各类数据描述的集合，是进行详细的数据收集和数据分析 所获得的主要成果，在数据库设计中占有很重要的地位。 数据字

6、典通常包括数据(2)(3)图2:办公室日常管理系统流图项、数据结构、数据流、数据存储和处理过程、外部项等六个部分。文件信息表属性名列名数据类型主键是否允许空文件编号WNoint是否文件名称WNamechar否文件类型WTypechar否存储位置WPIacechar否考勤信息表属性名列名数据类型主键是否空员工编号YNoint是否姓名YNameChar否性别Sexchar否时间YTimechar否出勤情况YCchar否会议记录表属性名列名数据类型主键是否空会议编号MNoint是否会议时间MTimechar否会议内容MContentchar否参会人MP eo piechar否记录人MRecorder

7、char否公告通知表属性名列名数据类型主键是否空公告编号GNoint是否公告内容GCo ntentchar否公告时间GTimeChar否通知人GP eo piechar否2.概念结构设计概念结构是各种数据模型的共同基础，它比数据模型更独立于机器、更抽象,从而更加稳定。描述概念模型的有力工具是E-R图。由于E-R图提供了人们对数据模型的描述，它即标准、规范，又直观、具体，从而使得E-R图成为应用最广泛的数据库概念设计工具。源程序import java.sql.*;import java.io.*;p ublic class OAp ublic static void wj()System.out

8、. printing+t存储位置);文件编号+t文件名称+t文件类型P ublic static void main( Stri ngargs)try Class.forName(s un .jdbc.odbc.JdbcOdbcDriver);catch(Exce ptio n e)System.out. printin (JDBC-ODBC driver failed to load.); return;try Connection con = DriverManager.getConnection(jdbc:odbc:OA, sa, );Stateme nt stmt = con .cre

9、ateStateme nt();int z=1; while(z!=0)System.out. printin (1.System.out. prin tl n(int x=0;try BufferedReaderInp utStreamReader(System.i n);x=I nteger. parselnt(br.readLi ne();catch(IOExce pti on ex)if(x=5) z=0;P ublic static void kq()System.out. printing+tt出勤情况);p ublic static void gg()System.out. pr

10、inting知人);p ublic static void hy()System.out. printing人+tt记录人);员工编号+姓名+t性别+tt时间公告编号+t公告内容+t公告时间+t通会议编号+会议内容+t会议时间+t参会查询2.插入3.更新4.删除);请选择：)；br=newBufferedReader( newif(x=1)System.out. printin (1.公告通知查询4.会议记录查询);System.out. prin tl n(int i=0;tryBufferedReaderInp utStreamReader(System.i n);文件信息查询2.考勤信息

11、查询3.请选择：）；br=newBufferedReader( newi=I nteger. parsel nt(br.readLine(); catch(IOExce ptio n ex) if(i=1) ResultSetWNo,WName,WTy pe,WPIace from wj);wj();while(rs. next()rs=stmt.executeQuery(selectint a=rs.getI nt(WNo);Stri ng b=rs.getStri ng(WName);Stri ng c=rs.getStri ng(WTy pe);Stri ng d=rs.getStri

12、ng(WPIace);System.out .printin (a+tt+b+c+d);if(i=2)ResuItSetYNo,YName,Sex,YTime,YC from kq);kq();while(rs. next()rs=stmt.executeQuery(selectint a=rs.get In t(YNo);Stri ng b=rs.getStri ng(YName);Stri ng c=rs.getStri ng(Sex);Stri ng d=rs.getStri ng(YTime);Stri ng e=rs.getStri ng(YC);System.out .prin t

13、l n( a+t+b+c+d+e);if(i=3)ResultSetGNo,GCo nten t,GTime,G Peo pie from gg);rs=stmt.executeQuery(selectgg();while(rs. next() int a=rs.get In t(GNo);Stri ng b=rs.getStri ng(GCo nten t);Stri ng c=rs.getStri ng(GTime);Stri ng d=rs.getStri ng(G Peo pie); System.out .printin(a+tt+b+c+d); if(i=4)ResultSetrs

14、=stmt.executeQuery(selectMNo,MTime,MCo nte nt,MP eo ple,MRecorder from hy);hy();while(rs. next()int a=rs.get In t(MNo);Stri ng b=rs.getStri ng(MTime);Stri ng c=rs.getStri ng(MCo nte nt);Stri ng d=rs.getStri ng(M Peo pie);Stri ng e=rs.getStri ng(MRecorder);System.out .prin tl n( a+t+b+c+d+e);m=I nteg

15、er. parsel nt(br.readLi ne();catch(IOExce ptio n ex) if(m=1)Stri ng c1=,c2=,c3=,c4=;/Prep aredStateme ntp stmt1=co n.prep areStateme nt(select * from muni cati on where Un ame=?);/pstmtI.setStri ng(1,c1);/ResultSet rs2=pstmt1.executeQuery();System.out. println(输入你要插入的文件编号：);tryBufferedReader br=new

16、BufferedReader( new InputStreamReader(System.i n);if(x=2)System.out. printin (1.会议记录插入4.公告通知插入);System.out. prin tl n(int m=0;tryBufferedReaderInp utStreamReader(System.i n);文件信息插入2.考勤信息插入3请选择：）；br=newBufferedReader( newc仁br.readL in e();catch(IOExce pti on ex)System.out .prin tl n( c1=+c1);System.o

17、ut. printing输入你要插入的文件名称：);tryBufferedReader br=new BufferedReader( new InputStreamReader(System.i n);c2=br.readL in e();catch(IOExce pti on ex)System.out .prin tl n(c2=+c2);System.out. println(输入你要插入的文件种类：);tryBufferedReader br=new BufferedReader( new InputStreamReader(System.i n);c3=br.readL in e()

18、;catch(IOExce pti on ex)System.out .printin (c3=+c3);System.out. printing输入你要插入的存储位置：);tryBufferedReader br=new BufferedReader( new InputStreamReader(System.i n);c4=br.readL in e();catch(IOExce pti on ex)System.out. prin tl n(c4=+c4); Prep aredStateme ntp stmt2=c on.prep areStateme nt(i nsert into w

19、j values亿？)；p stmt2.setStri ng(1,c1);p stmt2.setStri ng(2,c2);p stmt2.setStri ng(3,c3);p stmt2.setStri ng(4,c4);p stmt2.executeU pdate();System.out.printing插入成功!);p stmt2.close();/pstmt1.close();/rs2.close();if(m=2)Stri ng c1=,c2=,c3=,c4=,c5=;/Prep aredStateme ntp stmt1=c on.prep areStateme nt(selec

20、t * from Memo where Un ame=?);/pstmtI.setStri ng(1,c1);/ResultSet rs2=pstmt1.executeQuery();System.out. printing输入你要插入的员工编号：);tryBufferedReader br=newBufferedReader( newInp utStreamReader(System.i n);c仁br.readL in e();catch(IOExce pti on ex)System.out .prin tl n( c1=+c1);System.out .printing输入你要插入的姓

21、名：);tryBufferedReader br=newBufferedReader( newInp utStreamReader(System.i n);c2=br.readL in e();catch(IOExce pti on ex)System.out .prin tl n(c2=+c2); System.out. prin tl n(输入你要插入的性别：);tryBufferedReader br=newBufferedReader( newInp utStreamReader(System.i n);c3=br.readL in e(); catch(IOExce pti on e

22、x)System.out .printin (c3=+c3); /ResultSetrs2=pstmt1.executeQuery(); System.out .prin tl n(输入你要插入的时间：);tryBufferedReader br=newBufferedReader( newInp utStreamReader(System.i n);c4=br.readL in e();catch(IOExce pti on ex)System.out .prin tl n(c4=+c4);System.out .prin tl n(输入你要插入的出勤情况：);tryBufferedRead

23、er br=newBufferedReader( newInp utStreamReader(System.i n);c5=br.readL in e();catch(IOExce pti on ex) System.out. prin tl n(c5=+c5); PreparedStateme ntp stmt2=c on.prep areStateme nt(i nsert into kq values(?,?,?,?,?);p stmt2.setStri ng(1,c1);p stmt2.setStri ng(2,c2);p stmt2.setStri ng(3,c3);p stmt2.

24、setStri ng(4,c4);p stmt2.setStri ng(5,c5);p stmt2.executeU pdate();System.out.printing插入成功！)；p stmt2.close();/pstmt1.close();/rs2.close();if(m=3)Stri ng c1=,c2=,c3=,c4=,c5=;/Prep aredStateme ntp stmt仁c on.prep areStateme nt(select * from Diary where Un ame=?);/pstmt1.setStri ng(1,c1);/ResultSet rs2=

25、pstmt1.executeQuery();System.out. println(输入你要插入的会议编号：);tryBufferedReader br=newBufferedReader( newInp utStreamReader(System.i n);c仁br.readL in e();catch(IOExce pti on ex)System.out .prin tl n( c1=+c1);System.out. printing输入你要插入的会议时间：);tryBufferedReader br=newBufferedReader( newInp utStreamReader(Sy

26、stem.i n);c2=br.readL in e();catch(IOExce pti on ex)System.out .prin tl n(c2=+c2);System.out. println(输入你要插入的会议内容：);tryBufferedReader br=newBufferedReader( newInp utStreamReader(System.i n);c3=br.readL in e();catch(IOExce pti on ex)System.out .printin (c3=+c3);System.out. printing输入你要插入的参会人：);tryBuf

27、feredReader br=newBufferedReader( newInp utStreamReader(System.i n);c4=br.readL in e();catch(IOExce pti on ex)System.out. printin (c4=+c4);System.out. printing输入你要插入的记录人：);tryBufferedReader br=newBufferedReader( newInp utStreamReader(System.i n);c5=br.readL in e();catch(IOExce pti on ex)System.out.

28、prin tl n(c5=+c5);Prep aredStateme ntp stmt2=c on.prep areStateme nt(i nsert into hy values亿？,？)；p stmt2.setStri ng(1,c1);p stmt2.setStri ng(2,c2);p stmt2.setStri ng(3,c3);p stmt2.setStri ng(4,c4);p stmt2.setStri ng(5,c5);p stmt2.executeU pdate();System.out.printing插入成功!);p stmt2.close();/pstmt1.clo

29、se();/rs2.close();if(m=4)Stri ng c1=,c2=,c3=,c4=;/Prep aredStateme ntp stmt1=co n.prep areStateme nt(select * from Finance where Un ame=?);/pstmtI.setStri ng(1,c1);/ResultSet rs2=pstmt1.executeQuery();System.out. println(输入你要插入的公告编号：);tryBufferedReader br=newBufferedReader( newInp utStreamReader(Sys

30、tem.i n);c1=br.readL in e();catch(IOExce pti on ex)System.out .prin tl n( c1=+c1);System.out. println(输入你要插入的公告内容：);tryBufferedReader br=newBufferedReader( newInp utStreamReader(System.i n);c2=br.readL in e();catch(IOExce pti on ex)System.out .prin tl n(c2=+c2);System.out. printing输入你要插入的公告时间：);tryB

31、ufferedReader br=newBufferedReader( newInp utStreamReader(System.i n);c3=br.readL in e();catch(IOExce pti on ex)System.out .printin (c3=+c3);System.out. printing输入你要插入的通知人：);tryBufferedReader br=newBufferedReader( newInp utStreamReader(System.i n);c4=br.readL in e(); catch(IOExce pti on ex) System.o

32、ut.printin (c4=+c4); Prep aredStateme ntp stmt2=c on.prep areStateme nt(i nsert into gg values(?,?,?,?);p stmt2.setStri ng(1,c1);p stmt2.setStri ng(2,c2);p stmt2.setStri ng(3,c3);p stmt2.setStri ng(4,c4);p stmt2.executeU pdate();p stmt2.close();System.out.printing插入成功!);/pstmt1.close(); /rs2.close()

33、; if(x=3) System.out. printin (1.会议记录修改4.公告通知修改);System.out. prin tl n(int m=0;tryBufferedReaderInp utStreamReader(System.i n);m=I nteger. parsel nt(br.readLi ne();catch(IOExce ptio n ex) if(m=1) Stri ng m11=;Stri ng m13=;i ntm12=0; System.out .prin tl n(选择你要修改文件的编号：);try BufferedReaderInp utStreamR

34、eader(System.i n);m11=br.readL ine(); catch(IOExce pti on ex) Prep aredStateme ntp stmt31=c on.prep areStateme nt(select * from wj where WNo=?);p stmt31.setStri ng(1,m11);ResultSet rs3=pstmt31.executeQuery(); if(rs3. next()System.out.printing输入你要修改的项：1.文件名称2.文件种类3.存储位置);文件信息修改2.考勤信息修改3.请选择：）；br=newB

35、ufferedReader( newbr=newBufferedReader( newBufferedReader br=new BufferedReader(newInp utStreamReader(System.i n);try BufferedReader br=newBufferedReader( newInp utStreamReader(System.i n);m12=l nteger. parse In t(br.readLi ne();catch(IOExce ptio n ex)if(m12=1)System.out. printin (try BufferedReader

36、 br=new BufferedReader(new InputStreamReader(System.i n);m13=br.readL in e();catch(IOExce ptio n ex)p stmt31.close(); Prep aredStateme ntp stmt3=c on.prep areStateme nt(U pdate wj set WName=? where WNo=?);p stmt3.setStri ng(1,m13);p stmt3.setStri ng(2,m11);p stmt3.executeU pdate(); System.out.printl

37、n(修改成功!); if(m12=2)System.out. printin (的值:);try BufferedReader br=new BufferedReader(new InputStreamReader(System.i n);m13=br.readL in e();catch(IOExce ptio n ex)p stmt31.close(); Prep aredStateme ntp stmt3=c on.prep areStateme nt(U pdate wj set WTyp e=? where WNo=?);p stmt3.setStri ng(1,m13);/pstm

38、t3.set in t(2,m11);p stmt3.setStri ng(2,m11);p stmt3.executeU pdate();System.out.println(修改成功!);rs3.close();/pstmt3.close();if(m12=3)System.out .prin tl n(的值:);try m13=br.readL in e();输入你修改后输入你修改后输入你修改后BufferedReader br=new BufferedReader(newInp utStreamReader(System.i n);catch(IOExce ptio n ex)p st

39、mt31.close();Prep aredStateme ntp stmt3=c on.prep areStateme nt(U pdate wj set WPI ace=? where WNo=?);p stmt3.setStri ng(1,m13);/pstmt3.set in t(2,m11);p stmt3.setStri ng(2,m11);p stmt3.executeU pdate();System.out.println(修改成功!);rs3.close();/pstmt3.close();elseSystem.out.printin(”你要更改的项不存在!);if(m=2)

40、Stri ng m11=;Stri ng m13=;i nt m12=0;System.out .printing选择你要修改员工编号：);tryBufferedReaderInp utStreamReader(System.i n);m1仁br.readL in e();catch(IOExce pti on ex)Prep aredStateme ntp stmt31=c on.prep areStateme nt(select * from kq where YNo=?);p stmt31.setStri ng(1,m11);ResultSet rs3=pstmt31.executeQu

41、ery();if(rs3. next()System.out.printing输入你要修改的项：1.员工姓名2.性别3.时间4.出勤情况);tryBufferedReader br=newBufferedReader( newInp utStreamReader(System.i n);m12=I nteger. parse In t(br.readLi ne(); catch(IOExce ptio nex) if(m12=1)System.out .prin tl n(try m13=br.readL in e();catch(IOExce ptio n ex)p stmt31.ciose

42、();br=newBufferedReader( new输入你修改后BufferedReader br=new BufferedReader(newInp utStreamReader(System.i n);Prep aredStateme ntp stmt3=c on.prep areStateme nt(U pdate kq set YName=? where YNo=?);p stmt3.setStri ng(1,m13);p stmt3.setStri ng(2,m11);p stmt3.executeU pdate(); System.out.println(修改成功!);if(m

43、12=2)System.out. printin (try BufferedReader br=new BufferedReader(new InputStreamReader(System.i n);m13=br.readL in e();catch(IOExce ptio n ex)p stmt31.close(); Prep aredStateme ntp stmt3=c on.prep areStateme nt(U pdate kq set Sex=? where YNo=?);p stmt3.setStri ng(1,m13);/pstmt3.set in t(2,m11);p s

44、tmt3.setStri ng(2,m11);p stmt3.executeU pdate();System.out.println(修改成功!);rs3.close();/pstmt3.close();if(m12=3)System.out .prin tl n(的值:);try BufferedReader br=new BufferedReader(new InputStreamReader(System.i n);m13=br.readL in e();catch(IOExce ptio n ex)p stmt31.close();Prep aredStateme ntp stmt3=

45、c on.prep areStateme nt(U pdate kq set YTime=? where YNo=?);p stmt3.setStri ng(1,m13);/pstmt3.seti nt(2,m11);p stmt3.setStri ng(2,m11);p stmt3.executeU pdate();System.out.println(修改成功!);rs3.close();if(m12=4)System.out. printin (的值:);输入你修改后输入你修改后输入你修改后try BufferedReader br=new BufferedReader(new Inpu

46、tStreamReader(System.i n);m13=br.readL in e();catch(IOExce ptio n ex)p stmt31.close(); Prep aredStateme ntp stmt3=c on.prep areStateme nt(U pdate kq set YC=? where YNo=?);p stmt3.setStri ng(1,m13);/pstmt3.set in t(2,m11);p stmt3.setStri ng(2,m11);p stmt3.executeU pdate();System.out.println(修改成功!);rs

47、3.close(); elseSystem.out.println(你要更改的项不存在!); if(m=3)Stri ng m11=;Stri ng m13=;i nt m12=0; System.out .println(选择你要修改会议编号：);try BufferedReaderInp utStreamReader(System.i n);m11=br.readL in e();catch(IOExce pti on ex) Prep aredStateme ntp stmt31=c on.prep areStateme nt(select * from hy where MNo=?);

48、p stmt31.setStri ng(1,m11);ResultSet rs3=pstmt31.executeQuery(); if(rs3. next()System.out.printing输入你要修改的项：1.会议时间2.会议内容3.参会人4.记录人);try BufferedReader br=newBufferedReader( newInp utStreamReader(System.i n);m12=I nteger. parse In t(br.readLi ne(); catch(IOExce ptio nex) if(m12=1)System.out .prin tl n

49、(try m13=br.readL in e();br=newBufferedReader( new输入你修改后BufferedReader br=new BufferedReader(newInp utStreamReader(System.i n);catch(IOExce ptio n ex)p stmt31.close();Prep aredStateme ntp stmt3=c on.prep areStateme nt(U pdate hy set MTime=? where MNo=?);p stmt3.setStri ng(1,m13);p stmt3.setStri ng(2

50、,m11);p stmt3.executeU pdate(); System.out.println(修改成功!);if(m12=2)System.out. printin (try BufferedReader br=new BufferedReader(new InputStreamReader(System.i n);m13=br.readL in e();catch(IOExce ptio n ex)p stmt31.close(); Prep aredStateme ntp stmt3=c on.prep areStateme nt(U pdate hy set MConten t=

51、? where MNo=?);p stmt3.setStri ng(1,m13);/pstmt3.set in t(2,m11);p stmt3.setStri ng(2,m11);p stmt3.executeU pdate();System.out.println(修改成功!);rs3.close();/pstmt3.close();if(m12=3)System.out .prin tl n(的值:);try BufferedReader br=new BufferedReader(new InputStreamReader(System.i n);m13=br.readL in e()

52、;catch(IOExce ptio n ex)p stmt31.close(); Prep aredStateme ntp stmt3=c on.prep areStateme nt(U pdate hy set MPeopI e=? where MNo=?);p stmt3.setStri ng(1,m13);/pstmt3.seti nt(2,m11);p stmt3.setStri ng(2,m11);p stmt3.executeU pdate();System.out.println(修改成功!);rs3.close();输入你修改后输入你修改后if(m12=4)System.ou

53、t .printing输入你修改后的值:);try BufferedReader br=new BufferedReader(new InputStreamReader(System.i n);m13=br.readL in e();catch(IOExce ptio n ex)p stmt31.close(); Prep aredStateme ntp stmt3=c on.prep areStateme nt(U pdate hy set MRecorder=? where MNo=?);p stmt3.setStri ng(1,m13); /pstmt3.seti nt(2,m11);

54、pstmt3.setStri ng(2,m11); p stmt3.executeU pdate();System.out.println(修改成功!);rs3.close();elseSystem.out.println(你要更改的项不存在!); if(m=4)Stri ng m11=;Stri ng m13=;i nt m12=0; System.out. println(选择你要修改公告编号：);try BufferedReaderInp utStreamReader(System.i n);m11=br.readL in e();catch(IOExce pti on ex) Prep

55、 aredStateme ntp stmt31=c on.prep areStateme nt(select * from gg where GNo=?);p stmt31.setStri ng(1,m11);ResultSet rs3=pstmt31.executeQuery(); if(rs3. next()System.out.printing输入你要修改的项：1.公告内容2.公告时间3.通知人);tryBufferedReader br=newBufferedReader( newInp utStreamReader(System.i n);m12=I nteger. parse In

56、 t(br.readLi ne(); catch(IOExce ptio nex) if(m12=1)System.out. printin (的值:);tryBufferedReader br=new BufferedReader(newbr=newBufferedReader( new输入你修改后Inp utStreamReader(System.i n); m13=br.readL in e(); catch(IOExce ptio n ex) p stmt31.close();Prep aredStateme ntp stmt3=c on.prep areStateme nt(U pd

57、ate gg set GConten t=? where GNo=?);p stmt3.setStri ng(1,m13);p stmt3.setStri ng(2,m11);p stmt3.executeU pdate(); System.out.println(修改成功!); if(m12=2)System.out .prin tl n(try BufferedReader br=new BufferedReader(new InputStreamReader(System.i n);m13=br.readL in e();catch(IOExce ptio n ex)p stmt31.c

58、lose();Prep aredStateme ntp stmt3=c on.prep areStateme nt(U pdate gg set GTime=? where GNo=?);p stmt3.setStri ng(1,m13);/pstmt3.seti nt(2,m11);p stmt3.setStri ng(2,m11);p stmt3.executeU pdate();System.out.println(修改成功!);rs3.close();/pstmt3.close();if(m12=3)System.out .prin tl n(的值:);try BufferedRead

59、er br=new BufferedReader(new InputStreamReader(System.i n);m13=br.readL in e();catch(IOExce ptio n ex)p stmt31.close(); Prep aredStateme ntp stmt3=c on.prep areStateme nt(U pdate gg set GPeopI e=? where GNo=?);p stmt3.setStri ng(1,m13);/pstmt3.set in t(2,m11);p stmt3.setStri ng(2,m11);p stmt3.execut

60、eU pdate();System.out.println(修改成功!);输入你修改后输入你修改后rs3.close(); elseSystem.out.printin(”你要更改的项不存在!);i=I nteger. parsel nt(br.readLi ne();catch(IOExce ptio n ex) if(i=1)String S1=;System.out .prin tl n(输入你要删除的文件信息表中的文件编号：）；tryBufferedReaderInp utStreamReader(System.i n);S1=br.readLi ne();catch(IOExce p