社群 學習 工具庫 休閒
搜尋
繁体中文
首頁 > 資料庫 > mysql教程 > 主體

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

WBOY
發布： 2016-06-07 16:11:30
原創
801 人瀏覽過

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

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

<ol class="dp-xml">
<li class="alt"><span><span>using System.Data;  </span></span></li>
<li><span>using System.Data.SqlClient;  </span></li>
<li class="alt"><span>using System.Configuration;  </span></li>
<li><span>using System.Web;  </span></li>
<li class="alt"><span>using System.Web.Security;  </span></li>
<li><span>using System.Web.UI;  </span></li>
<li class="alt"><span>using System.Web.UI.WebControls;  </span></li>
<li><span>using System.Web.UI.WebControls.WebParts;  </span></li>
<li class="alt"><span>using System.Web.UI.HtmlControls;  </span></li>
<li>
<span>using </span>MySQL<span>(和PHP搭配之最佳组合)DriverCS;  </span>
</li>
<li class="alt">
<span>/// </span><span class="tag"><span class="tag-name">summary</span><span class="tag">></span><span> </span></span>
</li>
</ol>
登入後複製

db 的摘要说明

<ol class="dp-xml">
<li class="alt"><span><span>/// </span><span class="tag"></span><span class="tag-name">summary</span><span class="tag">></span><span> </span></span></li>
<li><span>public class db  </span></li>
<li class="alt"><span>{  </span></li>
<li><span>public db()  </span></li>
<li class="alt"><span>{  </span></li>
<li><span>//  </span></li>
<li class="alt"><span>// TODO: 在此处添加构造函数逻辑  </span></li>
<li><span>//  </span></li>
<li class="alt"><span>}  </span></li>
<li><span>/* public static SqlConnection createCon()  </span></li>
<li class="alt"><span>{  </span></li>
<li>
<span>return new SqlConnection("</span><span class="attribute">server</span><span>=.;</span><span class="attribute">database</span><span>=</span><span class="attribute-value">ylcg</span><span>;</span><span class="attribute">uid</span><span>=</span><span class="attribute-value">sa</span><span>;</span><span class="attribute">pwd</span><span>=</span><span class="attribute-value">123456</span><span>;");  </span>
</li>
<li class="alt"><span>}*/  </span></li>
<li>
<span>public static </span>MySQL<span>(和PHP搭配之最佳组合)Connection createCon()  </span>
</li>
<li class="alt"><span>{  </span></li>
<li>
<span>return new </span>MySQL<span>(和PHP搭配之最佳组合)Connection(new </span>MySQL<span>(和PHP搭配之最佳组合)ConnectionString("localhost","ylcg","root","123456").AsString);  </span>
</li>
<li class="alt"><span>}  </span></li>
<li><span>/* public static DataTable ylTable()  </span></li>
<li class="alt"><span>{  </span></li>
<li>
<span>SqlConnection </span><span class="attribute">con</span><span> = </span><span class="attribute-value">db</span><span>.createCon();  </span>
</li>
<li class="alt">
<span>SqlDataAdapter </span><span class="attribute">sda</span><span> = </span><span class="attribute-value">new</span><span> SqlDataAdapter();  </span>
</li>
<li>
<span class="attribute">sda.SelectCommand</span><span> = </span><span class="attribute-value">new</span><span> SqlCommand("select * from yl", con);  </span>
</li>
<li class="alt">
<span>DataSet </span><span class="attribute">myds</span><span> = </span><span class="attribute-value">new</span><span> DataSet();  </span>
</li>
<li><span>sda.Fill(myds, "yl");  </span></li>
<li class="alt"><span>sda.Dispose();  </span></li>
<li><span>con.Close();  </span></li>
<li class="alt"><span>return myds.Tables["yl"];   </span></li>
<li><span>}*/  </span></li>
<li class="alt"><span>public static DataTable ylTable()  </span></li>
<li><span>{  </span></li>
<li class="alt">MySQL<span>(和PHP搭配之最佳组合)Connection </span><span class="attribute">con</span><span> = </span><span class="attribute-value">db</span><span>.createCon();  </span>
</li>
<li>MySQL<span>(和PHP搭配之最佳组合)DataAdapter </span><span class="attribute">sda</span><span> = </span><span class="attribute-value">new</span><span> </span>MySQL<span>(和PHP搭配之最佳组合)DataAdapter();  </span>
</li>
<li class="alt">
<span class="attribute">sda.SelectCommand</span><span> = </span><span class="attribute-value">new</span><span> </span>MySQL<span>(和PHP搭配之最佳组合)Command("select * from yl",con);  </span>
</li>
<li>
<span>DataSet </span><span class="attribute">myds</span><span> = </span><span class="attribute-value">new</span><span> DataSet();  </span>
</li>
<li class="alt"><span>sda.Fill(myds, "yl");  </span></li>
<li><span>sda.Dispose();  </span></li>
<li class="alt"><span>con.Close();  </span></li>
<li><span>return myds.Tables["yl"];   </span></li>
<li class="alt"><span>}  </span></li>
<li><span>/* public static void insertNew(int num)  </span></li>
<li class="alt"><span>{  </span></li>
<li>
<span>SqlConnection </span><span class="attribute">con</span><span> = </span><span class="attribute-value">db</span><span>.createCon();  </span>
</li>
<li class="alt">
<span>SqlCommand </span><span class="attribute">cmd</span><span> = </span><span class="attribute-value">new</span><span> SqlCommand();  </span>
</li>
<li><span>try  </span></li>
<li class="alt"><span>{  </span></li>
<li>
<span>for (int </span><span class="attribute">i</span><span> = </span><span class="attribute-value">0</span><span>; i </span><span class="tag"><span> </span><span class="tag-name">100</span><span>; i++)  </span></span>
</li>
<li class="alt"><span>{  </span></li>
<li>
<span>string[] </span><span class="attribute">times</span><span> ={"00:10","00:20","00:30","00:40","00:50",  </span>
</li>
<li class="alt"><span>"01:10","01:20","01:30","01:40","01:50",  </span></li>
<li><span>"02:10","02:20","02:30","02:40","02:50",  </span></li>
<li class="alt"><span>"03:10","03:20","03:30","03:40","03:50",  </span></li>
<li><span>"04:10","04:20","04:30","04:40","04:50",  </span></li>
<li class="alt"><span>"05:10","05:20","05:30","05:40","05:50",  </span></li>
<li><span>"06:10","06:20","06:30","06:40","06:50",  </span></li>
<li class="alt"><span>"07:10","07:20","07:30","07:40","07:50",  </span></li>
<li><span>"08:10","08:20","08:30","08:40","09:50",  </span></li>
<li class="alt"><span>"10:10","10:20","10:30","10:40","10:50",  </span></li>
<li><span>"11:10","11:20","11:30","11:40","11:50",  </span></li>
<li class="alt"><span>"12:10","12:20","12:30","12:40","12:50",  </span></li>
<li><span>"13:10","13:20","13:30","13:40","13:50",  </span></li>
<li class="alt"><span>"14:10","14:20","14:30","14:40","14:50",  </span></li>
<li><span>"15:10","15:20","15:30","15:40","15:50",  </span></li>
<li class="alt"><span>"16:10","16:20","16:30","16:40","16:50",  </span></li>
<li><span>"17:10","17:20","17:30","17:40","17:50",  </span></li>
<li class="alt"><span>"18:10","18:20","18:30","18:40","18:50",  </span></li>
<li><span>"19:10","19:20","19:30","19:40","19:50"};  </span></li>
<li class="alt">
<span>System.Random </span><span class="attribute">r</span><span> = </span><span class="attribute-value">new</span><span> Random();  </span>
</li>
<li>
<span>int </span><span class="attribute">myyl</span><span> = </span><span class="attribute-value">r</span><span>.Next(1120, 1890);  </span>
</li>
<li class="alt">
<span>string </span><span class="attribute">sql</span><span> = </span><span class="attribute-value">"insert into yl values('"</span><span> + times[i].ToString() + "'," + myyl + ",11)";  </span>
</li>
<li><span>// System.Web.HttpContext.Current.Response.Write(sql);  </span></li>
<li class="alt"><span>con.Open();  </span></li>
<li>
<span class="attribute">cmd.Connection</span><span> = </span><span class="attribute-value">con</span><span>;  </span>
</li>
<li class="alt">
<span class="attribute">cmd.CommandType</span><span> = CommandType.Text;  </span>
</li>
<li>
<span class="attribute">cmd.CommandText</span><span> = </span><span class="attribute-value">sql</span><span>;  </span>
</li>
<li class="alt"><span>cmd.ExecuteNonQuery();  </span></li>
<li><span>cmd.Dispose();  </span></li>
<li class="alt"><span>con.Close();  </span></li>
<li><span>}  </span></li>
<li class="alt"><span>}  </span></li>
<li><span>catch  </span></li>
<li class="alt"><span>{  </span></li>
<li><span>System.Web.HttpContext.Current.Response.Write("dd");  </span></li>
<li class="alt"><span>}   </span></li>
<li><span> </span></li>
<li class="alt"><span>}*/  </span></li>
<li><span>public static void insertNew(int num)  </span></li>
<li class="alt"><span>{  </span></li>
<li>MySQL<span>(和PHP搭配之最佳组合)Connection </span><span class="attribute">con</span><span> = </span><span class="attribute-value">db</span><span>.createCon();  </span>
</li>
<li class="alt">MySQL<span>(和PHP搭配之最佳组合)Command </span><span class="attribute">cmd</span><span> = </span><span class="attribute-value">new</span><span> </span>MySQL<span>(和PHP搭配之最佳组合)Command();  </span>
</li>
<li><span>try  </span></li>
<li class="alt"><span>{  </span></li>
<li>
<span>for (int </span><span class="attribute">i</span><span> = </span><span class="attribute-value">0</span><span>; i </span><span class="tag"><span> </span><span class="tag-name">100</span><span>; i++)  </span></span>
</li>
<li class="alt"><span>{  </span></li>
<li>
<span>string[] </span><span class="attribute">times</span><span> ={"00:10","00:20","00:30","00:40","00:50",  </span>
</li>
<li class="alt"><span>"01:10","01:20","01:30","01:40","01:50",  </span></li>
<li><span>"02:10","02:20","02:30","02:40","02:50",  </span></li>
<li class="alt"><span>"03:10","03:20","03:30","03:40","03:50",  </span></li>
<li><span>"04:10","04:20","04:30","04:40","04:50",  </span></li>
<li class="alt"><span>"05:10","05:20","05:30","05:40","05:50",  </span></li>
<li><span>"06:10","06:20","06:30","06:40","06:50",  </span></li>
<li class="alt"><span>"07:10","07:20","07:30","07:40","07:50",  </span></li>
<li><span>"08:10","08:20","08:30","08:40","09:50",  </span></li>
<li class="alt"><span>"10:10","10:20","10:30","10:40","10:50",  </span></li>
<li><span>"11:10","11:20","11:30","11:40","11:50",  </span></li>
<li class="alt"><span>"12:10","12:20","12:30","12:40","12:50",  </span></li>
<li><span>"13:10","13:20","13:30","13:40","13:50",  </span></li>
<li class="alt"><span>"14:10","14:20","14:30","14:40","14:50",  </span></li>
<li><span>"15:10","15:20","15:30","15:40","15:50",  </span></li>
<li class="alt"><span>"16:10","16:20","16:30","16:40","16:50",  </span></li>
<li><span>"17:10","17:20","17:30","17:40","17:50",  </span></li>
<li class="alt"><span>"18:10","18:20","18:30","18:40","18:50",  </span></li>
<li><span>"19:10","19:20","19:30","19:40","19:50"};  </span></li>
<li class="alt">
<span>System.Random </span><span class="attribute">r</span><span> = </span><span class="attribute-value">new</span><span> Random();  </span>
</li>
<li>
<span>int </span><span class="attribute">myyl</span><span> = </span><span class="attribute-value">r</span><span>.Next(1120, 1890);  </span>
</li>
<li class="alt">
<span>string </span><span class="attribute">sql</span><span> = </span><span class="attribute-value">"insert into yl(sendtime,sendvalue,cgID) values('"</span><span> + times[i].ToString() + "'," + myyl + ",11)";  </span>
</li>
<li><span>// System.Web.HttpContext.Current.Response.Write(sql);  </span></li>
<li class="alt"><span>con.Open();  </span></li>
<li>
<span class="attribute">cmd.Connection</span><span> = </span><span class="attribute-value">con</span><span>;  </span>
</li>
<li class="alt">
<span class="attribute">cmd.CommandType</span><span> = CommandType.Text;  </span>
</li>
<li>
<span class="attribute">cmd.CommandText</span><span> = </span><span class="attribute-value">sql</span><span>;  </span>
</li>
<li class="alt"><span>cmd.ExecuteNonQuery();  </span></li>
<li><span>cmd.Dispose();  </span></li>
<li class="alt"><span>con.Close();  </span></li>
<li><span>}  </span></li>
<li class="alt"><span>}  </span></li>
<li><span>catch  </span></li>
<li class="alt"><span>{  </span></li>
<li><span>System.Web.HttpContext.Current.Response.Write("dd");  </span></li>
<li class="alt"><span>}  </span></li>
<li><span>}   </span></li>
<li class="alt"><span>}  </span></li>
<li>MySQL<span>(和PHP搭配之最佳组合)</span><span class="tag">></span><span> create table yl( ylID int(10) unsigned NOT NULL AUTO_INCREMENT Prima(最完善的虚拟主机管理系统)ry ke  </span>
</li>
<li class="alt">
<span>y, sendtime varchar(20), sendvalue int(10), cgID int(10) not null) </span><span class="attribute">ENGINE</span><span>=</span><span class="attribute-value">MyISAM</span><span> </span>
</li>
<li>
<span class="attribute">AUTO_INCREMENT</span><span>=</span><span class="attribute-value">1</span><span> DEFAULT </span><span class="attribute">CHARSET</span><span>=</span><span class="attribute-value">utf8</span><span>;  </span>
</li>
</ol>
登入後複製

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


