该程序用于测量Microsoft SQL Server 2005中的nterLib数据库,里面的表tb_booktype中的内容,效果如下:
代码如下:
package database;
import java.sql.*;
public class ConnDB {
public static void main(String args[]) {
String driverClass = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=InterLib";
String username = "admin";
String password = "123456";
try {
Class.forName(driverClass);
Connection dbConn = DriverManager.getConnection(url, username,
password);
Statement stmt = dbConn.createStatement();
ResultSet rs = stmt.executeQuery("select * from tb_booktype");
System.out.println("SQL2005连接成功!</p>");
System.out.println(" --- tb_booktype表中的内容如下:----");
while (rs.next()) {
System.out.println("<br>编号: " + rs.getString(1) + " 书名:"
+ rs.getString(2) + " 价格:" + rs.getString(3));
}
rs.close();
stmt.close();
dbConn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
将driverClass和url改成如下语句,也可以实现数据库的连接:
String driverClass="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:odbc:InterLib";