<%@page contentType="text/html; charset=utf8" import="java.util.*" %>
<%@ include file="20111019_DBSetup.jsp" %>
<% 
request.setCharacterEncoding("utf8");
if( request.getParameter("username") != null )
{
	// 檢查
	String query ;
	query = "select * from `account` where `username` = '"+request.getParameter("username")+"' and `password` = '"+request.getParameter("password")+"'";
	ResultSet res = stmt.executeQuery(query);
	if(res.next())
	{
		out.println("<h1 style=\"color:red\">帳號 "+request.getParameter("username")+" 登入成功</h1>");
		session.setAttribute("Login","OK");    // 設定 session
		response.sendRedirect("20111019_memberQuery.jsp");  // 轉換網頁。
	}
	else
	{
		out.println("<h1 style=\"color:red\">帳號或密碼錯誤</h1>");
	}
	res.close();
}
else
{
	String Login = (String)session.getAttribute("Login");
	if(Login != null && Login.equals("OK"))
	{
		out.println("<h1 style=\"color:red\">welcome.</h1>");
		response.setHeader("Refresh","1;url=20111019_memberQuery.jsp");  // 延遲五秒後轉向
	}
	else
	{%>
<html><head><title>memberAdd</title></head><body>
<form action="" method="post">
	帳號:<input type="text" name="username" value="taichunmin"/><br />
	密碼:<input type="password" name="password" value="1234" />
	<input type="submit" value="登入" />
</form>

</body></html>
	<%}
}
%>

 

<%@page contentType="text/html; charset=utf8" import="java.util.*" %>
<%@ include file="2011.10.19_DBSetup.jsp" %>
<html>
	<head><title>query</title></head>
	<body>
	<div><a href="20111019_memberAdd.jsp">新增使用者</a> <a href="20111019_memberLogin.jsp">使用者登入</a> <a href="20111019_memberLogout.jsp">使用者登出</a></div>
	<table width="100%" cellspacing="0" border="1">
	<%
		String query = "select * from `account` order by `username`";
		ResultSet res = stmt.executeQuery(query);
		while(res.next())
		{
			out.println("<tr>");
			String username = res.getString("username");
			out.println("<td>"+username+"</td>");
			out.println("<td>"+res.getString("password")+"</td>");
			out.println("<td><a href=\"20111019_memberUpdate.jsp?username=" + username + "\">修改</a></td>");
			out.println("<td><a href=\"20111019_memberDelete.jsp?username=" + username + "\">刪除</a></td>");
			out.println("</tr>");
		}
		res.close();
	%>
	</table>
	</body>
</html>

 

<%@page contentType="text/html; charset=utf8" import="java.util.*" %>
<%@ include file="20111019_DBSetup.jsp" %>
<% 
	session.setAttribute("Login",null);    // 設定 session
	response.sendRedirect("20111019_memberQuery.jsp");  // 轉換網頁。
%>

 

<%@page contentType="text/html; charset=utf8" import="java.util.*" %>
<%@ include file="20111019_DBSetup.jsp" %>
<% 
request.setCharacterEncoding("utf8");
if( request.getParameter("username") != null )
{
	if( request.getParameter("password") != null )
	{
		String query ;
		query = "select * from `account` where `username` = '"+request.getParameter("username")+"' and `password` = '"+request.getParameter("password")+"'";
		ResultSet res = stmt.executeQuery(query);
		if(res.next())
		{
			if(request.getParameter("password_n1")!=null && request.getParameter("password_n2")!=null && request.getParameter("password_n1").equals(request.getParameter("password_n2")))
			{
				query = "update `account` set `password` = ? where `username`=?";
				pstmt = conn.prepareStatement(query);
				pstmt.setString(1, request.getParameter("password_n1"));
				pstmt.setString(2, request.getParameter("username"));
				pstmt.executeUpdate();
				response.sendRedirect("20111019_memberQuery.jsp");  // 立即轉換網頁
			}
		}
		else
		{
			out.println("<h1 style=\"color:red\">帳號或密碼錯誤</h1>");
		}
		res.close();
	}
}
else
{
	out.println("<h1 style=\"color:red\">沒有 username = "+request.getParameter("username")+"</h1>");
	response.sendRedirect("20111019_memberQuery.jsp");  // 轉換網頁。
}
%>
<html><head><title>memberAdd</title></head><body>
<form action="" method="post">
	<input type="hidden" name="username" value="<%= request.getParameter("username") %>" />
	舊密碼:<input type="password" name="password" value="1234" />
	新密碼:<input type="password" name="password_n1" value="12345" />
	確認密碼:<input type="password" name="password_n2" value="12345" />
	<input type="submit" value="登入" />
</form>

</body></html>

 

<%@page contentType="text/html; charset=utf8" import="java.util.*" %>
<%@ include file="20111019_DBSetup.jsp" %>
<% 
request.setCharacterEncoding("utf8");
if( request.getParameter("username") != null )
{
	// 檢查
	String query ;
	query = "select * from `account` where `username` = '"+request.getParameter("username")+"'";
	ResultSet res = stmt.executeQuery(query);
	if(!(res.next()==true))
	{
		query = "insert into `account` (`username`,`password`) values (?,?)";
		pstmt = conn.prepareStatement(query);
		pstmt.setString(1, request.getParameter("username"));
		pstmt.setString(2, request.getParameter("password"));
		pstmt.executeUpdate();
		response.sendRedirect("20111019_memberQuery.jsp");  // 立即轉換網頁
	}
	else
	{
		out.println("<h1 style=\"color:red\">帳號 "+request.getParameter("username")+" 重複</h1>");
		response.setHeader("Refresh","5;url=20111019_memberQuery.jsp");  // 延遲五秒後轉向
	}
	res.close();
}
%>
<html><head><title>memberAdd</title></head><body>
<form action="" method="post">
	帳號:<input type="text" name="username" value="taichunmin"/><br />
	密碼:<input type="password" name="password" value="1234" />
	<input type="submit" value="Add" />
</form>

</body></html>

 

<%@page contentType="text/html; charset=utf8" import="java.util.*" %>
<%@ include file="20111019_DBSetup.jsp" %>
<% 
request.setCharacterEncoding("utf8");
if( request.getParameter("username") != null )
{
	String query;
	query = "delete from `account` where `username`=?";
	pstmt = conn.prepareStatement(query);
	pstmt.setString(1, request.getParameter("username"));
	pstmt.executeUpdate();
	response.sendRedirect("20111019_memberQuery.jsp");
}
%>
<html><head><title>memberAdd</title></head><body>
<form action="" method="post">
	帳號:<input type="text" name="username" value="taichunmin"/><br />
	<input type="submit" value="delete" />
</form>

</body></html>

 

<%@ page import="java.sql.*" %>
<%!
	Connection conn;
	PreparedStatement pstmt = null;
	Statement stmt = null;
%>
<%
	try{
		Class.forName("org.gjt.mm.mysql.Driver");
		String user="root",password="mis",dbName="db20111019";  // 在課堂上的設定
		//String user="jsp",password="mis",dbName="test";  // 在宿舍的設定
		String url="jdbc:mysql://localhost:3306/"+dbName+"?characterEncoding=utf8&useUnicode=true";
		conn = DriverManager.getConnection(url,user,password);
		stmt = conn.createStatement();
	}catch(SQLException sqle)
	{
		out.println("Sql Exception: "+sqle);
	}
%>
arrow
arrow
    全站熱搜

    和風信使 發表在 痞客邦 留言(0) 人氣()