jsp注册登录页面代码[试题]
2017-09-27 14页 doc 53KB 44阅读
is_153723
暂无简介
举报
jsp注册登录页面代码[试题]jsp注册登录页面代码[试题]
jsp注册页面代码
用户信息的bean:
package chen;
public class UserBean
{
private String userid;
private String password;
public void setUserId(String userid)
{
this.userid=userid;
}
public void setPassword(String password)
{
this.password=password;
}...
![jsp注册登录页面代码[试题]](https://swf.iask.com/jCYfGiOWG0V.svg?ssig=qjwH%2F0Iyhk&Expires=1720064250&KID=sina,ishare&range=0-5135)
jsp注册登录页面代码[试题]
jsp注册页面代码
用户信息的bean:
package chen;
public class UserBean
{
private String userid;
private String password;
public void setUserId(String userid)
{
this.userid=userid;
}
public void setPassword(String password)
{
this.password=password;
}
public String getUserId()
{
return this.userid;
}
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)
{
this.userBean=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.*" %>
用户信息注册页面
<%
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());
}
%>
返回 登陆验证页面: <%@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"); Connection con=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" %> 注册页面: <%@page contentType="text/html; charset=gb2312" language="java" import="java.util.*,java.io.*"%>
登陆成功页面:
<%@page import="java.util.*" contentType="text/html; charset=gb2312" %>
<%@include file="trans.jsp"%>
sucess
Register Test!
登录界面!!
后台处理程序 添加一个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()+":"+request.getServerPort()+path+"/"; %>My JSP 'cheklogin.jsp' starting page
<%
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("com.informix.jdbc.IfxDriver").newInstance(); //装载jdbc 驱动
String url =
"jdbc:informix-sqli://192.168.5.249:9003/testuser:informi
xserver=iservice_online_net"; // 定义数据库连接,,,
con =
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( );
}
//添加格
%>
返回 登陆验证页面: <%@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"); Connection con=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" %> 注册页面: <%@page contentType="text/html; charset=gb2312" language="java" import="java.util.*,java.io.*"%>
注册新用户
登录成功，欢迎您～
<%=trans(session.getAttribute("userid1"))%> 登录 前台界面设计 代码如下: <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>后台处理程序 添加一个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()+":"+request.getServerPort()+path+"/"; %>
浙公网安备 33021202002483