using System; /// <summary> mysql> create table yl( ylID int(10) unsigned NOT NULL AUTO_INCREMENT primary ke
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;
/// 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”);
}
}
}
y, sendtime varchar(20), sendvalue int(10), cgID int(10) not null) ENGINE=MyISAM
AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
压力监测程序sqlserver和mysql版_asp.net技巧
版权申明:本站文章部分自网络,如有侵权,请联系:west999com@outlook.com 特别注意:本站所有转载文章言论不代表本站观点! 本站所提供的图片等素材,版权归原作者所有,如需使用,请与原作者联系。未经允许不得转载:IDC资讯中心 » 压力监测程序sqlserver和mysql版_asp.net技巧
相关推荐
-      对.net framework 反射的反思_asp.net技巧
-      .net3.5和vs2008中的asp.net ajax_asp.net技巧
-      使用asp.net ajax框架扩展html map控件_asp.net技巧
-      asp.net应用程序资源访问安全模型_asp.net技巧
-      photoshop初学者轻松绘制螺旋漩涡特效_photoshop教程
-      photoshop通道结合图层模式抠狗尾巴草_photoshop教程
-      web.config详解+asp.net优化_asp.net技巧
-      asp.net中多彩下拉框的实现_asp.net技巧