基于Java web的科研管理系统（源码+数据库）.zip

package po; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import dao.user_thesis; public class thesis_dao { // 查找所有论文名称 public static ArrayList<String> findAllThnames() { ArrayList<String> thnames = new ArrayList<>(); Connection connection = link_db.getcon(); String sql = "select thname from user_thesis "; try { Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery(sql); if (resultSet != null) { // 如果查询到用户的论文信息 while (resultSet.next()) { thnames.add(resultSet.getString("thname")); } } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } link_db.close_db(connection); return thnames; } // 根据论文名称查出此篇论文信息 public static user_thesis findInfoByThname(String thname) { user_thesis ut = new user_thesis(); Connection connection = link_db.getcon(); String sql = "select *from thesis,user_thesis where user_thesis.thno=thesis.thesisno and user_thesis.thname='" + thname + "'"; try { Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery(sql); if (resultSet != null) { // 如果查询到用户的论文信息 while (resultSet.next()) { ut.setThid(resultSet.getString("thid"));// 论文编号 ut.setThname(resultSet.getString("thname"));// 论文名称 ut.setThusername(resultSet.getString("thusername"));// 第一作者 ut.setThtime(resultSet.getString("thtime"));// 发表时间 ut.setThno(resultSet.getString("thno") + " " + resultSet.getString("thesisname"));// 论文等级 } } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } link_db.close_db(connection); // System.out.println(ut.getThid() + ut.getThname()); return ut; } // 根据作者名字查出所有论文信息 public static ArrayList<user_thesis> findThesisInfoByUsername(String username) { ArrayList<user_thesis> thesisArray = new ArrayList<>(); Connection connection = link_db.getcon(); String sql = "select *from thesis,user_thesis where user_thesis.thno=thesis.thesisno and user_thesis.thusername='" + username + "'"; try { Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery(sql); if (resultSet != null) { // 如果查询到用户的论文信息 while (resultSet.next()) { user_thesis ut = new user_thesis(); ut.setThid(resultSet.getString("thid"));// 论文编号 ut.setThname(resultSet.getString("thname"));// 论文名称 ut.setThusername(resultSet.getString("thusername"));// 第一作者 ut.setThtime(resultSet.getString("thtime"));// 发表时间 ut.setThno(resultSet.getString("thno") + " " + resultSet.getString("thesisname"));// 论文等级 thesisArray.add(ut); } } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } link_db.close_db(connection); return thesisArray; } // 通过输入任意的关键字来查询论文的信息 public static ArrayList<user_thesis> findAllInfoByInput(String input) { ArrayList<user_thesis> thesisArray = new ArrayList<>(); Connection connection = link_db.getcon(); Statement statement; // 三表查询，接入shenbaouser表格。所以获得的数据为三表联合查询的结果 try { statement = connection.createStatement(); ResultSet resultSet = null; if (input.length() == 0) { /* String sql = resultSet = statement.executeQuery(sql); */ // 需要更改 String sql = "select distinct *from thesis,user_thesis where user_thesis.thno=thesis.thesisno "; if ((resultSet = statement.executeQuery(sql)) != null) { while (resultSet.next()) { user_thesis ut = new user_thesis(); ut.setThid(resultSet.getString("thid")); ut.setThusername(resultSet.getString("thusername")); ut.setThname(resultSet.getString("thname")); ut.setThtime(resultSet.getString("thtime")); ut.setThno(resultSet.getString("thno") + " " + resultSet.getString("thesisname"));// 把等级幻化成等级名 thesisArray.add(ut); } } } else { String propertys[] = { "thid", "thname", "thusername", "thtime", "thno" }; for (String property : propertys) { String sql = "select distinct *from thesis,user_thesis where thesis.thesisno=user_thesis.thno and user_thesis." + property + " like '%" + input + "%'"; if ((resultSet = statement.executeQuery(sql)) != null) { while (resultSet.next()) { user_thesis ut = new user_thesis(); ut.setThid(resultSet.getString("thid")); ut.setThusername(resultSet.getString("thusername")); ut.setThname(resultSet.getString("thname")); ut.setThtime(resultSet.getString("thtime")); ut.setThno(resultSet.getString("thno") + " " + resultSet.getString("thesisname"));// 把等级幻化成等级名 thesisArray.add(ut); } } } } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } link_db.close_db(connection); return thesisArray; } // 根据某个论文去更新该论文的信息 public boolean updateThesis(user_thesis uThesis) { boolean flag = false; Connection connection = link_db.getcon(); String sql = "update user_thesis set thname=?,thusername=?,thtime=?,thno=? where thid=?"; try { PreparedStatement preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, uThesis.getThname()); preparedStatement.setString(2, uThesis.getThusername()); preparedStatement.setString(3, uThesis.getThtime()); String thno = ""; thno = uThesis.getThno().charAt(0) + ""; preparedStatement.setString(4, thno); preparedStatement.setString(5, uThesis.getThid()); if (preparedStatement.executeUpdate() > 0) { flag = true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } link_db.close_db(connection); return flag; } // 发现所有论文的信息 public static ArrayList<user_thesis> findAllThesis() { ArrayList<user_thesis> result = new ArrayList<>(); Connection connection = link_db.getcon(); String sql = "select *from user_thesis"; PreparedStatement preparedStatement; try { preparedStatement = connection.prepareStatement(sql); ResultSet resultSet = preparedStatement.executeQuery(); if (resultSet != null) { while (resultSet.next()) { user_thesis uThesis = new user_thesis(); uThesis.setThid(resultSet.getString(1)); uThesis.setThname(resultSet.getString(2)); uThesis.setThusername(resultSet.getString(3)); uThesis.setThtime(resultSet.getString(4)); uThesis.setThno(resultSet.getString(5)); result.add(uThesis); } } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } link_db.close_db(connection); return result; } // 根据thid删除论文 public static boolean delTheById(String thid) { boolean flag = false; Connection connection = link_db.getcon(); String sql = "delete from user_thesis where thid=?"; PreparedStatement preparedStatement; try { preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, thid); if (preparedStatement.executeUpdate() > 0) { flag = true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } link_db.close_db(connection); return flag; } // 根据thid 获得该论文 public static user_the