我的环境为:
Eclipse+Tomcat+Lomboz +ORACLE
现在我单独写一个dbcon.java可以连接ORACLE,并显示数据;可是这不是在IE中显示的 ;
我想将这个查询的结果显示在IE中。
现在我做了一个测试的'欢迎使用IE'的Lombo Servlet Wizard可以在IE中显示;
可是我如何将dbcon.java中的内容显示在IE中啊!
dbcon.java中的内容如下:
package com.cownew.demo.p1;
import java.sql.*;
public class dbcon { /**
* @param args
*/
public static void main(String[] args) {
// TODO 自动生成方法存根
String sql="select dptno,dptnm from dptmst where dptyp='D'";
Connection con=null;
Statement st=null;
ResultSet rs=null; try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.3:1521:orcl", "test","123456");
st=con.createStatement();
rs=st.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getInt("dptno"));
System.out.println(rs.getString("dptnm"));
} }catch(Exception e) {e.printStackTrace();
}finally {try
{con.close(); }catch(Exception e) {}
try
{
st.close(); }catch(Exception e) { }
try {
rs.close(); }catch(Exception e) { } }
}
}index.jsp的内容为:
<!-- Copyright (c) 2002 by ObjectLearn. All Rights Reserved. --><html>
<head>
<title>Welcome</title>
</head>
<body>
<center>Welcome this is a test!! My name is Yang!</center>
</body>
</html>
我如何做才能将数据显示在IE中能?
Eclipse+Tomcat+Lomboz +ORACLE
现在我单独写一个dbcon.java可以连接ORACLE,并显示数据;可是这不是在IE中显示的 ;
我想将这个查询的结果显示在IE中。
现在我做了一个测试的'欢迎使用IE'的Lombo Servlet Wizard可以在IE中显示;
可是我如何将dbcon.java中的内容显示在IE中啊!
dbcon.java中的内容如下:
package com.cownew.demo.p1;
import java.sql.*;
public class dbcon { /**
* @param args
*/
public static void main(String[] args) {
// TODO 自动生成方法存根
String sql="select dptno,dptnm from dptmst where dptyp='D'";
Connection con=null;
Statement st=null;
ResultSet rs=null; try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.3:1521:orcl", "test","123456");
st=con.createStatement();
rs=st.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getInt("dptno"));
System.out.println(rs.getString("dptnm"));
} }catch(Exception e) {e.printStackTrace();
}finally {try
{con.close(); }catch(Exception e) {}
try
{
st.close(); }catch(Exception e) { }
try {
rs.close(); }catch(Exception e) { } }
}
}index.jsp的内容为:
<!-- Copyright (c) 2002 by ObjectLearn. All Rights Reserved. --><html>
<head>
<title>Welcome</title>
</head>
<body>
<center>Welcome this is a test!! My name is Yang!</center>
</body>
</html>
我如何做才能将数据显示在IE中能?
public static List obj()
{
String sql="select dptno,dptnm from dptmst where dptyp='D'";
Connection con=null;
Statement st=null;
ResultSet rs=null;
List list=new ArrayList();
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.3:1521:orcl", "test","123456");
st=con.createStatement();
rs=st.executeQuery(sql);
while(rs.next())
{
Object obj[]=new Object[2];
obj[0]=rs.getInt("dptno");
obj[1]=rs.getString("dptnm");
list.add(obj);
} }catch(Exception e) {e.printStackTrace();
}finally {try
{con.close(); }catch(Exception e) {}
try
{
st.close(); }catch(Exception e) { }
try {
rs.close(); }catch(Exception e) { } }
}
return list;
}
/**以下是jsp*/
<%
List list=dbcon.obj();
for(int i=0;i<list.size();i++)
{
Object obj[]=(Object[])list.get(i);
out.print(obj[0]+" "+obj[1]+"<br>");
}
%>
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.jsp.JspWriter;public class DbCon { // 注意这里的大小写
/**
* @param args
*/
public static void show(JspWriter out) {
// TODO 自动生成方法存根
String sql = "select dptno,dptnm from dptmst where dptyp='D'";
Connection con = null;
Statement st = null;
ResultSet rs = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.3:1521:orcl", "test", "123456");
st = con.createStatement();
rs = st.executeQuery(sql);
out.print("<table>");
while (rs.next()) {
out.print("<tr>");
out.println("<td>" + rs.getInt("dptno") + "</td>");
out.println("<td>" + rs.getString("dptnm") + "</td>");
out.print("</tr>");
}
out.print("</table>");
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
con.close();
} catch (Exception e) {}
try {
st.close();
} catch (Exception e) {}
try {
rs.close();
} catch (Exception e) {}
}
}
}index.jsp的内容为: <html>
<head>
<title> Welcome </title>
</head>
<body>
<center> Welcome this is a test!! My name is Yang! </center>
<%=com.cownew.demo.p1.DbCon.show(out)%>
</body>
</html>
{
Map map = new Map();
map.put("dptno",dptno);
map.put("dptnm",dptnm);
list.add(map); }
里面的 内容 封装到 List
在 jsp中 加 上
<%
for(int i = 0;i<list.size();i++)
{
Map map = (Map)list.get(i);
%>
<tr>
<td>
<%out.println(.....);%>
<td>
<tr>
<%
}
%>
在那里看看有无能回答你的,谢谢,LZ,甭忘了给俺分哦,谢谢LZ
http://topic.csdn.net/u/20080124/08/b14ab841-be1e-4d0d-b16e-52f77fd3a764.html?seed=1573367784
4楼的我按照你说做了,可是却又错误如下:type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSP:
JSP FileName:/index.jsp
Java FileName:/D:/eclipse/Tomcat 5.5/work/Catalina/localhost/YangTest//org/apache/jsp\index_jsp.javaAn error occurred at line: 9 in the jsp file: /index.jsp
The method print(boolean) in the type JspWriter is not applicable for the arguments (void)
6: </head>
7: <body>
8: <center>Welcome this is a test!! My name is Yang!</center>
9: <%=yangtest.Dbcon2.show(out)%>
10:
11: </body>
12: </html>
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:98)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:435)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:298)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:277)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:265)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:302)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.25 logs.
写这些资料的人的本意也是让更多的初学者能更快的入门。
olivesoup:不论你学习的再好,也会有一些问题是你解决不了的,你也不必再次为了夸耀而写这样危言耸听的话!
真诚的向你道歉!
我测试的时候总是报错!
代码也都贴上来吧,一并帮你解决了
package yangtest;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.jsp.JspWriter;public class Dbcon2 { /**
* @param args
*/
public static void show(JspWriter out) {
// TODO 自动生成方法存根
String sql = "select dptno,dptnm from dptmst where dptyp='D'";
Connection con = null;
Statement st = null;
ResultSet rs = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.183:1521:orcl", "beserp", "dsme");
st = con.createStatement();
rs = st.executeQuery(sql);
System.out.println("<table>");
while (rs.next()) {
System.out.println("<tr>");
System.out.println("<td>" + rs.getInt("dptno") + "</td>");
System.out.println("<td>" + rs.getString("dptnm") + "</td>");
System.out.println("</tr>");
}
System.out.println("</table>");
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
con.close();
} catch (Exception e) {}
try {
st.close();
} catch (Exception e) {}
try {
rs.close();
} catch (Exception e) {}
} }}index.jsp内容如下:
<!-- Copyright (c) 2002 by ObjectLearn. All Rights Reserved. --><html>
<head>
<title>Welcome</title>
</head>
<body>
<center>Welcome this is a test!! My name is Yang!</center>
<%=yangtest.Dbcon2.show(out)%>
</body>
</html>
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSP:
JSP FileName:/index.jsp
Java FileName:/D:/eclipse/Tomcat 5.5/work/Catalina/localhost/YangTest//org/apache/jsp\index_jsp.javaAn error occurred at line: 9 in the jsp file: /index.jsp
The method print(boolean) in the type JspWriter is not applicable for the arguments (void)
6: </head>
7: <body>
8: <center>Welcome this is a test!! My name is Yang!</center>
9: <%=yangtest.Dbcon2.show(out)%>
10:
11: </body>
12: </html>
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:98)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:435)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:298)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:277)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:265)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:302)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.25 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.5.25
yewen1027的方法是能出来的<!-- Copyright (c) 2002 by ObjectLearn. All Rights Reserved. --><html>
<head>
<title> Welcome </title>
</head>
<body>
<center> Welcome this is a test!! My name is Yang! </center> <%
java.util.List list=yangtest.Dbcon2.Dbcon2.show();
for(int i=0;i <list.size();i++){
out.print(list.get(i)+" <br> ");
}
%></body>
</html>package yangtest;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.jsp.JspWriter; public class Dbcon2 { /**
* @param args
*/
public static List<String> show(JspWriter out) {
// TODO 自动生成方法存根
String sql = "select dptno,dptnm from dptmst where dptyp='D'";
Connection con = null;
Statement st = null;
ResultSet rs = null;
List<String> list = new ArrayList<String>();
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.183:1521:orcl", "beserp", "dsme");
st = con.createStatement();
rs = st.executeQuery(sql);
System.out.println(" <table> ");
while (rs.next()) {
list.add(rs.getString("dptno"));
list.add(rs.getString("dptnm"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
con.close();
} catch (Exception e) {}
try {
st.close();
} catch (Exception e) {}
try {
rs.close();
} catch (Exception e) {}
} } }
我的是两个包。
按照你的一样的,我测试了,报错!
如下:HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSP:
JSP FileName:/index.jsp
Java FileName:/D:/eclipse/Tomcat 5.5/work/Catalina/localhost/YangTest//org/apache/jsp\index_jsp.javaAn error occurred at line: 10 in the jsp file: /index.jsp
The type com.sun.tools.javac.util.List cannot be resolved. It is indirectly referenced from required .class files
7: <body>
8: <center>Welcome this is a test!! My name is Yang!</center>
9: <%
10: java.util.List listOne=yangtest.Dbcon2.show();
11: for(int i=0;i <listOne.size();i++){
12: out.print(listOne.get(i)+" <br> ");
13: }
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:98)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:435)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:298)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:277)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:265)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:302)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.25 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.5.25
将
public static List<String> show(JspWriter out)
改成
public static List<String> show() 刚一时疏忽,给你发错了
错误如下:
[COVALENT-DEBUG] JSP Compile Error:
JSP FileName:/index.jsp
Java FileName:/D:/eclipse/Tomcat 5.5/work/Catalina/localhost/YangTest//org/apache/jsp\index_jsp.javaAn error occurred at line: 10 in the jsp file: /index.jsp
YangTest.src.yangtest.Dbcon2.Dbcon2 cannot be resolved to a type
7: <body>
8: <center>Welcome this is a test!! My name is Yang!</center>
9: <%
10: java.util.List list=YangTest.src.yangtest.Dbcon2.Dbcon2.show();
11: for(int i=0;i <list.size();i++){
12: out.print(list.get(i)+" <br> ");
13: }2008-1-28 17:06:57 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet jsp threw exception
org.apache.jasper.JasperException: Unable to compile class for JSP:
JSP FileName:/index.jsp
Java FileName:/D:/eclipse/Tomcat 5.5/work/Catalina/localhost/YangTest//org/apache/jsp\index_jsp.javaAn error occurred at line: 10 in the jsp file: /index.jsp
YangTest.src.yangtest.Dbcon2.Dbcon2 cannot be resolved to a type
7: <body>
8: <center>Welcome this is a test!! My name is Yang!</center>
9: <%
10: java.util.List list=YangTest.src.yangtest.Dbcon2.Dbcon2.show();
11: for(int i=0;i <list.size();i++){
12: out.print(list.get(i)+" <br> ");
13: }
Stacktrace:
at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:98)
at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
at org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:435)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:298)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:277)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:265)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:302)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)
先把jsp的<%
java.util.List list=yangtest.Dbcon2.Dbcon2.show();
for(int i=0;i <list.size();i++){
out.print(list.get(i)+" <br> ");
}
%>这部分去掉看出错不