Java用ODBC连接数据库错误，求解决

Question

private static Connection conn = null;
private static String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
public static Connection getConnection(){
try{
Class.forName(driver).newInstance();
conn = DriverManager.getConnection("jdbc:odbc:hello");
if(conn!=null){
System.out.println("连接sql server数据库成功！");
}
}catch(Exception ex){
ex.printStackTrace();
System.out.println(ex.getMessage());
}
return conn;
}
ODBC连接测试时提示错误：[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server 不存在或访问被拒绝
求解答！最好能具体点

Answer 1

import java.sql.*;
/**
* 利用JDBC连接数据库
* @author Administrator
*
*/
public class JDBConnection {

public static Connection getConn() {
String dbDriver = "com.mysql.jdbc.Driver"; // 定义数据库的驱动
String url = "jdbc:mysql://localhost:3306/shopping"; // 定义URL地址
Connection connection = null;
try {
Class.forName(dbDriver).newInstance(); // 加载数据库驱动
connection = DriverManager.getConnection(url, "root", "root"); // 加载数据库
} catch (Exception e) {
System.out.println("数据库加载失败");
}
return connection;
}

public static void close(Connection connection) {
try {
if(connection != null) {
connection.close();
connection = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}

public static void close(Statement ps) {
try {
if(ps != null) {
ps.close();
ps = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}

public static void close(ResultSet rs) {
try {
if(rs != null) {
rs.close();
rs = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}