安徽理工大学课程设计（论文）
} else if(s .equals(\论文名查询\ System.out.println(); System.out.println(); System.out.print(\请输入论文名:\ String name = br.readLine(); try{ //与数据库建立连接 Class.forName(\ String url=\ String user=\ String password=\ Connection conn= DriverManager.getConnection(url,user,password);//每用一次连接一次 System.out.println(); System.out.println(); PreparedStatement ps = conn.prepareStatement(\Paper.论文编号,所在期刊,获奖情况,论文简介,职工号,姓名 from Paper,GeneralCourse where Paper.论文编号 = GeneralCourse.论文编号 and Paper.论文名称 =?\ ps.setString(1,name); ResultSet rs = ps.executeQuery(); String code = null; String magazine = null; String award = null; String synopsis = null; String employeeId = null; String name1 = null; while(rs.next()){ code = rs.getString(1); magazine = rs.getString(2); award = rs.getString(3); synopsis = rs.getString(4); employeeId = rs.getString(5); name1 = rs.getString(6); } if(code!=null){ System.out.println(\论文名：\ 论文编号：\ System.out.println(\作者姓名：\ 职工号：\
-26-
安徽理工大学课程设计（论文）
System.out.println(\所在期刊：\ System.out.println(\获奖情况：\ System.out.println(\论文简介：\ } else{ System.out.println(\ System.out.println(\ System.out.println(\ 抱歉，系统没有找到此论文！\ } rs.close(); ps.close(); conn.close(); }catch(Exception e2){ System.out.println(\操作错误！请检查数据库语言及相关的连接！\ e2.printStackTrace(); } } else if(s.equals(\科研成果名查询\ System.out.println(); System.out.println(); System.out.print(\请输入科研成果名:\ String name = br.readLine(); try{ //与数据库建立连接 Class.forName(\ String url=\ String user=\ String password=\ Connection conn= DriverManager.getConnection(url,user,password);//每用一次连接一次 System.out.println(); System.out.println(); PreparedStatement ps = conn.prepareStatement(\Fruit.成果编号,姓名,职工号,证书,级别,类别,成果简介 from Fruit,GeneralCourse where Fruit.成果编号 = GeneralCourse.科研成果编号 and Fruit.成果名称=?\ ps.setString(1,name); ResultSet rs = ps.executeQuery();
-27-
安徽理工大学课程设计（论文）
String code = null; String name1 = null; String employeeId = null; String certificate = null; String level = null; String sort = null; String synopsis = null; while(rs.next()){ code = rs.getString(1); name1 = rs.getString(2); employeeId = rs.getString(3); certificate = rs.getString(4); level = rs.getString(5); sort = rs.getString(6); synopsis = rs.getString(7);//成果简介是长文本类型。注意回头检查是否能以字符串形式输入！ } if(code!=null){ System.out.println(\成果名：\成果编号：\ System.out.println(\工作者姓名：\职工号：\ System.out.println(\证书：\级别：\ System.out.println(\类别：\ System.out.println(\成果简介：\ } else{ System.out.println(\ System.out.println(\ System.out.println(\ 抱歉，系统没有找到相关科研成果！\ } rs.close(); ps.close(); conn.close(); }catch(Exception e3){ System.out.println(\操作错误！请检查数据库语言及相关的连接是否正确！\ e3.printStackTrace(); } } else if(s.equals(\科研项目名查询\ System.out.println(); System.out.println();
-28-
安徽理工大学课程设计（论文）
System.out.print(\请输入科研项目名:\ String name = br.readLine(); try{ //与数据库建立连接 Class.forName(\ String url=\ String user=\ String password=\ Connection conn= DriverManager.getConnection(url,user,password);//每用一次连接一次 System.out.println(); System.out.println(); PreparedStatement ps = conn.prepareStatement(\Item.项目编号,姓名,职工号,项目来源,起讫时间,参加人员角色,备注 from Item,GeneralCourse where Item.项目编号 = GeneralCourse.项目编号 and Item.项目名称=?\ ps.setString(1,name); ResultSet rs = ps.executeQuery(); String code = null; String name1 = null; String employeeId = null; String source = null; String time = null; String role = null; String remark = null; while(rs.next()){ code = rs.getString(1); name1 = rs.getString(2); employeeId = rs.getString(3); source = rs.getString(4); time = rs.getString(5); role = rs.getString(6); remark = rs.getString(7); } if(code != null){ System.out.println(\项目名：\项目编号：\ System.out.println(\工作者姓名：\ 职工号：\ System.out.println(\项目来源：\ System.out.println(\起讫时间：\
-29-
安徽理工大学课程设计（论文）
System.out.println(\参加人员角色：\ System.out.println(\备注：\ } else{ System.out.println(); System.out.println(); System.out.println(\ 抱歉，系统没有找到相关的科研项目！\ } rs.close(); ps.close(); conn.close(); }catch(Exception e3){ System.out.println(\操作错误！请检查数据库语言及相关的连接是否正确！\ e3.printStackTrace(); } } else if(s.equals(\部门名查询\ System.out.println(); System.out.println(); System.out.print(\请输入学院名:\ String name = br.readLine(); try{ //与数据库建立连接 Class.forName(\ String url=\ String user=\ String password=\ Connection conn= DriverManager.getConnection(url,user,password);//每用一次连接一次 System.out.println(); System.out.println(); PreparedStatement ps = conn.prepareStatement(\部门编号 from Department where 部门名称 = ?\ ps.setString(1,name); ResultSet rs = ps.executeQuery(); String code= null; while(rs.next()){
-30-