JSP 登录页面

1. index.jsp来提交请求

2. login.jsp来检查数据库数据

3. 需要注意的是，下载下来的mysql.conection jar包需要放到WEB-INF下面的lib文件夹下

jsp projectWEB-INFlibmysql-connector-java-5.1.25-bin.jar

 1 <%@ page contentType="text/html" pageEncoding="utf-8"%>
 2 <html>
 3     <head>
 4         <title>
 5             login page
 6         </title>
 7     </head>
 8 
 9     <body>
10         <center>
11             <h1>
12                 登录页面
13             </h1>
14             </br>
15             </br>
16             <form action="jsp/login.jsp" method="post">
17                 <table id="loginTable">
18                     <tr>
19                         <tb>用户名:</tb>
20                         <tb><input type="text" name="name"/><br></tb>
21                     </tr>
22                     <tr>
23                         <tb>密码：</tb>
24                         <tb><input type="password" name="passwd"/><br></tb>
25                     </tr>
26                     <tr>
27                         <tb><input type="submit"></tb>
28                         <tb><input type="reset"></tb>
29                     </tr>
30                 </table>
31             </form>
32         </center>
33     </body>
34 
35 </html>

 1 <%@ page contentType="text/html" pageEncoding="utf-8"%>
 2 <%@ page language="java"%>
 3 <%@ page import="com.mysql.jdbc.Driver" %>
 4 <%@ page import="java.sql.*" %>
 5 <html>
 6     <head>
 7         <title>
 8             check page
 9         </title>
10     </head>
11 
12     <body>
13         <%
14             String driverName="com.mysql.jdbc.Driver";
15             String userName="root";
16             String userPasswd="huawei";
17             String url="jdbc:mysql://localhost:3306/connect";
18             String result="false";
19             PreparedStatement statement = null;
20             Class.forName("com.mysql.jdbc.Driver").newInstance();
21             Connection connection=DriverManager.getConnection(url,userName,userPasswd);
22             ResultSet resultSet = null;
23             String loginName=request.getParameter("name");
24             String password=request.getParameter("passwd");
25             String tip = "";
26             if(connection != null)
27             {    
28                 statement= connection.prepareStatement("select passwd from userinfo where username='"+loginName+"'");
29                 resultSet = statement.executeQuery();
30                 tip = loginName + " login failed.";
31                 if(resultSet.next())
32                 {
33                     result=resultSet.getString(1);
34                     if(result.equals(password))
35                     {
36                         tip = loginName + " login successfully.";
37                     }
38                 }
39             }else
40             {
41                 tip = "Data base connection failed.";
42             }
43         %>
44 
45         <%=tip%>
46     </body>
47 
48 </html>