using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace 线程
{
class DBserver
{
private SqlConnection sc = new SqlConnection();
public DBserver()
{
sc.ConnectionString = "server=.;database=test;uid =sa;pwd=123456; ";//Trusted_Connection=true;
}
public void Open()
{
sc.Open();
}
public void Close()
{
sc.Close();
}
//代码效果参考:http://www.zidongmutanji.com/zsjx/482675.html
public DataSet DoSearch(string sql){
DataSet ds = new DataSet();
try
{
SqlDataAdapter sda = new SqlDataAdapter(sql, sc);
sda.Fill(ds);
Close();
}
catch (Exception e)
{
throw e;
}
finally
{
Close();
}
return ds;
}
public int Updata(string sql)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = sc;
cmd.CommandText = sql;
//代码效果参考:http://www.zidongmutanji.com/bxxx/436138.html
Open();int i = cmd.ExecuteNonQuery();
return i;
}
catch (Exception e)
{
throw e;
}
finally
{
Close();
}
}
}
}