黑马程序员--手机号码归属地验证

最新推荐文章于 2024-07-22 07:00:00 发布

hehe04

最新推荐文章于 2024-07-22 07:00:00 发布

阅读量608

点赞数

CC 4.0 BY-SA版权

文章标签：手机 string windows phone button textbox object

本文链接：https://blog.youkuaiyun.com/hehe04/article/details/7897621

本文介绍了一种从文件中批量导入电话号码区域数据到数据库的方法，并提供了验证数据正确性的示例代码。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

---------------------- Windows Phone 7手机开发、.Net培训、期待与您交流！ ----------------------

数据库数据可以在百度GOOGLE搜一下，有很多。优快云上也有

将数据导入数据库

        private void button1_Click(object sender, EventArgs e)
        {
            string phoneNo,province,city,areacode,postcode,phoneNoType;
            string connstr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
            if (openFileDialog1.ShowDialog() != DialogResult.OK)
            { return; }
            //using(FileStream filestream=File .OpenRead(openFileDialog1.FileName))
            //{
                using (StreamReader streamreader = new StreamReader(openFileDialog1.FileName,Encoding.Default))
                {

                    using (SqlConnection conn = new SqlConnection(connstr))
                    {
                        conn.Open();
                        using (SqlCommand cmd = conn.CreateCommand())
                        {
                            cmd.CommandText = "insert into phoneNoArea(phoneNo,province,city,areacode,postcode,phoneNoType) values(@phoneNo,@province,@city,@areacode,@postcode,@phoneNoType)";
                            string line = null;
                            while ((line = streamreader.ReadLine()) != null)
                            {
                                MatchCollection mc = regex.Matches(line);
                                string[] strarr = line.Split('-');
                                phoneNo = strarr[1];
                                province = strarr[2];
                                city = strarr[3];
                                areacode = strarr[4];
                                postcode = strarr[5];
                                phoneNoType = strarr[6];
                                cmd.Parameters.Clear();
                                cmd.Parameters.Add("phoneNo", phoneNo);
                                cmd.Parameters.Add("province", province);
                                cmd.Parameters.Add("city", city);
                                cmd.Parameters.Add("areacode", areacode);
                                cmd.Parameters.Add("postcode", postcode);
                                cmd.Parameters.Add("phoneNoType", phoneNoType);
                                cmd.ExecuteNonQuery();

                            }
                        }
                    }
                //}
            }
            MessageBox.Show("导入成功");
        }

以下是验证数据的代码

 private void button2_Click(object sender, EventArgs e)
        {
            string phoneNostr = textBox1.Text.Substring(0,7);
            string connstr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "SELECT [PhoneNo],[Province],[City],[AreaCode],[PostCode],[PhoneNoType] FROM [test].[dbo].[PhoneNoArea] where [PhoneNo] =@phoneNo";
                    cmd.Parameters.AddWithValue("phoneNo", phoneNostr);
                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        if (reader.Read())//读取数据，并判断是否为真
                        {
                            string result = reader.GetString(reader.GetOrdinal("Province"));
                            result += " " + reader.GetString(reader.GetOrdinal("city"));
                            result += " " + reader.GetString(reader.GetOrdinal("phoneNoType"));
                            resultlabel1.Text = result;
                        }
                    }
                    
                }
            }
        }

---------------------- Windows Phone 7手机开发、 .Net培训、期待与您交流！ ----------------------详细请查看： http://net.itheima.com/