www.pudn.com > IntMail.rar > CommonMail.cs

using System; 
using System.Collections.Generic; 
using System.ComponentModel; 
using System.Data; 
using System.Data.OleDb; 
using System.Drawing; 
using System.Text; 
using System.Windows.Forms; 
 
namespace IntMail 
{ 
    /// 
 
    /// 邮件信息 
    /// 
 
    public  struct MailAddress 
    { 
        public static int MailAddressID; 
        public static string MailAddressD; 
        public static string MailAddressSMTP; 
        public static string MailAddressPOP3; 
        public static string MailAddressUser; 
        public static string MailAddressPass; 
        public static string MailAddressDefault; 
    } 
    public struct CurrentMail 
    {  
    public static int MessageID; 
        public static string BodyText; 
        public static string BodyHtml; 
        public static string[] Attach; 
        public static string from; 
        public static string to; 
 
    } 
    /// 
 
    /// 数据库操作类 
    /// 
 
    public class CommonMail 
    { 
        public static OleDbConnection con; 
        public static OleDbDataAdapter ada; 
        public static DataSet ds; 
        /// 
 
        /// 初使化数据操作此方法用于操作数据库之前 
        /// 
 
        public static void init() 
        { 
            con = new OleDbConnection(); 
            // Page p=new Page(); 
 
            con.ConnectionString = @"provider=microsoft.jet.oledb.4.0;data source=" +Application.StartupPath+@"/MailDB.DB"+ ";Jet OLEDB:Database Password='zmnetworkint'"; 
            // p.Response.Write(con.ConnectionString.ToString()); 
            ada = new OleDbDataAdapter(); 
            ada.SelectCommand = new OleDbCommand(); 
            ada.UpdateCommand = new OleDbCommand(); 
            ada.DeleteCommand = new OleDbCommand(); 
            ada.InsertCommand = new OleDbCommand(); 
            ada.SelectCommand.Connection = con; 
            ada.UpdateCommand.Connection = con; 
            ada.DeleteCommand.Connection = con; 
            ada.InsertCommand.Connection = con; 
        } 
        /// 
 
        /// 执行数据库查询 执行此方法前须执行了init方法 
        /// 
 
        ///  
        ///  
        public static DataSet Search(string SQL) 
        { 
 
            ds = new DataSet(); 
            try 
            { 
                ada.SelectCommand.CommandText = SQL; 
                //MessageBox.Show(SQL); 
                ada.Fill(ds); 
                return ds; 
            } 
            catch (Exception ex) 
            { 
                //MessageBox.Show(ex.Message); 
                return null; 
            } 
        } 
        /// 
 
        /// 执行数据库添加记录操作 执行此方法前须执行了init方法 
        /// 
 
        ///  
        ///  
        public static int Insert(string SQL) 
        { 
            int i; 
            try 
            { 
                ada.InsertCommand.CommandText = SQL; 
                con.Open(); 
                i = ada.InsertCommand.ExecuteNonQuery(); 
                return i; 
            } 
            catch (Exception ex) 
            { 
                // MessageBox.Show(); 
                return 0; 
            } 
        } 
        /// 
 
        ///   执行数据库更新操作 执行此方法前须执行了init方法 
        /// 
 
        ///  
        ///  
        public static int Update(string SQL) 
        { 
            int i; 
            try 
            { 
                ada.UpdateCommand.CommandText = SQL; 
                con.Open(); 
                i = ada.UpdateCommand.ExecuteNonQuery(); 
                con.Close(); 
                return i; 
            } 
            catch (Exception ex) 
            { 
                return 0; 
            } 
        } 
        /// 
 
        /// 执行数据库删除操作 执行此方法前须执行了init方法 
        /// 
 
        ///  
        ///  
        public static int Delete(string SQL) 
        { 
            int i; 
            try 
            { 
                ada.DeleteCommand.CommandText = SQL; 
                con.Open(); 
                i = ada.DeleteCommand.ExecuteNonQuery(); 
                return i; 
            } 
            catch (Exception ex) 
            { 
                return 0; 
            } 
        } 
 
    } 
 
}