81,116
社区成员
发帖
与我相关
我的任务
分享请问jsp大虾：在*.jsp文件中可以有自己独立编写的类吗？
我的程序如下：
register.jsp
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312"%>
<html>
<head>
<title>register</title>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
</head>
<body bgcolor="#FFFFFF">
<%
class db{
Connection con;
Statement st;
ResultSet rs;
db(){
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();
}
}
db mysql=new db();
try{
mysql.st=mysql.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") +");";
mysql.st.executeQuery(strsql);
//st.executeQuery("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");");
//System.out.println(mysql.rs.getString(1));
} 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>
结果出现下列问题
Internal Servlet Error:
org.apache.jasper.JasperException: Unable to compile class for JSPC:\jakarta-tomcat-3.2.3\work\localhost_8080%2Fexamples\_0002fregister_0002ejspregister_jsp_0.java:90: Type expected.
try{
^
1 error
请问这是什么原因呢？期待着您的解答！
register.jsp
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312"%>
<html>
<head>
<title>register</title>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
</head>
<body bgcolor="#FFFFFF">
<%
class db{
Connection con;
Statement st;
ResultSet rs;
db(){
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();
}
}
db mysql=new db();
try{
mysql.st=mysql.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") +");";
mysql.st.executeQuery(strsql);
//st.executeQuery("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");");
//System.out.println(mysql.rs.getString(1));
} 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>
结果出现下列问题
Internal Servlet Error:
org.apache.jasper.JasperException: Unable to compile class for JSPC:\jakarta-tomcat-3.2.3\work\localhost_8080%2Fexamples\_0002fregister_0002ejspregister_jsp_0.java:90: Type expected.
try{
^
1 error
请问这是什么原因呢？期待着您的解答！
...全文
请发表友善的回复…
发表回复
yanghui88 2001-08-22
- 打赏
- 举报
也可以不一定要是bean,做成类,放在classpath其中的一个目录下,然后在.jsp文件开头就象平时import一样import进来就可以了
<%@ page import="java.sql.*,java.io.*,javax.naming.*,javax.sql.*,java.util.*" %>
<%@ page import="java.sql.*,java.io.*,javax.naming.*,javax.sql.*,java.util.*" %>
rinehart 2001-08-22
- 打赏
- 举报
还是把要用的类做成bean吧！
hexiaofeng 2001-08-22
- 打赏
- 举报
class db
{
Connection con;
Statement st;
ResultSet rs;
db()
{
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();
}
}
}
少了一个"}"
{
Connection con;
Statement st;
ResultSet rs;
db()
{
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();
}
}
}
少了一个"}"
skyyoung 2001-08-22
- 打赏
- 举报
类不行，方法可以，但两者都不提倡。
