package com.wy.tool;数据库加载失败?哪里错了?我用的是struct+jsp+sql server2008
import java.sql.*;public class JDBConnection {
private String dbDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; // 数据库的驱动 private String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_shopping"; // URL地址 public Connection connection = null; public JDBConnection() {
try {
Class.forName(dbDriver).newInstance(); // 加载数据库驱动
connection = DriverManager.getConnection(url, "sa", "123"); // 加载数据库
} catch (Exception ex) {
System.out.println("数据库加载失败");
}
}
}
import java.sql.*;public class JDBConnection {
private String dbDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; // 数据库的驱动 private String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_shopping"; // URL地址 public Connection connection = null; public JDBConnection() {
try {
Class.forName(dbDriver).newInstance(); // 加载数据库驱动
connection = DriverManager.getConnection(url, "sa", "123"); // 加载数据库
} catch (Exception ex) {
System.out.println("数据库加载失败");
}
}
}
解决方案 »
- 一直未解决的问题~求解答
- POI 格式设置问题
- 请问如何将网页里的东西导出.chm格式的文件
- struts2 页面全变成流的形式输出 这个问题有人遇到过吗
- jsp用javabean取空值怎么处理,求各位高手请教!!!
- j2sdk1.4.2_08编译中出现的问题,高手解答!
- 如何在struts中获得上传图片的内容
- timer为什么运行了2次
- 给学生XDJM推荐个地方,申请PHP,,jsp,asp空间,优惠!!
- 斑竹答题大家接分,WebViewFolderIcon使用遇难题,存为本地文件好用,放在服务器上就不好用了
- 各位大虾,问一个简单的问题,我发布WEB后,tomacate出现如下提示,无法浏览到网页。
- 如何制作网页游戏
System.out.println("数据库加载失败");
System.out.println(ex.getMessage());
}
DriverManager不需要定义啊
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=Shopping" ;
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:419)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause java.lang.NullPointerException
com.wy.dao.GoodsDao.selectMark(GoodsDao.java:52)
org.apache.jsp.index_jsp._jspService(index_jsp.java:70)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.26 logs.
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:419)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause java.lang.NullPointerException
com.wy.dao.GoodsDao.selectMark(GoodsDao.java:52)
org.apache.jsp.index_jsp._jspService(index_jsp.java:70)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.26 logs.
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:419)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause java.lang.NullPointerException
com.wy.dao.GoodsDao.selectMark(GoodsDao.java:52)
org.apache.jsp.index_jsp._jspService(index_jsp.java:70)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.26 logs.