jsp注册页面代码用户信息的bean:package chen;public class UserBean{private String userid;private String password;public void setUserId(String userid){erid=userid;}public void setPassword(String password){this.password=password;}public String getUserId(){return erid;}public String getPassword(){return this.password;}}提交数据库的bean:package chen;import com.mysql.jdbc.Driver;import java.sql.*;public class UserRegister{private UserBean userBean;private Connection con;//获得数据库连接。
public UserRegister(){String url="jdbc:mysql://localhost/"+"chao"+"?user="+"root"+"&password="+"850629"; try{Class.forName("com.mysql.jdbc.Driver").newInstance();con = DriverManager.getConnection(url);}catch(Exception e){e.printStackTrace();}}//设置待注册的用户信息。
public void setUserBean(UserBean userBean){erBean=userBean;}//进行注册public void regist() throws Exception{String reg="insert into userinfo(userid,password) values(?,?)";try{PreparedStatement pstmt=con.prepareStatement(reg);pstmt.setString(1,userBean.getUserId());pstmt.setString(2,userBean.getPassword());pstmt.executeUpdate();}catch(Exception e){e.printStackTrace();throw e;}}}提交注册数据进入数据库:<%@ page contentType="text/html;charset=gb2312" pageEncoding="gb2312" import="chen.*" %><jsp:useBean id="userBean" class="erBean" scope="request"><jsp:setProperty name="userBean" property="*"/></jsp:useBean><jsp:useBean id="regist" class="erRegister" scope="request"/><html><head><title> 用户信息注册页面</title><meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head><body>String userid =request.getParameter("userid");String password = request.getParameter("password");userBean.setUserId(userid);userBean.setPassword(password);System.out.println(userid+password);%><% try{regist.setUserBean(userBean);out.println(userid);regist.regist();out.println("注册成功");}catch(Exception e){out.println(e.getMessage());}%><br><a href="login.jsp">返回</a></body></html>登陆验证页面:<%@page import="java.sql.*" contentType="text/html;charset=GB2312" %><%@page import="java.util.*"%><%String userid1=new String(request.getParameter("userid"));String password1=new String(request.getParameter("password"));Class.forName("com.mysql.jdbc.Driver");Connectioncon=DriverManager.getConnection("jdbc:mysql://localhost:3306/chao","root","850629"); Statement stmt=con.createStatement();String sql="select * from userinfo where userid='"+userid1+"';";ResultSet rs=stmt.executeQuery(sql);if(rs.next()){String password=new String(rs.getString("password"));if(password.equals(password1)){session.setAttribute("userid1",userid1);response.sendRedirect("sucess.jsp");}else{response.sendRedirect("login.jsp");}}else{response.sendRedirect("login.jsp");%>登陆页面:<%@ page contentType="text/html; charset=gb2312" %><html><body><form method="get" action="checklogin.jsp"><table><tr><td> 输入用户名:</td><td><input type=text name=userid ></td></tr><tr><td>输入密码:</td><td><input type=password name=password></td></tr><tr><td><input type=submit value=确认></td></tr></table></form><form action="register.jsp"><input type=submit value=注册></form></body></html>注册页面:<%@page contentType="text/html; charset=gb2312" language="java" import="java.util.*,java.io.*"%><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head><body><center><h1>注册新用户</h1><form action="adduser.jsp" method=post><table border="1" bgcolor="#0099CC"><tr><td> 用户名:<input type="text" name="userid"></td></tr><tr valign="middle"><td> 密码:<input type="password" name="password" readonly></td></tr><tr><td><input type=submit value=提交></td></tr></table></form></center></body></html>登陆成功页面:<%@page import="java.util.*" contentType="text/html; charset=gb2312" %> <%@include file="trans.jsp"%><html><head><title>sucess</title></head><body bgcolor="#ffffff"><h1>登录成功,欢迎您!</h1><%=trans(session.getAttribute("userid1"))%></body></html>登录前台界面设计代码如下:<%@ page contentType="text/html; charset=gb2312"language="java" import="java.sql.*" errorPage="" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01Transitional//EN"><html><head><title>Register Test!</title></head><body> 登录界面!! <br><form method="post" action="cheklogin.jsp" name="form"> <table width="183" height="85" border="1"><tr><td>User:</td><td><input type="text" name="user" size="13"> </td></tr><tr><td>Password:</td><td><input type="Password" name="password" size="13" > </td></tr><tr><td><input type="Submit" name="bt1" text="OK" value="登录"></td><td><a href="do_register.jsp" target="_parent">新用户注册<br></a></td></tr></table></form></body></html>后台处理程序添加一个Jsp 右键webRoot : New—>JSP 名称cheklogin .jsp代码如下:<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><%String path = request.getContextPath();String basePath =request.getScheme()+"://"+request.getServerName()+":"+req uest.getServerPort()+path+"/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01Transitional//EN"><html><head><base href="<%=basePath%>"><title>My JSP 'cheklogin.jsp' starting page</title><meta http-equiv="pragma" content="no-cache"><meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"><meta http-equiv="keywords"content="keyword1,keyword2,keyword3"><meta http-equiv="description" content="This is my page"> <!--<link rel="stylesheet" type="text/css"href="styles.css">--></head><body><%String usr = request.getParameter("user");String pwd = request.getParameter("password");//String usr = "hurui";//String pwd = "free889";Connection con = null;Statement sm = null;ResultSet rs = null;try{Class.forName("rmix.jdbc.IfxDriver").newInstan ce(); //装载jdbc 驱动String url ="jdbc:informix-sqli://192.168.5.249:9003/testuser:informi xserver=iservice_online_net"; // 定义数据库连接URLcon =DriverManager.getConnection(url,"informix","informix"); //获取数据连接实例sm = con.createStatement(); //获取Statement 的实例rs = sm.executeQuery("select * from new_test_user where login='"+usr+"' and password='"+pwd+"'"); //执行查询语句,并返回给结果集}catch(Exception e){e.printStackTrace( );}//添加表格%><table border="1" width="80%"><tr><td>你的用户名是:</td><td>你的密码是:</td></tr><%while (rs.next()) { //循环输出产品信息String var_name=rs.getString(1);String var_val=rs.getString(2);%><tr><%if(usr == var_name || pwd ==var_val){System.out.println("success!");}%><td><%= var_name %></td><td><%= var_val %></td></tr><%}rs.close();sm.close();con.close();%></body></html>验证试验是否成功:输入:用户名:admin密码:11111。