c#多线程操作数据库问题

w350809090 2015-12-30 03:13:13

各位好我是c#一个初学者，今天刚发现了篇写多线程的文章，想到了昨天写的项目看看是否可以改进程多线程的但是出现了一些问题，请各位指教。
线程代码。

public static void ThreadProc5()

        {

            Thread thread5 = new Thread(new ThreadStart(ThreadProc4));

            thread5.Start();

            string mysql1 = "server=127.0.0.1;User Id=root;password=root;Database=wangyi";

            MySqlConnection conn = new MySqlConnection(mysql1);

            MySqlCommand str = new MySqlCommand("select count(*) from number", conn);

            conn.Open();

            MySqlDataReader reader;

            reader = str.ExecuteReader();

            if (reader.Read())

            {

                int oneinnumber = Convert.ToInt32(reader["count(*)"].ToString());

                for (int i = 0; i <= oneinnumber + 1; i++)

                {



                    MySqlConnection conn1 = new MySqlConnection(mysql1);

                    MySqlCommand str1 = new MySqlCommand("select name from number limit 5,1", conn1);

                    conn1.Open();

                    MySqlDataReader reader2;

                    reader2 = str1.ExecuteReader();

                    if (reader2.Read())

                    {

                        Uri uri = new Uri("http://zc.reg.163.com/checkName?id=EBB7F4D4BBD222E1408090F4247D9CF1735193ADBFB23AA5C7D70E6F266E44D89B233DECEC3106B6FE4D083202B913130439486E0046D4B0AD070FDB0FE98DC9D4B029B4FF47E56B89DBB106B22E9956&userName=" + reader2["name"].ToString() + "&channel=1");

                        HttpWebRequest myReq = (HttpWebRequest)WebRequest.Create(uri);

                        myReq.UserAgent = "User-Agent:Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; .NET CLR 1.0.3705";

                        myReq.Accept = "*/*";

                        myReq.KeepAlive = true;

                        myReq.Headers.Add("Accept-Language", "zh-cn,en-us;q=0.5");

                        HttpWebResponse result = (HttpWebResponse)myReq.GetResponse();

                        Stream receviceStream = result.GetResponseStream();

                        StreamReader readerOfStream = new StreamReader(receviceStream, System.Text.Encoding.GetEncoding("utf-8"));

                        string acc = readerOfStream.ReadToEnd();

                        if (acc.IndexOf("104") >= 0 || acc.IndexOf("401") >= 0)

                        {

                            MySqlConnection conn2 = new MySqlConnection(mysql1);

                            MySqlCommand str2 = new MySqlCommand("delete from number where name = '" + reader2["name"].ToString() + "'", conn2);

                            conn2.Open();

                            MySqlDataReader reader3;

                            reader3 = str2.ExecuteReader();

                            conn2.Close();

                        }

                        else if (acc.IndexOf("407") >= 0)

                        {

                            MySqlConnection conn4 = new MySqlConnection(mysql1);

                            MySqlCommand str4 = new MySqlCommand("delete from number where name = '" + reader2["name"].ToString() + "'", conn4);

                            conn4.Open();

                            MySqlDataReader reader5;

                            reader5 = str4.ExecuteReader();

                            conn4.Close();

                            MySqlConnection conn3 = new MySqlConnection(mysql1);

                            MySqlCommand str3 = new MySqlCommand("insert into numberok (name) values ('" + reader2["name"].ToString() + "')", conn3);

                            conn3.Open();

                            MySqlDataReader reader4;

                            reader4 = str3.ExecuteReader();

                            conn3.Close();

                        }

                        readerOfStream.Close();

                        receviceStream.Close();

                        result.Close();

                        conn1.Close();

                    }

                }

                //fs.Close();

            }



            conn.Close();

        }

我谢了5个线程代码，全部是相同的。
调用代码

 private void button1_Click(object sender, EventArgs e)

        {

            

            Thread thread6 = new Thread(new ThreadStart(ThreadProc5));

            thread6.Start();

            

        }

可是我感觉这样写还没以前快。不知道是什么问题。我百度到在执行数据库操作的时候多线程有个锁的概念，也没接触过

...全文