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)
<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)
...全文
相关推荐
jsp连接数据库大全
### JSP连接数据库大全#### 一、JSP连接Oracle 8/8i/9i 数据库(使用Thin模式)在使用JSP连接Oracle数据库时,我们通常采用JDBC驱动来实现这一目标。
JDBC驱动各种数据库方法
例如,Oracle可能需要TNS连接字符串,而MSSQL可能使用TCP/IP连接。同时,不同的数据库对参数化查询的支持也略有差异,如Oracle的?
简单模糊查询,是关于java和Oracle的一个模糊查询
**JDBC连接Oracle**: 首先,我们需要在Java代码中加载Oracle的JDBC驱动,并建立到数据库的连接。
Java jdbc数据库连接池总结
多数据库服务器和多用户:对于大型的企业级应用,常常需要同时连接不同的数据库(如连接 Oracle 和 Sybase)。如何连接不同的数据库呢?
JDBC.rar_jdbc登录_jdbc登录注册
JDBC为开发者提供了一种标准化的方法来连接、查询和操作各种关系型数据库,无论数据库系统是Oracle、MySQL、SQL Server还是其他。


Web 开发
