MySQL Memory 存储引擎浅析(7)

                new MySqlParameter("?obj", MySqlDbType.VarChar, 255)

            };

            parameters[0].Value = obj;

            if (DBUtility.MySqlHelper.ExecuteNonQuery(SQL_CONN, CommandType.Text, commandText, parameters) > 0)

                return true;

            else

                return false;

        }

        public static string DB_MyIsamSelect(int id)

        {

            string commandText = "SELECT obj FROM test_myisam WHERE id = ?id";

            MySqlParameter[] parameters = {

                new MySqlParameter("?id", MySqlDbType.Int32)

            };

            parameters[0].Value = id;

            return DBUtility.MySqlHelper.ExecuteScalar(SQL_CONN, CommandType.Text, commandText, parameters).ToString();

        }

        public static bool DB_MemoryInsert(string obj)

        {

            string commandText = "INSERT INTO test_memory (obj) VALUES (?obj)";

            MySqlParameter[] parameters = {

                new MySqlParameter("?obj", MySqlDbType.VarChar, 255)

            };

            parameters[0].Value = obj;

            if (DBUtility.MySqlHelper.ExecuteNonQuery(SQL_CONN, CommandType.Text, commandText, parameters) > 0)

                return true;

            else

                return false;