程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> MYSQL數據庫 >> MySQL綜合教程 >> MySQL數據庫和sqlserver壓力監測程序實操

MySQL數據庫和sqlserver壓力監測程序實操

編輯:MySQL綜合教程

你是否對獲壓力監測程序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. }*/  
  86. public static void insertNew(int num)  
  87. {  
  88. MySQL(和PHP搭配之最佳組合)Connection con = db.createCon();  
  89. MySQL(和PHP搭配之最佳組合)Command cmd = new MySQL(和PHP搭配之最佳組合)Command();  
  90. try  
  91. {  
  92. for (int i = 0; i < 100; i++)  
  93. {  
  94. string[] times ={"00:10","00:20","00:30","00:40","00:50",  
  95. "01:10","01:20","01:30","01:40","01:50",  
  96. "02:10","02:20","02:30","02:40","02:50",  
  97. "03:10","03:20","03:30","03:40","03:50",  
  98. "04:10","04:20","04:30","04:40","04:50",  
  99. "05:10","05:20","05:30","05:40","05:50",  
  100. "06:10","06:20","06:30","06:40","06:50",  
  101. "07:10","07:20","07:30","07:40","07:50",  
  102. "08:10","08:20","08:30","08:40","09:50",  
  103. "10:10","10:20","10:30","10:40","10:50",  
  104. "11:10","11:20","11:30","11:40","11:50",  
  105. "12:10","12:20","12:30","12:40","12:50",  
  106. "13:10","13:20","13:30","13:40","13:50",  
  107. "14:10","14:20","14:30","14:40","14:50",  
  108. "15:10","15:20","15:30","15:40","15:50",  
  109. "16:10","16:20","16:30","16:40","16:50",  
  110. "17:10","17:20","17:30","17:40","17:50",  
  111. "18:10","18:20","18:30","18:40","18:50",  
  112. "19:10","19:20","19:30","19:40","19:50"};  
  113. System.Random r = new Random();  
  114. int myyl = r.Next(1120, 1890);  
  115. string sql = "insert into yl(sendtime,sendvalue,cgID) values('" + times[i].ToString() + "'," + myyl + ",11)";  
  116. // System.Web.HttpContext.Current.Response.Write(sql);  
  117. con.Open();  
  118. cmd.Connection = con;  
  119. cmd.CommandType = CommandType.Text;  
  120. cmd.CommandText = sql;  
  121. cmd.ExecuteNonQuery();  
  122. cmd.Dispose();  
  123. con.Close();  
  124. }  
  125. }  
  126. catch  
  127. {  
  128. System.Web.HttpContext.Current.Response.Write("dd");  
  129. }  
  130. }   
  131. }  
  132. MySQL(和PHP搭配之最佳組合)> create table yl( ylID int(10) unsigned NOT NULL AUTO_INCREMENT Prima(最完善的虛擬主機管理系統)ry ke  
  133. y, sendtime varchar(20), sendvalue int(10), cgID int(10) not null) ENGINE=MyISAM 
  134. AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;  

以上的相關內容就是對壓力監測程序sqlserver和MySQL數據庫的介紹,望你能有所收獲。

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved