termlib.cs

来自「实现文本的特征提取」· CS 代码 · 共 52 行

using System;
using System.Data;
using System.Data.SqlClient;

namespace Njnu.DAL
{
	/// <summary>
	/// TermLib 的摘要说明。
	/// </summary>
	public class TermLib
	{
		public DataTable GetTermLibByCateID(string cateID)
		{
			DataTable dt = new DataTable();
			SqlParameter[] parameters = {};
			
			string str = "select * from TermLib where cateID = '" + cateID + "'";
			using(SqlDatabase sqlDB = new SqlDatabase(str, parameters))
			{
				sqlDB.Run(dt);
			}
			return dt;
		}

		public DataTable GetTermLib()
		{
			DataTable dt = new DataTable();
			SqlParameter[] parameters = {};
			
			string str = "select * from TermLib";
			using(SqlDatabase sqlDB = new SqlDatabase(str, parameters))
			{
				sqlDB.Run(dt);
			}
			return dt;
		}

		public DataTable GetCateID()
		{
			DataTable dt = new DataTable();
			SqlParameter[] parameters = {};
			
			string str = "select distinct(cateID) from TermLib";
			using(SqlDatabase sqlDB = new SqlDatabase(str, parameters))
			{
				sqlDB.Run(dt);
			}
			return dt;
		}
	}
}