studentlocator.cs

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

using System; 
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Collections;
namespace test
{
    public class studentLocator
    {
        OleDbConnection ConDB;
        OleDbCommand DbCommand;
        OleDbDataReader DataReader;
       // OleDbDataAdapter oleDbDataAdapter;
        public studentLocator()
        {
            ConDB = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.db.mdb");
        }
        public ArrayList FindAllstudent()
        {
            String SQL;
            SQL = "select * from student";
            ArrayList Arrstudent = new ArrayList();
            DbCommand = new OleDbCommand(SQL, ConDB);
            DbCommand.Connection.Open();
          
            DataReader = DbCommand.ExecuteReader();
            while (DataReader.Read())
            {
                student student = new student();
                student.age = int.Parse(DataReader["age"].ToString());
        
                student.id = Int32.Parse(DataReader["id"].ToString());
                student.sname = DataReader["sname"].ToString();
                student.sno = DataReader["sno"].ToString();
                student.sum = float.Parse(DataReader["sum"].ToString());
                Arrstudent.Add(student);
            }
            DataReader.Close();
            ConDB.Close();
            return Arrstudent;
        }
        public Boolean Addstudent(student student)
        {
            String SQL;
            try
            {
                SQL = "insert into student ([age],[sname],[sno],[sum]) values (@age,@sname,@sno,@sum)";
                DbCommand = new OleDbCommand(SQL, ConDB);
                DbCommand.Connection.Open();
                DbCommand.Parameters.Add("@age", student.age);
                DbCommand.Parameters.Add("@sname", student.sname);
                DbCommand.Parameters.Add("@sno", student.sno);
                DbCommand.Parameters.Add("@sum", student.sum);
                DataReader = DbCommand.ExecuteReader();
                DataReader.Close();
                ConDB.Close();
                return true;
            }
            catch (System.Exception ex)
            {
                DataReader.Close();
                ConDB.Close();
                return false;
            }
        }
        public Boolean DelstudentById(Int32 id)
        {
            String SQL;
            SQL = "delete from student 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 Updatestudent(student student)
        {
            String SQL;
            SQL = "update  student  set  [age]=@age,[sname]=@sname,[sno]=@sno,[sum]=@sum  where id=@id";
            DbCommand = new OleDbCommand(SQL, ConDB);
            DbCommand.Connection.Open();
            DbCommand.Parameters.Add("@age", student.age);
            DbCommand.Parameters.Add("@sname", student.sname);
            DbCommand.Parameters.Add("@sno", student.sno);
            DbCommand.Parameters.Add("@sum", student.sum);
            DbCommand.Parameters.Add("@id", student.id);
            DataReader = DbCommand.ExecuteReader();
            if (DataReader.RecordsAffected == 1)
            {
                DataReader.Close();
                ConDB.Close();
                return true;
            }
            else
            {
                DataReader.Close();
                ConDB.Close();
                return false;
            }
        }
    }
}