c#学习（十）-- MySqlDataAdapter实现对数据库的增删改查

using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace _09dataAdapterUpdateData
{
    class Program
    {
        public static MySqlConnection connection = null;
        public static string str= ConfigurationManager.ConnectionStrings["conStri"].ConnectionString;
        public static DataTable dataTable= new DataTable("news");
        static void Main(string[] args)
        {
            connection = new MySqlConnection(str);
            //增加
            insert(connection);
            //删除
            delete(connection);
            //修改
            update(connection);

            //查询
            select(connection);
            Console.ReadKey();
        }
        //增加
     public static void insert(MySqlConnection connection)
        {
            string sql = "insert into news (title,content,insertdate,memberid) values (@title,@content,@insertdate,@memberid)";
            // MySqlDataAdapter adapter = new MySqlDataAdapter("select * from news", connection);
            MySqlCommand mySqlCommand = new MySqlCommand();
            mySqlCommand.CommandText = sql;
            mySqlCommand.Connection = connection;
            MySqlParameter[] parameters = {
                new MySqlParameter("@title","增加标题"),
                new MySqlParameter("@content","增加内容"),
                new MySqlParameter("@insertdate",new DateTime()),
                 new MySqlParameter("@memberid",1),
            };
            mySqlCommand.Parameters.AddRange(parameters);
            MySqlDataAdapter adapter = new MySqlDataAdapter(mySqlCommand);
            dataTable.Clear();
            adapter.Fill(dataTable);
        }
        //删除
        public static void delete(MySqlConnection connection)
        {
            string sql = "delete from news where id =@newid";
            MySqlCommand mySqlCommand = new MySqlCommand(sql, connection);
            mySqlCommand.Parameters.AddWithValue("@newid", 3);
            MySqlDataAdapter adapter = new MySqlDataAdapter(mySqlCommand);
            dataTable.Clear();
            adapter.Fill(dataTable);
        }
        //修改

        public static void update(MySqlConnection connection)
        {
            string sql = "update news set content=@content where id=@newid";
            MySqlCommand mySqlCommand = new MySqlCommand(sql, connection);
            MySqlParameter[] parameters = {   
                new MySqlParameter("@content","修改内容"),
                 new MySqlParameter("@newid",1),
            };
            mySqlCommand.Parameters.AddRange(parameters);
            MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(mySqlCommand);
            dataTable.Clear();
            mySqlDataAdapter.Fill(dataTable);
        }
        //select

        public static void select(MySqlConnection connection)
        {
            string sql = "select * from news where id =@newid";
            MySqlCommand mySqlCommand = new MySqlCommand(sql,connection);
            mySqlCommand.Parameters.AddWithValue("@newid", 1);
            MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(mySqlCommand);
            dataTable.Clear();
            mySqlDataAdapter.Fill(dataTable);
            foreach (DataRow news in dataTable.Rows)
            {
                int id = (int)news["id"];
                string title = (string)news["title"];
                string content = (string)news["content"];
                var v = news["insertdate"];
                int memberid = (int)news["memberid"];
                Console.WriteLine(id + "   " + title + "   " + content + "   " +v+"   "+memberid);
            }
        }
    }
}