/// <summary> /// 测试数据库连接 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Splash_Load(object sender, EventArgs e) { try { SqlLiteConn conn = new SqlLiteConn(); conn.getConn(); } catch (Exception ex) { MessageBox.Show("数据库迷之消失:"+ex.Message); } return; }
public void SaveCookie(string username) { List <Cookie> cooklist = GetAllCookies(cookiec); SqlLiteConn conn = new SqlLiteConn(); string sql = ""; sql = "delete from cookie where username = '******';"; conn.ExecuteScalar(sql); foreach (Cookie cookie in cooklist) { string cookieString = JsonConvert.SerializeObject(cookie); sql = "insert into cookie (username,cookie) values ('" + username + "','" + cookieString + "');"; conn.ExecuteScalar(sql); } }
public CookieContainer RestoreCookie(string username) { DataTable dt = null; cookiec = new CookieContainer(); SqlLiteConn conn = new SqlLiteConn(); string sql = "select username,cookie from cookie where username = '******' ;"; dt = conn.ExecuteDataTable(sql); for (int i = 0; i < dt.Rows.Count; i++) { Cookie ck = JsonConvert.DeserializeObject <Cookie>(dt.Rows[i]["cookie"].ToString()); cookiec.Add(ck); } return(cookiec); }
private void checkIn() { MessageBox.Show("banana throw start"); DataTable dt = null; SqlLiteConn conn = new SqlLiteConn(); string sql = "select username,userpassword,userid from user ;"; dt = conn.ExecuteDataTable(sql); conn.ExecuteDataTable(sql); for (int i = 0; i < dt.Rows.Count; i++) { string s = webutil.login(dt.Rows[i]["username"].ToString(), dt.Rows[i]["userpassword"].ToString()); string userid = dt.Rows[i]["userid"].ToString(); string s1 = webutil.throwBanana(acNo,userid,webutil.cookiec); Thread.Sleep(20000); } MessageBox.Show("banana OK"); }
/// <summary> /// 检查是否为第一次使用和是否有id记录 /// </summary> /// <returns></returns> public void checkUserId() { bool isUserIdRec = false; SqlLiteConn conn = new SqlLiteConn(); DataTable dt = conn.GetSchema(); if (dt.Rows.Count > 0) { //是否有记录 SQLiteParameter[] pars = new SQLiteParameter[] { new SQLiteParameter("", "") }; string sql = "select count() from user where id >0"; SQLiteDataReader r = conn.ExecuteReader(sql, pars); if (r.Read() && (r.GetInt32(0) > 0)) { r.Close(); isUserIdRec = true; } else { isUserIdRec = false; } } else { //空数据库初始化 string sql = @" DROP TABLE IF EXISTS 'main'.'user'; CREATE TABLE 'user' ( 'id' INTEGER NOT NULL, 'userid' INTEGER, 'username' TEXT NOT NULL, 'userpassword' TEXT NOT NULL, 'moni' REAL, PRIMARY KEY ('id') );"; conn.ExecuteNonQuery(sql); } if (!isUserIdRec) { login loginform = new login(); loginform.Show(); } }