sqlserver java odbc_JAVA ODBC 连接SQLSERVER2008 | 学步园

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());

}

}

}

JAVA ODBC 连接SQLSERVER2008

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