急用java 连接sql server 2008 的驱动包，以及java代码的数据库连接之前的驱动安装位置和方法！

驱动类：com.microsoft.sqlserver.jdbc.SQLServerDriver

链接方法：jdbc:sqlserver://IP:端口DatabaseName=数据库

public class DB {

Statement stmt

String mc

Connection conn = null

CachedRowSetImpl crs

public static String url = "jdbc:sqlserver://127.0.0.1:1433DatabaseName=test"

public static String user = "sa"

public static String password = "123"

public DB() {}

public CachedRowSetImpl dbquery(String sqlstr){//查询时调用该方法

System.out.println("-*-*-*-*-*-*-*-chaxun-*-*-*-*-*-*-*" + sqlstr)

try

{

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance()

conn= DriverManager.getConnection(url,user,password)

stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE)

crs=new CachedRowSetImpl()

ResultSet rs=stmt.executeQuery(sqlstr)

crs.populate(rs)

if(rs!=null)

{

rs.close()

stmt.close()

rs=null

stmt=null

}

conn.close()

}catch(Exception e)

{

System.out.println("s4:"+e.toString())

//e.printStackTrace()

}

return crs

}

public void dbexe(String sqlstr){//用于增加、删除、修改

System.out.println("-*-*-*-*-*-*-*-caozuo-*-*-*-*-*-*-*" + sqlstr)

try

{

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance()

conn= DriverManager.getConnection(url,user,password)

stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE)

stmt.execute(sqlstr)

stmt.close()

conn.close()

}

catch(Exception e)

{

System.out.println(e.toString())

}

}

}

驱动包你给我 留个联系方式我发给你！

有问题可百度Hi我！good luck！~

用 sqljdbc4.jar 这个包

驱动代码：

String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"

String connectionUrl = "jdbc:sqlserver://localhost:1433" +

"databaseName=aauser=Yjpassword=123456"

con = DriverManager.getConnection(connectionUrl)

---