?? loginservlet.java
字號(hào):
package loginservlet;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import java.sql.*;/** * Title: 使用servlet用戶登陸程序 * Description: 教學(xué)示范 * Copyright: Copyright (c) 2003 * Company: 北京師范大學(xué)計(jì)算機(jī)系 * @author 孫一林 * @version 1.0 */public class loginServlet extends HttpServlet { static final private String CONTENT_TYPE = "text/html; charset=GBK"; Connection connection; // 創(chuàng)建連接對(duì)象 Vector user_Vec; // 定義向量存入個(gè)人注冊(cè)信息 Vector userbase_Vec; // 定義向量存入用戶名及密碼 public void init() throws ServletException { connection = null; user_Vec = new Vector(); userbase_Vec = new Vector(); } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String name = request.getParameter("username"); // 獲得登陸用戶名 String password = request.getParameter("password"); // 獲得登陸密碼 response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); out.println("<html>"); out.println("<head><title>登錄界面</title></head>"); out.println("<body>"); boolean logined = false; if ((logined=login(name, password))==true) // 判斷數(shù)據(jù)庫(kù)中是否有用戶名 { boolean right_pass = checkpass(password); // 檢測(cè)用戶密碼是否正確 if (right_pass) { getUserInfo(name, password); // 調(diào)用個(gè)人注冊(cè)信息，分別賦值給字符串變量 String truename = String.valueOf(user_Vec.elementAt(0)); String age = String.valueOf(user_Vec.elementAt(1)); String sex = String.valueOf(user_Vec.elementAt(2)); String mail = String.valueOf(user_Vec.elementAt(3)); String tel = String.valueOf(user_Vec.elementAt(4)); // 顯示個(gè)人注冊(cè)信息 out.println("<p align=center>用戶名：" + name + "</p>"); out.println("<p align=center>用戶姓名：" + truename + "</p>"); out.println("<p align=center>年齡：" + age + "</p>"); out.println("<p align=center>性別：" + sex + "</p>"); out.println("<p align=center>郵件地址：" + mail + "</p>"); out.println("<p align=center>電話：" + tel + "</p>"); } else // 密碼不正確處理情況 { out.println("密碼不正確！<br>"); out.println("<p align=center><a href='login.htm'>重新登錄</a></p>"); } } else // 用戶名不存在處理情況 { out.println("用戶名不存在！<br>"); out.println("<p align=center><a href='login.htm'>重新登錄</a></p>"); } out.println("</body></html>"); } public void destroy() { } public boolean login(String name, String password) { boolean logined = false; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 實(shí)例化JDBC-ODBC橋的驅(qū)動(dòng) String url = "jdbc:odbc:login"; // 設(shè)置連接字符串 connection = DriverManager.getConnection(url); // 連接數(shù)據(jù)庫(kù) Statement statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); String sql = "select * from userbase where user_name = '" + name + "'"; ResultSet rs = statement.executeQuery(sql); int recordCount = 0; while(rs.next()) { recordCount++; } if (recordCount>0) // 判斷數(shù)據(jù)庫(kù)表userbase中是否有用戶信息 { userbase_Vec.clear(); rs.first(); userbase_Vec.addElement(rs.getString("user_name")); // 將個(gè)人信息存入向量對(duì)象userbase_Vec中 userbase_Vec.addElement(rs.getString("user_password")); logined = true; } } catch(Exception ex) // 捕捉異常 { ex.printStackTrace(); } return logined; } public void getUserInfo(String name, String password) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 實(shí)例化JDBC-ODBC橋的驅(qū)動(dòng) String url = "jdbc:odbc:login"; // 設(shè)置連接字符串 connection = DriverManager.getConnection(url); // 連接數(shù)據(jù)庫(kù) // 創(chuàng)建Statement接口對(duì)象 Statement statement = connection.createStatement(); String sql = "select * from userinfo where user_name = '" + name + "' and user_password = '" + password + "'"; ResultSet rs = statement.executeQuery(sql); rs.next(); user_Vec.clear(); // 將個(gè)人注冊(cè)信息存入向量user_Vec中 user_Vec.addElement(rs.getString("user_truename")); user_Vec.addElement(rs.getString("user_age")); user_Vec.addElement(rs.getString("user_sex")); user_Vec.addElement(rs.getString("user_mail")); user_Vec.addElement(rs.getString("user_tel")); } catch(Exception ex) // 捕捉異常 { ex.printStackTrace(); } } public boolean checkpass(String password) // 定義驗(yàn)證密碼函數(shù) { boolean right_pass = false; if (password.equals(String.valueOf(userbase_Vec.elementAt(1)))) { right_pass = true; } return right_pass; }}?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -