jsp下访问数据库出现未见过的错误，哪为大虾能帮忙看一看？

littledapan 2001-08-21 03:48:27

我的程序结构如下
apply.html
<html>
<meta HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<nobr><center>Welcome to register<hr color=green>
<font color=green>welcome to ecogrid
</font>
<form method=post action=register.jsp>
<table width=600>
<tr><td align=right>Account:<td align=left><input name=account size=30 maxlength=20>
<tr><td align=right>Password:<td align=left><input type=password name=passwd size=30 maxlength=20>
<tr><td align=right>Password:<td align=left><input type=password name=passwd1 size=30 maxlength=20>
<tr><td align=right>Name:<td align=left><input name=name size=30 maxlength=20>
<tr><td align=right>Company:<td align=left><input name=company size=30 maxlength=40>
<tr><td align=right>Ecogrid_card:<td align=left><input name=ecogrid_card size=30 maxlength=20>
<tr><td align=right>Ecogrid_password:<td align=left><input type=password name=ecogrid_passwd size=30 maxlength=20>
<tr><td align=right>Ecogrid_password:<td align=left><input type=password name=ecogrid_passwd1 size=30 maxlength=20>
<tr><td align=right>email:<td align=left><input name=email size=30 maxlength=40>

</table>
<P>
<input type=submit value=Submit>

<input type=reset value=Reset>
</P>
</form></center>
</html>
访问mysql的jsp程序如下：
<html>
<head>
<title>register</title>
<meta http-equiv="Content-Type" content="text/html;charset=big5">
</head>
<body bgcolor="#FFFFFF">

<%@ page import java.sql.* %>
<%@ page contentType="text/html;charset=gb2312"%>
<%
Connection con;
Statement st;
ResultSet rs;

try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();

//加载 mm.mysql.driver
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/ecogrid","dapan","780318");
//创建数据库联接
}
catch (Exception R)
{
System.err.println("Unable to load driver.");
R.printStackTrace();

}
try{
st=con.createStatement();
String strsql = "insert into jobapply(account,passwd,name,company,ecogrid_card,ecogrid_passwd,email) VALUES(" + request.getParameter("account") + "," + request.getParameter("passwd") + "," + request.getParameter("name") + "," + request.getParameter("ecogrid_card") + "," + request.getParameter("ecogrid_passwd") + "," + request.getParameter("email") +";"
st.executeQuery(strsql);

} catch (SQLException E)
{
System.out.println("hi");
System.out.println("SQLException: " + E.getMessage());
System.out.println("SQLState: " + E.getSQLState());
System.out.println("VendorError: " + E.getErrorCode());
}

%>
</body>
</html>
结果出现下列错误很是奇怪：
Error: 500
Location: /examples/register.jsp
Internal Servlet Error:

org.apache.jasper.compiler.ParseException: C:\jakarta-tomcat-3.2.3\webapps\examples\register.jsp(7,17) Attribute import has no value
at org.apache.jasper.compiler.JspReader.parseAttributeValue(JspReader.java:519)
at org.apache.jasper.compiler.JspReader.parseTagAttributes
等等
请问高手知道这是什么错误吗？

...全文

104 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

fandiy 2001-08-22

打赏
举报

<%
Connection con=null;
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/ecogrid","dapan","780318");
}
catch (Exception R)
{
System.err.println("Unable to load driver.");
R.printStackTrace();
}
try
{
Statement st=con.createStatement();
String strsql = "insert into jobapply values (account,passwd,name,company,ecogrid_card,ecogrid_passwd,email) VALUES('" + request.getParameter("account") + "','" + request.getParameter("passwd") + "','" + request.getParameter("name") + "','" + request.getParameter("ecogrid_card") + "','" + request.getParameter("ecogrid_passwd") + "','" + request.getParameter("email") +"');";
st.executeUpdate(strsql);
st.close();
con.close();
}
catch(Exception e)
{
out.println(e.getMessage());
}
%>

littledapan 2001-08-21

打赏
举报

修改后出现了新问题
org.apache.jasper.JasperException: Unable to compile class for JSPC:\jakarta-tomcat-3.2.3\work\localhost_8080%2Fexamples\_0002fregister_0002ejspregister_jsp_0.java:80: Undefined variable: st
st=con.createStatement();
^
C:\jakarta-tomcat-3.2.3\work\localhost_8080%2Fexamples\_0002fregister_0002ejspregister_jsp_0.java:80: Undefined variable or class name: con
st=con.createStatement();
^
C:\jakarta-tomcat-3.2.3\work\localhost_8080%2Fexamples\_0002fregister_0002ejspregister_jsp_0.java:81: Undefined variable or class name: st
st.executeQuery(strsql);
^
C:\jakarta-tomcat-3.2.3\work\localhost_8080%2Fexamples\_0002fregister_0002ejspregister_jsp_0.java:82: Exception java.sql.SQLException is never thrown in the body of the corresponding try statement.
} catch (SQLException E)
^

vdragon 2001-08-21