读书人

关于jsp连oracle的有关问题

发布时间: 2013-09-11 18:34:25 作者: rapoo

关于jsp连oracle的问题?
我用的jsp连oracle的类是conn.java

package com.qingsoft.ga.utils;

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class conn {

java.sql.Connection Conn = null;
javax.sql.DataSource ds = null;
java.sql.ResultSet rs = null;

public conn() {
try {
Class.forName( "oracle.jdbc.driver.OracleDriver ");
String user = "system ";
String password = "manager ";
Conn = DriverManager.getConnection( "jdbc:oracle:thin:@192.168.1.18:1521:MYORACLE ",user, password);
} catch (Exception e) {
Conn = null;
System.out.print( "Error To Create Connection ");
}
}

public ResultSet executeQuery(String sql) {
rs = null;
try {
Statement stmt = Conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
Conn = null;
rs = null;
System.err.println( "aq.execute-Query: " + ex.getMessage());
}
return rs;

}

}
主页index.jsp中的3个iframe是
dwml.jsp
<%@ page language= "java " contentType= "text/html;charset=gb2312 " import= "java.sql.* "%>
<jsp:useBean id= "dbconn " class= "com.qingsoft.ga.utils.conn " scope= "page "/>
<link href= "images/css.css " rel= "stylesheet " type= "text/css " />
<SCRIPT language=JavaScript>
function openwin(code)
{
var wincode;
wincode=code;
//window.open( "khfa.jsp?id= ' "+wincode+ " ' ", "khfa ", " ");
//window.open( "khjg.jsp?id= ' "+wincode+ " ' ", "khjg ", " ");
document.getElementById( "khfa ").src = "khfa.jsp?id= ' "+wincode+ " ' ";
document.getElementById( "khjg ").src = "khjg.jsp?id= ' "+wincode+ " ' ";
}
</script>
<%!
ResultSet rst=null ;
%>
<%
try
{
String code=request.getParameter( "id ");
if(code==null){
code= "420100000001 ";
}
ResultSet rst=dbconn.executeQuery( "select CORP_NAME,CORP_CODE from T_B_CORP where SUP_CORP_CODE= ' "+code+ " ' and IS_USE= '1 ' ");
if(rst==null){
out.println( "暂时没有单位! ");


}else{
%>
<table width= "100% ">
<%
rst.last(); // 将 Cursor 移到最后
int size = rst.getRow(); // 取得记录数
rst.beforeFirst(); // 将 Cursor 移到初始状态
for(int i =1;i <=size;i++)
{if(i % 4 == 1){
%>
<tr>
<td> <a href= "javascript:openwin( <%=rst.getString( "CORP_CODE ")%> ) " class= "txt "> <%=rst.getString( "CORP_NAME ")%> </a> </td>
<%}
else if (i % 4 == 0){
%> <td> <a href= "javascript:openwin( <%=rst.getString( "CORP_CODE ")%> ) " class= "txt "> <%=rst.getString( "CORP_NAME ")%> </a> </td> </tr>
<%
}
else{
%>
<td> <a href= "javascript:openwin( <%=rst.getString( "CORP_CODE ")%> ) " class= "txt "> <%=rst.getString( "CORP_NAME ")%> </a> </td>
<%
}
}
%>
</table>
<%
rst.close();
}
}
catch(Exception e)
{
e.printStackTrace();
}
%>



[解决办法]
root cause

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 13 in the jsp file: /test.jsp
Generated servlet error:
system.out cannot be resolved to a type
已经告诉你了system.out的问题.
一定注意大小写:System.out
我的异常网推荐解决方案:org.apache.jasper.JasperException: Unable to compile class,http://www.myexception.cn/j2ee/2308.html

读书人网 >Java Web开发

热点推荐