java与sqlserver 2008_使用java连接sqlserver2008 R2/sqlserver2008

package com.product.jdbc.dbutil;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class DemoConn {

Connection conn = null;

static {

try {

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");// 加载数据库驱动

System.out.println("数据库驱动加载成功!!!--sqlserver");

} catch (ClassNotFoundException e) {

e.printStackTrace();

}

}

public Connection DemoConn() {

String url = "jdbc:sqlserver://213-PC:1433; DatabaseName=Movie";

String userName = "sa";

String passWord = "123";

try {

conn = DriverManager.getConnection(url, userName, passWord);// 获取数据库连接

if (conn != null) {

System.out.println("数据库连接成功!!!--sqlserv