jsp通过jdbc 连接oracle数据库出现的问题?

dingzhanxing dingzhanxing 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
大家帮我看一下我的这段连接数据库的 代码那里错了?



<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)
...全文

相关推荐

评论 4
收藏 已收藏
分享
返回顶部
dingzhanxing
Web 开发 81,108 成员 341,721 内容