<html>
<head>
<title>登录检查</title>
<%@ page session="true" %>
<%@ page contentType="text/html;charset=gb2312" %>
<%@page import="test.chatreg"%></head><body bgcolor="#ccccff"><%@ page language="java" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.sql.*" %>
<%
String regName=(String)request.getParameter("username");
regName=regName.trim();
String regPassword=(String)request.getParameter("password");
regPassword=regPassword.trim(); String regEmail=(String)request.getParameter("useremail");
regEmail=regEmail.trim(); String regHomepage=(String)request.getParameter("homepage");
regHomepage=regHomepage.trim();
%> <% String sql="select * from chao where username='" + regName + "'";
Connection conn = null;
ResultSet rs = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("chao: " + e.getMessage());
}
try {
conn = DriverManager.getConnection(jdbc:odbc:chao);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
if(rs.next()) { rs.close();
out.println("<center><h2 >对 不 起, 你 的 大 名 已 经 存 在</h2> </center><br> <br>");
out.println( "<center><a href=\"reg.jsp\" > 重 新 注 册 </a></center><br> ");
out.println( "<center><a href=\"chao.jsp\" > 我 不 注 册 了 </a></center> ");
}
else
{
String strSQL="insert into chao(username , password , email ,homepage ) values('" + regName + "', '" + regPassword +"' , '" + regEmail + "' , '" + regHomepage + "') ";
reg.executeQuery(strSQL);
out.println("<center><h2 color=red>恭 喜 你 注 册 成 功 !</h2> </center><br> <br>");
out.println( "<center><a href=\"chao.jsp?regName\" > 返回 </a></center> ");
}
%>
</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: Unable to compile class for JSPAn error occurred at line: 35 in the jsp file: /web/regcof.jspGenerated servlet error:
[javac] Compiling 1 source fileC:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\myapp\org\apache\jsp\web\regcof_jsp.java:95: ')' expectedAn error occurred at line: 35 in the jsp file: /web/regcof.jspGenerated servlet error:
conn = DriverManager.getConnection(jdbc:odbc:chao);
^
1 error
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:127)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:351)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:458)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:553)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:291)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
<head>
<title>登录检查</title>
<%@ page session="true" %>
<%@ page contentType="text/html;charset=gb2312" %>
<%@page import="test.chatreg"%></head><body bgcolor="#ccccff"><%@ page language="java" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.sql.*" %>
<%
String regName=(String)request.getParameter("username");
regName=regName.trim();
String regPassword=(String)request.getParameter("password");
regPassword=regPassword.trim(); String regEmail=(String)request.getParameter("useremail");
regEmail=regEmail.trim(); String regHomepage=(String)request.getParameter("homepage");
regHomepage=regHomepage.trim();
%> <% String sql="select * from chao where username='" + regName + "'";
Connection conn = null;
ResultSet rs = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("chao: " + e.getMessage());
}
try {
conn = DriverManager.getConnection(jdbc:odbc:chao);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
if(rs.next()) { rs.close();
out.println("<center><h2 >对 不 起, 你 的 大 名 已 经 存 在</h2> </center><br> <br>");
out.println( "<center><a href=\"reg.jsp\" > 重 新 注 册 </a></center><br> ");
out.println( "<center><a href=\"chao.jsp\" > 我 不 注 册 了 </a></center> ");
}
else
{
String strSQL="insert into chao(username , password , email ,homepage ) values('" + regName + "', '" + regPassword +"' , '" + regEmail + "' , '" + regHomepage + "') ";
reg.executeQuery(strSQL);
out.println("<center><h2 color=red>恭 喜 你 注 册 成 功 !</h2> </center><br> <br>");
out.println( "<center><a href=\"chao.jsp?regName\" > 返回 </a></center> ");
}
%>
</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: Unable to compile class for JSPAn error occurred at line: 35 in the jsp file: /web/regcof.jspGenerated servlet error:
[javac] Compiling 1 source fileC:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\myapp\org\apache\jsp\web\regcof_jsp.java:95: ')' expectedAn error occurred at line: 35 in the jsp file: /web/regcof.jspGenerated servlet error:
conn = DriverManager.getConnection(jdbc:odbc:chao);
^
1 error
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:127)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:351)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:458)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:553)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:291)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
括号匹配不上。
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(jdbc:odbc:chao);
改成conn = DriverManager.getConnection("jdbc:odbc:chao"); ?