mysql多表连接分页查询_Java的MyBatis框架中实现多表连接查询和查询结果分页

实现多表联合查询

还是在david.mybatis.model包下面新建一个Website类，用来持久化数据之用，重写下相应toString()方法，方便测试程序之用。

package david.mybatis.model;

import java.text.SimpleDateFormat;

import java.util.Date;

public class Website {

private int id;

private String name;

private int visitorId;

private int status;

private Date createTime;

private Visitor visitor;

public Website() {

// TODO Auto-generated constructor stub

createTime = new Date();

visitor = new Visitor();

}

public Website(String name, int visitorId) {

this.name = name;

this.visitorId = visitorId;

visitor = new Visitor();

status = 1;

createTime = new Date();

}

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public Visitor getVisitor() {

return visitor;

}

public void setVisitor(Visitor visitor) {

this.visitor = visitor;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public int getStatus() {

return status;

}

public void setStatus(int status) {

this.status = status;

}

public Date getCreateTime() {

return createTime;

}

public void setCreateTime(Date createTime) {

this.createTime = createTime;

}

public int getVisitorId() {

int id = 0;

if (visitor == null)

id = visitorId;

else

id = visitor.getId();

return id;

}

public void setVisitorId(int visitorId) {

this.visitorId = visitorId;

}

@Override

public String toString() {

StringBuilder sb = new StringBuilder(String.format("Website=> {Id：%d, Name：%s, CreateTime：%s}\r\n", id, name,

new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(createTime)));

if (visitor != null)

sb.append(String.format("Visitor=> %s", visitor.toString()));

return sb.toString();

}

}

在david.mybatis.demo下面分别新建相应的操作接口：

package david.mybatis.demo;

import java.util.List;

import david.mybatis.model.Website;

public interface IWebsiteOperation {

public int add(Website website);

public int delete(int id);

public int update(Website website);

public Website query(int id);

public List getList();

}

在mapper文件夹下新建WebsiteMapper.xml映射文件，分别参照上一张所说的把增删改查的单表操作配置分别放进去，这样你可以建造一点测试数据。如下

/p>

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

&#