using System ;
using UnityEngine;
using System.Collections.Generic ;
using Mono.Data .sqlite;
using System.Collections;
public class DBmanager {
  
   /// <summary>
     ///单例模式
     /// </summary>
    
      private static DBmanager instance;

     public static DBmanager Instance
     {
          get
          {
               if(instance == null )
               {
                    instance = new DBmanager ();
               }
               return instance ;
          }
     }

     private DBmanager (){}

     //连接
     private sqliteConnection dbConnect;
     //指令
     private sqliteCommand dbCommand;
     //写操作
     private sqliteDataReader dbDataReader;

     public  Dictionary <string,List <string >> dbDic;

     /// <summary>
     /// Opens the sql.
     /// </summary>
     public void Opensql()
     {
          try
          {
               string path = "Data Source = " + Application.dataPath + "/rank.sqlite";
               dbConnect = new sqliteConnection (path );
               dbConnect.Open ();
               dbCommand = new sqliteCommand ();
               dbCommand.Connection = dbConnect ;
          }
          catch (Exception ex )
          {
               Debug.Log ("Exception is :" + ex.ToString ());
          }
     }
     /// <summary>
     /// Enquiries the sql.
     /// 读取数据
     /// </summary>
     /// <returns>返回数据集</returns>
     /// <param name="str">sql命令</param>
     public  Dictionary <string,List <string >> Enquirysql(string str)
     {

          dbDic = new Dictionary<string,List<string>> ();

          try
          {
               dbCommand.CommandText = str ;
               dbDataReader = dbCommand.ExecuteReader ();
              
               while (dbDataReader.Read ())
               {
                    for ( int i = 0 ; i < dbDataReader.FieldCount ; i ++)
                    {
                         string keyStr = dbDataReader.GetName (i);
                         string valueStr = dbDataReader.GetValue (i).ToString ();

                         if(!dbDic  .ContainsKey(keyStr ))
                         {
                              dbDic [keyStr ] = new List<string> ();
                              dbDic [keyStr ].Add (valueStr );
                         }
                         else
                         {
                              dbDic [keyStr ].Add (valueStr );
                         }
                    }
               }
               //记得读取完关上它 - -
               dbDataReader .Close ();
               return dbDic ;
          }
          catch (Exception ex)
          {
               Debug.Log ("Exception is :" + ex.ToString ());
               return dbDic ;
          }
     }


     /// <summary>
     ///执行增删改查操作
     /// </summary>
     /// <returns>The sql.</returns>
     /// <param name="str">String.</param>
     public     int Executesql(string str)
     {
          try
          {
               dbCommand.CommandText = str;
               return dbCommand.ExecuteNonQuery ();
          }
          catch (Exception ex)
          {
               Debug.Log("Exception is :" + ex.ToString ());
               return 0;
          }
     }

     /// <summary>
     ///关闭数据库
     /// </summary>
     public void Closesql()
     {
          dbConnect.Close ();
          dbCommand.Dispose();
     }
 }

[code]csharpcode：

public class Creat : MonoBehavIoUr {

     /// <summary>
     ///该脚本挂到list上
     /// </summary>


     private RectTransform rt;
     //记录高度
     private float height;

     void Start () {
          rt = GetComponent <RectTransform >();
          //生成5条数据
          for ( int i = 0 ; i < 5 ; i ++)
          {
               GameObject go =Instantiate (  Resources .Load ("Data")) as GameObject ;
          //生成的数据为List的子物体
               go.transform.SetParent (transform );
               //list的高度变化
               height += go.GetComponent <RectTransform >().sizeDelta.y;
          }
          //将height赋值给List
          rt.sizeDelta = new Vector2 (rt.sizeDelta.x,height );
     }