📄 register.java
字号:
/******************************************************************************************************************
IT03July Java Assignment
Message Board!
Created by Jason(632)
This program using JDBC to record user detail and using HTTP session to remember user infomations from HTML pages.
******************************************************************************************************************/
package myelf;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
import java.util.*;
import java.text.*;
public class register extends HttpServlet
{
public void doPost (HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
String url = "jdbc:hsqldb:" + getServletContext().getRealPath("/db/myDB");
Statement statement;
ResultSet resultSet;
Connection connection;
DateFormat df = DateFormat.getDateInstance(DateFormat.SHORT);
String date = (df.format(new java.util.Date())).toString();//get the crruent date
String username = request.getParameter ("user");
String password = request.getParameter ("pass1");
String email = request.getParameter ("email");
HttpSession session;
session = request.getSession();
try
{
Class.forName ("org.hsqldb.jdbcDriver");
connection = DriverManager.getConnection (url,"sa", "");
}
catch (ClassNotFoundException cnfex)
{
ErrorMessage (response, "Failed to load JDBC/ODBC driver.");
return;
}
catch (SQLException sqlex)
{
ErrorMessage (response, "Unable to connect to database.");
return;
}
try
{
statement = connection.createStatement ();
statement.executeUpdate ("INSERT INTO User Values ('" + username + "','" + password + "','" + email + "', Now());");//insert user into database
statement.close ();
display(response,username,password,email,date);
session.putValue("username", username);
}
catch (SQLException sqlex)
{
ErrorMessage ( response, "Your username arleady taked, Please change another username !" );
return;
}
try
{
connection.close ();
}
catch (SQLException sqlex)
{
}
}
public void ErrorMessage (HttpServletResponse response,String message)
throws ServletException, IOException
{
PrintWriter output;//Start to write HTML files in java
response.setContentType ("text/html");
output = response.getWriter ();
output.println ("<HTML><HEAD><TITLE>Error</TITLE></HEAD><BODY>");
output.println ("<H1>" + message + "</H1></BODY></HTML>");
output.println("<a href = javascript:history.back()>BACK</a>");
output.close ();
}
private void display (HttpServletResponse response,String user,String pass,String email,String date)
throws ServletException, IOException
{
PrintWriter output;//Start to write HTML files in java
response.setContentType ("text/html");
output = response.getWriter ();
output.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"http://www.w3.org/TR/html4/loose.dtd\">");
output.println("<html>");
output.println("<head>");
output.println("<meta http-equiv=\"Content-Type\" content=\"text/html\"; charset=\"gb2312\">");
output.println("<title>Successful Register</title>");
output.println("<style type=\"text/css\">");
output.println("<!--");
output.println("body {");
output.println("background-color: #66CCFF;");
output.println("margin-left: 10px;");
output.println("margin-top: 10px;");
output.println("margin-right: 10px;");
output.println("margin-bottom: 10px;");
output.println("}");
output.println(".style7 {font-family: Tahoma}");
output.println("body,td,th {");
output.println("font-family: Tahoma;");
output.println("}");
output.println(".style8 {");
output.println("font-family: Geneva, Arial, Helvetica, sans-serif;");
output.println("font-size: 16px;");
output.println("}");
output.println("-->");
output.println("</style></head>");
output.println("<body>");
output.println("<form name=\"form\" method=\"post\" action=\"http://www.myjavaserver.com/servlet/myelf.message\">");
output.println("<table width=\"745\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">");
output.println("<tr>");
output.println("<th width=\"139\" scope=\"col\"><img src=\"http://myjavaserver.com/~myelf/pic/logo.jpg\" width=\"139\" height=\"82\"></th>");
output.println("<th width=\"318\" class=\"style7\" scope=\"col\"> </th>");
output.println("<th width=\"45\" scope=\"col\"> </th>");
output.println("<th width=\"59\" valign=\"baseline\" scope=\"col\"><span class=\"style7\"><a href=\"http://myjavaserver.com/~myelf/login.htm\">Login</a></span></th>");
output.println("<th width=\"81\" valign=\"baseline\" scope=\"col\"><span class=\"style7\"><a href=\"http://myjavaserver.com/~myelf/register.htm\">Register</a></span></th>");
output.println("</tr>");
output.println("</table>");
output.println("<p> </p>");
output.println("<p> </p>");
output.println("<table width=\"747\" height=\"46\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">");
output.println("<tr>");
output.println("<th scope=\"col\"> </th>");
output.println("</tr>");
output.println("<tr>");
output.println("<th scope=\"col\"><h2 class=\"style9\">Congratulation</h2></th>");
output.println("</tr>");
output.println("<tr>");
output.println("<th scope=\"col\"><h2><span class=\"style10\">You are sucessful register! </span></h2></th>");
output.println("</tr>");
output.println("</table>");
output.println("<table width=\"749\" height=\"64\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">");
output.println("<tr>");
output.println("<th colspan=\"2\" scope=\"col\"> </th>");
output.println("<th colspan=\"2\" scope=\"col\"> </th>");
output.println("</tr>");
output.println("<tr>");
output.println("<th width=\"364\" valign=\"bottom\" scope=\"row\"><div align=\"right\">Username:</div></th>");
output.println("<th width=\"10\" scope=\"row\"> </th>");
output.println("<td width=\"11\"> </td>");
output.println("<td width=\"364\" valign=\"bottom\"><em>" + user +"</em></td>");
output.println("</tr>");
output.println("<tr>");
output.println("<th valign=\"bottom\" scope=\"row\"><div align=\"right\">E-mail Address: </div></th>");
output.println("<th scope=\"row\"> </th>");
output.println("<td> </td>");
output.println("<td valign=\"bottom\"><em>"+ email + "</em></td>");
output.println("</tr>");
output.println("<tr>");
output.println("<th valign=\"bottom\" scope=\"row\"><div align=\"right\">Date Of Register:</div></th>");
output.println("<th scope=\"row\"> </th>");
output.println("<td> </td>");
output.println("<td valign=\"bottom\"><em>" + date +"</em></td>");
output.println("</tr>");
output.println("<tr>");
output.println("<th valign=\"bottom\" scope=\"row\"> </th>");
output.println("<th scope=\"row\"> </th>");
output.println("<td> </td>");
output.println("<td valign=\"bottom\"> </td>");
output.println("</tr>");
output.println("</table>");
output.println("<table width=\"748\" height=\"32\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">");
output.println("<tr>");
output.println("<th height=\"16\" scope=\"col\"><input name=\"Submit\" type=\"submit\" class=\"style7\" value=\"GO TO THE MESSAGE BOARD\"></th>");
output.println("</tr>");
output.println("</table>");
output.println("<p> </p>");
output.println("</form>");
output.println("</body>");
output.println("</html>");
output.close ();
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -