大家帮我看一下我的这段连接数据库的 代码那里错了? <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 JSPAn error occurred at line: 11 in the jsp file: /index1.jspGenerated servlet error:
[javac] Compiling 1 source fileC:\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.jspGenerated 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.jspGenerated 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.jspGenerated 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)
<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 JSPAn error occurred at line: 11 in the jsp file: /index1.jspGenerated servlet error:
[javac] Compiling 1 source fileC:\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.jspGenerated 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.jspGenerated 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.jspGenerated 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)
解决方案 »
- 为什么iframe的width height 设为100% iframe不见了?
- SSH2下注解的方式上传文件如何配置?
- 简单问题,如何实现下拉框 的 单击事件?
- 请教高手hibernate+spring 对于里面saveOrUpdate()方法,session不能同步数据库问题?
- 弹出模态窗口后,点击提交后如何关闭当前的模态窗口?也不要弹出另外的一个页面?
- 有谁知道Token怎么写的啊
- 谁有好的jsf教程?要pdf文档的
- 验证位置问题
- 7桥问题,图论,关系路近求解
- 谁有struts框架作的例子或者程序?(越详细越好)高分相送。
- jsp中页面间传递数据,字符编码问题
- 菜鸟求救,javascript中的传值问题
jsp:
out.println(rset.getString(2));