 |
|
|
 首页 |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
package spider.tools; import java.sql.*; public class DBTools { public static final int ORACLE = 0; public static final int SQLSERVER = 1; private static String oracleDriver = "oracle.jdbc.driver.OracleDriver"; private static String sqlserverDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; public Connection createConnection(String host, String dataBase, String user, String password, int dbKind) { Connection result = null; String dbUrl = null; String dbDriver = null; if (dbKind == ORACLE) { dbUrl = createOracleUrl(host, dataBase); dbDriver = oracleDriver; } else if (dbKind == SQLSERVER) { dbUrl = createSqlserverUrl(host, dataBase); dbDriver = sqlserverDriver; } else { MyUtil.log( "initial database connection failure: " + "Unsupport data base!"); return null; } try { Class.forName(dbDriver); result = DriverManager.getConnection(dbUrl, user, password); } catch (Exception e) { MyUtil.log( "initial database connection failure: " + e.toString()); return null; } return result; } public String createOracleUrl(String host, String dataBase) { String oracleUrl = "jdbc:oracle:thin:@" + host + ":1521:" + dataBase; return oracleUrl; } public String createSqlserverUrl(String host, String dataBase) { String sqlServerUrl = "jdbc:microsoft:sqlserver://" + host + ":1433;DatabaseName=" + dataBase; return sqlServerUrl; } public boolean isTableExist(Connection cnn, String table) { boolean result = false; String strSQL = "select * from sysobjects where id=object_id(\\\'" + table + "\\\')"; Statement st = null; ResultSet rs = null; try { st = cnn.createStatement(); rs = st.executeQuery(strSQL); if(rs.next()) result = true; } catch (SQLException ex) { MyUtil.log("Error happen when check table existance! table name: " + table); } finally { if (st != null) { try { st.close(); } catch (SQLException ex1) {} } if (rs != null) { try { rs.close(); } catch (SQLException ex1) {} } } return result; } public boolean clearTable(Connection cnn, String table) { if (!isTableExist(cnn, table)) return false; boolean flag = true; PreparedStatement ps = null; try { ps = cnn.prepareStatement("delete from " + table); ps.executeUpdate(); } catch (Exception e) { flag = false; } finally { if (ps != null) { try { ps.close(); } catch (SQLException ex) {} } } return flag; } } 返回类别: 教程 上一教程: 问题：Thread .Sleep(500)后你的线程睡了多久？ 下一教程: Java 调用存储过程 您可以阅读与"java链接数据库的工具类"相关的教程: · 关于JAVA中连接各类数据库的代码及其补充说明 · JAVA成功访问SQL SERVER 2000数据库的方式 · 在java应用程序中显示数据库的blob图像 · [分享]eclipse 3.0 中jre设置的小错误导致在java文件中连接数据库失败 · 利用JAVABEAN轻松实现对数据库的连接、查询以及增删改 |
  |
| 快精灵印艺坊 版权所有 |
首页 会员中心在线印刷在线编辑付款方式索取样品设计指南连锁门店
|
||
