sqllite的使用

sqllite的使用

  <appSettings>
  <!--查询时间-->
    <add key="SqliteTime" value="10" />
  </appSettings>

 public string SqliteTime = System.Configuration.ConfigurationManager.AppSettings["SqliteTime"].ToString();       

//查询十分钟内的时间
            FileInfo fi = new FileInfo(@"D:\After20190701\file.txt");
            if (fi.Exists)
            {
   
                FileInfo copyfi = new FileInfo(@"D:\After20190701\copyfile.txt");
                if (copyfi.Exists)
                {
   
                    File.Delete(@"D:\After20190701\copyfile.txt");
                    fi.CopyTo(@"D:\After20190701\copyfile.txt");
                }
                else
                {
   
                    fi.CopyTo(@"D:\After20190701\copyfile.txt");
                }
            }
            using (SQLiteConnection con = new SQLiteConnection(DB_PATH))
            {
   

                con.Open();
                string sqlStr = &#