支持情況

      支持SQLSERVER、Oracle、MySQL、sqlite、access等oldeb連接。

使用說明

以sqlserver為例

1.添加對DBUtil.dll的引用,添加命名空間 using DBUtil

2.創(chuàng)建IDb對象

DBUtil.IDbAccess iDb =DBUtil.IDBFactory.CreateIDB("DataSource=.;Initial Catalog=JACKOA;User ID=sa;PassWord=sa;","SQLSERVER");

3.查詢單個數(shù)據(jù)

String CreateUserName = iDb.GetFirstColumnString("select Name from SysUser where ID='1'");

4.查詢單個表

DataTable dt = iDb. GetDataTable(“select * from sysuser”)

5.查詢多個表

DataSet ds = iDb. GetDataSet(“select * from sysuserselect * from sysrole”)

6.執(zhí)行sql語句

iDb. ExecuteSql(“update sysuser setpwd=1”)

7.判斷表或視圖存在

iDb.JudgeTableOrViewExist(“sysuser”)

8.判斷列是否存在

iDb.JudgeColumnExist(“sysuser”,”id”)

9.獲得分頁的查詢語句

GetSqlForPageSize(“select name,id,pwd from sysuser”, “orderby id asc”, 5,1)

10.開啟事務(wù)

iDb. BeginTrans()

11.提交事務(wù)

iDb.Commit();

12.撤回

iDb.Rollback();

13.創(chuàng)建參數(shù)

iDb.CreatePara()

14.生成日期過濾字符串

GetDateFilter(“birthday”, “1990-01-01”, “2000-01-01”, true,true)

15.更新數(shù)據(jù)

Hashtable ht = new Hashtable();

ht.Add(“Remark”,”備注”);

iDb.UpdateData("F_GWSW",ht, " AND CaseNo='GWFW2016011200001'");

16.添加數(shù)據(jù)

Hashtable ht = new Hashtable();

ht.Add(“CaseNo”,”GWFW2015020100003”);

ht.Add(“Remark”,”備注”);

iDb.AddData("F_GWSW",ht)

17.刪除數(shù)據(jù)

iDb.DeleteTableRow("F_GWSW",”and caseno=’2015020300002’”)

github地址：https://github.com/jackletter/DBUtil