jsp與Javabean實現登錄注冊

2024-07-21 02:52:52

字體：大中小

來源：轉載

供稿：網友

jsp與javabean實現登錄注冊

jsp與Javabean實現登錄注冊jsp技術MySQL數據庫編程結合javabean組件實現最簡單基礎的一個注冊登錄demoJavaBean開發表示用戶信息的JavaBeanUserInfojava在Mysql數據庫中創建數據庫及相應的表格注冊用戶時執行數據庫操作的JavaBeanUserRegistjava用戶登錄時連接數據庫處理的JavaBeanUserLoginjavaJSP頁面的開發填寫用戶注冊信息的JSP頁面registerjsp用戶登錄頁面loginjsp運行結果

jsp技術+Mysql數據庫編程，結合javabean組件，實現最簡單基礎的一個注冊登錄demo

思路：首先需要登錄頁面以及相應的登錄驗證，對于未注冊用戶需要點擊注冊按鈕進行用戶信息注冊，注冊同樣需要一個注冊表單以及各個字段的驗證處理。為了簡化JavaBean中的處理和重用，我們把用戶的信息封裝成一個值對象的JavaBean，這個JavaBean只包含用戶信息相關的屬性和這些屬性相關的getter和setter方法，我們將其命名為UserInfo.java，其次，隨著JSP技術的發展和開發技術的成熟，在JSP頁面中連接數據庫的編程方式已經很少見，雖然在JSP頁面中使用Scriptlets也可以連接數據庫，進行數據庫操作，但這樣會造成頁面難以維護等缺點，在大型項目中，這些缺點會更加突出，所以我們建議在JavaBean中連接數據庫，UserRegiste.java用來處理注冊時連接數據庫查詢事務，UserLogin.java用來處理登錄時連接數據庫插入事務。

JavaBean開發

表示用戶信息的JavaBean(UserInfo.java)

