register.jsp<script language="javascript" type="text/javascript">
function checkForm(){
var uname=document.getElementById("username").value;
if(uname.length<6){
window.alert("Error: the length of username less than 6!");
return false;
}......
<body>
<form name="form1" method="post" action="">
<span class="STYLE4">用户注册</span>
<p align="left">用 户 名
.........<p align="left">
<input type="submit" name="Submit" value="提交" onClick="javascript:checkForm">
<input name="reset" type="reset" id="reset" value="重置">
</p>
</form>
</body>
</html>
doRegister.jsp<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@page import="Javabean.RegForm"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<jsp:useBean id="regbean" class="Javabean.RegForm"></jsp:useBean>
<jsp:setProperty name="regbean" property="*"/>
<%
if(regbean.register()==1){
%>
注册成功
<%}else{ %>
注册失败
<%} %>
</body>
</html>
调用方法为:
public int excuteUpdate_id(String sql){
int result=0;
try{
conn=DriverManager.getConnection("jdbc:odbc:bookstore" );
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
result=stmt.executeUpdate(sql);
String ID="SELECT @@IDENTITY as id";
rs=stmt.executeQuery(ID);
if(rs.next()){
int autoID=rs.getInt("id");
result=autoID;
}}catch(SQLException ex){
result=0;
}
return result;
}
function checkForm(){
var uname=document.getElementById("username").value;
if(uname.length<6){
window.alert("Error: the length of username less than 6!");
return false;
}......
<body>
<form name="form1" method="post" action="">
<span class="STYLE4">用户注册</span>
<p align="left">用 户 名
.........<p align="left">
<input type="submit" name="Submit" value="提交" onClick="javascript:checkForm">
<input name="reset" type="reset" id="reset" value="重置">
</p>
</form>
</body>
</html>
doRegister.jsp<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@page import="Javabean.RegForm"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<jsp:useBean id="regbean" class="Javabean.RegForm"></jsp:useBean>
<jsp:setProperty name="regbean" property="*"/>
<%
if(regbean.register()==1){
%>
注册成功
<%}else{ %>
注册失败
<%} %>
</body>
</html>
调用方法为:
public int excuteUpdate_id(String sql){
int result=0;
try{
conn=DriverManager.getConnection("jdbc:odbc:bookstore" );
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
result=stmt.executeUpdate(sql);
String ID="SELECT @@IDENTITY as id";
rs=stmt.executeQuery(ID);
if(rs.next()){
int autoID=rs.getInt("id");
result=autoID;
}}catch(SQLException ex){
result=0;
}
return result;
}
function checkForm(){
var uname=document.getElementById("username").value;
if(uname.length <6){
window.alert("Error: the length of username less than 6!");
return false;
}......
<body>
<form name="form1" method="post" action="">
<span class="STYLE4">用户注册 </span>
<p align="left">用 户 名
......... <p align="left">
<input type="submit" name="Submit" value="提交" onClick="javascript:checkForm">
<input name="reset" type="reset" id="reset" value="重置">
</p>
</form>
</body>
</html>
doRegister.jsp <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@page import="Javabean.RegForm"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档 </title>
</head>
<body>
<jsp:useBean id="regbean" class="Javabean.RegForm"> </jsp:useBean>
<jsp:setProperty name="regbean" property="*"/>
<%
if(regbean.register()==1){
%>
注册成功
<%}else{ %>
注册失败
<%} %>
</body>
</html>
调用方法为:
public int excuteUpdate_id(String sql){
int result=0;
try{
conn=DriverManager.getConnection("jdbc:odbc:bookstore" );
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
result=stmt.executeUpdate(sql);
String ID="SELECT @@IDENTITY as id";
rs=stmt.executeQuery(ID);
if(rs.next()){
int autoID=rs.getInt("id");
result=autoID;
}}catch(SQLException ex){
result=0;
} return result;
}
在控制器中转向或重定向
如果要在一个页面根据是否登陆显示不同的东西。可以用C:if
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Exception in JSP: /doRegister.jsp:1512: <jsp:useBean id="regbean" class="Javabean.RegForm"></jsp:useBean>
13: <jsp:setProperty name="regbean" property="*"/>
14: <%
15: if(regbean.register()!=0){
16: %>
17: out.println("<script language='javascript'>alter('注册成功');window.location.href='login.jsp';</script>");
18: <%}else{ %>
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause javax.servlet.ServletException: General error
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.doRegister_jsp._jspService(doRegister_jsp.java:87)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.sql.SQLException: General error
sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
Javabean.RegForm.register(RegForm.java:86)
org.apache.jsp.doRegister_jsp._jspService(doRegister_jsp.java:69)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.5.17