java中三层架构的增删改_增删改查_三层架构.doc

增删改查_三层架构

增删改查_三层架构

BLL层：

public static IList GetContact()

{

return ContactDal.GetContactList();

}

public static void DelContact(Model.Contact contact)

{

ContactDal.DeleteContact(contact);

}

public static void UoContact(Model.Contact contact)

{

ContactDal.UpdateContact(contact);

}

public static IList FindContact(String contId, String contName, String contSex, String contAdress)

{

return ContactDal.FindContactList(contId, contName, contSex, contAdress);

}

public static void InsContact(Model.Contact contact)

{

ContactDal.InsertContact(contact);

}

DAL层：

public class ContactDal

{

// static string conn = "Provider=Microsoft.Jet.OleDb.4.0;Data Source="+Mat+" D:\\WEB\\weiwei.mdb";

static string conn = ConfigurationManager.ConnectionStrings["stron"].ToString();

static OleDbConnection connection = new OleDbConnection(conn);

public static IList GetContactList()

{

connection.Open();

string sql = "select * from tblContact";

OleDbCommand command = new OleDbCommand(sql, connection);

OleDbDataReader dr = command.ExecuteReader();

List list = new List();

while(dr.Read())

{

Model.Contact contact =new Model.Contact();

contact.Cont_Id = dr[0].ToString();

contact.Cont_Name = dr[1].ToString();

contact.Cont_Sex = dr[2].ToString();

contact.Cont_Birth = dr[3].ToString();

contact.Cont_Email = dr[4].ToString();

contact.Cont_Duty = dr[5].ToString();

contact.Cont_Phone = dr[6].ToString();

contact.Cont_Mobile = dr[7].ToString();

contact.Cont_Address = dr[8].ToString();