zhuche.jsp<%@ page contentType="text/html;charset=GB2312" %>
<html>
<head><title>注册页面</title></head>
<p>选择你的登录类别:
<form action="zhuzhe1.jsp" method=post name=form>
<select name="leibeigo">
<option selected value="1">普通用户
<option value="0">管理员
</select>
<p>用户名: <input type="text" name="y_id"></p>
<p>密码: <input type="text" name="y_pass" ></p>
<p>用户姓名: <input type="text" name="y_name" ></p>
<p><input type="submit" value="注册" name="ok">
<input type="reset" value="重置" name="cancel"></p>
</form>
zhuzhe1.jsp<%@ page contentType="text/html; charset=GB2312" language="java"%>
<%@ page import="java.sql.*" %>
<html>
<head><title>用户注册功能</title></head>
<body>
<%@ include file="convert.jsp" %>
<%
String s1=request.getPatameter("leibeigo");
String y_id=Bytes(request.getPatameter("y_id"));
String y_pass=Bytes(request.getParameter("y_pass"));
String y_name=Bytes(request.getParameter("y_name"));
if(y_id!=null)
{
try
{
Connection conn=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String strConn="jdbc:odbc:shop";
String strUser="sa";
String strPassword="";
conn=DriverManager.getConnection(strConn,strUser,strPassword);
Statement stmt=conn.createStatement(); if(s1.equals("1"))
{
String strSql1="INSERT INTO yonghu VALUES('"+y_id+"','"+y_pass+"','"+y_name+"')";
String strSql="SELECT COUNT(*) FROM yonghu WHERE y_id='"+y_id+" ' ";
ResultSet rs=stmt.executeQuery(strSql);
if(rs.next()!=0)
{
out.println("<font size=4pt color='red'>"+"该用户以存在!"+"</font>");
}
else
{
int intTemp=stmt.executeUpdate(strSql1);
if(intTemp!=0)
{
out.println("<font size=4pt color='red'>"+"用户注册成功!"+"</font>");
}
else
{
out.println("<font size=4pt color='red'>"+"用户注册失败!"+"</font>");
}
}
}
if(s1.equals("0"))
{
String strSql1="INSERT INTO guanliyuan VALUER('"+y_id+"','"+y_pass+"','"+y_name+"')";
String strSql="SELECT COUNT(*) FROM guanliyuan WHERE g_id='"+y_id+" '";
ResultSet rs=stat.executeQuery(strSql);
if(rs.next()!=0)
{
out.println("<font size=4pt color='red'>"+"该用户以存在!"+"</font>");
}
else
{
int intTemp=stmt.executeUpdate(strSql1);
if(intTemp!=0)
{
out.println("<font size=4pt color='red'>"+"用户注册成功!"+"</font>");
}
else
{
out.println("<font size=4pt color='red'>"+"用户注册失败!"+"</font>");
}
}
}
rs.close();
stmt.close();
conn.close();
}
}
catch(ClassNotFoundException e)
{
out.println(e.getMessage());
}
catch(SQLException e)
{
out.println(e.getMessage());
}
%>
</body>
</html>错误提示
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: /zhuzhe1.jsp(6,0) File "/convert.jsp" not found
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:40)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:407)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:88)
org.apache.jasper.compiler.Parser.processIncludeDirective(Parser.java:345)
org.apache.jasper.compiler.Parser.parseIncludeDirective(Parser.java:378)
org.apache.jasper.compiler.Parser.parseDirective(Parser.java:486)
org.apache.jasper.compiler.Parser.parseElements(Parser.java:1444)
org.apache.jasper.compiler.Parser.parse(Parser.java:138)
org.apache.jasper.compiler.ParserController.doParse(ParserController.java:216)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:103)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:154)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:315)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:295)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:282)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:586)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.找半天找不出来,数据库连接也没问题呀
<html>
<head><title>注册页面</title></head>
<p>选择你的登录类别:
<form action="zhuzhe1.jsp" method=post name=form>
<select name="leibeigo">
<option selected value="1">普通用户
<option value="0">管理员
</select>
<p>用户名: <input type="text" name="y_id"></p>
<p>密码: <input type="text" name="y_pass" ></p>
<p>用户姓名: <input type="text" name="y_name" ></p>
<p><input type="submit" value="注册" name="ok">
<input type="reset" value="重置" name="cancel"></p>
</form>
zhuzhe1.jsp<%@ page contentType="text/html; charset=GB2312" language="java"%>
<%@ page import="java.sql.*" %>
<html>
<head><title>用户注册功能</title></head>
<body>
<%@ include file="convert.jsp" %>
<%
String s1=request.getPatameter("leibeigo");
String y_id=Bytes(request.getPatameter("y_id"));
String y_pass=Bytes(request.getParameter("y_pass"));
String y_name=Bytes(request.getParameter("y_name"));
if(y_id!=null)
{
try
{
Connection conn=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String strConn="jdbc:odbc:shop";
String strUser="sa";
String strPassword="";
conn=DriverManager.getConnection(strConn,strUser,strPassword);
Statement stmt=conn.createStatement(); if(s1.equals("1"))
{
String strSql1="INSERT INTO yonghu VALUES('"+y_id+"','"+y_pass+"','"+y_name+"')";
String strSql="SELECT COUNT(*) FROM yonghu WHERE y_id='"+y_id+" ' ";
ResultSet rs=stmt.executeQuery(strSql);
if(rs.next()!=0)
{
out.println("<font size=4pt color='red'>"+"该用户以存在!"+"</font>");
}
else
{
int intTemp=stmt.executeUpdate(strSql1);
if(intTemp!=0)
{
out.println("<font size=4pt color='red'>"+"用户注册成功!"+"</font>");
}
else
{
out.println("<font size=4pt color='red'>"+"用户注册失败!"+"</font>");
}
}
}
if(s1.equals("0"))
{
String strSql1="INSERT INTO guanliyuan VALUER('"+y_id+"','"+y_pass+"','"+y_name+"')";
String strSql="SELECT COUNT(*) FROM guanliyuan WHERE g_id='"+y_id+" '";
ResultSet rs=stat.executeQuery(strSql);
if(rs.next()!=0)
{
out.println("<font size=4pt color='red'>"+"该用户以存在!"+"</font>");
}
else
{
int intTemp=stmt.executeUpdate(strSql1);
if(intTemp!=0)
{
out.println("<font size=4pt color='red'>"+"用户注册成功!"+"</font>");
}
else
{
out.println("<font size=4pt color='red'>"+"用户注册失败!"+"</font>");
}
}
}
rs.close();
stmt.close();
conn.close();
}
}
catch(ClassNotFoundException e)
{
out.println(e.getMessage());
}
catch(SQLException e)
{
out.println(e.getMessage());
}
%>
</body>
</html>错误提示
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: /zhuzhe1.jsp(6,0) File "/convert.jsp" not found
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:40)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:407)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:88)
org.apache.jasper.compiler.Parser.processIncludeDirective(Parser.java:345)
org.apache.jasper.compiler.Parser.parseIncludeDirective(Parser.java:378)
org.apache.jasper.compiler.Parser.parseDirective(Parser.java:486)
org.apache.jasper.compiler.Parser.parseElements(Parser.java:1444)
org.apache.jasper.compiler.Parser.parse(Parser.java:138)
org.apache.jasper.compiler.ParserController.doParse(ParserController.java:216)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:103)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:154)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:315)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:295)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:282)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:586)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.找半天找不出来,数据库连接也没问题呀
是否是路径错了
路径错误