关于数据最大ID 的操作函数

分享此函数方便以后的使用

此函数应用场景为：当ID为自增长的时候，数据库执行为insert语句时候，进行的回滚操作。

  

    #region 执行删除第一行数据

        public static bool deletop()
        {

            String myExecuteQuery = "DELETE FROM air_tightness_test WHERE ID =" + getTopId() + "";
            bool result = false;
            MySqlConnection connection = new MySqlConnection(Conn);
            connection.Open();
            MySqlCommand cmd = new MySqlCommand(myExecuteQuery, connection);
            try
            {

                cmd.ExecuteNonQuery();
                result = true;

            }
            catch (Exception)
            {

            }
            finally
            {

                connection.Close();

            }

            return result;
       
        }
        #endregion

        #region 获取最后一个ID
        public static int getTopId()
        {

            String query = "SELECT ID FROM air_tightness_test ORDER BY ID DESC LIMIT 1";

            string s="";

            MySqlConnection connection = new MySqlConnection(Conn);
            connection.Open();
            MySqlCommand cmd = new MySqlCommand(query, connection);
       
            MySqlDataReader dataReader = cmd.ExecuteReader();

            //Read the data and store them in the list  

            while (dataReader.Read())
            {
               s=dataReader["ID"] + "";

            }
            dataReader.Close();
            connection.Close();

            int id=0;
            id = Convert.ToInt32(s);
            return id;
        }
        #endregion