当前位置:Gxlcms > mysql > MySQL数据库和sqlserver压力监测程序实操

MySQL数据库和sqlserver压力监测程序实操

时间:2021-07-01 10:21:17 帮助过:28人阅读

你是否对获压力监测程序MySQL数据库和sqlserver的实际操作感到很是头疼?别急,以下的文章将会给你相应的解决方案,以下的文章主要是介绍获得压力监测程序 MySQL数据库和sqlserver的方案,以下就是其具体内容描述。 usingSystem.Data; usingSystem.Data.SqlC

你是否对获压力监测程序MySQL数据库和sqlserver的实际操作感到很是头疼?别急,以下的文章将会给你相应的解决方案,以下的文章主要是介绍获得压力监测程序 MySQL数据库和sqlserver的方案,以下就是其具体内容描述。

  1. using System.Data;
  2. using System.Data.SqlClient;
  3. using System.Configuration;
  4. using System.Web;
  5. using System.Web.Security;
  6. using System.Web.UI;
  7. using System.Web.UI.WebControls;
  8. using System.Web.UI.WebControls.WebParts;
  9. using System.Web.UI.HtmlControls;
  10. using MySQL(和PHP搭配之最佳组合)DriverCS;
  11. /// <summary>

db 的摘要说明

  1. /// summary>
  2. public class db
  3. {
  4. public db()
  5. {
  6. //
  7. // TODO: 在此处添加构造函数逻辑
  8. //
  9. }
  10. /* public static SqlConnection createCon()
  11. {
  12. return new SqlConnection("server=.;database=ylcg;uid=sa;pwd=123456;");
  13. }*/
  14. public static MySQL(和PHP搭配之最佳组合)Connection createCon()
  15. {
  16. return new MySQL(和PHP搭配之最佳组合)Connection(new MySQL(和PHP搭配之最佳组合)ConnectionString("localhost","ylcg","root","123456").AsString);
  17. }
  18. /* public static DataTable ylTable()
  19. {
  20. SqlConnection con = db.createCon();
  21. SqlDataAdapter sda = new SqlDataAdapter();
  22. sda.SelectCommand = new SqlCommand("select * from yl", con);
  23. DataSet myds = new DataSet();
  24. sda.Fill(myds, "yl");
  25. sda.Dispose();
  26. con.Close();
  27. return myds.Tables["yl"];
  28. }*/
  29. public static DataTable ylTable()
  30. {
  31. MySQL(和PHP搭配之最佳组合)Connection con = db.createCon();
  32. MySQL(和PHP搭配之最佳组合)DataAdapter sda = new MySQL(和PHP搭配之最佳组合)DataAdapter();
  33. sda.SelectCommand = new MySQL(和PHP搭配之最佳组合)Command("select * from yl",con);
  34. DataSet myds = new DataSet();
  35. sda.Fill(myds, "yl");
  36. sda.Dispose();
  37. con.Close();
  38. return myds.Tables["yl"];
  39. }
  40. /* public static void insertNew(int num)
  41. {
  42. SqlConnection con = db.createCon();
  43. SqlCommand cmd = new SqlCommand();
  44. try
  45. {
  46. for (int i = 0; i < 100; i++)
  47. {
  48. string[] times ={"00:10","00:20","00:30","00:40","00:50",
  49. "01:10","01:20","01:30","01:40","01:50",
  50. "02:10","02:20","02:30","02:40","02:50",
  51. "03:10","03:20","03:30","03:40","03:50",
  52. "04:10","04:20","04:30","04:40","04:50",
  53. "05:10","05:20","05:30","05:40","05:50",
  54. "06:10","06:20","06:30","06:40","06:50",
  55. "07:10","07:20","07:30","07:40","07:50",
  56. "08:10","08:20","08:30","08:40","09:50",
  57. "10:10","10:20","10:30","10:40","10:50",
  58. "11:10","11:20","11:30","11:40","11:50",
  59. "12:10","12:20","12:30","12:40","12:50",
  60. "13:10","13:20","13:30","13:40","13:50",
  61. "14:10","14:20","14:30","14:40","14:50",
  62. "15:10","15:20","15:30","15:40","15:50",
  63. "16:10","16:20","16:30","16:40","16:50",
  64. "17:10","17:20","17:30","17:40","17:50",
  65. "18:10","18:20","18:30","18:40","18:50",
  66. "19:10","19:20","19:30","19:40","19:50"};
  67. System.Random r = new Random();
  68. int myyl = r.Next(1120, 1890);
  69. string sql = "insert into yl values('" + times[i].ToString() + "'," + myyl + ",11)";
  70. // System.Web.HttpContext.Current.Response.Write(sql);
  71. con.Open();
  72. cmd.Connection = con;
  73. cmd.CommandType = CommandType.Text;
  74. cmd.CommandText = sql;
  75. cmd.ExecuteNonQuery();
  76. cmd.Dispose();
  77. con.Close();
  78. }
  79. }
  80. catch
  81. {
  82. System.Web.HttpContext.Current.Response.Write("dd");
  83. }
  84. }*/
  85. public static void insertNew(int num)
  86. {
  87. MySQL(和PHP搭配之最佳组合)Connection con = db.createCon();
  88. MySQL(和PHP搭配之最佳组合)Command cmd = new MySQL(和PHP搭配之最佳组合)Command();
  89. try
  90. {
  91. for (int i = 0; i < 100; i++)
  92. {
  93. string[] times ={"00:10","00:20","00:30","00:40","00:50",
  94. "01:10","01:20","01:30","01:40","01:50",
  95. "02:10","02:20","02:30","02:40","02:50",
  96. "03:10","03:20","03:30","03:40","03:50",
  97. "04:10","04:20","04:30","04:40","04:50",
  98. "05:10","05:20","05:30","05:40","05:50",
  99. "06:10","06:20","06:30","06:40","06:50",
  100. "07:10","07:20","07:30","07:40","07:50",
  101. "08:10","08:20","08:30","08:40","09:50",
  102. "10:10","10:20","10:30","10:40","10:50",
  103. "11:10","11:20","11:30","11:40","11:50",
  104. "12:10","12:20","12:30","12:40","12:50",
  105. "13:10","13:20","13:30","13:40","13:50",
  106. "14:10","14:20","14:30","14:40","14:50",
  107. "15:10","15:20","15:30","15:40","15:50",
  108. "16:10","16:20","16:30","16:40","16:50",
  109. "17:10","17:20","17:30","17:40","17:50",
  110. "18:10","18:20","18:30","18:40","18:50",
  111. "19:10","19:20","19:30","19:40","19:50"};
  112. System.Random r = new Random();
  113. int myyl = r.Next(1120, 1890);
  114. string sql = "insert into yl(sendtime,sendvalue,cgID) values('" + times[i].ToString() + "'," + myyl + ",11)";
  115. // System.Web.HttpContext.Current.Response.Write(sql);
  116. con.Open();
  117. cmd.Connection = con;
  118. cmd.CommandType = CommandType.Text;
  119. cmd.CommandText = sql;
  120. cmd.ExecuteNonQuery();
  121. cmd.Dispose();
  122. con.Close();
  123. }
  124. }
  125. catch
  126. {
  127. System.Web.HttpContext.Current.Response.Write("dd");
  128. }
  129. }
  130. }
  131. MySQL(和PHP搭配之最佳组合)> create table yl( ylID int(10) unsigned NOT NULL AUTO_INCREMENT Prima(最完善的虚拟主机管理系统)ry ke
  132. y, sendtime varchar(20), sendvalue int(10), cgID int(10) not null) ENGINE=MyISAM
  133. AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

以上的相关内容就是对压力监测程序sqlserver和MySQL数据库的介绍,望你能有所收获。

人气教程排行