datalink.cs

个人信息管理系统

using System;
using System.Data.OleDb;
using System.Data;
using System.Configuration;
using System.Xml;


namespace personal
{
	/// <summary>
	/// 一个超轻量级的数据处理类，分层开发的一次美丽测试！数据库ACCESS！
	/// 2005年10月22日 powerd by 我不孤单 oicq:170186326
	/// </summary>
	public class datalink
	{
		#region 构造函数
		public datalink()
		{
			//
			//
			//
		}
		#endregion
	
		#region 配置数据库连接字符串
		///<summary>
		///配置数据库连接字符串
		///</summary>
		public static string connectionstring= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=personal.mdb"; 
		#endregion

		#region 执行SQL语句，返回BOOL值
		///<summary>
		///执行SQL语句，返回BOOL值
		///<param name="sql">要执行SQL语句</param>
		///<returns>返回BOOL值</returns>
		public  bool executesql(string sql)
		{
			OleDbConnection con = new OleDbConnection(datalink.connectionstring);
			OleDbCommand cmd = new OleDbCommand(sql,con);
			try
			{	
				con.Open();
				cmd.ExecuteNonQuery();
				return true;
			}
			catch
			{
				return false;
			}
			finally
			{
				con.Close();
				con.Dispose();
				cmd.Dispose();
			}
		}
		#endregion

		#region 执行SQL语句返回OleDbDataReader
		///<summary>
		///执行SQL语句返回OleDbDataReader
		///</summary>
		///<param  name="sql">要执行的SQL语句</param>
		///<returns>返回OleDbDataReader,需要手动关闭连接！</returns>
		public  OleDbDataReader datareader(string sql)
		{
			OleDbConnection con=new OleDbConnection(datalink.connectionstring);
			OleDbCommand cmd=new OleDbCommand(sql,con);
			OleDbDataReader dr=null;
			try
			{
				con.Open();
				dr=cmd.ExecuteReader(CommandBehavior.CloseConnection);
			}
			catch (OleDbException oe)
			{
				dr.Close();
				con.Dispose();
				cmd.Dispose();
				throw new Exception(oe.ToString());
			}
			return dr;;
		}
		#endregion

		#region  执行SQL语句，返回DataSet
		/// <summary>
		/// 执行SQL语句，返回DataSet
		/// </summary>
		/// <param name="sql">要执行的SQL语句</param>
		/// <param name="tablename">DataSet中要填充的表名</param>
		/// <returns>返回dataSet类型的执行结果</returns>
		public DataSet dataset(string sql,string tablename)
		{
			DataSet ds= new DataSet();
			OleDbConnection con=new OleDbConnection(datalink.connectionstring);
			OleDbDataAdapter da=new OleDbDataAdapter(sql,con);
			try
			{
				da.Fill(ds,tablename);
			}
			catch (OleDbException oe)
			{
				throw new Exception(oe.ToString());
			}
			finally
			{
				con.Close();
				con.Dispose();
				da.Dispose();
			}
			return ds;
		}
		#endregion

		#region  执行SQL语句，返回DataTable
		/// <summary>
		/// 执行SQL语句，返回DataTable
		/// </summary>
		/// <param name="sql">要执行的SQL语句</param>
		/// <returns>返回DataTable类型的执行结果</returns>
		public DataTable datatable(string sql)  
		{
			DataSet ds= new DataSet();
			OleDbConnection con=new OleDbConnection(datalink.connectionstring);
			OleDbDataAdapter da=new OleDbDataAdapter(sql,con);
			try
			{
				da.Fill(ds,"tb");
			}
			catch (Exception ex)
			{
				throw new Exception(ex.ToString());
			}
			finally
			{
				con.Close();
				con.Dispose();
				da.Dispose();
			}
			DataTable result=ds.Tables["tb"];
			return result;
		}
		#endregion

		#region  执行SQL语句并返回受影响的行数
		/// <summary>
		/// 执行SQL语句并返回受影响的行数
		/// </summary>
		/// <param name="sql">要执行的SQL语句</param>
		/// <returns>返回Int类型的受影响的行数</returns>
		public int getcount(string sql)
		{
			OleDbConnection con=new OleDbConnection(datalink.connectionstring);
			OleDbCommand cmd=new OleDbCommand(sql,con);
			try
			{
				con.Open();
				int count=(int)cmd.ExecuteScalar();
				return count;
			}
			catch 
			{
				return 0;
			}
			finally
			{
				con.Close();
				con.Dispose();
				cmd.Dispose();
			}
		}
		#endregion

		#region 验证用户是否合法用户
		/// <summary>
		/// 验证用户是否合法用户
		/// </summary>
		/// <param name="strname">要验证的用户名</param>
		/// <param name="strpwd">要验证的密码</param>
		/// <returns>返回BOOL值，True为验证成功</returns>
		public bool checkname (string strname,string strpwd)
		{
			string sql;
			strname=strname.Trim();
			strname=strname.Replace("'","");
			strpwd=strname.Trim();
			strpwd=strname.Replace("'","");
			sql="select count(1) from power where power_username='"+strname+"'and power_password='"+strpwd+"'";
			if(getcount(sql)>0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}
		#endregion
	}
}