C#对ACCESS数据库执行命令封装以及调用的代码 该怎么写

private void button1_Click(object sender, EventArgs e)
{
OleDbConnection olecon = null;
olecon = new OleDbConnection(CommonClass.strconnection);
olcom = new OleDbCommand("insert into Things (ID,Name,zhuangtai)values('"+comboBox1.Text+"','"+textBox1.Text+"','正常')",olecon);
olecon.Open();
olcom.ExecuteNonQuery();
olecon.Close();
this.Hide();
}
这是我的添加数据代码。对数据库 执行命令的封装代码该怎么写，然后这段代码该怎么修改调用封装的代码

有没有愿意回答一下的朋友

捉鸡啊

新建一个SqlHelp类：
public class SqlHelp
{
public static OleDbConnection conn = new OleDbConnection(CommonClass.strconnection);
public static OleDbConnection GetConnStr()
{
if (conn.State.Equals(ConnectionState.Closed))
{
conn.Open();
}
return conn;
}
public static int ExecuteNonquery(string sql, params OleDbParameter[] paras)
{
using (OleDbCommand cmd = new OleDbCommand(sql, GetConnStr()))
{
try
{
cmd.Parameters.AddRange(paras);
return cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
调用：
private void button1_Click(object sender, EventArgs e)
{
string sql = "insert into Things (ID,Name,zhuangtai)values(@id,@name,@zt)";
OleDbParameter[] paras = new OleDbParameter[] {
new OleDbParameter("@id",comboBox1.Text),
new OleDbParameter("@name",textBox1.Text),
new OleDbParameter("@zt","正常")
};
if(SqlHelp.ExecuteNonquery(sql, paras)>0)
{
this.Hide();
}
}