using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Net.NetworkInformation;
using System.Text;
using System.Threading.Tasks;
namespace StudentInsert
{
internal class Program
{
static readonly string[] surnames = new string[] //初始化姓数组
{ "郑", "胡", "张", "李", "王", "赵", "周", "刘", "钱", "孙" };
static readonly string[] names = new string[] //初始化名数组
{ "一", "二", "三", "四", "五", "六", "七", "八", "九", "十" };
static void Main(string[] args)
{//连接student数据库
string connectionString = //数据库连接字符串
"Data Source=.\\SQLExpress;Database=aq;Trusted_Connection=true;";
SqlConnection connection = new SqlConnection(connectionString);//创建数据库连接实例
connection.Open();
Console.WriteLine("数据库aq连接成功!");
Random r = new Random();//随机放在循环外面
Random r1 = new Random();
int i =9;
//向数据库aq的表staq_info中批量添加学生信息
for (int id = 20220001; id < 20220011; id++)
{
SqlCommand cmd = new SqlCommand(); //创建数据查询类实例
cmd.Connection = connection;
//插入学生信息SQL语句
int a = r.Next(0, i);//a是未被添加的随机索引
cmd.CommandText = @"INSERT INTO staq_info
(id,name,age,grade,result,sex)
VALUES(@id,@name,@age,@grade,@result,@sex)";
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;//学号
cmd.Parameters.Add("@name", SqlDbType.VarChar, 10).Value = surnames[a] + names[a]; //姓名
surnames[a] = surnames[i]; names[a] = names[i];//最后一个元素移动到当前位置 ,目的使每个随机添加的姓名都不同(这样最后的都是未被添加的)
cmd.Parameters.Add("@age", SqlDbType.Int).Value = r.Next(20, 25); //年龄
cmd.Parameters.Add("@grade", SqlDbType.Int).Value = r.Next(1, 5); //年级
cmd.Parameters.Add("@result", SqlDbType.Int).Value = r.Next(0, 101); //成绩
cmd.Parameters.Add("@sex", SqlDbType.NChar, 1).Value = r1.Next(2) == 0 ? "男" : "女";
//修改性别值
//string[] genders = { "男", "女", "男", "女" };
//Random r1 = new Random();
//string randomGender = genders[r1.Next(genders.Length)];
//cmd.Parameters.Add("@sex", SqlDbType.NChar, 1).Value = randomGender;
int count = cmd.ExecuteNonQuery(); //执行SQL语句
Console.WriteLine(count);
if (count > 0)
Console.WriteLine("向staq_info表中插入学生信息成功!");
i--;//元素数减一
cmd.Dispose();
}
connection.Close();
Console.ReadKey();
}
}
}
本实例代码主要利用SQL语句向数据表中插入10条学生信息。首先通过SqlConnection对象连接数据库,然后创建SqlCommand对象执行插入学生信息操作。SqlConnection对象赋值给SqlCommand对象的Connection属性,将SQL查询语句赋值给SqlCommand对象的CommandText属性,调用SqlCommand对象的Parameters属性的Add方法为SQL语句中的变量赋值。最后通过SqlCommand对象的ExecuteNonQuery方法执行插入操作。
运行C#代码:
然后在SQL Server Management Studio Management Studio 查看插入信息结果(先刷新):