JSP第12次作业

package week12;

public class EmailEntity {
	public String sender;
	public String receiver;
	public String title;
	public String content;
	public String status;
	
	public EmailEntity() {
		sender = new String("");
		receiver = new String("");
		title = new String("");
	    content = new String("");
		status = new String("");
	}
	
	public String getHtml()
	{
		String _str;
		_str = new String("<td>\n" + sender + "</td>\n" + 
				"<td>\n" + receiver + "</td>\n" + 
				"<td>\n" + title + "</td>\n" + 
				"<td>\n" + content + "</td>\n" + 
				"<td>\n" + status + "</td>\n");
		
		return _str;
	}
}

package week12;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

public class UserDao {
	public static Connection CreateConnection()
	{
		Connection conn = null;
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/week12", "root", "1234567");
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
		}
		return conn;
	}
	
	public static void closeConn(Connection conn)
	{
		try
		{
			conn.close();
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}
	
	public static void register(String name, String password, int age)
	{
		
		Connection conn = null;

		try
		{
			conn = CreateConnection();
			java.sql.Statement sqlStatement = conn.createStatement();
			String sqlQuery = "INSERT INTO `user_table` SET `name`='" + name + "',`password`='" + password + "',`age`=" + age + ";";
			sqlStatement.executeQuery(sqlQuery);
		}
		catch (java.sql.SQLException throwables)
		{
			throwables.printStackTrace();
		}
		finally
		{
			if (conn != null)
			{
				closeConn(conn);	
			}
		}
	}
	
	public static boolean login(String name, String password)
	{
		
		Connection conn = null;
		
		
		
		
		int count = 0;
		
		try
		{
			conn = CreateConnection();
			java.sql.Statement sqlStatement = conn.createStatement();
			String sqlQuery = "select count(*) from user_table where name = '"+ name +"', password = '" + password + "';";
			ResultSet rs = sqlStatement.executeQuery(sqlQuery);
			while (rs.next() != false)
			{
				count = rs.getInt(1);
			}			
		}
		catch (java.sql.SQLException throwables)
		{
			throwables.printStackTrace();
		}
		finally
		{
			if (conn != null)
			{
				closeConn(conn);	
			}
		}
		return (count > 0);
	}
	public static ArrayList<EmailEntity> getEmail() {
		Connection conn = null;
		
		ArrayList<EmailEntity> emailEntities = new ArrayList<EmailEntity>();
		
		
		

		try
		{
			conn = CreateConnection();
			java.sql.Statement sqlStatement = conn.createStatement();
			String sqlQuery = "select sender, receiver, title, content, status from email;";
			ResultSet rs = sqlStatement.executeQuery(sqlQuery);
			while (rs.next() != false)
			{
				EmailEntity email = new EmailEntity();
				email.sender = rs.getString(0);
				email.receiver = rs.getString(1);
				email.title = rs.getString(2);
				email.content = rs.getString(3);
				email.status = rs.getString(4);
				emailEntities.add(email);
			}
		}
		catch (java.sql.SQLException throwables)
		{
			throwables.printStackTrace();
		}
		finally
		{
			if (conn != null)
			{
				closeConn(conn);	
			}
		}
//		EmailEntity email = new EmailEntity();
//		email.sender = "张三";
//		email.receiver = "user";
//		email.title = "测试";
//		email.content = "测试内容啦啦啦";
//		email.status = "未读";
//		emailEntities.add(email);
//		
//		EmailEntity email2 = new EmailEntity();
//		email2.sender = "aa";
//		email2.receiver = "user";
//		email2.title = "测试2";
//		email2.content = "测试2";
//		email2.status = "已读";
//		emailEntities.add(email2);
		
		return emailEntities;
		
	}
	
	void deleteEmail(int id)
	{
		Connection conn = null;
		try
		{
			conn = CreateConnection();
			java.sql.Statement sqlStatement = conn.createStatement();
			String sqlQuery = "delete from email where id = '" + id + "'";
			sqlStatement.executeQuery(sqlQuery);
		}
		catch (java.sql.SQLException throwables)
		{
			throwables.printStackTrace();
		}
		finally
		{
			if (conn != null)
			{
				closeConn(conn);	
			}
		}
	}
	
	void replyEmail(String sender, String receiver, String title, String content)
	{
		Connection conn = null;
		try
		{
			conn = CreateConnection();
			java.sql.Statement sqlStatement = conn.createStatement();
			String sqlQuery = "insert into email (sender, receiver, title, content, status) values(?, ?, ?, ?, ?);";
			PreparedStatement ps = null;
			try
			{
				ps = conn.prepareStatement(sqlQuery);
				ps.setString(1, sender);
				ps.setString(2, receiver);
				ps.setString(3, title);
				ps.setString(4, content);
				ps.setString(5, "未读");
				ps.executeUpdate();
			}
			catch (SQLException e)
			{
				e.printStackTrace();
			}
			finally
			{
			}
		}
		catch (java.sql.SQLException throwables)
		{
			throwables.printStackTrace();
		}
		finally
		{
			if (conn != null)
			{
				closeConn(conn);	
			}
		}
	}
	static public EmailEntity getReply(int id)
	{
		Connection conn = null;
		
		EmailEntity email = null;
		
		try
		
		{
			conn = CreateConnection();
			java.sql.Statement sqlStatement = conn.createStatement();
			String sqlQuery = "select sender, receiver, title, content, status from email;";
			ResultSet rs = sqlStatement.executeQuery(sqlQuery);
			while (rs.next() != false)
			{
				email.sender = rs.getString(0);
				email.receiver = rs.getString(1);
				email.title = rs.getString(2);
				email.content = rs.getString(3);
				email.status = rs.getString(4);
			}
		}
		catch (java.sql.SQLException throwables)
		{
			throwables.printStackTrace();
		}
		finally
		{
			if (conn != null)
			{
				closeConn(conn);	
			}
		}
		return email;
	}
}

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
    
