首先下载sqljdbc4.jar包,注意只需要这一个jar包就行了,不要同时导入其他的驱动包了如sqljdbc.jar包,有可能会冲突
导入到(直接复制粘贴就行了),稍后我会附上下载地址
package com.beijing.manyi.utils;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class JdbcConnection {
private final static String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";//连接mySql数据库的驱动
private final static String url = "jdbc:sqlserver://192.168.6.2:1433;DatabaseName=数据库名";//1433是端口号
private final static String user = "sa";
private final static String password = "qaz!123";
static {
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection conn = null;
try {
conn = DriverManager.getConnection(url,user,password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static void close(Connection conn){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
参考:http://blog.csdn.net/stewen_001/article/details/19553173