=========================================
reg.html
=========================================
<form action="reg.jsp"method="post">
用户名:<input type="text"name="uname" /><br/>
密码:<input type="password"name="psd" /><br/>
确认密码:<input type="password"name="repsd" /><br/>
<input type="submit" value="注册"/>
<input type="reset" value="重写"/>
</form>
=========================================
reg.jsp
=========================================
<%@ page pageEncoding="GB2312"import="java.sql.*"%>
<%
Stringusername=request.getParameter("uname");
String psd=request.getParameter("psd");
String repsd=request.getParameter("repsd");
if(psd.equals(repsd))
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Stringurl="jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ="+application.getRealPath("db1.mdb");
Connectionconn=DriverManager.getConnection(url,"","");
Statementstate=conn.createStatement();
ResultSetrs=state.executeQuery("select * from usertable wherename='"+username+"'");
if(rs.next())
{
out.print("该用户名已经被使用!");
state.close();
conn.close();
}
else
{
rs.close();
inti=state.executeUpdate("insert into usertable(name,psd) values('"+username+"','"+psd+"')");
state.close();
conn.close();
out.print("您已经成功注册,请<ahref="login.html">登录</a>");
}
}
else
{
out.print("两次输入的密码不一致!");
}
%>