index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>登录界面</title>
</head>
<body>
<div>
<img alt="未知原因" src="img/background.jpg" width="100%" height="350">
</div>
<center>
<div>
<form action="dologin.jsp" method="post">
<font size="5">用户名:<input type="text" name="username">
</font><br> <font size="5"> 密码:<input type="text"
name="password">
</font><br> <input type="submit" name="login" value="登录">
</form>
<form action="registered1.jsp" method="post">
<input type="submit" name="registered" value="注册">
</form>
</div>
</center>
</body>
</html>
dologin.jsp
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.*"%>
<%@page import="javax.servlet.jsp.tagext.TryCatchFinally"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>登录界面</title>
</head>
<body>
<div>
<img alt="未知原因" src="img/background.jpg" width="100%" height="350">
</div>
<%!String URL = "jdbc:mysql://127.0.01:3306/t1?useUnicode=true&characterEncoding=utf-8&useSSL=false";
String USER = "root";
String PASSWORD = "jinfeng123";%>
<%
Connection conn = null;
String sql = "";
PreparedStatement ps = null;
ResultSet rs;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(URL, USER, PASSWORD);
System.out.println("数据库连接成功!");
} catch (Exception e) {
System.out.println("数据库连接失败!");
}
String username = request.getParameter("username");
String password = request.getParameter("password");
sql = " select * from user where username = ? ";
ps = conn.prepareStatement(sql);
ps.setString(1, username);
rs = ps.executeQuery();
if(rs.next()){
if((rs.getString("password")).equals(password)){
request.getRequestDispatcher("succeed.jsp").forward(request, response);
}
else{
session.setAttribute("why", "密码错误");
response.sendRedirect("failure.jsp");
}
}
else{
session.setAttribute("why", "该帐号不存在");
response.sendRedirect("failure.jsp");
}
rs.close();
ps.close();
conn.close();
%>
</body>
</html>
succeed.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>登录成功</title>
</head>
<body>
<div>
<img alt="未知原因" src="img/background.jpg" width="100%" height="350">
</div>
<center>
<h1>登录成功</h1>
<table>
<tr>
<td><img alt="" src="img/12.jpg" width="100" height="100"></td>
<td><img alt="" src="img/12.jpg" width="100" height="100"></td>
<td><img alt="" src="img/12.jpg" width="100" height="100"></td>
</tr>
<tr>
<td><img alt="" src="img/12.jpg" width="100" height="100"></td>
<td><img alt="" src="img/12.jpg" width="100" height="100"></td>
<td><img alt="" src="img/12.jpg" width="100" height="100"></td>
</tr>
<tr>
<td><img alt="" src="img/12.jpg" width="100" height="100"></td>
<td><img alt="" src="img/12.jpg" width="100" height="100"></td>
<td><img alt="" src="img/12.jpg" width="100" height="100"></td>
</tr>
</table>
</center>
</body>
</html>
failure.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>登录失败</title>
</head>
<body>
<div>
<img alt="未知原因" src="img/background.jpg" width="100%" height="350">
</div>
<center>
<h1>登录失败</h1>
<hr>
原因:<%
out.print(session.getAttribute("why"));
%>
<a href="login.jsp">返回</a>
</center>
</body>
</html>
registered1.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>注册界面1</title>
</head>
<body>
<div>
<img alt="未知原因" src="img/background.jpg" width="100%" height="350">
</div>
<center>
<div>
<form action="registered.jsp" method="post">
<font size="5">用户名:<input type="text" name="username">
</font><br> <font size="5"> 密码:<input type="text"
name="password">
</font><br> <input type="submit" name="login" value="提交">
</form>
</div>
</center>
</body>
</html>
registered.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>注册界面2</title>
</head>
<body>
<div>
<img alt="未知原因" src="img/background.jpg" width="100%" height="350">
</div>
<%!String URL = "jdbc:mysql://127.0.01:3306/t1?useUnicode=true&characterEncoding=utf-8&useSSL=false";
String USER = "root";
String PASSWORD = "jinfeng123";
String str="";
%>
<%
Connection conn = null;
String sql = ""+" insert into user (username,password) "
+" values(?,?) ";
PreparedStatement ps = null;
String username = request.getParameter("username");
String password = request.getParameter("password");
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(URL, USER, PASSWORD);
System.out.println("数据库连接成功!");
ps=conn.prepareStatement(sql);
ps.setString(1, username);
ps.setString(2, password);
ps.execute();
str="注册成功";
} catch (Exception e) {
System.out.println("数据库连接失败!");
str="注册失败";
}
ps.close();
conn.close();
%>
<center>
<h1><%=str %></h1>
<a href="login.jsp">返回</a>
</center>
</body>
</html>