?using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
//因為要使用Access數據庫，所以這里得引入命名空間
using System.Data.OleDb;
//該源碼下載自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

/// <summary>
/// 這里主要是留言本會用到的數據庫連接類，因為數據操作并不多，所以把常規的操作類也一并放這里了
/// </summary>
public class odb
{
   public string name;
    public string email;
    public string qq;
    public string msn;
    public string url;
    public string title;
    public string concent;
    public string face;
    public string ip;
    public string pwd;
    public string uid;
    public string pwda;
    public DateTime dtt;
    
    public odb()
	{
		//
		// TODO: 在此處添加構造函數邏輯
		//
	}
    public static OleDbConnection con()
    {//數據庫連接類
        OleDbConnection con = new OleDbConnection(ConfigurationManager.ConnectionStrings["book"].ConnectionString);
        return con;
    }
    public static bool insert(string que)
    { //根據傳進來的ＳＱＬ語句執行插入/刪除/更新等操作
        OleDbConnection con = odb.con();
        con.Open();
        OleDbCommand cmd = new OleDbCommand(que,con);
        int count = Convert.ToInt32(cmd.ExecuteNonQuery());
        if (count > 0)
            return true;
        else
            return false;
    }
    public static DataTable ds(string que)
    {//返回一個裝載了SQL制定留言的數據表，
        OleDbConnection con = odb.con();
        OleDbDataAdapter oda = new OleDbDataAdapter();
        oda.SelectCommand=new OleDbCommand(que,con);
        DataSet ds = new DataSet();
        oda.Fill(ds,"thc");
        return ds.Tables["thc"];
    }
    public static bool img(string que)
    {//根據傳來的條件查詢該項是否有內容，有就返回true
        OleDbConnection con = odb.con();
        con.Open();
        OleDbCommand cmd = new OleDbCommand(que,con);
        if (cmd.ExecuteScalar().ToString() != "")
            return true;
        else
            return false;
        con.Close();
    }
    public static string scr(string que)
    {//同樣是根據傳來的ＳＱＬ語句返回一個字段的值，我不太喜歡把ＳＱＬ語句做在內中，感覺不靈活 
        OleDbConnection con = odb.con();
        con.Open();
        OleDbCommand cmd = new OleDbCommand(que,con);
        return cmd.ExecuteScalar().ToString();
    }
    public static int num(string mm)
    {//根據要求返回一個一個顯示條目數
       return  Convert.ToInt32(odb.scr("select ["+mm+"] from [config]"));
    }
}