JAVA ODBC 连接SQLSERVER2008

来源：互联网发布：连接sqlserver数据库编辑：程序博客网时间：2024/05/20 01:37

package mypackage;import java.sql.*;public class DB {String sDBDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //String sConnStr = "jdbc:sqlserver://PC--20110331FNJ:1433;databaseName=productShowSys;integratedSecurity=true;"; String sConnStr = "jdbc:odbc:mydb"; Connection conn = null; Statement stmt = null; ResultSet rs = null; public DB() { try {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //Class.forName(sDBDriver); } catch (java.lang.ClassNotFoundException e) { e.printStackTrace(); } } public ResultSet executeQuery(String sql) { rs = null; try { conn = DriverManager.getConnection(sConnStr); stmt = conn.createStatement(); rs = stmt.executeQuery(sql); } catch (SQLException ex) { ex.printStackTrace(); } return rs; } public void executeUpdate(String sql) { rs = null; try { conn = DriverManager.getConnection(sConnStr); stmt = conn.createStatement(); stmt.executeUpdate(sql); } catch (SQLException ex) { ex.printStackTrace(); } } public void close() { try { if (stmt != null) { stmt.close(); stmt = null; } if (conn != null) { conn.close(); } } catch (Exception e) { System.err.println("??��????????????????????: " + e.getMessage()); } }}

以后对于任何集成的SQLSERVER用户，都用ODBC 连接数据库