那个驱动注册的好像被注释了吧,你看的是不是
企业门户新闻网\src\com\wsy\Connsqlserver.java
我看这个源码里那一段被注释了
/*try {
cn = DriverManager.getConnection("proxool.net");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
企业门户新闻网\src\com\wsy\Connsqlserver.java
我看这个源码里那一段被注释了
/*try {
cn = DriverManager.getConnection("proxool.net");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
解决方案 »
- 求助, applet可以再appletvrever中显示,网页中只有一块灰色
- struts2 标签 combobox
- 一个子框架中的from,在另一个子框架中提交,在线等
- CSDN中资源下载里留言功能????
- 薪资管理系统
- 帮忙解决下 如何控制对话框?
- 不知不觉凌晨4点了,还没有搞定,请高手指点,估计是配置问题,但是.....
- 关于finally{}的问题
- 请教高手:怎样将JDBC的驱动程序放到服务器的类路径里去,什么是服务器的类路径,一般在什么地方?
- 大对象入库问题,报“读取违反顺序“的错误!请经历过同样问题的同仁指点!
- 我想用java做一个音乐网站。真心想学。对这个特别感兴趣。。。。
- maven使用内嵌tomcat问题
at org.apache.naming.NamingContext.lookup(NamingContext.java:770)
at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
at com.wsy.Connsqlserver.getConnection(Connsqlserver.java:30)
at com.wsy.Connsqlserver.executeQuery(Connsqlserver.java:51)
at com.wsy.Selectsql.selectNews(Selectsql.java:138)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:108)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.wsy.Filter.ModifyCode.doFilter(ModifyCode.java:23)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1774)
at java.lang.Thread.run(Thread.java:619)
java.lang.NullPointerException
at com.wsy.Connsqlserver.executeQuery(Connsqlserver.java:53)
at com.wsy.Selectsql.selectNews(Selectsql.java:138)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:108)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.wsy.Filter.ModifyCode.doFilter(ModifyCode.java:23)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1774)
at java.lang.Thread.run(Thread.java:619)
然后开始纠正错误!
1、更改WEB-INF\web.xml里
<res-ref-name>jdbc/ConnectionPool</res-ref-name>
为
<res-ref-name>TestJNDI</res-ref-name>
【吐槽】傻逼作者,编译后的Connsqlserver.class文件找的是TestJNDI,可是他给的配置文件却是jdbc/ConnectionPool,老子反编译class才发现的,源码是jdbc/ConnectionPool,狗日的!!!脑子被门挤了!!
2、发现META-INF\context.xml文件里的url读取不到,我各种方式都试过了,文件名Content.xml首字母要大写了,修改Context.xml后要清除tomcat\conf\Catalina\localhost\项目名称.xml了,连接sqlserver2000和2005的驱动写法不同了,我都试过,俩字:无效!!!!最后把context.xml的内容写到tomcat\conf\server.xml才生效具体如下<Context path="/" docBase="这里写你项目的位置">
<Resource name="TestJNDI" type="javax.sql.DataSource" auth="Container" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://localhost:1433;DatabaseName=db_net" username="sa" password="111" maxActive="100" maxIdle="30" maxWait="6000" />
</Context>插播一句:我的sqlserver2008是vs2010自带的,无法导入分离的数据库,老子又去装了个SSMS,这一节就不吐槽了,以后总用得上。
最后老子终于打开那个页面了,艹,睡觉去!
帐号:mr
密码:mrsoft
输入下面的密码一样可以登录'or '1'='1
好了,开始上班,我就不找它的毛病了