#ifndef CSqliteOp_H_
#define CSqliteOp_H_

#include <string>
#include "../SQLite/sqlite3.h"
#include "../Json/json/json.h"

class CSqliteOp 
{
 public:
 	CSqliteOp (std::string m_path);
			~CSqliteOp (void);
			//初始化一个DB
			int InitDB(std::string &path);
 public:
			int IsTableExt(std::string &name);
 int CreateTable(sqlite3 *db,std::string &sqltxt);
			int SelectSql(sqlite3 *db,std::string &sqltxt,Json::Value &JsonResult);
			int NoSelectSql(sqlite3 *db,std::string &sqltxt);
			// 开始事务
			bool BeginTransaction(sqlite3 *db);
			// 提交事务
			bool CommitTransaction(sqlite3 *db);
			// 回滚事务
			bool RollbackTransaction(sqlite3 *db);

			bool ExcuteNonQuery16(sqlite3 *db,wchar_t *lpSql);

			bool ExcuteNonQuery(sqlite3 *db,char *lpSql);
			sqlite3 *GetDb(){ return m_db;}
 public:
private: 
	 sqlite3 *OpenSqlite();
		 void CloseSqlite(sqlite3 *db);
	 std::string m_path;
			//数据库是否初始化
			bool IsIniDB();
 sqlite3 *m_db;
	 
};
#endif