基于Java web的校园失物招领系统（源码+数据库）.rar

package DBJavaBean; import java.sql.*; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Calendar; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpSession; import javax.swing.JOptionPane; import org.apache.struts2.interceptor.ServletRequestAware; import JavaBean.GongGaoBean; import JavaBean.MyMessBean; import JavaBean.PingLunBean; import JavaBean.ShiWuLiuYanBean; import JavaBean.UserNameBean; import JavaBean.WuPinBean; import JavaBean.ZhaoHuiBean; //实现ServletRequestAware 通过IoC方式直接访问Servlet，并通过 request获取 session对象 public class DB implements ServletRequestAware { private String driverName = "com.mysql.jdbc.Driver"; private String url = "jdbc:mysql://localhost:3306/bysj?useUnicode=true&characterEncoding=gbk"; private String user = "root"; private String password = "123456"; private Connection con = null; private Statement st = null; private ResultSet rs = null; private HttpServletRequest request; public DB() { } public String getDriverName() { return driverName; } public void setDriverName(String driverName) { this.driverName = driverName; } public String getUrl() { return url; } public void setUrl(String url) { this.url = url; } public String getUser() { return user; } public void setUser(String user) { this.user = user; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public void setServletRequest(HttpServletRequest hsr) { request = hsr; } // 1、查询个人信息，并返回 rs public ResultSet selectMess(HttpServletRequest request, String userName) { try { String sql = "select * from user where userName='" + userName + "'"; st = getStatement(); return st.executeQuery(sql); } catch (Exception e) { e.printStackTrace(); return null; } } // 2、完成连接数据库操作，并生成容器返回 public Statement getStatement() { try { Class.forName(getDriverName()); con = DriverManager.getConnection(getUrl(), getUser(), getPassword()); return con.createStatement(); } catch (Exception e) { e.printStackTrace(); return null; } } // 3、 /* * 调用myLogin、myMessage、myFriends、myDayTime、myFile方法，把所有的和用户有关的信息全部保存到session对象中 * ,该方法，登录成功后调用 */ public String addList(HttpServletRequest request, String userName) { String sure = null; String login = myLogin(request, userName); String fbxx = myFile(request, userName); String fabu = faBu(request, userName); String mess = myMessage(request, userName); // // String pingLun =pingLunXinXi(request,userName); // String qbxx=quanBuFaBu(request, userName); // String fri=myFriends(request,userName); // String day=myDayTime(request,userName); // String file=myFile(request,userName); // if(login.equals("ok")&&mess.equals("ok")&&fri.equals("ok")&&day.equals("ok")&&file.equals("ok")){ // sure="ok"; // }else{ // sure=null; // } if (login.equals("ok") && mess.equals("ok") && fabu.equals("ok") && fbxx.equals("ok")) { sure = "ok"; } else { sure = null; } return sure; } // /找回密码。。。 public String addList2(HttpServletRequest request, String userName) { String sure = null; // String login=myLogin(request,userName); String zhao = myZhao(request, userName); if (zhao.equals("ok")) { sure = "ok"; } else { sure = null; } return sure; } // 4、把登录人的信息保存到session对象中 public String myLogin(HttpServletRequest request, String userName) { try { ArrayList listName = null; HttpSession session = request.getSession(); listName = new ArrayList(); rs = selectMess(request, userName); if (rs.next()) { rs = selectMess(request, userName); while (rs.next()) { UserNameBean mess = new UserNameBean(); mess.setUserName(rs.getString("userName")); mess.setPassword(rs.getString("password")); mess.setJueSe(rs.getString("juese")); listName.add(mess); session.setAttribute("userName", listName); // session.setAttribute("user", rs.getString("userName"));// // 保存登录名 } } else { session.setAttribute("userName", listName); } return "ok"; } catch (Exception e) { e.printStackTrace(); return null; } } // 4-2、把找回密码的信息保存到session对象中 public String myZhao(HttpServletRequest request, String userName) { try { ArrayList listName2 = null; HttpSession session = request.getSession(); listName2 = new ArrayList(); rs = selectMess(request, userName); if (rs.next()) { rs = selectMess(request, userName); while (rs.next()) { ZhaoHuiBean mess = new ZhaoHuiBean(); mess.setUserName(rs.getString("userName")); mess.setWenti(rs.getString("wenti")); mess.setDaan(rs.getString("daan")); listName2.add(mess); session.setAttribute("userName", listName2); } } else { session.setAttribute("userName", listName2); } return "ok"; } catch (Exception e) { e.printStackTrace(); return null; } } // 4-3重设密码保存信息到session // public String ChongShe(HttpServletRequest request, String userName) { // try { // // ArrayList listName3 = null; // HttpSession session = request.getSession(); // listName3 = new ArrayList(); // rs = selectMess(request, userName); // if (rs.next()) { // rs = selectMess(request, userName); // while (rs.next()) { // ChongSheBean mess = new ChongSheBean(); // mess.setUserName(rs.getString("userName")); // mess.setPassword(rs.getString("password")); // listName3.add(mess); // session.setAttribute("userName", listName3); // } // } else { // session.setAttribute("userName", listName3); // } // return "ok"; // } catch (Exception e) { // e.printStackTrace(); // return null; // } // } // 5、查询登录名，密码是否存在 public ResultSet selectLogin(HttpServletRequest request, String userName, String password) { try { String sql = "select * from user where userName='" + userName + "' and password='" + password + "'"; st = getStatement(); return st.executeQuery(sql); } catch (Exception e) { e.printStackTrace(); return null; } } // 5-2 public ResultSet selectLogin2(HttpServletRequest request, String userName, String daan) { try { String sql = "select * from user where userName='" + userName + "' and daan='" + daan + "' "; st = getStatement(); return st.executeQuery(sql); } catch (Exception e) { e.printStackTrace(); return null; } } // 5-3 public ResultSet selectLogin3(HttpServletRequest request, String userName, String wenti) { try { String sql = "select * from user where userName='" + userName + "' and wenti='" + wenti + "' "; st = getStatement(); return st.executeQuery(sql); } catch (Exception e) { e.printStackTrace(); return null; } } // 重新设置密码 // 修改用户密码 public String updatePass(HttpServletRequest request, String userName, String password) { try { String sure = null; String sql = "update user set password='" + password + "' where userName='" + userName + "'"; st = getStatement(); int row = st.executeUpdate(sql); if (row == 1) { // String mess=ChongShe(request,userName); String mess = myLogin(request, userName); if (mess.equals("ok")) { sure = "ok"; } else { sure = null; } } else { sure = null; } return sure; } catch (Exception e) { e.printStackTrace(); return null; } } //