bookforaccess.cs

一个用csharp做的简单图书管理系统,用sql数据库连接.

using System;
using System.Data;

using Com.LXJ.Database;

namespace Com.LXJ.Example.Book.Data
{
	/// <summary>
	/// BookForAccess类，记得继承
	/// </summary>
	public class BookForAccess:ConnDbForAcccess  
	{
		private string sql;  //sql语句变量

		public BookForAccess()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}


		/// <summary>
		/// 新增
		/// </summary>
		/// <param name="bookName">书名</param>
		/// <returns></returns>
		public bool Create(string bookName)
		{
			sql = "";
			sql = sql + " INSERT INTO t_Book(BookName) VALUES('"+bookName+"') ";
			return ExeSQL(sql);
		}


		/// <summary>
		/// 更新
		/// </summary>
		/// <param name="bookId">编号</param>
		/// <param name="bookName">书名</param>
		/// <returns></returns>
		public bool Update(int bookId,string bookName)
		{
			sql = "";
			sql = sql + " UPDATE t_Book SET BookName = '"+bookName+"' WHERE BookId = " + bookId;
			return ExeSQL(sql);
		}


		/// <summary>
		/// 删除
		/// </summary>
		/// <param name="bookId">编号</param>
		/// <returns></returns>
		public bool Delete(int bookId)
		{
			sql = "";
			sql = sql + " DELETE FROM t_Book WHERE BookId = " + bookId;
			return ExeSQL(sql);
		}


		/// <summary>
		/// 检索一个
		/// </summary>
		/// <param name="bookId">编号</param>
		/// <returns></returns>
		public DataRow Retrive(int bookId)
		{
			sql = "";
			sql = sql + " SELECT * FROM t_Book WHERE BookId = " + bookId;
			using(DataSet list = ReturnDataSet(sql))
			{
				return list.Tables[0].Rows[0];
			}
		}


		/// <summary>
		/// 取得列表
		/// </summary>
		/// <returns></returns>
		public DataSet List()
		{
			sql = "";
			sql = sql + " SELECT * FROM t_Book ";
			using(DataSet list = ReturnDataSet(sql))
			{
				return list;
			}
		}

	}//
}//