Java web的爱心宠物诊所系统（源码+数据库）.zip

package login; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import javax.swing.JOptionPane; public class LoginServlet extends HttpServlet { private static final long serialVersionUID = 1L; public void wrong1() { String msg = "用户名不能为空"; int type = JOptionPane.YES_NO_CANCEL_OPTION; String title = "信息提示"; JOptionPane.showMessageDialog(null, msg, title, type); } public void wrong2() { String msg = "密码不能为空"; int type = JOptionPane.YES_NO_CANCEL_OPTION; String title = "信息提示"; JOptionPane.showMessageDialog(null, msg, title, type); } public void wrong3() { String msg = "用户名错误"; int type = JOptionPane.YES_NO_CANCEL_OPTION; String title = "信息提示"; JOptionPane.showMessageDialog(null, msg, title, type); } public void wrong4() { String msg = "密码错误"; int type = JOptionPane.YES_NO_CANCEL_OPTION; String title = "信息提示"; JOptionPane.showMessageDialog(null, msg, title, type); } public LoginServlet() { super(); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String emp_name = new String(request.getParameter("emp_name").getBytes("ISO-8859-1"), "UTF-8"); String emp_pwd = new String(request.getParameter("emp_pwd").getBytes("ISO-8859-1"), "UTF-8"); if (emp_name.equals("")) { wrong1(); response.sendRedirect("http://localhost:8080/DayByDay/login/botton.jsp"); } else if (emp_pwd.equals("")) { wrong2(); response.sendRedirect("http://localhost:8080/DayByDay/login/botton.jsp"); } else { Connection conn = null; Statement sta = null; ResultSet rs = null; try { Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/Ada?useUnicode=true&characterEncoding=UTF-8"; conn = DriverManager.getConnection(url, "root", "admin"); sta = conn.createStatement(); String sql = "select*from employee where name='" + emp_name + "'"; rs = sta.executeQuery(sql); int N = 0; int P = 0; while (rs.next()) { if (emp_name.equals(rs.getString("name"))) { N = 1001; } if (emp_pwd.equals(rs.getString("password"))) { P = 1001; LoginBean lb = new LoginBean(); lb.setUserName(emp_name); lb.setPassword(emp_pwd); HttpSession session = request.getSession(); ArrayList login = new ArrayList(); login.add(lb); session.setAttribute("login", login); response.sendRedirect("http://localhost:8080/DayByDay/main/main.jsp"); } else { N++; } } if (N < 1001) { wrong3(); response.sendRedirect("http://localhost:8080/DayByDay/login/botton.jsp"); } else if (P < 1001) { wrong4(); response.sendRedirect("http://localhost:8080/DayByDay/login/botton.jsp"); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { try { if (rs != null) { rs.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { if (sta != null) { sta.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { if (conn != null) { conn.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } // response.sendRedirect("http://localhost:8080/DayByDay/main/NewPet.jsp"); } } } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse * response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }