java版sqlhelper

1、java版sqlhelper* 獵取一個(gè)具有更新功能的數(shù)據(jù)模型 假如只要讀取數(shù)據(jù)，就不要用它了 * param cmdtext 能返回一個(gè)數(shù)據(jù)集的查詢(xún)sql 語(yǔ)句 * return 表格數(shù)據(jù)模型 * dataset 沒(méi)有找到在哪個(gè)包中,由于臨時(shí)用不到所以省略此辦法 public static dataset getdataset(string cmdtext) statement stmt = getstatement(); dataset dbc = new dataset(); if (stmt = null) dbc.code = -2; return dbc; / 查詢(xún)語(yǔ)句 dbc.r

2、s = stmt.executequery(cmdtext); dbc.model = buildtablemodel(dbc.rs); dbc.code = dbc.model.getrowcount(); catch (sqlexception ex) logger.getlogger(sqlhelper.class.getname().log(level.severe, null, ex); dbc.code = -1; return dbc; * 獵取一個(gè)具有更新功能的數(shù)據(jù)模型 假如只要讀取數(shù)據(jù)，就不要用它了 * param conn 數(shù)據(jù)庫(kù)銜接 * param cmdtext 能返回

3、一個(gè)數(shù)據(jù)集的查詢(xún)sql 語(yǔ)句 * return 表格數(shù)據(jù)模型 * 同上一個(gè)辦法 public static dataset getdataset(connection conn, string cmdtext) statement stmt = getstatement(conn); dataset dbc = new dataset(); if (stmt = null) dbc.code = -2; return dbc; / 查詢(xún)語(yǔ)句 dbc.rs = stmt.executequery(cmdtext); dbc.model = buildtablemodel(dbc.rs); dbc

4、.code = dbc.model.getrowcount(); catch (sqlexception ex) logger.getlogger(sqlhelper.class.getname().log(level.severe, null, ex); dbc.code = -1; return dbc; * 獵取一個(gè)具有更新功能的數(shù)據(jù)模型 假如只要讀取數(shù)據(jù)，就不要用它了 * param cmdtext 需要 ? 參數(shù)的 sql 語(yǔ)句 * param cmdparams sql 語(yǔ)句的參數(shù)表 * return 表格數(shù)據(jù)模型 * 同上一個(gè)辦法 * public static dataset

5、getdataset(string cmdtext, object. cmdparams) preparedstatement pstmt = getpreparedstatement(cmdtext, cmdparams); dataset dbc = new dataset(); if (pstmt = null) dbc.code = -2; return dbc; / 查詢(xún)語(yǔ)句 dbc.rs = pstmt.executequery(); dbc.model = buildtablemodel(dbc.rs); dbc.code = dbc.model.getrowcount(); c

6、atch (sqlexception ex) logger.getlogger(sqlhelper.class.getname().log(level.severe, null, ex); dbc.code = -1; return dbc; * 獵取一個(gè)具有更新功能的數(shù)據(jù)模型 假如只要讀取數(shù)據(jù)，就不要用它了 * param conn 數(shù)據(jù)庫(kù)銜接 * param cmdtext 需要 ? 參數(shù)的 sql 語(yǔ)句 * param cmdparams sql 語(yǔ)句的參數(shù)表 * return 表格數(shù)據(jù)模型 * 同上 public static dataset getdataset(connection

7、 conn, string cmdtext, object. cmdparams) preparedstatement pstmt = getpreparedstatement(conn, cmdtext, cmdparams); dataset dbc = new dataset(); if (pstmt = null) dbc.code = -2; return dbc; / 查詢(xún)語(yǔ)句 dbc.rs = pstmt.executequery(); dbc.model = buildtablemodel(dbc.rs); dbc.code = dbc.model.getrowcount();

8、 catch (sqlexception ex) logger.getlogger(sqlhelper.class.getname().log(level.severe, null, ex); dbc.code = -1; return dbc; private static vo close(object obj) if (obj = null) return; if (obj instaeof statement) (statement) obj).close(); else if (obj instanceof preparedstatement) (preparedstatement)

9、 obj).close(); else if (obj instanceof resultset) (resultset) obj).close(); else if (obj instanceof connection) (connection) obj).close(); catch (sqlexception ex) logger.getlogger(sqlhelper.class.getname().log(level.severe, null, ex); private static void closeex(object obj) if (obj = null) return; i

10、f (obj instanceof statement) (statement) obj).close(); else if (obj instanceof preparedstatement) (preparedstatement) obj).close(); else if (obj instanceof resultset) (resultset) obj).getstatement().close(); else if (obj instanceof connection) (connection) obj).close(); catch (sqlexception ex) logge

11、r.getlogger(sqlhelper.class.getname().log(level.severe, null, ex); private static void closeconnection(object obj) if (obj = null) return; if (obj instanceof statement) (statement) obj).getconnection().close(); else if (obj instanceof preparedstatement) (preparedstatement) obj).getconnection().close(); else if (obj instanceof resultset) (resultset) obj).getstatement().getconnection().