JSP处理用户的注册和登陆信息源代码
这是一个JSP实例，由四个JSP页面组成，处理用户的注册和登陆信息
2. 首先是login.jsp,代码如下：
<%@ page contentType="text/html; charset=gb2312" language="java"
import="java.sql.*"%>
3. test.jsp代码如下：（主要处理用户注册，将注册信息插入数据库）
<%@ page language="java" import="java.sql.*"%>
your username is:<%=request.getParameter("username")%>
your password is:<%=request.getParameter("pass")%>
<%
String name=request.getParameter("username");
String pass=request.getParameter("pass");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection dbcon=DriverManager.getConnection("jdbc:odbc:test","sa","");
PreparedStatement stat=dbcon.prepareStatement(
"insert login values(?,?)");
stat.setString(1,name);
stat.setString(2,pass);
stat.executeUpdate();
out.println("
insert successful");
}
catch(Exception e)
{
out.println(e);
}
%>
Click here to view all people
4. test2.jsp，代码如下：（处理当用户注册成功之后可以查看所有的注册用户名单）
<%@ page language="java" import="java.sql.*"%>
<% try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection dbcon=DriverManager.getConnection("jdbc:odbc:test","sa","");
PreparedStatement stat=dbcon.prepareStatement(
"select * from login");
ResultSet result=stat.executeQuery();
%>
<%
while(result.next())
{
%>
| <%=result.getString(1)%> | |
<%
}
%>
<%
}
catch(Exception e)
{
out.println(e);
}
%>
5. test3.jsp代码如下：（处理用户登录信息）
your username is:<%=request.getParameter("username")%>
your password is:<%=request.getParameter("pass")%>
<%@ page language="java" import="java.sql.*"%>
<%
String name=request.getParameter("username");
String pass=request.getParameter("pass");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection dbcon=DriverManager.getConnection("jdbc:odbc:test","sa","");
PreparedStatement stat=dbcon.prepareStatement(
"select * from login where username=? and password=?");
stat.setString(1,name);
stat.setString(2,pass);
ResultSet result=stat.executeQuery();
if(result.next())
{
out.println("Login Successful");
}
else
{
out.println("Login Error");
}
}
catch(Exception e)
{
out.println(e);
}
%>
6.此外还需要一个名为login的数据库，只需要两个列username,password就可以了
先注册,用户名33,密码33
注册成功
察看注册用户
登陆成功
