teacherlocator.cs

可以自动生成一些应用代码

using System; 
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Collections;
namespace test
{
    public class teacherLocator
    {
        OleDbConnection ConDB;
        OleDbCommand DbCommand;
        OleDbDataReader DataReader;
        OleDbDataAdapter oleDbDataAdapter;
        public teacherLocator()
        {
            ConDB = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.db.mdb");
        }
        public ArrayList FindAllteacher()
        {
            String SQL;
            SQL = "select * from teacher";
            ArrayList Arrteacher = new ArrayList();
            DbCommand = new OleDbCommand(SQL, ConDB);
            DbCommand.Connection.Open();
            DataReader = DbCommand.ExecuteReader();
            while (DataReader.Read())
            {
                teacher teacher = new teacher();
                teacher.id = Int32.Parse(DataReader["id"].ToString());
                teacher.myok = DataReader["myok"].ToString();
                teacher.tname = DataReader["tname"].ToString();
                Arrteacher.Add(teacher);
            }
            DataReader.Close();
            ConDB.Close();
            return Arrteacher;
        }
        public Boolean Addteacher(teacher teacher)
        {
            String SQL;
            try
            {
                SQL = "insert into teacher ([myok],[tname]) values (@myok,@tname)";
                DbCommand = new OleDbCommand(SQL, ConDB);
                DbCommand.Connection.Open();
                DbCommand.Parameters.Add("@myok", teacher.myok);
                DbCommand.Parameters.Add("@tname", teacher.tname);
                DataReader = DbCommand.ExecuteReader();
                DataReader.Close();
                ConDB.Close();
                return true;
            }
            catch (System.Exception ex)
            {
                return false;
            }
        }
        public Boolean DelteacherById(Int32 id)
        {
            String SQL;
            SQL = "delete from teacher where id=@id";
            DbCommand = new OleDbCommand(SQL, ConDB);
            DbCommand.Connection.Open();
            DbCommand.Parameters.Add("@id", id);
            DataReader = DbCommand.ExecuteReader();
            if (DataReader.RecordsAffected == 1)
            {
                DataReader.Close();
                ConDB.Close();
                return true;
            }
            else
            {
                DataReader.Close();
                ConDB.Close();
                return false;
            }
        }
        public Boolean Updateteacher(teacher teacher)
        {
            String SQL;
            SQL = "update  teacher  set  [myok]=@myok,[tname]=@tname  where id=@id";
            DbCommand = new OleDbCommand(SQL, ConDB);
            DbCommand.Connection.Open();
            DbCommand.Parameters.Add("@myok", teacher.myok);
            DbCommand.Parameters.Add("@tname", teacher.tname);
            DbCommand.Parameters.Add("@id", teacher.id);
            DataReader = DbCommand.ExecuteReader();
            if (DataReader.RecordsAffected == 1)
            {
                DataReader.Close();
                ConDB.Close();
                return true;
            }
            else
            {
                DataReader.Close();
                ConDB.Close();
                return false;
            }
        }
    }
}