压力监测程序sqlserver和MYSQL版

王朝mysql·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

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;

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航