mysql mysql库中的表_获取mysql数据库中的表信息

#region 根据表名获取数据库表字段信息

///

///根据表名获取数据库表字段信息///

///

///

public Task> GetFieldList(stringtable)

{using (MySqlConnection conn =GetConnection())

{

Dictionary dic = new Dictionary();

MySqlCommand cmd=conn.CreateCommand();

cmd.CommandText=string.Format("select table_name,column_name,data_type,column_comment from information_schema.columns where table_schema='"+ dataName + "' and table_name='{0}'",table);using (MySqlDataReader reader =cmd.ExecuteReader())

{while(reader.Read())

{

Columns columns= newColumns();string column = reader.GetString("column_name");string types = reader.GetString("data_type");string comment = reader.GetString("column_comment");

columns.ColumnName=column;

columns.TypeName=types;

columns.comment=comment;if(dic.ContainsKey(table))

{

dic[table].ColumnList.Add(columns);

}else{

MyTable t= newMyTable();

t.Table=table;

t.ColumnList.Add(columns);

dic.Add(t.Table, t);

}

}

}

conn.Close();returnTask.FromResult(dic.Values.ToList());

}

}#endregion

publicMySqlConnection GetConnection()

{

MySqlConnection conn= newMySqlConnection(ConfigurationManager.conns);

conn.Open();returnconn;

}