using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data?;
using?System.Data.SqlClient?;
using?System.Windows.Forms;

namespace?KTV
{
????class?DBHelp
????{
????????///?

????????///?初始化數(shù)據(jù)庫鏈接
????????///?

????????//private?static?void?InitConnection（）
????????//{
????????public?static?String?coon?=?“data?source?=?.;initial?catalog?=KTV;integrated?security=true“;
????????public?static?SqlConnection?con?=?new?SqlConnection（coon）;
????????//}
????????///?

????????///?增、刪、改
????????///?

????????///?
????????///?
????????public?static?int?ExecuteNonQuery（string?sqlStr）
????????{
????????????int?num?=?0;
????????????try
????????????{
????????????????con.Open（）;
????????????????SqlCommand?com?=?new?SqlCommand（sqlStr?con）;
????????????????num?=?com.ExecuteNonQuery（）;
????????????}
????????????catch（Exception?ex）
????????????{
????????????????MessageBox?.Show?（ex.Message）;
????????????}
????????????finally?{
????????????????con.Close（）;
????????????}
????????????return?num;
????????}
????????///?

????????///?查
????????///?

????????///?
????????///?
????????public?static?DataSet?executeQuery（String?sql）
????????{
????????????DataSet?data?=?new?DataSet（）;
????????????try
????????????{
????????????????SqlDataAdapter?adapter?=?new?SqlDataAdapter（sqlcon?）;
????????????????adapter.Fill（data）;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????MessageBox.Show（ex.Message）;
????????????}
????????????finally
????????????{
????????????????con.Close（）;
????????????}
????????????return?data;
????????}
????????///?

????????///?更新人氣
????????///?

????????///?
????????///?
????????public?static?void??Count（string?song）
????????{
????????????string?sql?=?““;
????????????sql?=?String.Format（“?update?Song_Info?set?Song_play_count?=?Song_play_count?+?1?where?Song_name??=?‘{0}‘“?song）;
????????????int?num?=?ExecuteNonQuery（?sql?）;
????????}
?????????????
????}

}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-12-21?23:11??KTV項(xiàng)目\
?????目錄???????????0??2017-06-10?14:52??KTV項(xiàng)目\KTV\
?????文件???????14784??2017-06-11?21:09??KTV項(xiàng)目\KTV.sql
?????目錄???????????0??2017-06-18?22:28??KTV項(xiàng)目\KTV\KTV\
?????文件?????????851??2017-06-01?10:08??KTV項(xiàng)目\KTV\KTV.sln
?????文件???????39936??2017-06-09?15:59??KTV項(xiàng)目\KTV\KTV.suo
?????文件???????96256??2017-07-29?16:50??KTV項(xiàng)目\KTV\KTV.v11.suo
?????目錄???????????0??2017-06-10?14:52??KTV項(xiàng)目\KTV\ktvpic\
?????文件????????9853??2017-06-05?20:26??KTV項(xiàng)目\KTV\ktvpic\2017-06-05_202631.png
?????文件???????39899??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\a-1.png
?????文件???????37127??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\b-1.png
?????文件???????18838??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\btn1.png
?????文件????????6220??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\btn10.png
?????文件???????17869??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\btn2.png
?????文件???????17481??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\btn3.png
?????文件???????18290??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\btn4.png
?????文件???????15072??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\btn5.png
?????文件????????6281??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\btn6.png
?????文件????????6229??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\btn7.png
?????文件????????6432??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\btn8.png
?????文件????????6540??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\btn9.png
?????文件???????47678??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\c-1.png
?????文件???????37877??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\d-1.png
?????文件???????38483??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\e-1.png
?????文件???????40602??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\f-1.png
?????文件??????146073??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\fy-1.jpg
?????文件???????30827??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\fy-2.jpg
?????文件????????4287??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\fy_2.jpg
?????文件????????6837??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\g-1.png
?????文件????????6311??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\h-1.png
?????文件???????51262??2017-05-18?11:42??KTV項(xiàng)目\KTV\ktvpic\ico.ico
............此處省略206個(gè)文件信息