又遇到问题了,Java连接Oracle时出错,大家帮忙看看哈,谢谢哈。
配置文件连接语句代码如下:
DBType=3OracleDriver=oracle.jdbc.driver.OracleDriver
OracleURL=jdbc:oracle:thin:@localhost:1521:XE
datasource.username=system
datasource.password=yaoyao123456
Java类中读取数据代码如下:
package dataConn;
import java.io.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;import javax.servlet.*;
import javax.servlet.http.*;public class GetData extends HttpServlet {
DBConnection DBConn = new DBConnection();
public ResultSet rs =null;
public Connection con=null;
public Statement st=null;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException{ response.setContentType("text/xml;charset=utf-8");
response.setHeader("Cache-Control", "no-cache");
String content = "";
String name="";
String id="";
String detail="";
try{
Connection condb = DBConn.getConn();
st = condb.createStatement();
rs=st.executeQuery("select * from TBLABEQU");
while(rs.next()){
id = rs.getString("LabEquID");
name = rs.getString("LabEquName");
detail = rs.getString("LabEquDtl");
content+="<equlist><id>"+id+"</id><name>"+name+"</name><detail>"+
detail+"</detail></equlist>";
}
}catch( SQLException e1){
e1.printStackTrace();
}
content="<?xml version=\"1.0\" encoding=\"utf-8\"?><equlists>"+content;
content+="</equlists>"; System.out.println(content);
response.getWriter().write(content);
}
} 错误信息:
严重: Servlet.service() for servlet GetData threw exception
java.lang.NullPointerException
at dataConn.GetData.doGet(GetData.java:31)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
配置文件连接语句代码如下:
DBType=3OracleDriver=oracle.jdbc.driver.OracleDriver
OracleURL=jdbc:oracle:thin:@localhost:1521:XE
datasource.username=system
datasource.password=yaoyao123456
Java类中读取数据代码如下:
package dataConn;
import java.io.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;import javax.servlet.*;
import javax.servlet.http.*;public class GetData extends HttpServlet {
DBConnection DBConn = new DBConnection();
public ResultSet rs =null;
public Connection con=null;
public Statement st=null;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException{ response.setContentType("text/xml;charset=utf-8");
response.setHeader("Cache-Control", "no-cache");
String content = "";
String name="";
String id="";
String detail="";
try{
Connection condb = DBConn.getConn();
st = condb.createStatement();
rs=st.executeQuery("select * from TBLABEQU");
while(rs.next()){
id = rs.getString("LabEquID");
name = rs.getString("LabEquName");
detail = rs.getString("LabEquDtl");
content+="<equlist><id>"+id+"</id><name>"+name+"</name><detail>"+
detail+"</detail></equlist>";
}
}catch( SQLException e1){
e1.printStackTrace();
}
content="<?xml version=\"1.0\" encoding=\"utf-8\"?><equlists>"+content;
content+="</equlists>"; System.out.println(content);
response.getWriter().write(content);
}
} 错误信息:
严重: Servlet.service() for servlet GetData threw exception
java.lang.NullPointerException
at dataConn.GetData.doGet(GetData.java:31)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
解决方案 »
- oracle 10g 10.1.0.2.0版本的数据库怎么恢复到10.2.0.1的数据库上?
- 有关pl\sql调试 设断点,运行至断点处
- oracle 10G XE 老是报这样的错 求帮助
- 请教一个SQL语句
- Oracle8.16如何还原数据库呀,我只有一个.dmp文件?
- 安装oracle8I死机
- 求把一数据库表迅速导出oracle成为标准文本文件的方法
- 请问Oracle中有没有把一个字符型转换成整型的函数呀 ?
- job_queue_processes与job?
- 紧急求救,oracle临时表空间快慢了,怎么办??!在线等待回答??!
- 安装oracle 10g问题
- 【高手们请】如果我向数据库中某表批量导入了一批数据,最后我忘记了COMMIT(或永不提交,或放弃),这样子的话,
Connection condb = DBConn.getConn();
st = condb.createStatement();
可能是连接oracle没有成功,返回null对象了。
把该方法( DBConn.getConn();)的内容贴出来看看。
at dataConn.GetData.doGet(GetData.java:31)
这事哪一行?另外,格里的字段名全部改成大写,小写或混和oracle取不出来的。要么就得用1/2/3:
id = rs.getString("LabEquID");
name = rs.getString("LabEquName");
detail = rs.getString("LabEquDtl");
他的31行,藐视是这两行中的一行(我推算的)。
Connection condb = DBConn.getConn();
st = condb.createStatement();
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716