mysql2008安装包百度云_求个SQL server 2008 64位安装包,急用急用,最好是百度云盘,拜托了...

驱动类：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:1433;DatabaseName=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！~

取消

评论