jsp通过jdbc 连接oracle数据库出现的问题?
大家帮我看一下我的这段连接数据库的 代码那里错了?
<html>
<body>
<%@ page language = "java" import = "java.sql.*"%>
<%
try{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//连结数据库,格式为(”jdbc:oracle:thin:@主机host:端口号:数据库名”,”用户名”,”密码”)
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:myora","sys","87409031");
//创建SQL语句
Statement stmt=conn.createStatement();
//处理查询结果
ResultSet rset=stmt.executeQuery("select * from ding");
while(rset.next())
System.out.println(rset.getString(2));
rset.close();
stmt.close();
conn.close();
System.out.println("linked ok");
}catch(Exception e){
out.println("SQLException:" + e);
}
%>
</body>
</html>
错误提示;
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 11 in the jsp file: /index1.jsp
Generated servlet error:
[javac] Compiling 1 source file
C:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\index1_jsp.java:59: illegal character: \161
??
^
An error occurred at line: 11 in the jsp file: /index1.jsp
Generated servlet error:
C:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\index1_jsp.java:59: illegal character: \161
??
^
An error occurred at line: 11 in the jsp file: /index1.jsp
Generated servlet error:
C:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\index1_jsp.java:82: illegal character: \161
}??
^
An error occurred at line: 11 in the jsp file: /index1.jsp
Generated servlet error:
C:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\index1_jsp.java:82: illegal character: \161
}??
^
4 errors
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:83)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:315)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:406)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:463)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:442)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:430)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:274)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)