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>
/// Summary of the database
/// </Summary>
Public class DB
{
Public dB ()
{
//
// Todo: add the constructor logic here
//
}
/* 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 ",
",
",
",
",
"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 ",
",
"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 ",
",
",
"15: 10", "15: 20", "15: 30", "15: 40", "15: 50 ",
"16: 10", "16: 20", "16: 30", "16: 40", "16: 50 ",
"10 10", "17:20", "17:30", "17:40", "17:50 ",
",
"19:10", "19:20", "19:30", "19:40", "19:50 "};
System. Random r = new random ();
Int myyl = R. Next (1120,189 0 );
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 ",
",
",
",
",
"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 ",
",
"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 ",
",
",
"15: 10", "15: 20", "15: 30", "15: 40", "15: 50 ",
"16: 10", "16: 20", "16: 30", "16: 40", "16: 50 ",
"10 10", "17:20", "17:30", "17:40", "17:50 ",
",
"19:10", "19:20", "19:30", "19:40", "19:50 "};
System. Random r = new random ();
Int myyl = R. Next (1120,189 0 );
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;