using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using MySql.Data.MySqlClient;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Reflection;
using KSDataInfo.utils;
namespace KSDataInfo.Models
{
public static class MySqlHelper
{
public static readonly string connStrLocal = ConfigurationManager.ConnectionStrings["MySqlConnStr"].ConnectionString;
public static List<string> GetTableNames()
{
using (MySqlConnection con = new MySqlConnection(connStrLocal))
{
con.Open();
DataTable dt = con.GetSchema("Tables");
List<string> tableName = dt.Rows.OfType<DataRow>().Select(x => (string)x["Table_Name"]).ToList();
con.Close();
return tableName;
}
}
//1.执行增、删、改的方法:ExecuteNonQuery
public static int ExecuteNonQuery(string sql, params MySqlParameter[] pms)
{
using (MySqlConnection con = new MySqlConnection(connStrLocal))
{
using (MySqlCommand cmd = new MySqlCommand(sql, con))
{
if (pms != null)
{
cmd.Parameters.AddRange(pms);
}
con.Open();