源程序
import java.sql.*; import java.io.*;
public class OA {
public static void wj() {
System.out.println(\文件编号\文件名称\文件类型\存储位置\ }
public static void kq() {
System.out.println(\员工编号\姓名\性别\时间\出勤情况\ }
public static void gg() {
System.out.println(\公告编号\公告内容\公告时间\通知人\ }
public static void hy() {
System.out.println(\会议编号\会议内容\会议时间\参会人\记录人\ }
public static void main(String[]args) {
try {
Class.forName(\ }catch(Exception e){
System.out.println(\ return; } try {
Connection con = DriverManager.getConnection(\\
Statement stmt = con.createStatement(); int z=1; while(z!=0) {
System.out.println(\查询2.插入3.更新4.删除\ System.out.println(\请选择：\ int x=0; try {
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
x=Integer.parseInt(br.readLine()); }catch(IOException ex){} if(x==5) z=0; if(x==1) {
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) {
ResultSet rs=stmt.executeQuery(\WNo,WName,WType,WPlace from wj\ wj();
while(rs.next()) {
int a=rs.getInt(\
String b=rs.getString(\ String c=rs.getString(\ String d=rs.getString(\ System.out.println(a+\ } }
if(i==2) {
ResultSet rs=stmt.executeQuery(\YNo,YName,Sex,YTime,YC from kq\ kq();
while(rs.next()) {
int a=rs.getInt(\
String b=rs.getString(\
String c=rs.getString(\ String d=rs.getString(\ String e=rs.getString(\ System.out.println(a+\ } }
if(i==3) {
ResultSet rs=stmt.executeQuery(\GNo,GContent,GTime,GPeople from gg\ gg();
while(rs.next()) {
int a=rs.getInt(\
String b=rs.getString(\ String c=rs.getString(\ String d=rs.getString(\ System.out.println(a+\ } }
if(i==4) {
ResultSet rs=stmt.executeQuery(\MNo,MTime,MContent,MPeople,MRecorder from hy\ hy();
while(rs.next()) {
int a=rs.getInt(\
String b=rs.getString(\ String c=rs.getString(\ String d=rs.getString(\ String e=rs.getString(\ System.out.println(a+\ } } }
if(x==2) {
System.out.println(\文件信息插入2.考勤信息插入3会议记录插入4.公告通知插入\
System.out.println(\请选择：\ int m=0; try{
BufferedReader br=new BufferedReader(new
InputStreamReader(System.in));
m=Integer.parseInt(br.readLine()); }catch(IOException ex){} if(m==1){
String c1=\ //PreparedStatement
pstmt1=con.prepareStatement(\* from Communication where Uname=?\
//pstmt1.setString(1,c1);
//ResultSet rs2=pstmt1.executeQuery();
System.out.println(\输入你要插入的文件编号：\ try{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
c1=br.readLine(); }catch(IOException ex){}
System.out.println(\
System.out.println(\输入你要插入的文件名称：\ try{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
c2=br.readLine(); }catch(IOException ex){}
System.out.println(\
System.out.println(\输入你要插入的文件种类：\ try{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
c3=br.readLine(); }catch(IOException ex){}
System.out.println(\
System.out.println(\输入你要插入的存储位置：\ try{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
c4=br.readLine(); }catch(IOException ex){}
System.out.println(\pstmt2=con.prepareStatement(\ pstmt2.setString(1,c1); pstmt2.setString(2,c2); pstmt2.setString(3,c3); pstmt2.setString(4,c4); pstmt2.executeUpdate();
System.out.println(\插入成功!\ pstmt2.close(); //pstmt1.close(); //rs2.close(); }
if(m==2){
String c1=\ //PreparedStatement
pstmt1=con.prepareStatement(\ //pstmt1.setString(1,c1);
//ResultSet rs2=pstmt1.executeQuery();
System.out.println(\输入你要插入的员工编号：\ try{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
c1=br.readLine(); }catch(IOException ex){}
System.out.println(\
System.out.println(\输入你要插入的姓名：\ try{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
c2=br.readLine(); }catch(IOException ex){}
System.out.println(\
System.out.println(\输入你要插入的性别：\ try{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
c3=br.readLine(); }catch(IOException ex){}
System.out.println(\
//ResultSet rs2=pstmt1.executeQuery();
System.out.println(\输入你要插入的时间：\ try{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
c4=br.readLine(); }catch(IOException ex){}
System.out.println(\
System.out.println(\输入你要插入的出勤情况：\ try{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));