更方便快捷的外部操作数据库的方法(另类玩法)

usingSystem;
usingSystem.Data;
usingSystem.Data.SqlClient;
publicclassHelper
{
publicstaticvoidMain()
{
//连接字符串
stringstrcon="server=.;database=blog;uid=sa;pwd=1";
SqlHelperhelper=newSqlHelper(strcon);
//表employee中有neme(varchar(20)),age(int),sex(bit)三个字段;
stringsql="select*fromemployee";
SqlDataReaderreader=helper.Reader(sql,null);
using(reader)
{
while(reader.Read())
{
Console.WriteLine(reader["name"].ToString());
}
}
/*stringsql="insertintoemployeevalues(@name,@age,@sex)";
SqlParameter[]ps=newSqlParameter[]
{
newSqlParameter("@name",SqlDbType.VarChar,20),
newSqlParameter("@age",SqlDbType.Int),
newSqlParameter("@sex",SqlDbType.Int)
};

ps[0].Value="张宇";
ps[1].Value=40;
ps[2].Value=1;
helper.ExecuteNonQuery(sql,ps);*/
}
}
publicclassSqlHelper
{
privateSqlConnectioncon=null;
privateSqlCommandcmd=null;
publicSqlHelper(stringstrcon)
{
con=newSqlConnection(strcon);
cmd=newSqlCommand();
cmd.Connection=con;
}
//执行初始化Command对象
privatevoidPreparedCommand(stringsql,paramsSqlParameter[]param)
{
cmd.CommandText=sql;
//清空Parameteras中的对象
cmd.Parameters.Clear();
if(param!=null)
{
foreach(SqlParameterpinparam)
{
cmd.Parameters.Add(p);
}
}
con.Open();
}
/*执行非查询语句*/
//有参数
publicintExecuteNonQuery(stringsql,paramsSqlParameter[]param)
{
PreparedCommand(sql,param);
inti=cmd.ExecuteNonQuery();
Close();
returni;
}
//无参数
publicintExecuteNonQuery(stringsql)
{
PreparedCommand(sql,null);
inti=cmd.ExecuteNonQuery();
Close();
returni;
}
/*执行查询语句*/
//有参数
publicSqlDataReaderReader(stringsql,paramsSqlParameter[]param)
{
PreparedCommand(sql,param);
returncmd.ExecuteReader();
}
//无参数
publicSqlDataReaderReader(stringsql)
{
PreparedCommand(sql,null);
returncmd.ExecuteReader();

}

publicvoidOpen()
{
con.Open();
}
publicvoidClose()
{
cmd.Dispose();
con.Close();
}

}