m13=br.readLine();
}catch(IOException ex){} pstmt31.close(); PreparedStatement
pstmt3=con.prepareStatement(\ pstmt3.setString(1,m13); //pstmt3.setint(2,m11); pstmt3.setString(2,m11); pstmt3.executeUpdate();
System.out.println(\修改成功!\ rs3.close(); }
}
else{System.out.println(\你要更改的项不存在!\ } } if(x==4) {
System.out.println(\文件信息删除2.考勤信息删除3.公告通知删除4.会议记录删除\
System.out.println(\请选择：\ int i=0; try{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
i=Integer.parseInt(br.readLine()); }catch(IOException ex){} if(i==1){
String S1=\
System.out.println(\输入你要删除的文件信息表中的文件编号：\
try{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
S1=br.readLine();
}catch(IOException ex){} PreparedStatement
pstmt2=con.prepareStatement(\ pstmt2.setString(1,S1); System.out.println(S1);
pstmt2.executeUpdate();
System.out.println(\已删除!\ pstmt2.close(); }
if(i==2){
String S1=\
System.out.println(\输入你要删除的考勤信息表的员工编号：\
try{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
S1=br.readLine();
}catch(IOException ex){} PreparedStatement
pstmt2=con.prepareStatement(\ pstmt2.setString(1,S1); pstmt2.executeUpdate();
System.out.println(\已删除!\ pstmt2.close(); }
if(i==3){
String S1=\
System.out.println(\输入你要删除的公告通知表的公告编号：\
try{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
S1=br.readLine();
}catch(IOException ex){} PreparedStatement
pstmt2=con.prepareStatement(\ pstmt2.setString(1,S1); pstmt2.executeUpdate();
System.out.println(\已删除!\ pstmt2.close(); }
if(i==4){
String S1=\
System.out.println(\输入你要删除的会议信息表的会议编号：\
try{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
S1=br.readLine();
}catch(IOException ex){} PreparedStatement
pstmt2=con.prepareStatement(\ pstmt2.setString(1,S1); pstmt2.executeUpdate();
System.out.println(\已删除!\ pstmt2.close(); } } }
}catch(Exception e){
System.out.println(e); } } }
图1 文件信息查询表
图2 考勤信息查询表
图3 公告通知查询表
