登 录
package mypackage;<br /> import java.sql.*;<br /> public class DB {<br /> String sDBDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";</p> <p> //String sConnStr = "jdbc:sqlserver://PC--20110331FNJ:1433;databaseName=productShowSys;integratedSecurity=true;";<br /> String sConnStr = "jdbc:odbc:mydb";<br /> Connection conn = null;<br /> Statement stmt = null;<br /> ResultSet rs = null;<br /> public DB() {<br /> try {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");<br /> //Class.forName(sDBDriver);<br /> } catch (java.lang.ClassNotFoundException e) {<br /> e.printStackTrace();<br /> }<br /> }<br /> public ResultSet executeQuery(String sql) {<br /> rs = null;<br /> try {<br /> conn = DriverManager.getConnection(sConnStr);<br /> stmt = conn.createStatement();<br /> rs = stmt.executeQuery(sql);<br /> } catch (SQLException ex) {<br /> ex.printStackTrace();<br /> }<br /> return rs;<br /> }<br /> public void executeUpdate(String sql) {<br /> rs = null;<br /> try {<br /> conn = DriverManager.getConnection(sConnStr);<br /> stmt = conn.createStatement();<br /> stmt.executeUpdate(sql);<br /> } catch (SQLException ex) {<br /> ex.printStackTrace();<br /> }<br /> }<br /> public void close() {<br /> try {<br /> if (stmt != null) {<br /> stmt.close();<br /> stmt = null;<br /> }<br /> if (conn != null) {<br /> conn.close();<br /> }<br /> } catch (Exception e) {<br /> System.err.println("??��????????????????????: " + e.getMessage());<br /> }<br /> }<br /> }<br />
JAVA ODBC 连接SQLSERVER2008
以后对于任何集成的SQLSERVER用户，都用ODBC 连接数据库
抱歉!评论已关闭.