eclipse webservices发布时候总是连接不到sql2008数据库

java
package data;

import java.sql.*;

public class Test {

public static void main(String[] srg) {

String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动

String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=test"; //连接服务器和数据库test

String userName = "sa"; //默认用户名
String userPwd = "123456789"; //密码
Connection dbConn;

try {

Class.forName(driverName);

dbConn = DriverManager.getConnection(dbURL, userName, userPwd);

System.out.println("Connection Successful!"); //如果连接成功 控制台输出Connection Successful!

} catch (Exception e) {

e.printStackTrace();
}
}
}

jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">



hello


<%
Statement sql;
ResultSet rs;
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动

String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=test"; //连接服务器和数据库sample

String userName = "sa"; //默认用户名

String userPwd = "123456789"; //密码

Connection dbConn;

try {

Class.forName(driverName);

dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
sql=dbConn.createStatement();
rs=sql.executeQuery("select*from table");
System.out.println("Connection Successful!"); //如果连接成功 控制台输出Connection Successful!
out.println("

");
out.println("");
out.println("");
out.println("");
out.println("");
out.println("");
while(rs.next())
{
out.println("");
out.println("");
out.println("");
out.println("");
}
out.println("
用户数据
idname
"+rs.getString(1)+""+rs.getString(2)+"
");
dbConn.close();
} catch (Exception e) {

e.printStackTrace();

}

%>

java application能运行出结果也可以发布但是就是显示没有连接到数据库数据库我也是用用户名密码登陆。
图片说明

图片说明
求大神求解！

你sqlserver的jdbc驱动包没加进来.

希望能够帮到你...

图片说明