languagelocator.cs

改程序能够查询课程表

using System; 
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Collections;
namespace test
{
    public class LanguageLocator
    {
        OleDbConnection ConDB;
        OleDbCommand DbCommand;
        OleDbDataReader DataReader;
        OleDbDataAdapter oleDbDataAdapter;
        public LanguageLocator()
        {
            ConDB = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.db.mdb");
        }
        public ArrayList FindAllLanguage()
        {
            String SQL;
            SQL = "select * from Language";
            ArrayList ArrLanguage = new ArrayList();
            DbCommand = new OleDbCommand(SQL, ConDB);
            DbCommand.Connection.Open();
            DataReader = DbCommand.ExecuteReader();
            while (DataReader.Read())
            {
                Language Language = new Language();
                Language.languageType = DataReader["languageType"].ToString();
                ArrLanguage.Add(Language);
            }
            DataReader.Close();
            ConDB.Close();
            return ArrLanguage;
        }
       
        public Boolean AddLanguage(Language Language)
        {
            String SQL;
            try
            {
                SQL = "insert into Language ([languageType]) values (@languageType)";
                DbCommand = new OleDbCommand(SQL, ConDB);
                DbCommand.Connection.Open();
                DbCommand.Parameters.Add("@languageType", Language.languageType);
                DataReader = DbCommand.ExecuteReader();
                DataReader.Close();
                ConDB.Close();
                return true;
            }
            catch (System.Exception ex)
            {
                return false;
            }
        }
        public Boolean DelLanguageById(Int32 id)
        {
            String SQL;
            SQL = "delete from Language where id=@id";
            DbCommand = new OleDbCommand(SQL, ConDB);
            DbCommand.Connection.Open();
            DataReader = DbCommand.ExecuteReader();
            if (DataReader.RecordsAffected == 1)
            {
                DataReader.Close();
                ConDB.Close();
                return true;
            }
            else
            {
                DataReader.Close();
                ConDB.Close();
                return false;
            }
        }
       
    }

}