3_32江_0511—MVC—MySQL

3_32江_0511—MVC—MySQL

---

1、MySQL操作

在MySQL创建数据库band332，创建一张表名为apartment，代码如下：

create database band332
go
use band332
go
create table apartment
(
 aid int(5)  primary key,
 aname varchar(10) not null,
 tel varchar(15),
 email varchar(20),
 remark varchar(50)
 )

创建效果:

2、entity包的Apartment类定义

创建Apartment类，定义成员变量并进行构造函数的声明与get、set方法的声明，代码如下：

public class Apartment {
    private Integer aid;
    private String aname;
    private String tel;
    private String remark;

    public Apartment() {
    }

    public Apartment(Integer aid, String aname, String tel, String remark) {
        this.aid = aid;
        this.aname = aname;
        this.tel = tel;
        this.remark = remark;
    }

    public Integer getAid() {
        return aid;
    }

    public void setAid(Integer aid) {
        this.aid = aid;
    }

    public String getAname() {
        return aname;
    }

    public void setAname(String aname) {
        this.aname = aname;
    }

    public String getTel() {
        return tel;
    }

    public void setTel(String tel) {
        this.tel = tel;
    }

    public String getRemark() {
        return remark;
    }

    public void setRemark(String remark) {
        this.remark = remark;
    }
}

3、persist包的IApartmentDao接口定义

定义接口，完成方法的定义，代码如下

public interface IApartmentDao {
    public Boolean insert(Apartment apartment);
    public Boolean delete(Integer aid);
    public Boolean update(Apartment apartment);
    public Band findById(Integer aid);
    public List<Band> findAll();
    public List<Band> find(Apartment apartment);
    public List<Band> pagenate(int page,int pageSize,Apartment apartment);
}

4、persist路径下的impl包的ApartmentDao类定义

代码如下：

public class ApartmentDao implements IApartmentDao {
    @Override
    public Boolean insert(Apartment apartment) {
        return null;
    }
    @Override
    public Boolean delete(Integer aid) {
        return null;
    }
    @Override
    public Boolean update(Apartment apartment) {
        return null;
    }
    @Override
    public Band findById(Integer aid) {
        return null;
    }
    @Override
    public List<Band> findAll() {
        return null;
    }
    @Override
    public List<Band> find(Apartment apartment) {
        return null;
    }
    @Override
    public List<Band> pagenate(int page, int pageSize, Apartment apartment) {
        return null;
    }
}