java连接Oracle数据库问题
五月 23, 2016 11:09:27 上午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet [HANA.HanaInputOracle] in context with path [/JAVA_HANA] threw exception
java.lang.NullPointerException
at HANA.HanaInputOracle.doPost(HanaInputOracle.java:59)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
这是报错信息,以下是相对应的java文件
package HANA;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
Servlet implementation class HanaInputOracle
*/
@WebServlet("/HanaInputOracle")
public class HanaInputOracle extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
@see HttpServlet#HttpServlet()
*/
HanaInputOracle() {
super();
// TODO Auto-generated constructor stub
}
/**
@see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
response)
*/
void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
}
/**
@see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
response)
*/
void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
ORACLE oarcle = new ORACLE();
Connection conn = oarcle.connoracle();
PreparedStatement st = null;
USER user = (USER) request.getSession().getAttribute("zb");
String INSERT = "insert into SCM_S901 VALUES('" + user.getSPMON() + "','" + user.getSPTAG() + "','"
user.getVTWEG() + "','" + user.getMATNR() + "','" + user.getZXSJE() + "')";
//String SEC = "select * from SAPRED.S901 where SPMON='201506'";
{
// st.executeUpdate(SEC);
st.executeUpdate(INSERT);
response.sendRedirect("../result.jsp");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
response.sendRedirect("../error.jsp");
}
}
}
相关阅读:
jquery 选择器 去掉 首尾元素
angularjs新手 模块的config方法不执行
PHP GnuPG迁移问题
为什么
标签不能在css中设置color?
CNAME未检测到配置,请稍后再试。
pyspark如何一次提交多个文件?
动态语言使用JIT技术重新实现一次有什么优势?
为什么会出现 invalid operands 的问题?
有哪些值得一读的不使用 this 和原型,而使用闭包进行面向对象封装的 JS 项目
请问有计算"工作日"(非节假日)的工具么?
vc开发一个小型的http服务器
JSP里执行js的window.onload()方法异常
lua中的迭代器、闭包、table
Object是怎样构建原型链的?
Echarts API 中图表行为的理解
Hashmap Key的范围?
PHP程序运行的时候,既然是每一个HTTP请求对应一个数据库PDO连接对象实例
web消息通知系统设计问题
如何获取嵌套的 frame 中的元素?
如何计算出没有分配出去的IP地址