database.cs

一个供大家参考的自己做的计算机等级考试网上系统

using System;
using System.Data;
using System.Data.OleDb;
using System.ComponentModel;
using System.Collections;
using System.Web;
using System.Web.Configuration;
using System.Drawing.Drawing2D;
using System.Web.UI.WebControls;
namespace djks
{
	/// <summary>
	/// database 的摘要说明。
	/// </summary>
     
	public class database
	{
		public static string ConnString ="Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + System.Web.HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["DBConnectionString"]) + "";  
		public database()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		// 创建表单
		public static DataSet CreateDateSet(string strSQL)
		{

			OleDbDataAdapter objcmd=new OleDbDataAdapter(strSQL,ConnString);

			DataSet ds=new DataSet();
			objcmd.Fill(ds);

			objcmd.Dispose();
			return ds;
		}
		public static OleDbDataReader ExecuteReader(string Sqlstr)   //返回一 SqlDataReader
		{
			
			OleDbConnection conn=new OleDbConnection(ConnString);
			conn.Open();
			//			try
			//			{
			OleDbCommand cmd=new OleDbCommand(Sqlstr,conn);
			OleDbDataReader _OleDbReader=cmd.ExecuteReader(CommandBehavior.CloseConnection);
			//			    cmd.Dispose();
			//			    _sqlcon.Close();
			return _OleDbReader;
			//			}
			//			catch
			//			{
			//				System.Web.HttpContext.Current.Response.Redirect("error.htm");	
			//				return _sqlReader=null;
			//			}
			//			
		}
		public static int Count(string sql)
		{
			int count;
			OleDbConnection conn=new OleDbConnection(ConnString);
			conn.Open();
			OleDbCommand cmd= new OleDbCommand(sql,conn);
			count=Convert.ToInt32(cmd.ExecuteScalar());
			conn.Close();
			return count;

		}
		public static int Number()
		{
			int Number;
			string temp;
			string strSql="select bmh from bmk where id=(select max(id) from bmk)";
			OleDbConnection conn=new OleDbConnection(ConnString);
			conn.Open();
			OleDbCommand cmd= new OleDbCommand(strSql,conn);
			
			
			if(cmd.ExecuteScalar()!=null)
			{
				temp=cmd.ExecuteScalar().ToString();
				Number=Convert.ToInt32(temp.Substring(8));
			}
			else
			{
				Number=0;
			}
			conn.Close();
			return Number;

		}
		public static bool doSql(string strSql)
		{
			
			OleDbConnection Sqlcon=new OleDbConnection(ConnString);
			Sqlcon.Open();
			try
			{
				OleDbCommand cmd=new OleDbCommand(strSql,Sqlcon);					
				cmd.ExecuteNonQuery(); 
//				hxyy_js.jsAlert("操作成功");
				return true;
			}
			catch
			{
				System.Web.HttpContext.Current.Response.Write("<script>alert('操作失败,请查证后在提交');</script>");//ex.ToString()
				return false;
			}
			finally
			{
				Sqlcon.Close();
			}				
		}
		public static bool doSql_return(string strSql)
		{
			
			OleDbConnection Sqlcon=new OleDbConnection(ConnString);
			Sqlcon.Open();
			try
			{
				OleDbCommand cmd=new OleDbCommand(strSql,Sqlcon);					
				cmd.ExecuteNonQuery(); 				
				return true;
			}
			catch
			{
				System.Web.HttpContext.Current.Response.Write("<script>alert('操作失败,请查证后在提交');</script>");//ex.ToString()
				return false;
			}
			finally
			{
				Sqlcon.Close();
			}				
		}
		public static void drpl_bind(string strSql,DropDownList drpl,string selected)
		{
			DataSet ds=new DataSet();
			ds=CreateDateSet(strSql);    //获取查询数据表
			
			string tem;
			string temp;

			foreach(DataRow dr in ds.Tables[0].Rows)
			{
				tem=dr.ItemArray[0].ToString();
				temp=dr.ItemArray[1].ToString();
				string strtext=tem+"-"+temp;
				ListItem li=new ListItem(strtext,tem);
				if (dr.ItemArray[0].ToString()==selected)
				{li.Selected=true;}
				drpl.Items.Add(li);　　//为下拉列表框添加数据项
			}
		
		}
	}
}