lwordtask.cs

随便上传一文章 随便上传一文章 随便上传一文章 随便上传一文章

using System;
using System.Data;
using System.Data.OleDb;
using System.Web;

namespace TraceLWord2
{
	/// <summary>
	/// LWordTask 数据库任务类
	/// </summary>
	public class LWordTask
	{
		// 数据库连接字符串
		private const string DB_CONN=@"PROVIDER=Microsoft.Jet.OLEDB.4.0; DATA Source=C:\DbFs\TraceLWordDb.mdb";

		/// <summary>
		/// 读取数据库表 LWord，并填充 DataSet 数据集
		/// </summary>
		/// <param name="ds">填充目标数据集</param>
		/// <param name="tableName">表名称</param>
		/// <returns>记录行数</returns>
		public int ListLWord(DataSet ds, string tableName)
		{
			string cmdText="SELECT * FROM [LWord] ORDER BY [LWordID] DESC";

			OleDbConnection dbConn=new OleDbConnection(DB_CONN);
			OleDbDataAdapter dbAdp=new OleDbDataAdapter(cmdText, dbConn);

			int count=dbAdp.Fill(ds, tableName);

			return count;
		}

		/// <summary>
		/// 发送留言信息到数据库
		/// </summary>
		/// <param name="textContent">留言内容</param>
		public void PostLWord(string textContent)
		{
			// 留言内容不能为空
			if(textContent==null || textContent=="")
				throw new Exception("留言内容为空");

			string cmdText="INSERT INTO [LWord]([TextContent]) VALUES(@TextContent)";

			OleDbConnection dbConn=new OleDbConnection(DB_CONN);
			OleDbCommand dbCmd=new OleDbCommand(cmdText, dbConn);

			// 设置留言内容
			dbCmd.Parameters.Add(new OleDbParameter("@TextContent", OleDbType.LongVarWChar));
			dbCmd.Parameters["@TextContent"].Value=textContent;

			try
			{
				dbConn.Open();
				dbCmd.ExecuteNonQuery();
			}
			catch
			{
				throw;
			}
			finally
			{
				dbConn.Close();
			}
		}
	}
}