?? logonservlet.java
字號:
package dcfs;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Date;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class for Servlet: LogonServlet
*
*/
public class LogonServlet extends javax.servlet.http.HttpServlet implements
javax.servlet.Servlet {
/**
*
*/
private static final long serialVersionUID = 1L;
public LogonServlet() {
super();
}
public void destroy() {
super.destroy();
}
protected void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
// 獲得注冊用戶的信息
String id = request.getParameter("id");
String password = request.getParameter("password");
String password_db = null;
// 設置頁面屬性
response.setContentType("text/html");
response.setCharacterEncoding("GBK");
PrintWriter out = response.getWriter();
out.print("<html>");
out.print("<head>");
out.println("<title>登錄成功</title>");
out.println("</head>");
out.println("<body>");
// 獲取當前時間
Date currentTime = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
// 聲明數據庫連接的相關對象
Connection con;
Statement sql;
Statement sql_update_count;
Statement sql_update_time;
ResultSet rs;
// 定義對上次登錄時間更新的SQL語句
String stmt_update_time = "update user_info set 上次登錄時間 = sysdate where ID號='" + id + "'";
// 定義對登錄次數更新的SQL語句
String stmt_update_count = "update user_info set 登錄次數=登錄次數 + 1 where ID號='" + id + "'";
// 定義相關的SQL語句:select
String stmt_select = "select * from user_info where ID號='" + id + "'";
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
System.out.println("ClassNotFound");
}
try {
con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:orcl", "hongshuai",
"hongshuai");
System.out.println("數據庫連接成功");
sql = con.createStatement();
sql_update_count = con.createStatement();
sql_update_time = con.createStatement();
// 執行SQL語句
rs = sql.executeQuery(stmt_select);
if (rs.next()) {
// 獲得注冊用戶的密碼
password_db = rs.getString("密碼");
if((password.trim()).equals(password_db)) {
id = rs.getString("ID號");
out.print("-----------登錄成功-----------<br>");
out.print("姓名為：" + rs.getString("姓名") + "<br>");
out.print("性別為：" + rs.getString("性別") + "<br>");
out.print("學校為：" + rs.getString("學校") + "<br>");
out.print("專業為：" + rs.getString("專業") + "<br>");
out.print("電話為：" + rs.getString("電話") + "<br>");
out.print("郵箱為：" + rs.getString("郵箱") + "<br>");
out.print("興趣為：" + rs.getString("興趣") + "<br>");
out.print("住址為：" + rs.getString("住址") + "<br><br>");
out.print("您這是第" + (rs.getInt("登錄次數")+1) + "次登錄本站" + "<br><br>");
sql_update_count.execute(stmt_update_count);
out.print("上次登錄時間為：" + rs.getString("上次登錄時間") + "<br><br>");
sql_update_time.execute(stmt_update_time);
out.print(" 當前的時間為：" + sdf.format(currentTime));
out.print("<br><br>");
out.print("<form action='UpdateServlet' method='post' name='form_update'>"+
"<input type='hidden' name='id' value="+id+">" +
"<input type='submit' value='修改個人信息'>");
out.println("</body>");
out.println("</html>");
out.flush();
out.close();
}
else {
out.println("用戶名密碼錯誤!請重新輸入密碼!!");
out.println("</body>");
out.println("</html>");
out.flush();
out.close();
}
// out.print("ID號為：" + rs.getString("ID號") + "<br>");
// out.print("密碼為：" + rs.getString("密碼") + "<br>");
}
else {
out.print("用戶名不存在!請重新登錄!~~~~~~");
out.println("</body>");
out.println("</html>");
out.flush();
out.close();
}
// 關閉數據連接
con.close();
System.out.println("數據庫已經關閉!~~~");
} catch (SQLException ex) {
System.out.println("SQL,Logon出錯！！");
}
} public void init() throws ServletException {
super.init();
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -