Java连接Sql Server数据库

1. import java.sql.*;
3. public class T {
4.     public static void main(String[] args) {
5.         String sql;
6.         Connection conn;
7.         Statement stmt; // 声明Statement对象
8.         ResultSet rs;
9.         try {
10.             Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
11.             String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=shopping";
12.             String user = "sa";
13.             String password = "sa";
14.             conn = DriverManager.getConnection(url, user, password);
15.             stmt = conn.createStatement();
16.             sql = "select * from Users";
17.             rs = stmt.executeQuery(sql);
18.             while (rs.next()) {
19.                 System.out.println(rs.getString(1)); // 输出数据库第一列
20.                 System.out.println(rs.getString(2));
21.             }
22.             rs.close();
23.             stmt.close();
24.             conn.close();
25.         } catch (Exception e) {
26.             e.printStackTrace();
27.         }
29.     }
30. }