yutao 2008-4-12 20:43
数据库问题
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!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>
<%
String yonghu=request.getParameter("f5.t11.value");
String mima=request.getParameter("f5.p11.value");
String querenmima=request.getParameter("f5.p22.value");
String xingbie=request.getParameter("f5.r1.value");
String di=request.getParameter("f5.t0.value");
String you=request.getParameter("f5.youxiang.value");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:db3");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("SELECT * FROM y where 用户名='"+yonghu+"'");
if(rs.next())
{
out.print("有相同的用户名");
}
else
{
String ss="insert into y(用户名，密码，确认密码，性别,联系地址,电子邮箱)"+" values ('"+yonghu+"','"+mima+"','"+querenmima+"','"+xingbie+"','"+
di+"','"+you+"')";
st.executeUpdate(ss);
out.print("注册成功");
con.close();
}
%>
</body>
</html>
出现这样的错误org.apache.jasper.JasperException: An exception occurred processing JSP page /ch22/zhucechuli.jsp at line 30
27: {
28: String ss="insert into y(用户名，密码，确认密码，性别,联系地址,电子邮箱)"+" values ('"+yonghu+"','"+mima+"','"+querenmima+"','"+xingbie+"','"+
29: di+"','"+you+"')";
30: st.executeUpdate(ss);
31: out.print("注册成功");
32: con.close();
33: }
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause
javax.servlet.ServletException: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 查询值的数目与目标字段中的数目不同。
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.ch22.zhucechuli_jsp._jspService(zhucechuli_jsp.java:97)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 查询值的数目与目标字段中的数目不同。
sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Unknown Source)
org.apache.jsp.ch22.zhucechuli_jsp._jspService(zhucechuli_jsp.java:83)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs.