压力监测程序sqlserver和MYSQL版_ASP.NET技巧

时间：2010-10-13 来源：蔚蓝的大海

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;

Replica lv Hangbags

discount Hangbags

Hangbags

replica handbags

handbags

replica handbags

replica handbags replica handbags discount designer handbags handbags handbags handbags replica handbags replica handbags replica handbags replica handbags replica handbags discount designer handbags replica handbags replica handbags replica handbags replica handbags replica handbags replica handbags replica handbags replica handbags replica handbags discount handbags replica designer handbags discount designer handbags

usb cable

usb flash drives

usb flash drives usb flash drives usb flash drives USB Connectors,HDMI Cable,Custom Usb Flash Drives USB Connector Replica Watches Replica Watches Replica Watches Replica designer Watches Replica Watches Replica Watches cheap Watches replica Watches replica Watches replica Watches replica Watches replica Watches
Replica Chanel Wallet Classic Wallet - Bifold Chanel-CC1400 HandbagsReplica Chanel Wallet Classic Wallet - Compact Chanel-CC1380 HandbagsReplica Chanel Wallet Classic Wallet - Fold Chanel-CC1410 HandbagsReplica Chanel Wallet Classic Wallet - Medium Chanel-CC1390 HandbagsReplica Chanel Wallet cosmetic -bronze chanel B0026 Chanel-B0026 HandbagsReplica Chanel Wallet cosmetic -gold chanel B0027 Chanel-B0027 HandbagsReplica Chanel Wallet cosmetic -pink chanel B0030 Chanel-B0030 HandbagsReplica Chanel Wallet cosmetic -red chanel B00 chanel B0029 Chanel-B0029 HandbagsReplica Chanel Wallet Denim Fold Wallet Chanel-CC1430 HandbagsReplica Chanel Wallet Denim Long Zipper Wallet Chanel-CC1420 HandbagsReplica Chanel Wallet Embossed Detail Wallet - Beige Chanel-CC1850 HandbagsReplica Chanel Wallet Embossed Detail Wallet - Black Chanel-CC1860 HandbagsReplica Chanel Wallet Embossed Detail Wallet - Gold Chanel-CC1870 HandbagsReplica Chanel Wallet Embossed Detail Wallet - Pink Chanel-CC1880 HandbagsReplica Chanel Wallet Embossed Detail Wallet - Silver Chanel-CC1890 HandbagsReplica Chanel Wallet fold 31511-red Chanel A0017 Chanel-A0017 HandbagsReplica Chanel Wallet key holder 048 - beige Chanel-048--beige HandbagsReplica Chanel Wallet key holder 048 - black with shinning CC Chanel-048--black-with-shinnin HandbagsReplica Chanel Wallet Leather Wallet Large Fold - Black on Black Chanel-CC1260 HandbagsReplica Chanel Wallet Leather Wallet Medium Fold - Black on Black Chanel-CC1210 Handbags