用Winfrom动态生成SQL的insert语句

本文主要是介绍用Winfrom动态生成SQL的insert语句，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

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();
}

form1的代码动态生成任意条数据:

private void button1_Click(object sender, EventArgs e)
{

SaveFileDialog sfd = new SaveFileDialog();
sfd.Title = "保存文件";
sfd.Filter = "文本文件|*.txt|网页文件|*.html|所有文件|*.*";
//声明一个文件流对象。。
if (sfd.ShowDialog() == DialogResult.OK)
{

///保存文件
//第一步声明一个文件流对像
FileStream fs = new FileStream(sfd.FileName, FileMode.Create);
//第二步穿件写入器
StreamWriter sw = new StreamWriter(fs, Encoding.Default);
//第三步写操作
if (textBox1.Text != "")
{
List<string> MaleNames = NameHelper.GetNames(true, Convert.ToInt32(textBox1.Text)); //textBox1个男性名字

foreach (var item in MaleNames)
{
Random Age = new Random();
int age = Age.Next(10, 101);

for (int i = 0; i <= 1000000; i++)
{ }

Random Math = new Random();
int math = Age.Next(0, 100);

for (int i = 0; i <= 1000000; i++)
{ }

Random English = new Random();
int english = Age.Next(0, 100);

for (int i = 0; i <= 1000000; i++)
{ }
sw.WriteLine("insert into " + textBox2.Text + " values（'" + item + "'，" + age + "，" + "男" + "，" + math + "," + english + ")");
//释放写入器和写操做

}
}

if (textBox3.Text != "")
{
List<string> FemaleNames = NameHelper.GetNames(false, Convert.ToInt32(textBox3.Text)); //textBox3个女性名字

foreach (var item in FemaleNames)
{
Random Age = new Random();
int age = Age.Next(10, 101);

for (int i = 0; i <= 1000000; i++)
{ }

Random Math = new Random();
int math = Age.Next(0, 100);

for (int i = 0; i <= 1000000; i++)
{ }

Random English = new Random();
int english = Age.Next(0, 100);

for (int i = 0; i <= 1000000; i++)
{ }
sw.WriteLine("insert into " + textBox2.Text + " values（'" + item + "'，" + age + "，" + "女" + "，" + math + "," + english + ")");
}

}

sw.Close();
fs.Close();

}

MessageBox.Show("写入完成");
}