数据库自批量插入工具源码及使用方法.docxVIP

该代码由c#编程，需要使用VS2010工具。该软件可以像mysql中插入数据。需要有Mysql.data.dall（mysql/bin）。才能使用。以下是操作截图。源码：Program:using System;using System.Collections.Generic;using System.Linq;using System.Windows.Forms;namespace Insert{ static class Program { /// summary /// 应?|用??程¨?序¨°的ì?主??入¨?口¨2点ì?。?ê /// /summary [STAThread] static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new Form1()); } }}Class1:using System;using System.Collections.Generic;using System.Linq;using System.Text;using MySql.Data.MySqlClient;using System.Windows.Forms;namespace Insert{ class Msql { public static MySqlConnection mysqlconn(string database, string IP, string ID, string PW) { String mysqlStr = Database= + database + ;Data Source= + IP + ;User Id= + ID + ;Password= + PW + ;pooling=false;CharSet=utf8;port=3306;//数oy据Y库a连￠?接¨?参?数oy MySqlConnection mysql = new MySqlConnection(mysqlStr);//连￠?接¨?数oy据Y库a return mysql; } public static MySqlCommand getSqlCommand(String sql, MySqlConnection mysql) { MySqlCommand mySqlCommand = new MySqlCommand(sql, mysql); return mySqlCommand; } }}Form1: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;using MySql.Data.MySqlClient;namespace Insert{ public partial class Form1 : Form { public Form1() { InitializeComponent(); textBox1.Text = net_grid_wlc_community; textBox2.Text = 28; textBox3.Text = root; textBox4.Text = root; } private void button1_Click_1(object sender, EventArgs e) { int b = Convert.ToInt32(textBox5 .Text); for (int i = 1; i b + 1; i++) { MySqlConnection mysql = Msql.mysqlconn(textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text); string sqlInsert = + richTextBox1.Text + ; MySqlCommand mySqlCommand = Msql.getSqlCommand(sqlInsert, mysql);//调ì??用??方¤?法¤?§ try { mysql.Open();//打?¨°开a数oy据Y库a } catch (Exception ex) { String message = ex.Message; MessageBox.Sh