java sqlserver odbc_java使用JDBC方式和JDBC-ODBC桥连接sqlserver数据库 | 学步园

一. java连接sqlserver，jdbc方式。

/*

* @SuppressWarnings("unchecked") public static void oracleConnKey() {

* String driver = "oracle.jdbc.driver.OracleDriver", url =

* "jdbc:oracle:thin:@localhost:1521:ORCL", user = "danfoss", pwd =

* "danfoss"; DatabaseBean databaseBean = new DatabaseBean(driver, url,

* user, pwd); try { final String SQL = "select count(*) from mm_lot"; List

* list = databaseBean.queryForList(SQL, new Object[] {}); for (int i = 0; i

* < list.size(); i++) { Map map = (Map) list.get(i);

* System.out.println(map.get("COUNT(*)")); } } catch (Exception e) {

* e.printStackTrace(); } }

*

* @SuppressWarnings("unchecked") public static void sqlServerConnKey() {

* String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver", //

* 172.31.5.130 ; 192.168.1.106 url =

* "jdbc:sqlserver://localhost:1433;DatabaseName=danfoss_sap", user = "sa",

* pwd = "1234567890";

*

* DatabaseBean databaseBean = new DatabaseBean(driver, url, user, pwd); try

* { final String SQL = "select count(*) FROM V_Item"; List list =

* databaseBean.queryForList(SQL, new Object[] {}); for (int i = 0; i <

* list.size(); i++) { Map map = (Map) list.get(i);

*

* System.out.print("ItemCode = " + map.get("ItemCode"));

* System.out.print(" UserText = " + map.get("UserText"));

* System.out.print(" U_TS_BBH = " + map.get("U_TS_BBH"));

* System.out.print(" ItemName = " + map.get("ItemName"));

* System.out.print(" InvntryUom = " + map.get("InvntryUom"));

* System.out.print(" SalPackUn = " + map.get("SalPackUn"));

* System.out.println();

*

* System.out.print(" count = " + map.get("")); } } catch (Exception e) {

* e.printStackTrace(); } }

*/

驱动程序使用的是sqljdbc4.jar 这个包在我的资源里可以下载

二. 下面的方法使用的是jdbc-odbc桥方式连接本机的sqlserver数据源，不需要驱动程序。

public static void main(String[] args) {

Connection connection = null;

Statement statement = null;

try {

// 1.加载驱动

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

connection = DriverManager.getConnection("jdbc:odbc:danfoss_sap",

"sa", "1234567890");

statement = connection.createStatement();

ResultSet resultSet = statement

.executeQuery("select * FROM V_Item");

while (resultSet.next()) {

System.out.println(resultSet.getString(1));

}

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

if (statement != null) {

(statement).close();

}

if (connection != null) {

connection.close();

}

} catch (Exception e) {

e.printStackTrace();

}

}

}