SqlServer2008 jdbc 连接所需jar和代码示例_sqlserver 2008 jar版本-CSDN博客

本文介绍了如何使用Java的JDBC连接SQLServer2008数据库，提供了详细的代码示例，包括数据库URL、用户名、密码以及驱动加载和数据库连接的方法。在`testConnection`方法中，展示了查询student表并打印姓名的步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package model;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.junit.Test;

public class TestConn2005 {

private Connection conn = null;
private String url="jdbc:sqlserver://localhost:1433;DatabaseName=base1";
private String USER = "sa";
private String PASSWORD = "sa";
private String driver ="com.microsoft.jdbc.sqlserver.SQLServerDriver";

public void getConnection() {
   try {
    Class.forName(driver);
   } catch (ClassNotFoundException e) {
    System.out.println("****加载驱动失败****");
   }
   try {
    conn =DriverManager.getConnection(url,USER,PASSWORD);
   } catch (SQLException e) {
    System.out.println("****连接失败****");
   }

}

public void testConnection() throws Exception {
  if (conn == null)
   this.getConnection();
   String sql = "select * from student";
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(">>>"+rs.getString("姓名"));
   }
   rs.close();
   stmt.close();

}

public static void main(String[] args) throws Exception {
  TestConn2005 bean = new TestConn2005();
  bean.testConnection();
}

}