相關標籤：
mysql sqlserver 資料庫 監測 程式
來源：php.cn
上一篇：MySQL使用的前奏，新手学习导航 下一篇：MySQL数据库值得我们大家使用的5大理由
本網站聲明
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn
作者最新文章
最新問題
如何從結果集中僅顯示最低值（MYSQL） 我有以下聲明：selectDATE(recieved_on)asDay,round(count(*)/24)AS'average'frommessagewherefacilityi...
來自於 2024-04-06 21:44:19
0
1
603
使用MySQL SQL查詢計算另一張表中欄位的總和 我有一個這樣的模式：具有屬性“user_id”和“username”的用戶表以及具有屬性“customer_id”（user_id的FK）和“finalPrice”的訂單表資料庫架...
來自於 2024-04-06 19:39:29
0
1
441
MySQL：'從......中選擇文字作為<此處變數或子查詢>” 我有下表，其中包含以下數據：id文本語言1德語文本德語2英文文本英語我想要的是獲得以下格式的結果：german="deutschertext"english=&...
來自於 2024-04-06 19:25:54
0
2
529
MySQL中如何進行分組和計數？ 我正在嘗試編寫查詢，提取發送給朋友的未刪除訊息的總數。這是表格結構的螢幕截圖：我想要實現的輸出結果如下：idmessages_count----------------------...
來自於 2024-04-06 18:30:17
0
1
353
MySQL從多個表中取得數據 我有一個eg_design表，其中包含以下幾列：和eg_domains表，其中包含以下列：和eg_fonts表，其中包含以下幾列：現在，基於$domain_id我想獲取eg_des...
來自於 2024-04-06 18:42:44
0
2
479
相關專題
更多>
熱門推薦
熱門教學
更多>
相關教學
熱門推薦
最新課程
最新下載
更多>
網站特效
網站源碼
網站素材
前端模板