login.jsp
<!DOCTYPE html>
<html>
<head>
<title>登录</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div>
<form action="loginServlet.do" method="post">
<table>
<tr>
<td><label for="user">用户名:</label></td>
<td><input type="text" id="user" name="user"></td>
</tr>
<tr>
<td><label for="password">密码:</label></td>
<td><input type="password" id="passwd" name="passwd"></td>
</tr>
<tr>
<input type="submit" name="submit" value="登录"></td>
</tr>
</table>
</form>
</div>
</body>
</html>
loginServlet.java
package login;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/loginServlet.do")
public class LoginServlet extends HttpServlet {
Login L = null;
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
// TODO Auto-generated method stub
//super.doPost(req, resp);
try {
L = new Login();
} catch (Exception e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
resp.setContentType("text/html;charset=utf-8");
req.setCharacterEncoding("utf-8");
String action = req.getParameter("action");
PrintWriter out = resp.getWriter();
String name = req.getParameter("user");
String password = req.getParameter("passwd");
try {
boolean flag = L.LoginCorrect(name, password);
if (flag) {
out.println("<h1>登陆成功</h1>");
}else {
out.println("<!DOCTYPE html>");
out.println("<html>");
out.println("<head>");
out.println("<meta charset=\"utf-8\">");
out.println("<title>登录失败</title>");
out.println("</head>");
out.println("<body>");
out.println("<h1>登录失败");
out.println("<a href=\"login.jsp\">回首页登录");
out.println("</body>");
out.println("</html>");
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("name:"+name);
System.out.println("password:"+password);
}
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
// TODO Auto-generated method stub
super.doGet(req, resp);
}
}
login.java
package login;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Login {
private Connection conn = null;
private Statement statement = null;
public Login() throws Exception {
conn = getConnection();
statement = conn.createStatement();
}
// 查看登录用户名和密码是否正确
public boolean LoginCorrect(String name, String password) throws Exception {
String sql = "select * from login where loginName = '"+name + "' and pwd = '"+password+"";
ResultSet rs = statement.executeQuery(sql);
// 查看是否合法
while (rs.next()) {
if (name.equals(rs.getString("loginName"))
&& password.equals(rs.getString("pwd")))
{
System.out.println("登录成功");
return true;
}
}
rs.close();
return false;
}
private Connection getConnection() throws Exception {
String driverClass = "com.mysql.jdbc.Driver";
String url ="jdbc:mysql://localhost:3306/login" ;
String user = "root";
String password = "";
// 注册加载驱动
Class.forName(driverClass);
// 获取连接
Connection conn = DriverManager.getConnection(url, user, password);
System.out.println(conn);
return conn;
}
}
数据库文件: