本示例用到了上篇<Java实现MD5加密>中的文件MD5.java
login.jsp
- <%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>
- <html>
- <head>
- <base>
- <title>登陆页面</title>
- </head>
- <body>
- <form name="" method="post" action="md5.jsp">
- <table>
- <tr>
- <td>
- 用户名:
- </td>
- <td>
- <input type="text" name="username" size="15">
- </td>
- </tr>
- <tr>
- <td>
- 密码:
- </td>
- <td>
- <input type="password" name="password" size="15">
- <td>
- </tr>
- <tr>
- <td>
- <input type="submit" name="Submit" value="登陆">
- </td>
- </tr>
- </table>
- </form>
- </body>
- </html>
- md5.jsp
- <%@ page language='java' contentType="text/html; charset=gb18030"%>
- <jsp:directive.page import="java.io.PrintWriter"/>
- <jsp:useBean id='oMD5' scope='request' class='mybean.MD5' />
- <%@ page import='java.sql.*'%>
- <html>
- <body>
- <%
- String username = request.getParameter("username"); //获取用户输入username
- String password = request.getParameter("password"); //获取用户输入的password
- String pwdmd5 = oMD5.getMD5ofStr(password); //计算MD5的值
- PrintWriter rp = response.getWriter();
- Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
- Connection con = DriverManager.getConnection ("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=myhibernate", "sa", "sa");
- //myhibernate是我的数据库的名称,数据库的用户名和密码都为sa
- Statement stmt = con.createStatement();
- ResultSet rs = stmt.executeQuery("select * from login where username ='"
- + username + "' and password= '" + pwdmd5 + "'");
- if (rs.next()) {
- response.getWriter().append("<script>window.alert('登陆成功!');</script>");
- rp.print("Login OK");
- } else {
- response.getWriter().append("<script>window.alert('登陆失败!');</script>");//怎么没用阿???
- response.sendRedirect("login.jsp");
- }
- stmt.close();
- con.close();
- %>
- </body>
- </html>
转载于:https://blog.51cto.com/huqianhao/953853