private static void InsertTest()
        {
            string sql = "insert into user(Id,Name) values(?Id,?Name);";

            MySqlParameter[] spArr = new MySqlParameter[] {
                new MySqlParameter("Id", 2),
                new MySqlParameter("Name", "leaf")
            };
            int r = MySqlHelper1.ExecuteNonQuery(sql, spArr);

            Console.WriteLine(r);
        }
        static void Main1(string[] args)
        {
            //TestConnection();
            //InsertTest();
            //ExecuteDataTableTest();

            string sql      = "select count(1) from user";
            int    rowCount = Convert.ToInt32(MySqlHelper1.ExecuteScalar(sql));

            Console.WriteLine(rowCount);

            Console.Read();
        }
        private static void ExecuteDataTableTest()
        {
            string    sql = "select * from user";
            DataTable dt  = MySqlHelper1.ExecuteDataTable(sql);

            foreach (DataRow dr in dt.Rows)
            {
                foreach (DataColumn dc in dt.Columns)
                {
                    Console.Write("{0}:{1}\t", dc.ColumnName, dr[dc.ColumnName].ToString());
                }
                Console.WriteLine();
            }
        }