【在线相册】--登入模块

tubaluer

浏览: 1456546 次

最近访客更多访客>>

anlinko

u012363178

sunddenly

tao8565

博主相关

博客

微博

相册

留言

关于我

文章分类

全部博客 (1987)

社区版块

存档分类

2012-01 ( 244)
2011-12 ( 185)
2011-11 ( 131)
更多存档...

UserLoginBean.java

package bean; import java.sql.*; public class UserLoginBean { private Connection con; private ResultSet rs; private Statement stmt; private static final String DRIVER_NAME= "oracle.jdbc.driver.OracleDriver"; private static final String URL_STR= "jdbc:oracle:thin:@127.0.0.1:1521:ORCL"; public UserLoginBean() { try{ Class.forName(DRIVER_NAME); con=DriverManager.getConnection(URL_STR,"ymc","ymc"); } catch (SQLException se) { se.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } } public boolean login(String userName, String passWord) { boolean b = false; try { stmt = con.createStatement(); String sql= "select user_pwd from userLogin where user_name='" + userName + "'"; rs=stmt.executeQuery(sql); while(rs.next()) { String pwd=rs.getString(1); if(pwd.equals(passWord)) { b = true; } } } catch (SQLException se) { se.printStackTrace(); b = false; } finally { this.close(con, rs, stmt); } return b; } public void close(Connection con, ResultSet rs, Statement stmt) { try{ if(null != con) { con.close(); } if(null != rs) { rs.close(); } if(null != stmt) { stmt.close(); } } catch(SQLException se) { se.printStackTrace(); } } }

UserLoginServlet.java

import java.io.*; import java.util.*; import javax.servlet.*; import javax.servlet.http.*; import bean.*; public class UserLoginServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { PrintWriter out = response.getWriter(); try { String userName = request.getParameter("userName").trim(); String passWord=request.getParameter("passWord").trim(); UserLoginBean ubl = new UserLoginBean(); boolean b = ubl.login(userName,passWord); if(b) { this.forward(request, response,"/loginOK.jsp"); } else { this.forward(request, response,"/loginFail.jsp"); } } catch (Exception e) { out.println("Login Fail.<br>"); out.println(e.toString()); } } private void forward(HttpServletRequest request, HttpServletResponse response, String url) throws ServletException, IOException { RequestDispatcher rd = request.getRequestDispatcher(url); rd.forward(request,response); } }

index.jsp

<%@ page contentType="text/html; charset=GBK"%> <html> <head> <title>JSP+Servlet+JavaBean Case--Login</title> </head> <body> <br><br><br> <center> <font size="5" color="#FF0000"> <b>JSP+Servlet+JavaBean Case--Login</b> </font> <br><hr></hr><br><br> <form name="loginForm" method="post" action="UserLoginServlet"> <table border="0" align="center" cellpadding="2" cellspacing="2" bgcolor="snow"> <tr> <td><div align="center">User:</div></td> <td><div align="center"><input type="text" name="userName" size="20" maxlength="10"></div></td> </tr> <tr> <td><div align="center">PassWord:</div></td> <td><div align="center"><input type="password" name="passWord" size="20" maxlength="10"></div></td> </tr> <tr width="100%"> <td> <div align="center"><input type="submit" value="Login"> <input type ="reset" value ="reset"></div> </td> </tr> </table> </form> </center> </body> </html>

loginOK.jsp

<%@ page contentType="text/html; charset=GBK"%> <html> <head> <title>Login OK</title> </head> <body> <br><br><br> <center> <font size="5" color="#FF0000"> <b>JSP+Servlet+JavaBean</b> </font> <br><hr></hr><br><br> <font color="red" size = "4">Login OK!</font> </center> </body> </html>

loginFail.jsp

<%@ page contentType="text/html; charset=GBK"%> <html> <head> <title>Login Fail</title> </head> <body> <br><br><br> <center> <font size="5" color="#FF0000"> <b>JSP+Servlet+JavaBean</b> </font> <br><hr></hr><br><br> <font color="red" size = "4">Login Fail!</font> </center> </body> </html>

web.xml

<?xml version="1.0" encoding="ISO-8859-1"?> <web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" version="2.4">  <servlet> <servlet-name>UserLoginServlet</servlet-name> <servlet-class>UserLoginServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>UserLoginServlet</servlet-name> <url-pattern>/UserLoginServlet</url-pattern> </servlet-mapping>  <welcome-file-list> <welcome-file> index.jsp </welcome-file> </welcome-file-list> </web-app>

分享到：