压力监测程序sqlserver和MYSQL版

核心提示：using System;using System.Data;using System.Data.SqlClient;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using Syste

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MySQLDriverCS;

/// <summary>
/// db 的摘要说明
/// </summary>
public class db
{
 public db()
 {
  //
  // TODO: 在此处添加构造函数逻辑
  //
 }
  /*  public static SqlConnection createCon()
　  {
　　　  return new SqlConnection("server=.;database=ylcg;uid=sa;pwd=123456;");
　  }*/
　  public static MySQLConnection createCon()
　  {
　　　  return new MySQLConnection(new MySQLConnectionString("localhost","ylcg","root","123456").AsString);
　  }
　 /* public static DataTable ylTable()
　  {
　　　  SqlConnection con = db.createCon();
　　　  SqlDataAdapter sda = new SqlDataAdapter();
　　　  sda.SelectCommand = new SqlCommand("select * from yl", con);
　　　  DataSet myds = new DataSet();
　　　  sda.Fill(myds, "yl");
　　　  sda.Dispose();
　　　  con.Close();
　　　  return myds.Tables["yl"];　　　
　  }*/
　  public static DataTable ylTable()
　  {
　　　  MySQLConnection con = db.createCon();
　　　  MySQLDataAdapter sda = new MySQLDataAdapter();
　　　  sda.SelectCommand = new MySQLCommand("select * from yl",con);
　　　  DataSet myds = new DataSet();
　　　  sda.Fill(myds, "yl");
　　　  sda.Dispose();
　　　  con.Close();
　　　  return myds.Tables["yl"];　　　
　  }
 /*　 public static void insertNew(int num)
　  {
　　　  SqlConnection con = db.createCon();
　　　  SqlCommand cmd = new SqlCommand();
　　　  try
　　　  {
　　　　　  for (int i = 0; i < 100; i++)
　　　　　  {
　　　　　　　  string[] times ={"00:10","00:20","00:30","00:40","00:50",
　　　　　　　　　  "01:10","01:20","01:30","01:40","01:50",
　　　　　　　  "02:10","02:20","02:30","02:40","02:50",
　　　　　　　  "03:10","03:20","03:30","03:40","03:50",
　　　　　　　  "04:10","04:20","04:30","04:40","04:50",
　　　　　　　  "05:10","05:20","05:30","05:40","05:50",
　　　　　　　  "06:10","06:20","06:30","06:40","06:50",
　　　　　　　　 "07:10","07:20","07:30","07:40","07:50",
　　　　　　　　 "08:10","08:20","08:30","08:40","09:50",
　　　　　　　　 "10:10","10:20","10:30","10:40","10:50",
　　　　　　　　 "11:10","11:20","11:30","11:40","11:50",
　　　　　　　  "12:10","12:20","12:30","12:40","12:50",
　　　　　　　  "13:10","13:20","13:30","13:40","13:50",
　　　　　　　  "14:10","14:20","14:30","14:40","14:50",
　　　　　　　  "15:10","15:20","15:30","15:40","15:50",
　　　　　　　  "16:10","16:20","16:30","16:40","16:50",
　　　　　　　  "17:10","17:20","17:30","17:40","17:50",
　　　　　　　  "18:10","18:20","18:30","18:40","18:50",
　　　　　　　  "19:10","19:20","19:30","19:40","19:50"};
　　　　　　　  System.Random r = new Random();
　　　　　　　  int myyl = r.Next(1120, 1890);
　　　　　　　  string sql = "insert into yl values('" + times[i].ToString() + "'," + myyl + ",11)";
　　　　　　 //　 System.Web.HttpContext.Current.Response.Write(sql);
　　　　　　　  con.Open();
　　　　　　　  cmd.Connection = con;
　　　　　　　  cmd.CommandType = CommandType.Text;
　　　　　　　  cmd.CommandText = sql;
　　　　　　　  cmd.ExecuteNonQuery();
　　　　　　　  cmd.Dispose();
　　　　　　　  con.Close();
　　　　　  }
　　　  }
　　　  catch
　　　  {
　　　　　  System.Web.HttpContext.Current.Response.Write("dd");
　　　  }
　　　
　  }*/
　  public static void insertNew(int num)
　  {
　　　  MySQLConnection con = db.createCon();
　　　  MySQLCommand cmd = new MySQLCommand();
　　　  try
　　　  {
　　　　　  for (int i = 0; i < 100; i++)
　　　　　  {
　　　　　　　  string[] times ={"00:10","00:20","00:30","00:40","00:50",
　　　　　　　　　  "01:10","01:20","01:30","01:40","01:50",
　　　　　　　  "02:10","02:20","02:30","02:40","02:50",
　　　　　　　  "03:10","03:20","03:30","03:40","03:50",
　　　　　　　  "04:10","04:20","04:30","04:40","04:50",
　　　　　　　  "05:10","05:20","05:30","05:40","05:50",
　　　　　　　  "06:10","06:20","06:30","06:40","06:50",
　　　　　　　　 "07:10","07:20","07:30","07:40","07:50",
　　　　　　　　 "08:10","08:20","08:30","08:40","09:50",
　　　　　　　　 "10:10","10:20","10:30","10:40","10:50",
　　　　　　　　 "11:10","11:20","11:30","11:40","11:50",
　　　　　　　  "12:10","12:20","12:30","12:40","12:50",
　　　　　　　  "13:10","13:20","13:30","13:40","13:50",
　　　　　　　  "14:10","14:20","14:30","14:40","14:50",
　　　　　　　  "15:10","15:20","15:30","15:40","15:50",
　　　　　　　  "16:10","16:20","16:30","16:40","16:50",
　　　　　　　  "17:10","17:20","17:30","17:40","17:50",
　　　　　　　  "18:10","18:20","18:30","18:40","18:50",
　　　　　　　  "19:10","19:20","19:30","19:40","19:50"};
　　　　　　　  System.Random r = new Random();
　　　　　　　  int myyl = r.Next(1120, 1890);
　　　　　　　  string sql = "insert into yl(sendtime,sendvalue,cgID) values('" + times[i].ToString() + "'," + myyl + ",11)";
　　　　　　　  //　 System.Web.HttpContext.Current.Response.Write(sql);
　　　　　　　  con.Open();
　　　　　　　  cmd.Connection = con;
　　　　　　　  cmd.CommandType = CommandType.Text;
　　　　　　　  cmd.CommandText = sql;
　　　　　　　  cmd.ExecuteNonQuery();
　　　　　　　  cmd.Dispose();
　　　　　　　  con.Close();
　　　　　  }
　　　  }
　　　  catch
　　　  {
　　　　　  System.Web.HttpContext.Current.Response.Write("dd");
　　　  }
　  }　　
}
 

mysql> create table yl( ylID int(10) unsigned NOT NULL AUTO_INCREMENT PRimary ke
y, sendtime varchar(20), sendvalue int(10), cgID int(10) not null) ENGINE=MyISAM
 AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;