java使用JDBC方式和JDBC-ODBC桥连接sqlserver数据库

来源：互联网发布：工信部办公软件样本编辑：程序博客网时间：2024/05/16 06:24

一. 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();
   }
  }

}