/// <summary>
/// 执行带参数组sql语句返回行数
/// </summary>
/// <param name="sql"></param>
/// <param name="values"></param>
/// <returns></returns>
public static int ExecuteCommand(string sql,params OleDbParameter[] values )
{
OleDbCommand cmd = new OleDbCommand(sql,Connection);
cmd.Parameters.AddRange(values);
Connection.Close();
return cmd.ExecuteNonQuery();
}
/// <summary>
/// 插入新闻
/// </summary>
/// <param name="news"></param>
/// <returns></returns>
public static int AddNews(News news)
{
string sql = "insert into News([title],[Author],[EditTime],[Hits],[IsPublic],[IsHome],[IsTop],[Content],[categoryID])" +
"values"+
"(@title,@Author,@EditTime,@Hits,@IsPublic,@IsHome,@IsTop,@Content,@categoryID)";
OleDbParameter[] para = new OleDbParameter[]
{
new OleDbParameter("@title",news.Title),
new OleDbParameter("@Author",news.Author),
new OleDbParameter("@EditTime",news.EditTime),
new OleDbParameter("@Hits",news.Hits),
new OleDbParameter("@IsPublic",news.IsPublic),
new OleDbParameter("@IsHome",news.IsHome),
new OleDbParameter("@IsTop",news.IsTop),
new OleDbParameter("@Content",news.Content),
new OleDbParameter("@categoryID",news.CategoryID)
};
return DBHelper.ExecuteCommand(sql, para);
}
每次插入多这样写sql 语句, 感觉有点累 有没有方法
能实现自动组装sql ?? 高手 来指导指导啊
/// 执行带参数组sql语句返回行数
/// </summary>
/// <param name="sql"></param>
/// <param name="values"></param>
/// <returns></returns>
public static int ExecuteCommand(string sql,params OleDbParameter[] values )
{
OleDbCommand cmd = new OleDbCommand(sql,Connection);
cmd.Parameters.AddRange(values);
Connection.Close();
return cmd.ExecuteNonQuery();
}
/// <summary>
/// 插入新闻
/// </summary>
/// <param name="news"></param>
/// <returns></returns>
public static int AddNews(News news)
{
string sql = "insert into News([title],[Author],[EditTime],[Hits],[IsPublic],[IsHome],[IsTop],[Content],[categoryID])" +
"values"+
"(@title,@Author,@EditTime,@Hits,@IsPublic,@IsHome,@IsTop,@Content,@categoryID)";
OleDbParameter[] para = new OleDbParameter[]
{
new OleDbParameter("@title",news.Title),
new OleDbParameter("@Author",news.Author),
new OleDbParameter("@EditTime",news.EditTime),
new OleDbParameter("@Hits",news.Hits),
new OleDbParameter("@IsPublic",news.IsPublic),
new OleDbParameter("@IsHome",news.IsHome),
new OleDbParameter("@IsTop",news.IsTop),
new OleDbParameter("@Content",news.Content),
new OleDbParameter("@categoryID",news.CategoryID)
};
return DBHelper.ExecuteCommand(sql, para);
}
每次插入多这样写sql 语句, 感觉有点累 有没有方法
能实现自动组装sql ?? 高手 来指导指导啊
public static int ExecuteCommand(string sql,params OleDbParameter[] values )
{
OleDbCommand cmd = new OleDbCommand(sql,Connection);
cmd.Parameters.AddRange(values);
Connection.Close(); ?? 关闭?
return cmd.ExecuteNonQuery();
}
http://download.csdn.net/source/871334