jdbc连接mysql数据库 几个时候后 空指针异常_jdbc连接数据库空指针

第一句异常，java.lang.ClassNotFoundException:com.microsoft.sqlserver.jdbc.SQLServerDriver

找不到sqlserver驱动包……sqljdbc4.jar找这个包吧

回复

@不忘初心_且听风吟:java项目一般会建一个lib文件间存放jar包，然后添加的buildpath。web项目直接把jar包拷贝到WEB-INF/lib下面就可以了。回复

@不忘初心_且听风吟:要拷到lib下。我能不能问一下关于导入包的问题，是只需要在构建路径里导入就行了呢。还是需要再把包拷入WEB-INF/lib文件夹？没连接sqlserver的jar包，连接失败，然后导致查不到数据，你的bean就是为空，引用空的对象，报空指针

我能不能问一下关于导入包的问题，是只需要在构建路径里导入就行了呢。还是需要再把包拷入WEB-INF/lib文件夹？jar包拷贝到lib目录回复

@不忘初心_且听风吟:看了你下面的截图，没必要的哈还需要在构建路径里导入吗

引用来自“muzifeng78186948”的评论没连接sqlserver的jar包，连接失败，然后导致查不到数据，你的bean就是为空，引用空的对象，报空指针

包已经拷到lib文件夹下了构建路径里也导入了tomcat也重启了源码也重新编译了为什么还是不行？

