為您找到相關(guān)結(jié)果78,012個(gè)
SQLite數(shù)據(jù)庫(kù)中如何獲取新插入數(shù)據(jù)的自增長(zhǎng)ID_數(shù)據(jù)庫(kù)其它_腳本之家
conn.Open(); DbCommand cmdInsert = conn.CreateCommand(); cmdInsert.Parameters.Add(cmdInsert.CreateParameter()); cmdInsert.Parameters.Add(cmdInsert.CreateParameter()); cmdInsert.Parameters.Add(cmdInsert.CreateParameter()); DbTransaction trans = conn.BeginTransaction(); try { cmdInsert.CommandText ="...
www.dbjr.com.cn/database/3196081...htm 2025-6-5
DAM 簡(jiǎn)單跨數(shù)據(jù)庫(kù)ADO.NET組件_實(shí)用技巧_腳本之家
DbConnection connection = null; DbTransaction transaction = null; try { connection = Factory.CreateConnection(); connection.Open(); transaction = connection.BeginTransaction(); int resultInt1 = Execute.SExecuteNonQuery(connection, transaction, "sp_name1", paras); int resultInt2 = Execute.SExecuteN...
www.dbjr.com.cn/article/261...htm 2025-5-30
SQLite速度評(píng)測(cè)代碼_SQLite_腳本之家
DbCommand cmd = conn.CreateCommand(); cmd.Connection = conn; cmd.CommandText = sql; cmd.ExecuteNonQuery(); // 添加參數(shù) cmd.Parameters.Add(cmd.CreateParameter()); // 開(kāi)始計(jì)時(shí) Stopwatch watch = new Stopwatch(); watch.Start(); DbTransaction trans = conn.BeginTransaction(); // <--- try ...
www.dbjr.com.cn/article/158...htm 2025-6-3
記一次成功的sql注入入侵檢測(cè)附帶sql性能優(yōu)化_MsSql_腳本之家
// 創(chuàng)建DbCommand命令,并進(jìn)行預(yù)處理 DbCommand cmd = Factory.CreateCommand(); bool mustCloseConnection = false; PrepareCommand(cmd, connection, (DbTransaction)null, commandType, sql, parameters, out mustCloseConnection); // 執(zhí)行DbCommand命令,并返回結(jié)果. ...
www.dbjr.com.cn/article/283...htm 2025-5-28
System.Data.SQLite 數(shù)據(jù)庫(kù)詳細(xì)介紹_SQLite_腳本之家
using (DbTransaction transaction = connection.BeginTransaction()) { using (SQLiteCommand command = new SQLiteCommand(connection)) { command.CommandText = sql; if (parameters != null) { command.Parameters.AddRange(parameters); } affectedRows = command.ExecuteNonQuery(); ...
www.dbjr.com.cn/article/263...htm 2025-5-20
Discuz!NT數(shù)據(jù)庫(kù)讀寫分離方案詳解_實(shí)用技巧_腳本之家
首先就是(Discuz.Data\DbHelper.cs)代碼,主要變動(dòng)如下(新增方法部分): 復(fù)制代碼代碼如下: /// /// 獲取使用的數(shù)據(jù)庫(kù)(或快照)鏈接串 /// /// 存儲(chǔ)過(guò)程名或都SQL命令文本 /// <returns></returns> public static string GetRealConnectionString(string commandText...
www.dbjr.com.cn/article/239...htm 2025-5-23
C#使用開(kāi)源驅(qū)動(dòng)連接操作MySQL數(shù)據(jù)庫(kù)_C#教程_腳本之家
DbTransaction trans = conn.BeginTransaction(); //開(kāi)啟事物 try { //com.ExecuteNonQuery(); //還要執(zhí)行更多的語(yǔ)句時(shí)應(yīng)使用事物 Console.WriteLine(com.ExecuteScalar().ToString()); trans.Commit(); } catch (MySQLException ex) { Console.WriteLine(ex.Message); ...
www.dbjr.com.cn/article/612...htm 2025-5-28
告別ADO.NET實(shí)現(xiàn)應(yīng)用系統(tǒng)無(wú)縫切換的煩惱(總結(jié)篇)_實(shí)用技巧_腳本之家
public void AddParam(string ParaName, DbType SqlType, object ParaValue, DbParameterCollection ParaCollect) { //不允許將一個(gè)DbCommand對(duì)象的Parameters插入到另外一個(gè)DbCommand對(duì)象,那么多個(gè)參數(shù)的話可以加上下面一句判斷 //如果已經(jīng)存在至少一個(gè)對(duì)象時(shí),再深層拷貝一個(gè) ...
www.dbjr.com.cn/article/207...htm 2025-5-26
php中在PDO中使用事務(wù)(Transaction)_php技巧_腳本之家
在PDO 中, 事務(wù)已經(jīng)顯得非常簡(jiǎn)單. 下面一個(gè)基本的例子, 演示了向 SQLite 數(shù)據(jù)庫(kù)插入 1000000 條數(shù)據(jù), 并且在出錯(cuò)的時(shí)候回滾. 復(fù)制代碼代碼如下: try { $conn = new PDO('sqlite:Transactioion.s3db'); $conn->beginTransaction(); for($i=0; $i<1000000; $i++) ...
www.dbjr.com.cn/article/271...htm 2025-5-21