public class UserInfo { //屬性 PRivate String name; private String passWord; private String phone; //方法 public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getPhone() { return phone; } public void setPhone(String phone) { this.phone = phone; }}

在Mysql數據庫中創建數據庫及相應的表格

create database jspdev;use jspdev;create table user_Info( name varchar(15), password varchar(20), phone varchar(15));

注冊用戶時執行數據庫操作的JavaBean（UserRegist.java）

import java.io.UnsupportedEncodingException;import java.sql.DriverManager;import com.mysql.jdbc.Connection;import com.mysql.jdbc.PreparedStatement;public class UserRegist { private UserInfo userInfo; private Connection con; // 獲得數據庫連接 public UserRegist() { String Classforname = "com.mysql.jdbc.Driver"; String Servanddb = "jdbc:mysql://127.0.0.1/jspdev"; String user = "root"; String pwd = "123456"; try { Class.forName(Classforname); con = (Connection) DriverManager.getConnection(Servanddb, user, pwd); } catch (Exception e) { e.printStackTrace(); } } // 設置待注冊的用戶信息 public void setUserInfo(UserInfo userInfo) { this.userInfo = userInfo; } // 進行注冊 public void regist() throws Exception { String reg = "insert into user_Info values(?,?,?)"; try { PreparedStatement pstmt = (PreparedStatement) con.prepareStatement(reg); pstmt.setString(1, transFormat(userInfo.getName())); pstmt.setString(2, userInfo.getPassword()); pstmt.setString(3, userInfo.getPhone()); pstmt.execute(); } catch (Exception e) { e.printStackTrace(); throw e; } } String transFormat(String s) { try { byte[] b = s.getBytes("iso-8859-1"); s = new String(b); } catch (UnsupportedEncodingException e) { System.out.println(e.toString()); } return s; }}

用戶登錄時連接數據庫處理的JavaBean(UserLogin.java)

import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;import com.mysql.jdbc.Connection;public class UserLogin { private UserInfo userInfo; private Connection con; // 獲得數據庫連接 public UserLogin() { String Classforname = "com.mysql.jdbc.Driver"; String Servanddb = "jdbc:mysql://127.0.0.1/jspdev"; String user = "root"; String pwd = "123456"; try { Class.forName(Classforname); con = (Connection) DriverManager.getConnection(Servanddb, user, pwd); } catch (Exception e) { e.printStackTrace(); } } // 獲取已經注冊的用戶信息 public void setUserInfo(UserInfo userInfo) { this.userInfo = userInfo; } // 進行登錄查詢驗證 public boolean login(String name, String password) throws Exception { try { Statement stmt = con.createStatement(); ResultSet rst = stmt.executeQuery( "select name, password from user_Info where name= '" + name + "' and password='" + password + "'"); if (rst.next()) { rst.close(); stmt.close(); con.close(); return false; } else { rst.close(); stmt.close(); con.close(); return true; } } catch (Exception e) { e.printStackTrace(); } return false; }}

JSP頁面的開發

填寫用戶注冊信息的JSP頁面（register.jsp）

<%@page import="org.apache.jasper.tagplugins.jstl.core.Out"%><%@ page language="java" contentType="text/html; charset=gb2312"%><%@ page import="java.sql.*,java.io.*"%><jsp:useBean id="info" class="webUser.UserInfo" scope="request"> <jsp:setProperty property="*" name="info" /></jsp:useBean><jsp:useBean id="regist" class="webUser.UserRegist" scope="request"> <jsp:setProperty property="*" name="regist" /></jsp:useBean><%! String transFormat(String s){ try{ byte []b=s.getBytes("iso-8859-1"); s=new String(b); } catch(UnsupportedEncodingException e){ System.out.println(e.toString()); } return s;}%><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>登錄首頁</title><script type="text/Javascript"> function register() { if (document.registerform.name.values == "") { window.alert("請輸入用戶名稱"); document.registerform.name.focus(); return false; } if (document.registerform.password.value == "") { window.alert("請輸入密碼"); document.registerform.password.focus(); return false; } if (document.registerform.repassword.value == "") { window.alert("請確認密碼"); document.registerform.repassword.focus(); return false; } if (document.registerform.password.value != document.registerform.repassword.value) { window.alert("兩次密碼不同，請重新輸入"); document.registerform.repassword.focus(); return false; } if (document.registerform.phone.value == "") { window.alert("請輸入電話號碼"); document.registerform.phone.focus(); return false; } return true; }</script></head><body bgcolor=cyan> <font size=4> <% /* request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); response.setContentType("text/html; charset=utf-8"); */ String name = request.getParameter("name"); String password = request.getParameter("password"); String repassword = request.getParameter("repassword"); String phone = request.getParameter("phone"); if (name == null) { name = ""; if (password == null) { password = ""; if (repassword == null) { repassword = ""; if (phone == null) { phone = ""; } } } } boolean isSuccessRegist = false; if (password.equals(repassword) && !name.equals("") && !password.equals("") && !repassword.equals("") && !phone.equals("")) { name=transFormat(name); regist.setUserInfo(info); regist.regist(); isSuccessRegist = true; } %> <form action="" method=post name=registerform> <table width="100%" height="500" align="center"> <tr> <td> <div heigh="100%" align="center"> <table border="0" align="center"> <tr> <td>用戶名：</td> <td><input type="text" name="name"></td> </tr> <tr> <td>密碼：</td> <td><input type="password" name="password"></td> </tr> <tr> <td>確認密碼：</td> <td><input type="password" name="repassword"></td> </tr> <tr> <td>手機號碼：</td> <td><input type="text" name="phone"></td> </tr> </table> <p align="center"> <a href="login.jsp"><input type="button" value="登錄" name="button"></a> <input type="submit" value="注冊" name="regist" onclick="register()"> </p> <font size=4 color=red> <% if(isSuccessRegist){ out.println(name); out.println("注冊成功"); } %> </font> </div> </td> </tr> </table> </form> </font></body></html>

用戶登錄頁面（login.jsp）

<%@ page language="java" contentType="text/html; charset=gb2312"%><jsp:useBean id="info" class="webUser.UserInfo" scope="request"> <jsp:setProperty property="*" name="info" /></jsp:useBean><jsp:useBean id="login" class="webUser.UserLogin" scope="request"> <jsp:setProperty property="*" name="login" /></jsp:useBean><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>登錄首頁</title><script type="text/javascript"> function login() { if (document.registerform.name.values == "") { window.alert("請輸入用戶名稱"); document.registerform.name.focus(); return false; } if (document.registerform.password.value == "") { window.alert("請輸入密碼"); document.registerform.password.focus(); return false; } return true; }</script></head><body bgcolor=cyan> <font size=4> <% String name = request.getParameter("name"); String password = request.getParameter("password"); if (name == null) { name = ""; if (password == null) { password = ""; } } boolean isSuccessLogin = false; if (!name.equals("") && !password.equals("")) { login.setUserInfo(info); isSuccessLogin = login.login(name,password); if (isSuccessLogin) { response.sendRedirect("welcome.jsp"); } isSuccessLogin = false; } %> <form action="" method=post name=form> <table width="100%" height="500" align="center"> <tr> <td> <div heigh="100%" align="center"> <table border="0" align="center"> <tr> <td>用戶名：</td> <td><input type="text" name="name"></td> </tr> <tr> <td>密碼：</td> <td><input type="password" name="password"></td> </tr> </table> <p align="center"> <input type="submit" value="登錄" name="login" onclick="login()"> <a href="register.jsp"><input type="button" value="注冊" name="button"></a> </p> </div> </td> </tr> </table> </form> </font></body></html>### 登錄成功跳轉頁面（Main.jsp） ###<%@ page language="java" contentType="text/html; charset=gb2312"%><html><head><meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"><title>主頁面</title></head><body bgcolor=cyan><font size=6 color=red><div height="100%" align="center" valign="center"> <br><br>歡迎來到本頁面！?。?lt;/div></font></body></html>