文件名称:sql2000-JDBC驱动
文件大小:355KB
文件格式:RAR
更新时间:2012-05-11 11:18:32
java,jdbc驱动,sql2000,chendy
sql2000的JDBC驱动程序
连接方法:
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bookDB";
String userName = "chendy";
String userPwd = "123456";
Connection dbConn = null;
Statement stat = null;
ResultSet rs = null;
try {
Class.forName(driverName);
System.out.println("加载驱动成功");
dbConn = DriverManager.getConnection(dbURL,userName,userPwd);
System.out.println("连接数据库成功");
stat = dbConn.createStatement();
System.out.println("创建语句对象成功!
");
rs = stat.executeQuery("select * from book");
while(rs.next())
{
for(int i = 1;i <= 5;i++)
System.out.println(rs.getString(i)+" ");
}
}catch (Exception e) {}
【文件预览】:
sql2000驱动程序
----mssqlserver.jar(65KB)
----msbase.jar(280KB)
----msutil.jar(58KB)