<%@ page import="week12.UserDao" %>
<%@ page import="week12.EmailEntity" %>

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Detail</title>
</head>
<body>
	<table border = "1">
		<tr>
			<th>发件人</th>
			<th>主题</th>
			<th>状态</th>
			<th>时间</th>
		</tr>
		<tr>
			<td>张三</td>
			<td>测试</td>
			<td>已读</td>
			<td>2022-5-22</td>
		</tr>
	</table>
	<p>
	<%= UserDao.getReply(1); %>
	</p>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@ page import="week11.UserDao" %>
<%@ page import="week11.EmailEntity" %>
<%@ page import="java.util.ArrayList" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Email</title>
</head>
<body>
	<p>
	你好
	<%
		session.setAttribute("username", new String("user"));
		out.println(session.getAttribute("username").toString());
	%>
	</p>
	<table border = "1">
		<tr>
			<th>发件人</th>
			<th>主题</th>
			<th>内容</th>
			<th>状态</th>
			<th>时间</th>
			<th></th>
		</tr>
		<%
			request.setCharacterEncoding("utf-8");
			ArrayList<EmailEntity> emailEntities = UserDao.getEmail();
			for (int n = 0; n < emailEntities.size(); n++)
			{
				out.println("<tr>");
				out.println(emailEntities.get(n).getHtml());
				out.println("</tr>");
			}
		%>
	</table>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>

<%@ page import="week11.UserDao" %>
<!DOCTYPE html>
<html>
<head>

<title>Login Process</title>
</head>
<body>
<%
	request.setCharacterEncoding("utf-8");
	String username = request.getParameter("username");
	String password = request.getParameter("password");
	if (UserDao.login(username, password))
	{
		out.println("<h1>登录成功</h1>");
		session.setAttribute("username", username);
	}
	else
	{
		out.println("<h1>登录失败</h1>");
	}
%>


</body>

</html>

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Login</title>
<script>
function verify() {
	let user = document.getElementById("username").value;
	let password = document.getElementById("password").value;
	if (user == '' || password == '') {
		alert("用户名与密码不能为空.");
		return;
	}
	loginForm.submit();
}
</script>
</head>
<body>
<form action="login_process.jsp" method="POST" name="loginForm">
用户名: <input type="text" id="username" name="username"><br/>
密码: <input type="password" id="password" name="password"><br/>
<input type="button" name="submitButton" value="提交" onclick="verify()">
<a href="register.jsp">register page</a>
</form>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
    
<%@ page import="week11.UserDao" %>
<!DOCTYPE html>
<html>
<head>

<title>Register Process</title>
</head>
<body>
<%
	request.setCharacterEncoding("utf-8");
	String username = request.getParameter("username");
	String password = request.getParameter("password");
	String age = request.getParameter("age");
	
	UserDao.register(username, password, Integer.parseInt(age));
	out.println("<h1>注册成功</h1>");
%>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
    
<%@ page import="week12.UserDao" %>
<%@ page import="week12.EmailEntity" %>

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Detail</title>
</head>
<body>
	<table border = "1">
		<tr>
			<th>发件人</th>
			<th>主题</th>
			<th>状态</th>
			<th>时间</th>
		</tr>
		<tr>
			<td>张三</td>
			<td>测试</td>
			<td>已读</td>
			<td>2022-5-22</td>
		</tr>
	</table>
	<p>
	<%= UserDao.getReply(1); %>
	</p>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Register</title>
<script>
function verify() {
	let user = document.getElementById("username").value;
	let password = document.getElementById("password").value;
	if (user == '' || password == '') {
		alert("用户名与密码不能为空.");
		return;
	}
	loginForm.submit();
}
</script>
</head>
<body>
<form action="register_process.jsp" method="POST" name="loginForm">
用户名: <input type="text" id="username" name="username"><br/>
密码: <input type="password" id="password" name="password"><br/>
<input type="button" name="submitButton" value="提交" onclick="verify()">
<a href="login.jsp">login page</a>
</form>
</body>
</html>