如何读取现成的sqlLite数据库

最新推荐文章于 2024-07-23 11:38:51 发布

aceweihl

最新推荐文章于 2024-07-23 11:38:51 发布

阅读量2.6k

点赞数

CC 4.0 BY-SA版权

分类专栏： Windws phone

本文链接：https://blog.youkuaiyun.com/weihualeiok/article/details/9032993

Windws phone 专栏收录该内容

4 篇文章

订阅专栏

本文介绍如何在Windows Phone 8 (WP8) 平台上使用SQLite进行数据库操作，包括数据库复制、数据查询等关键步骤，并提供具体实现代码。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、添加右键引用NUGet包安装VICI CoolStorage

2、此时可以看到引用中多两个文件Vici.CoolStorage.WP8 和Vici.Core.WP8

3、

public class SQLite
{

private static SQLite _instance;

        public static SQLite getInstance()
        {
            if (_instance == null)
                _instance = new SQLite();
            return _instance;
        }

        public SQLite()
        {
        }

        ///// <summary>
        ///// 通过!iStorage.FileExists(fn)保证程序第一次
        ///// 运行的时候才会将数据库复制
        ///// 到隔离存储空间中，
        ///// fn为复制的数据库路径及名称
        ///// </summary>
        ///// <param name="fn"></param>
        //private void move(string fn)
        //{
        //    //StreamResourceInfo sr = Application.GetResourceStream(new Uri(fn, UriKind.Relative));
        //    IsolatedStorageFile iStorage = IsolatedStorageFile.GetUserStoreForApplication();
        //    if (!iStorage.FileExists(fn))
        //    {
        //        using (var outputStream = iStorage.OpenFile(fn, System.IO.FileMode.CreateNew))
        //        {
        //            byte[] buffer = new byte[10000];

        //            for (; ; )
        //            {
        //                int read = sr.Stream.Read(buffer, 0, buffer.Length);

// if (read <= 0)
// break;

        //                outputStream.Write(buffer, 0, read);
        //            }
        //        }
        //    }
        //}

        /// <summary>
        /// 将文件存储到独立存储空间
        /// </summary>
        /// <param name="assemblyName">项目名</param>
        /// <param name="dbName">文件名</param>
        private void CopyFromContentToStorage(string assemblyName, String dbName)
        {
            IsolatedStorageFile store = IsolatedStorageFile.GetUserStoreForApplication();
            System.IO.Stream src = Application.GetResourceStream(new Uri("/" + assemblyName + ";component/DataBase/" + dbName, UriKind.Relative)).Stream;
            IsolatedStorageFileStream dest = new IsolatedStorageFileStream(dbName, System.IO.FileMode.OpenOrCreate, System.IO.FileAccess.Write, store);
            src.Position = 0;
            CopyStream(src, dest);
            dest.Flush();
            dest.Close();
            src.Close();
            dest.Dispose();
        }

        /// <summary>
        /// 复制流
        /// </summary>
        /// <param name="input"></param>
        /// <param name="output"></param>
        private static void CopyStream(System.IO.Stream input, IsolatedStorageFileStream output)
        {
            byte[] buffer = new byte[32768];
            long TempPos = input.Position;
            int readCount;
            do
            {
                readCount = input.Read(buffer, 0, buffer.Length);
                if (readCount > 0)
                {
                    output.Write(buffer, 0, readCount);
                }
            } while (readCount > 0);
            input.Position = TempPos;
        }

        /// <summary>
        /// 查询区域信息表中的所有数据信息
        /// </summary>
        /// <param name="sTableName">表名称</param>
        /// <param name="sWhere">查询条件</param>
        /// <param name="sOrder"></param>
        /// <returns></returns>
        public CSGenericRecordList queryAllData(String sSelect, String sTableName, String sWhere, String sOrder)
        {
             string strSql = string.Empty;

strSql += "SELECT " +sSelect+" FROM " + sTableName;

            if (!sWhere.Equals(""))
            {
                strSql = strSql + " WHERE " + sWhere;
            }
            if (!sOrder.Equals(""))
            {
                strSql=strSql+" ORDER BY "+sOrder;
            }

//move(fn);

CopyFromContentToStorage("PingAn_WP", "FinancialTel.db");

//设置使用的数据库
CSConfig.SetDB("FinancialTel.db");

CSGenericRecordList arealist = CSDatabase.RunQuery(strSql);

return arealist;

}
}

4、调用

protected override void OnNavigatedTo(NavigationEventArgs e)
        {
            SQLite sqlLite = new SQLite();
            CSGenericRecordList cslis = sqlLite.queryAllData("distinct level2,tel", "pingan", "level3=''", "sort");
            lb_Main.ItemsSource = from cs in cslis select new PingAn_Model(cs["level2"].ToString(), cs["tel"].ToString());

            //PingAn_Model是一个对象
            base.OnNavigatedTo(e);
        }