压力监测程序sqlserver和mysql版_asp.net技巧

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;