Java连接Sql Server数据库
[*]import java.sql.*;
[*]
[*]public class T {
[*] public static void main(String[] args) {
[*] String sql;
[*] Connection conn;
[*] Statement stmt; // 声明Statement对象
[*] ResultSet rs;
[*] try {
[*] Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
[*] String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=shopping";
[*] String user = "sa";
[*] String password = "sa";
[*] conn = DriverManager.getConnection(url, user, password);
[*] stmt = conn.createStatement();
[*] sql = "select * from Users";
[*] rs = stmt.executeQuery(sql);
[*] while (rs.next()) {
[*] System.out.println(rs.getString(1)); // 输出数据库第一列
[*] System.out.println(rs.getString(2));
[*] }
[*] rs.close();
[*] stmt.close();
[*] conn.close();
[*] } catch (Exception e) {
[*] e.printStackTrace();
[*] }
[*]
[*] }
[*]}
页:
[1]