写一个程序,能够动态生成多条插入语句如:insert into MyStudents values(“人名1”,年龄,‘男’,分数1,分数2)。将生成的插入语句输出到记事本文件 SQLStr.txt中
窗体应用程序insert.cs:后台
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 System.IO;
namespace NameGenerator
{
public partial class Insert : Form
{
public Insert()
{
InitializeComponent();
}
static public int chushi(Random tmp)
{
int age = tmp.Next(1, 120);
return age;
}
private void button1_Click(object sender, EventArgs e)
{
List<string> MaleNames = NameHelper.GetNames(true, Convert.ToInt32(number.Text)); //100个男性名字
List<string> FemaleNames = NameHelper.GetNames(false, Convert.ToInt32(number.Text)); //100个女性名字
Console.WriteLine("100个男性名字\n");
Stream streamw = File.Open(@"C:\Users\PC_think\Desktop\SQLStr.txt", FileMode.OpenOrCreate, FileAccess.Write);
StreamWriter sw = new StreamWriter(streamw);
if (comboBox1.Text == "男")
{
string[] item = new string[100];
for (int i = 0; i < Convert.ToInt32(number.Text); i++)
{
item[i] = MaleNames[i];
Random rage = new Random();
int age = chushi(rage);
Random rmath = new Random();
int math = rmath.Next(1,99);
for (int n = 0; n < 1000000; n++)
{ }