见鬼了!见鬼了!jsp怎么都连不上sql2005!!
azg12 2012-05-17 05:15:12 package com.wy.tool;
import java.sql.*;
public class JDBConnection {
private final String url = "jdbc:sqlserver://localhost:1433;DatabaseName=db_BlodMay";
private final String userName = "sa";
private final String password = "111";
private Connection con = null;
// 通过构造方法加载数据库驱动
static {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver")
.newInstance();
} catch (Exception ex) {
System.out.println("数据库加载失败");
}
}
// 创建数据库连接
public boolean creatConnection() {
try {
con = DriverManager.getConnection(url, userName, password);
con.setAutoCommit(true);
} catch (Exception e) {
System.out.println(e.getMessage());
System.out.println("creatConnectionError!");
}
return true;
}
连接sql2005的驱动sqljdbc.jar 已经放入D:\apache-tomcat-7.0.11\webapps\111\WEB-INF\lib目录下,
而且写了另外一个小程序测试了一下,能连接到数据库,但是 一回到项目就连接不上,提示如下
数据库加载失败
No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_BlodMay
creatConnectionError!
2012-5-17 17:17:06 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet [ConsumerServlet] in context with path [/111] threw exception
java.lang.NullPointerException
谢谢各位了,帮忙看看~