17,740
社区成员
发帖
与我相关
我的任务
分享
[DllImport("sqlite3.dll", EntryPoint = "sqlite3_prepare_v2", CallingConvention = CallingConvention.Cdecl)]
public static extern int sqlite3_prepare_v2(IntPtr db, string zSql, int nByte, out IntPtr ppStmpt, IntPtr pzTail);
query = "REPLACE into Train(cc,Sf,Fs,Zd,Ds) values('1010','1234','12:34','1010','02:41')";
query = "REPLACE into Train(cc,Sf,Fs,Zd,Ds) values('1010','济南','12:34','1010','02:41')";
sqlite.sqllite.SQLite.sqlite3_prepare_v2(db, query, query.Length, out stmHandle, IntPtr.Zero)
int sqlite3_bind_text(sqlite3_stmt*, int, const char*, int n, void(*)(void*));
public delegate void FPtr( IntPtr ptr);
DllImport("sqlite3.dll", EntryPoint = "sqlite3_bind_text", CallingConvention = CallingConvention.Cdecl)]
public static extern int sqlite3_bind_text(IntPtr db,int num,string zSql, int nByte, FPtr fp);
UTF8Encoding utf8 = new UTF8Encoding();
Byte[] encodedBytes = utf8.GetBytes("济南");
String decodedString = utf8.GetString(encodedBytes);
if (sqlite.sqllite.SQLite.sqlite3_prepare_v2(db, query, query.Length, out stmHandle, IntPtr.Zero) != sqlite.sqllite.SQLite.SQLITE_OK)
{
err = sqlite.sqllite.SQLite.sqlite3_errmsg(db);
}
if (sqlite.sqllite.SQLite.SQLITE_OK != sqlite.sqllite.SQLite.sqlite3_bind_text16(stmHandle, 1, decodedString, -1, IntPtr.Zero))
{
err = sqlite.sqllite.SQLite.sqlite3_errmsg(db);
}