java 怎么调用 vf数据库文件

显示全部楼层 · 2007-12-4 17:38:04

public class DBA { private String user = "db2inst1"; // 用户名 private String pwd = "1";// 密码 private String url = "jdbc:db2:web";// 连接地址字符串 private String driver = "COM.ibm.db2.jdbc.app.DB2Driver";// 连接驱动架包 private Connection conn;// 连接 private Statement sta;// 会话 private ResultSet res;// 结果 public static DBA dba; public DBA() {try { Class.forName(driver); conn = DriverManager.getConnection(url, user, pwd); System.out.println("conn db2 success"); sta = conn.createStatement();} catch (ClassNotFoundException e) { System.out.println("「错误: 缺少架包支持」"); e.printStackTrace();} catch (SQLException e) { System.out.println("「错误: 用户名密码登陆错误」"); e.printStackTrace();} } public ResultSet querry(String sql) {try { res = sta.executeQuery(sql);} catch (SQLException e) { System.out.println("「错误：您输入的sql语句无法执行!!! 」"); e.printStackTrace();}return res; } public int update(String sql) {int flag = -1;// 执行结果返回为0则sql语句可正确执行只是不满足条件// 为-1 则表示sql语句有错误无法执行try { flag = sta.executeUpdate(sql);} catch (SQLException e) { System.out.println("「错误：您输入的sql语句无法执行!!! 」"); e.printStackTrace();}return flag; } public Connection conn() {return conn; } public void close() {try { if (res != null) {
res.close(); } if (sta != null) {
sta.close(); } if (conn != null) {
conn.close(); }} catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace();} }}

千问 · 2007-12-4 17:38:04

通过JDBC-ODBC桥去连接。