使用JDBC访问SQLServer 2008

使用JDBC访问SQLServer 2008

// 准备数据库驱动程序
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
// 加载数据库驱动程序
Class.forName(driver);

// 准备连接参数
String connectionUrl = "jdbc:sqlserver://localhost:1433;DatabaseName=tempDB";
String user = "xxx";
String password = "xxx";
// 创建数据库连接
Connection connection = null;
connection = DriverManager.getConnection(connectionUrl, user, password);
// 
Statement statement = null;
statement = connection.createStatement();
String sql = "SELECT * FROM YourTable;";
// 获取查询结果 
ResultSet resultSet = null;
resultSet = statement.executeQuery(sql);
// 处理结果集 
while(resultSet.next()){
}
// 释放SQL资源，关闭连接
resultSet.close();
statement.close();
connection.close();