c# 3层架构代码实解

注意：

不要忘记添加：

/提取数据/

using projectname.DA/Helper/Model;

using MySql.Data.MySqlClient;

/读取数据/

using System.Data.Common;

using System.Data;

 

添加数据：

public static void Name(ModelName o)

        {

            try

            {

                MySqlConnection conn = Database.MakeConnection();

                string query = "INSERT INTO table (data) VALUES (@data)";

 

                MySqlCommand cmd = new MySqlCommand(query, conn);

 

                cmd.Parameters.AddWithValue("@data", o.data);

 

                cmd.ExecuteNonQuery();

            }

            catch (Exception e)

            {

                throw;

            }

            finally

            {

 

            }

        }

///

Model m = new Model();

 

            m.data = intdata/strdata

 

            DA.Name(m);

 

连接到数据库：

public static MySqlConnection MakeConnection()

        {

            MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder

            {

                Server = "localhost",

                Database = "/",

                UserID = "/",

                Password = "/",

                Port = /

            };

 

            MySqlConnection conn = new MySqlConnection(builder.ConnectionString);

            conn.Open();

            return conn;

        }

        public static void CloseConnection(MySqlConnection conn)

        {

            if (conn != null)

            {

                conn.Close();

                conn = null;

            }

        }

 

更改/删除数据：

public static void Name(name1, name2)

        {

            MySqlConnection conn = Database.MakeConnection();

 

            更改: string sql = "UPDATE table SET data1 = @data1 WHERE data2 = @data2";

            删除: string sql = "DELETE data1 = @data1 FROM table WHERE data2 = @data2"";

 

            MySqlCommand cmd = new MySqlCommand(sql, conn);

 

            cmd.Parameters.AddWithValue("@data1", name1);

            cmd.Parameters.AddWithValue("@data2", name2);

 

            cmd.ExecuteNonQuery();

 

        }

 

提取数据：

public static Gebruiker Name(naam)

        {

            Model M = new Model();

 

            string sql = "SELECT * FROM table where name=@name";

            MySqlConnection conn = Database.MakeConnection();

            MySqlCommand GetName = new MySqlCommand(sql, conn);

            GetName.CommandText = sql;

 

            GetName.Parameters.AddWithValue("@name", name);

 

            DbDataReader reader = GetName.ExecuteReader();

 

            reader.Read();

 

            M.A = Convert.ToInt16(reader["A"]);

            M.B = (reader["B"].ToString());

 

            reader.Close();

 

            return Ge;

        }

 

添加数据到ListView：

private void RefreshList()

        {

            listView1.Items.Clear();

            foreach (Model m in DA.Name())

            {

                ListViewItem item = new ListViewItem(new String[] { m.A.ToString(), m.B });

                item.Tag = m;

                listView1.Items.Add(item);

            }

        }

///

            Model m = new Model();

 

            m = DA.Name(naam);

 

            string[][] Search = new string[10][];

            Search[0] = new string[] { Convert.ToString(m.A), m.B };

            ListViewItem item = new ListViewItem(Search[0]);

 

            listView1.Items.Add(item);

            this.listView1.EndUpdate();