四月05,20164:48:09下午org.apache.tomcat.util.digester.SetPropertiesRulebegin警告:[SetPropertiesRule]{Server/Service/Engine/Host/Context}Settingproperty'source'to'org.eclipse.jst.jee.server:JavaServlet'didnotfindamatchingproperty.四月05,20164:48:09下午org.apache.catalina.startup.VersionLoggerListenerlog信息:Serverversion:ApacheTomcat/8.0.32四月05,20164:48:09下午org.apache.catalina.startup.VersionLoggerListenerlog信息:Serverbuilt:Feb2201619:34:53UTC四月05,20164:48:09下午org.apache.catalina.startup.VersionLoggerListenerlog信息:Servernumber:8.0.32.0四月05,20164:48:09下午org.apache.catalina.startup.VersionLoggerListenerlog信息:OSName:Windows7四月05,20164:48:09下午org.apache.catalina.startup.VersionLoggerListenerlog信息:OSVersion:6.1四月05,20164:48:09下午org.apache.catalina.startup.VersionLoggerListenerlog信息:Architecture:x86四月05,20164:48:09下午org.apache.catalina.startup.VersionLoggerListenerlog信息:JavaHome:D:\jdk8\jre四月05,20164:48:09下午org.apache.catalina.startup.VersionLoggerListenerlog信息:JVMVersion:1.8.0_45-b15四月05,20164:48:09下午org.apache.catalina.startup.VersionLoggerListenerlog信息:JVMVendor:OracleCorporation四月05,20164:48:09下午org.apache.catalina.startup.VersionLoggerListenerlog信息:CATALINA_BASE:D:\MyJava\.metadata\.plugins\org.eclipse.wst.server.core\tmp0四月05,20164:48:09下午org.apache.catalina.startup.VersionLoggerListenerlog信息:CATALINA_HOME:D:\apache-tomcat-8.0.32四月05,20164:48:09下午org.apache.catalina.startup.VersionLoggerListenerlog信息:Commandlineargument:-Dcatalina.base=D:\MyJava\.metadata\.plugins\org.eclipse.wst.server.core\tmp0四月05,20164:48:09下午org.apache.catalina.startup.VersionLoggerListenerlog信息:Commandlineargument:-Dcatalina.home=D:\apache-tomcat-8.0.32四月05,20164:48:09下午org.apache.catalina.startup.VersionLoggerListenerlog信息:Commandlineargument:-Dwtp.deploy=D:\MyJava\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps四月05,20164:48:09下午org.apache.catalina.startup.VersionLoggerListenerlog信息:Commandlineargument:-Djava.endorsed.dirs=D:\apache-tomcat-8.0.32\endorsed四月05,20164:48:09下午org.apache.catalina.startup.VersionLoggerListenerlog信息:Commandlineargument:-Dfile.encoding=GBK四月05,20164:48:09下午org.apache.catalina.core.AprLifecycleListenerlifecycleEvent信息:TheAPRbasedApacheTomcatNativelibrarywhichallowsoptimalperformanceinproductionenvironmentswasnotfoundonthejava.library.path:D:\jdk8\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;D:/jdk8/bin/../jre/bin/client;D:/jdk8/bin/../jre/bin;D:/jdk8/bin/../jre/lib/i386;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\ProgramFiles(x86)\NVIDIACorporation\PhysX\Common;D:\SQL2010\共享功能目录\100\Tools\Binn\;D:\SQL2010\100\Tools\Binn\;D:\SQL2010\100\DTS\Binn\;D:\SQL2010\共享功能目录\100\Tools\Binn\VSShell\Common7\IDE\;C:\ProgramFiles(x86)\MicrosoftVisualStudio9.0\Common7\IDE\PrivateAssemblies\;D:\SQL2010\共享功能目录\100\DTS\Binn\;D:\jdk8\bin;D:\apache-maven-3.3.9\bin;D:\eclipse-sss\eclipse-jee-mars-2-win32\eclipse-jee-mars-2-win32;;.四月05,20164:48:09下午org.apache.coyote.AbstractProtocolinit信息:InitializingProtocolHandler["http-nio-8080"]四月05,20164:48:09下午org.apache.tomcat.util.net.NioSelectorPoolgetSharedSelector信息:Usingasharedselectorforservletwrite/read四月05,20164:48:09下午org.apache.coyote.AbstractProtocolinit信息:InitializingProtocolHandler["ajp-nio-8009"]四月05,20164:48:09下午org.apache.tomcat.util.net.NioSelectorPoolgetSharedSelector信息:Usingasharedselectorforservletwrite/read四月05,20164:48:09下午org.apache.catalina.startup.Catalinaload信息:Initializationprocessedin542ms四月05,20164:48:09下午org.apache.catalina.core.StandardServicestartInternal信息:StartingserviceCatalina四月05,20164:48:09下午org.apache.catalina.core.StandardEnginestartInternal信息:StartingServletEngine:ApacheTomcat/8.0.32四月05,20164:48:09下午org.apache.catalina.util.SessionIdGeneratorBasecreateSecureRandom信息:CreationofSecureRandominstanceforsessionIDgenerationusing[SHA1PRNG]took[156]milliseconds.四月05,20164:48:10下午org.apache.jasper.servlet.TldScannerscanJars信息:AtleastoneJARwasscannedforTLDsyetcontainednoTLDs.EnabledebugloggingforthisloggerforacompletelistofJARsthatwerescannedbutnoTLDswerefoundinthem.SkippingunneededJARsduringscanningcanimprovestartuptimeandJSPcompilationtime.四月05,20164:48:10下午org.apache.coyote.AbstractProtocolstart信息:StartingProtocolHandler["http-nio-8080"]四月05,20164:48:10下午org.apache.coyote.AbstractProtocolstart信息:StartingProtocolHandler["ajp-nio-8009"]四月05,20164:48:10下午org.apache.catalina.startup.Catalinastart信息:Serverstartupin602mscom.microsoft.sqlserver.jdbc.SQLServerException:无法打开登录所请求的数据库"TestNXSC"。登录失败。ClientConnectionId:7e753b99-2f56-44d4-86f0-492f110efcd0atcom.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)atcom.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)atcom.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)atcom.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)atcom.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)atcom.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)atjava.sql.DriverManager.getConnection(DriverManager.java:664)atjava.sql.DriverManager.getConnection(DriverManager.java:247)atcom.bean.SqlBean.(SqlBean.java:27)atorg.apache.jsp.SearchList_jsp._jspService(SearchList_jsp.java:143)atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:729)atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:729)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)atorg.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)atorg.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)atorg.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)atorg.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)atorg.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)atorg.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)atorg.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)atorg.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)atjava.lang.Thread.run(Thread.java:745)四月05,20164:48:22下午org.apache.catalina.core.StandardWrapperValveinvoke严重:Servlet.service()forservlet[jsp]incontextwithpath[/JavaServlet]threwexception[java.lang.NullPointerException]withrootcausejava.lang.NullPointerExceptionatcom.bean.SqlBean.getSearch(SqlBean.java:200)atorg.apache.jsp.SearchList_jsp._jspService(SearchList_jsp.java:158)atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:729)atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:729)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)atorg.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)atorg.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)atorg.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)atorg.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)atorg.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)atorg.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)atorg.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)atorg.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)atjava.lang.Thread.run(Thread.java:745)com.microsoft.sqlserver.jdbc.SQLServerException:无法打开登录所请求的数据库"TestNXSC"。登录失败。ClientConnectionId:44a14f26-dcdc-413f-bb32-e75328ee6e95atcom.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)atcom.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)atcom.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)atcom.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)atcom.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)atcom.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)atjava.sql.DriverManager.getConnection(DriverManager.java:664)atjava.sql.DriverManager.getConnection(DriverManager.java:247)atcom.bean.SqlBean.(SqlBean.java:27)atorg.apache.jsp.SearchList_jsp._jspService(SearchList_jsp.java:143)atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:729)atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:729)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)atorg.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)atorg.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)atorg.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)atorg.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)atorg.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)atorg.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)atorg.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)atorg.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)atjava.lang.Thread.run(Thread.java:745)四月05,20164:48:31下午org.apache.catalina.core.StandardWrapperValveinvoke严重:Servlet.service()forservlet[jsp]incontextwithpath[/JavaServlet]threwexception[java.lang.NullPointerException]withrootcausejava.lang.NullPointerExceptionatcom.bean.SqlBean.getSearch(SqlBean.java:200)atorg.apache.jsp.SearchList_jsp._jspService(SearchList_jsp.java:158)atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:729)atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:729)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)atorg.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)atorg.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)atorg.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)atorg.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)atorg.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)atorg.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)atorg.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)atorg.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)atjava.lang.Thread.run(Thread.java:745)com.microsoft.sqlserver.jdbc.SQLServerException:无法打开登录所请求的数据库"TestNXSC"。登录失败。ClientConnectionId:d58b16a2-938b-470b-816b-b6746fc1dcbfatcom.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)atcom.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)atcom.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)atcom.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)atcom.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)atcom.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)atjava.sql.DriverManager.getConnection(DriverManager.java:664)atjava.sql.DriverManager.getConnection(DriverManager.java:247)atcom.bean.SqlBean.(SqlBean.java:27)atorg.apache.jsp.SearchList_jsp._jspService(SearchList_jsp.java:143)atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:729)atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:729)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)atorg.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)atorg.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)atorg.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)atorg.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)atorg.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)atorg.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)atorg.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)atorg.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)atjava.lang.Thread.run(Thread.java:745)四月05,20164:49:47下午org.apache.catalina.core.StandardWrapperValveinvoke严重:Servlet.service()forservlet[jsp]incontextwithpath[/JavaServlet]threwexception[java.lang.NullPointerException]withrootcausejava.lang.NullPointerExceptionatcom.bean.SqlBean.getSearch(SqlBean.java:200)atorg.apache.jsp.SearchList_jsp._jspService(SearchList_jsp.java:158)atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:729)atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:729)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)atorg.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)atorg.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)atorg.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)atorg.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)atorg.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)atorg.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)atorg.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)atorg.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)atjava.lang.Thread.run(Thread.java:745)四月05,20164:49:50下午org.apache.catalina.core.StandardContextreload信息:ReloadingContextwithname[/JavaServlet]hasstarted四月05,20164:49:50下午org.apache.catalina.loader.WebappClassLoaderBaseclearReferencesJdbc警告:Thewebapplication[JavaServlet]registeredtheJDBCdriver[com.microsoft.sqlserver.jdbc.SQLServerDriver]butfailedtounregisteritwhenthewebapplicationwasstopped.Topreventamemoryleak,theJDBCDriverhasbeenforciblyunregistered.四月05,20164:49:50下午org.apache.catalina.loader.WebappClassLoaderBasecheckThreadLocalMapForLeaks严重:Thewebapplication[JavaServlet]createdaThreadLocalwithkeyoftype[com.microsoft.sqlserver.jdbc.ActivityCorrelator$1](value[com.microsoft.sqlserver.jdbc.ActivityCorrelator$1@64d275])andavalueoftype[com.microsoft.sqlserver.jdbc.ActivityId](value[8b05b511-2eca-48be-939a-84ac97e85520-1])butfailedtoremoveitwhenthewebapplicationwasstopped.Threadsaregoingtoberenewedovertimetotryandavoidaprobablememoryleak.四月05,20164:49:50下午org.apache.catalina.loader.WebappClassLoaderBasecheckThreadLocalMapForLeaks严重:Thewebapplication[JavaServlet]createdaThreadLocalwithkeyoftype[com.microsoft.sqlserver.jdbc.ActivityCorrelator$1](value[com.microsoft.sqlserver.jdbc.ActivityCorrelator$1@64d275])andavalueoftype[com.microsoft.sqlserver.jdbc.ActivityId](value[27ea5514-ccb7-462a-91a1-77a6ad98b149-1])butfailedtoremoveitwhenthewebapplicationwasstopped.Threadsaregoingtoberenewedovertimetotryandavoidaprobablememoryleak.四月05,20164:49:50下午org.apache.catalina.loader.WebappClassLoaderBasecheckThreadLocalMapForLeaks严重:Thewebapplication[JavaServlet]createdaThreadLocalwithkeyoftype[com.microsoft.sqlserver.jdbc.ActivityCorrelator$1](value[com.microsoft.sqlserver.jdbc.ActivityCorrelator$1@64d275])andavalueoftype[com.microsoft.sqlserver.jdbc.ActivityId](value[efe0319f-99c5-4a34-bd92-a8b3e532f4a4-1])butfailedtoremoveitwhenthewebapplicationwasstopped.Threadsaregoingtoberenewedovertimetotryandavoidaprobablememoryleak.四月05,20164:49:50下午org.apache.jasper.servlet.TldScannerscanJars信息:AtleastoneJARwasscannedforTLDsyetcontainednoTLDs.EnabledebugloggingforthisloggerforacompletelistofJARsthatwerescannedbutnoTLDswerefoundinthem.SkippingunneededJARsduringscanningcanimprovestartuptimeandJSPcompilationtime.四月05,20164:49:50下午org.apache.catalina.core.StandardContextreload信息:ReloadingContextwithname[/JavaServlet]iscompleted

回复

@Im柏杨:感谢~原来是我数据库名写错了～　　　　学JAVA是不是英文不好不行啊~　　　　看不懂报错回复

@不忘初心_且听风吟:上面两个异常，一个是找不到数据库，说明你数据库连接肯定不对。其次nullpoint，说明你用了空对象。而且这个空对象估计就是你创建的连接，所以你先把数据库地址写对吧，大概是密码和库名哪里错了。回复

@县小闲:能连上啊表都建好了回复

@不忘初心_且听风吟:你确定你的数据库可以连接上？错误变成了这样~