java 和 sql 的连接_Java JDBC - 如何使用JDBC和ODBC连接到SQL Express

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.Statement;

public class Main {

public static void main(String args[]) throws Exception {

Connection conn = null;

Statement s = null;

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

conn = DriverManager

.getConnection("jdbc:odbc:Driver={SQL Server};"

+ "Server=.\\SQLEXPRESS;" + "Trusted_Connection=yes;"

+ "Database=myDb");

s = conn.createStatement();

s.executeQuery("SELECT * FROM dbo.SalesSummary WHERE 0 = 1");

ResultSet rs = s.getResultSet();

ResultSetMetaData rsmd = rs.getMetaData();

for (int i = 1; i <= rsmd.getColumnCount(); i++) {

System.out.println(String.format("-- Column %d --", i));

System.out

.println(String.format("Column name: %s", rsmd.getColumnName(i)));

System.out.println(String.format("Database-specific type name: %s",

rsmd.getColumnTypeName(i)));

System.out.println(String.format("Column size (DisplaySize): %d",

rsmd.getColumnDisplaySize(i)));

System.out.println(String.format("java.sql.Type of column: %d",

rsmd.getColumnType(i)));

System.out.println();

}

s.close();

conn.close();

}

}