sql的insert语句自动生成器_c#源码

21 篇文章 0 订阅

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using NameGenerator;
using System.IO;

namespace sql_Insert
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        System.Random r = new Random();
        private void button1_Click(object sender, EventArgs e)
        {
           
          
            int Gender;
            List<string> Names;
            if (radioButton1.Checked)
            {
                Names = NameHelper.GetNames(true, Convert.ToInt32(textBox1.Text));
                Gender = 1;//男
            }
            else
            {
                Names = NameHelper.GetNames(false, Convert.ToInt32(textBox1.Text));
                Gender = 0;//女
            }
            FileStream stream = new FileStream("c:\\a.txt", FileMode.Create);
            StreamWriter writer = new StreamWriter(stream, Encoding.Default);
            for(int i=0;i<Convert.ToInt32( textBox1.Text);i++)
            {
                int age = r.Next(1, 100);
                int yw = r.Next(1, 101);
                int sx = r.Next(1, 101);
                string insert = "insert into " + textBox2.Text + "(" + textBox3.Text + ")" + "values";
                string values = "(" +"'"+ Names[i]+"'" +","+age.ToString()+","+Gender+","+yw.ToString()+","+sx.ToString()+ ")";
                writer.WriteLine(insert + values);
               
            }
            writer.Close();
            stream.Close();
            MessageBox.Show("已完成,文件在c盘根目录下,a.txt");
            //共5个字段名,分别为:姓名,年龄,性别,语文,数学。

            //会输出如下效果:insert into Class(姓名,年龄,性别,语文,数学)values(温秀羽,51,女,7,70)


        }
    }
}

NameHelper.cs文件如下:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace NameGenerator
{
    public class NameHelper
    {

        #region 随机姓名生成器

        static string[] _firstName = new string[]{ 
                    "白","毕","卞","蔡","曹","岑","常","车","陈","成" ,"程","池","邓","丁","范","方","樊","费","冯","符"
                   ,"傅","甘","高","葛","龚","古","关","郭","韩","何" ,"贺","洪","侯","胡","华","黄","霍","姬","简","江"
                   ,"姜","蒋","金","康","柯","孔","赖","郎","乐","雷" ,"黎","李","连","廉","梁","廖","林","凌","刘","柳"
                   ,"龙","卢","鲁","陆","路","吕","罗","骆","马","梅" ,"孟","莫","母","穆","倪","宁","欧","区","潘","彭"
                   ,"蒲","皮","齐","戚","钱","强","秦","丘","邱","饶" ,"任","沈","盛","施","石","时","史","司徒","苏","孙"
                   ,"谭","汤","唐","陶","田","童","涂","王","危","韦" ,"卫","魏","温","文","翁","巫","邬","吴","伍","武"
                   ,"席","夏","萧","谢","辛","邢","徐","许","薛","严" ,"颜","杨","叶","易","殷","尤","于","余","俞","虞"
                   ,"元","袁","岳","云","曾","詹","张","章","赵","郑" ,"钟","周","邹","朱","褚","庄","卓","东方","上官"
                   ,"令狐","申屠","欧阳" };

        static string _lastNameMale = "伟刚勇毅俊峰强军平保东文辉力明永健世广志义兴良海山仁波宁贵福生龙元全国胜学祥才发武新利清飞彬富顺信子杰涛昌成康星光天达安岩中茂进林有坚和彪博诚先敬震振壮会思群豪心邦承乐绍功松善厚庆磊民友裕河哲江超浩亮政谦亨奇固之轮翰朗伯宏言若鸣朋斌梁栋维启克伦翔旭鹏泽晨辰士以建家致树炎德行时泰盛雄琛钧冠策腾楠榕风航弘";

        static string _lastNameFeMa = "秀娟英华慧巧美娜静淑惠珠翠雅芝玉萍红娥玲芬芳燕彩春菊兰凤洁梅琳素云莲真环雪荣爱妹霞香月莺媛艳瑞凡佳嘉琼勤珍贞莉桂娣叶璧璐娅琦晶妍茜秋珊莎锦黛青倩婷姣婉娴瑾颖露瑶怡婵雁蓓纨仪荷丹蓉眉君琴蕊薇菁梦岚苑婕馨瑗琰韵融园艺咏卿聪澜纯毓悦昭冰爽琬茗羽希宁欣飘育滢馥筠柔竹霭凝鱼晓欢霄枫芸菲寒伊亚宜可姬舒影荔枝思丽墨";

        public static List<string> GetNames(bool? sex, int count)
        {
            int fLength = _firstName.Length;
            int lLength = 0;

            string nameSource = string.Empty;
            if (sex.HasValue)
            {
                lLength = sex.Value ? _lastNameMale.Length : _lastNameFeMa.Length;
                nameSource = sex.Value ? _lastNameMale : _lastNameFeMa;
            }
            else
            {
                lLength = _lastNameMale.Length + _lastNameFeMa.Length;
                nameSource = string.Concat(_lastNameMale, _lastNameFeMa);
            }

            List<string> names = new List<string>();

            System.Threading.Thread.Sleep(20);
            int[] Indexfn = GenerateNonRepeatArray(count, count);
            System.Threading.Thread.Sleep(20);
            int[] Indexln1 = GenerateNonRepeatArray(count, count);
            System.Threading.Thread.Sleep(20);
            int[] Indexln2 = GenerateNonRepeatArray(count, count);

            int nameLength = nameSource.Length;

            for (int i = 0; i < count; i++)
            {
                int v1 = Indexfn[i];
                int v2 = Indexln1[i];
                int v3 = Indexln2[i];

                if (v1 >= fLength)
                {
                    int j = Indexfn[i] / fLength;
                    v1 = Indexfn[i] - fLength * j;
                }
                if (v2 >= nameLength)
                {
                    int j = Indexln1[i] / nameLength;
                    v2 = Indexln1[i] - nameLength * j;
                }
                if (v3 >= nameLength)
                {
                    int j = Indexln2[i] / nameLength;
                    v3 = Indexln2[i] - nameLength * j;
                }

                if (v1 < 0 || v2 < 0 || v3 < 0)
                {
                    Console.WriteLine();
                }

                if (v1 >= _firstName.Length || v2 >= nameSource.Length || v3 >= nameSource.Length)
                {
                    Console.WriteLine();
                }

                string n1 = string.Empty;
                string n2 = string.Empty;
                string n3 = string.Empty;

                names.Add(string.Format("{0}{1}{2}", _firstName[v1], nameSource[v2], nameSource[v3]));
               
            }

            return names;
        }

        #endregion

        /// <summary>
        /// 返回指定范围内不重复的随机数组,如范围小于数组长度,则返回最多能生成的随机数组
        /// </summary>
        /// <param name="max"></param>
        /// <param name="count"></param>
        /// <returns></returns>
        private static int[] GenerateNonRepeatArray(int max, int count)
        {
            if (max <= 0) { throw new Exception("范围不能等于或小于0"); }

            int size = count > max ? count - max : 0;

            List<int> temp = new List<int>();
            Random ran = new Random();

            while (temp.Count < (count - size))
            {
                int item = ran.Next(max);
                if (!temp.Contains(item))
                {
                    temp.Add(item);
                }
            }

            return temp.ToArray();
        }

       
    }

     
}

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值