MyBatis多表联合查询实例

最新推荐文章于 2024-06-28 08:54:25 发布

sbj_java

最新推荐文章于 2024-06-28 08:54:25 发布

阅读量789

点赞数 1

分类专栏： MyBatis

本文链接：https://blog.csdn.net/sbj_java/article/details/78947404

版权

MyBatis 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

<article>
<h1 class="csdn_top">MyBatis 多表联合查询及优化</h1>
<div class="article_bar clearfix">
<div class="artical_tag">

原创 
2015年05月25日 11:50:27
</div>

<ul class="article_tags clearfix csdn-tracking-statistics tracking-click" data-mod="popu_377">
<li class="tit">标签：</li>


<li><a href="http://so.csdn.net/so/search/s.do?q=mybatis&t=blog" target="_blank">mybatis</a> /</li>
<li><a href="http://so.csdn.net/so/search/s.do?q=多表&t=blog" target="_blank">多表</a> /</li>
<li><a href="http://so.csdn.net/so/search/s.do?q=联合查询&t=blog" target="_blank">联合查询</a> /</li>

</ul>
<ul class="right_bar">
<li><button class="btn-noborder">90957</button></li>
<li class="edit" style="display: none;">
<a class="btn-noborder" href="http://write.blog.csdn.net/postedit/45967763">
编辑
</a>
</li>
<li class="del" style="display: none;">
<a class="btn-noborder" οnclick="javascript:deleteArticle(fileName);return false;">
删除
</a>
</li>
</ul>
</div>
<div id="article_content" class="article_content csdn-tracking-statistics tracking-click" data-mod="popu_519" data-dsm="post" style="overflow: hidden;">

 <h1 style="font-family:'微软雅黑';font-size:14px;line-height:21px;"><a name="t0"></a>序</h1>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">这篇文章我打算来简单的谈谈 mybatis 的多表联合查询。起初是觉得挺简单的，没必要拿出来写，毕竟 mybatis 这东西现在是个开发的都会用，而且网上的文章也是一搜罗一大堆，根本就用不着我来重复。但是吧，就我前几天在做一个多表联合查询的时候，竟然出了很多意想不到的问题，而且这些问题的出现，并不是对 mybatis 不了解，而是在用的过程中会或多或少的忽略一些东西，导致提示各种错误。</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<h1 style="font-family:'微软雅黑';font-size:14px;line-height:21px;"><a name="t1"></a>背景</h1>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">老规矩，开始之前，还是要先说说这件事的背景。也就是最近几天，公司要做一个后台的管理平台，由于之前的一些限制，这次要做成单独的项目进行部署，因此就要重新考虑很多东西。索性这几天有时间，就做了一个小 Demo ，实现 mybatis 的多表联合查询的，由于之前用的是 Hibernate 做的联合查询，众所周知，Hibernate 是全自动的数据库持久层框架，它可以通过实体来映射数据库，通过设置一对多、多对一、一对一、多对多的关联来实现联合查询。</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<h1 style="font-family:'微软雅黑';font-size:14px;line-height:21px;"><a name="t2"></a>正文</h1>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">下面就来说一下 mybatis 是通过什么来实现多表联合查询的。首先看一下表关系，如图：</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="text-align:center;font-family:'微软雅黑';font-size:14px;line-height:21px;">
<img src="https://img-blog.csdn.net/20150525113540142?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaGFwcHlsZWU2Njg4/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt=""> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">这里，我已经搭好了开发的环境，用到的是 SpringMVC + Spring + MyBatis，当然，为了简单期间，你可以不用搭前端的框架，只使用 Spring + MyBatis 就可以，外加 junit 测试即可。环境我就不带大家搭了，这里只说涉及到联合查询的操作。</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">设计好表之后，我用到了 mybatis 的自动生成工具 mybatis generator 生成的实体类、mapper 接口、以及 mapper xml 文件。由于是测试多表联合查询，因此需要自己稍加改动。</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">下面是 User 和 Role 的实体类代码：</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">User</div>
<div style="line-height:21px;"><div class="dp-highlighter bg_java"><div class="bar"><div class="tools">[java] <a href="#" class="ViewSource" title="view plain" οnclick="dp.sh.Toolbar.Command('ViewSource',this);return false;">view plain</a> <a href="#" class="CopyToClipboard" title="copy" οnclick="dp.sh.Toolbar.Command('CopyToClipboard',this);return false;">copy</a><div style="position: absolute; left: 166px; top: 1296px; width: 16px; height: 16px; z-index: 99;"><embed id="ZeroClipboardMovie_1" src="http://static.blog.csdn.net/scripts/ZeroClipboard/ZeroClipboard.swf" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="16" height="16" name="ZeroClipboardMovie_1" align="middle" allowscriptaccess="always" allowfullscreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="id=1&width=16&height=16" wmode="transparent"></div> <a href="#" class="PrintSource" title="print" οnclick="dp.sh.Toolbar.Command('PrintSource',this);return false;">print</a><a href="#" class="About" title="?" οnclick="dp.sh.Toolbar.Command('About',this);return false;">?</a></div></div><ol start="1" class="dp-j"><li class="alt"><span style="font-family:Comic Sans MS;font-size:12px;">package com.sica.domain;  </li><li class="">  </li><li class="alt">import java.io.Serializable;  </li><li class="">import java.util.List;  </li><li class="alt">  </li><li class="">public class User implements Serializable {  </li><li class="alt">    private String id;  </li><li class="">  </li><li class="alt">    private String username;  </li><li class="">  </li><li class="alt">    private String password;  </li><li class="">  </li><li class="alt">    private List<Role> roles;  </li><li class="">  </li><li class="alt">    private static final long serialVersionUID = 1L;  </li><li class="">  </li><li class="alt">    public String getId() {  </li><li class="">        return id;  </li><li class="alt">    }  </li><li class="">  </li><li class="alt">    public void setId(String id) {  </li><li class="">        this.id = id == null ? null : id.trim();  </li><li class="alt">    }  </li><li class="">  </li><li class="alt">    public String getUsername() {  </li><li class="">        return username;  </li><li class="alt">    }  </li><li class="">  </li><li class="alt">    public void setUsername(String username) {  </li><li class="">        this.username = username == null ? null : username.trim();  </li><li class="alt">    }  </li><li class="">  </li><li class="alt">    public String getPassword() {  </li><li class="">        return password;  </li><li class="alt">    }  </li><li class="">  </li><li class="alt">    public void setPassword(String password) {  </li><li class="">        this.password = password == null ? null : password.trim();  </li><li class="alt">    }  </li><li class="">  </li><li class="alt">    public List<Role> getRoles() {  </li><li class="">        return roles;  </li><li class="alt">    }  </li><li class="">  </li><li class="alt">    public void setRoles(List<Role> roles) {  </li><li class="">        this.roles = roles;  </li><li class="alt">    }  </li><li class="">  </li><li class="alt">    @Override  </li><li class="">    public boolean equals(Object that) {  </li><li class="alt">        if (this == that) {  </li><li class="">            return true;  </li><li class="alt">        }  </li><li class="">        if (that == null) {  </li><li class="alt">            return false;  </li><li class="">        }  </li><li class="alt">        if (getClass() != that.getClass()) {  </li><li class="">            return false;  </li><li class="alt">        }  </li><li class="">        User other = (User) that;  </li><li class="alt">        return (this.getId() == null ? other.getId() == null : this.getId().equals(other.getId()))  </li><li class="">            && (this.getUsername() == null ? other.getUsername() == null : this.getUsername().equals(other.getUsername()))  </li><li class="alt">            && (this.getPassword() == null ? other.getPassword() == null : this.getPassword().equals(other.getPassword()));  </li><li class="">    }  </li><li class="alt">  </li><li class="">    @Override  </li><li class="alt">    public int hashCode() {  </li><li class="">        final int prime = 31;  </li><li class="alt">        int result = 1;  </li><li class="">        result = prime * result + ((getId() == null) ? 0 : getId().hashCode());  </li><li class="alt">        result = prime * result + ((getUsername() == null) ? 0 : getUsername().hashCode());  </li><li class="">        result = prime * result + ((getPassword() == null) ? 0 : getPassword().hashCode());  </li><li class="alt">        return result;  </li><li class="">    }  </li><li class="alt">}  </li></ol></div><pre class="java" name="code" style="display: none;">package com.sica.domain;

import java.io.Serializable;
import java.util.List;

public class User implements Serializable {
private String id;

private String username;

private String password;

private List<Role> roles;

private static final long serialVersionUID = 1L;

public String getId() {
return id;
}

public void setId(String id) {
this.id = id == null ? null : id.trim();
}

public String getUsername() {
return username;
}

public void setUsername(String username) {
this.username = username == null ? null : username.trim();
}

public String getPassword() {
return password;
}

public void setPassword(String password) {
this.password = password == null ? null : password.trim();
}

public List<Role> getRoles() {
return roles;
}

public void setRoles(List<Role> roles) {
this.roles = roles;
}

@Override
public boolean equals(Object that) {
if (this == that) {
return true;
}
if (that == null) {
return false;
}
if (getClass() != that.getClass()) {
return false;
}
User other = (User) that;
return (this.getId() == null ? other.getId() == null : this.getId().equals(other.getId()))
&& (this.getUsername() == null ? other.getUsername() == null : this.getUsername().equals(other.getUsername()))
&& (this.getPassword() == null ? other.getPassword() == null : this.getPassword().equals(other.getPassword()));
}

@Override
public int hashCode() {
final int prime = 31;
int result = 1;
result = prime * result + ((getId() == null) ? 0 : getId().hashCode());
result = prime * result + ((getUsername() == null) ? 0 : getUsername().hashCode());
result = prime * result + ((getPassword() == null) ? 0 : getPassword().hashCode());
return result;
}
}</pre></div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">Role</div>
<div style="line-height:21px;"><div class="dp-highlighter bg_java"><div class="bar"><div class="tools">[java] <a href="#" class="ViewSource" title="view plain" οnclick="dp.sh.Toolbar.Command('ViewSource',this);return false;">view plain</a> <a href="#" class="CopyToClipboard" title="copy" οnclick="dp.sh.Toolbar.Command('CopyToClipboard',this);return false;">copy</a><div style="position: absolute; left: 166px; top: 2799px; width: 16px; height: 16px; z-index: 99;"><embed id="ZeroClipboardMovie_2" src="http://static.blog.csdn.net/scripts/ZeroClipboard/ZeroClipboard.swf" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="16" height="16" name="ZeroClipboardMovie_2" align="middle" allowscriptaccess="always" allowfullscreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="id=2&width=16&height=16" wmode="transparent"></div> <a href="#" class="PrintSource" title="print" οnclick="dp.sh.Toolbar.Command('PrintSource',this);return false;">print</a><a href="#" class="About" title="?" οnclick="dp.sh.Toolbar.Command('About',this);return false;">?</a></div></div><ol start="1" class="dp-j"><li class="alt"><span style="font-family:Comic Sans MS;font-size:12px;">package com.sica.domain;  </li><li class="">  </li><li class="alt">import java.io.Serializable;  </li><li class="">  </li><li class="alt">public class Role implements Serializable {  </li><li class="">    private String id;  </li><li class="alt">  </li><li class="">    private String name;  </li><li class="alt">  </li><li class="">    private String jsms;  </li><li class="alt">  </li><li class="">    private String bz;  </li><li class="alt">  </li><li class="">    private Integer jlzt;  </li><li class="alt">  </li><li class="">    private String glbm;  </li><li class="alt">  </li><li class="">    private String userid;  </li><li class="alt">  </li><li class="">    private static final long serialVersionUID = 1L;  </li><li class="alt">  </li><li class="">    public String getId() {  </li><li class="alt">        return id;  </li><li class="">    }  </li><li class="alt">  </li><li class="">    public void setId(String id) {  </li><li class="alt">        this.id = id == null ? null : id.trim();  </li><li class="">    }  </li><li class="alt">  </li><li class="">    public String getName() {  </li><li class="alt">        return name;  </li><li class="">    }  </li><li class="alt">  </li><li class="">    public void setName(String name) {  </li><li class="alt">        this.name = name == null ? null : name.trim();  </li><li class="">    }  </li><li class="alt">  </li><li class="">    public String getJsms() {  </li><li class="alt">        return jsms;  </li><li class="">    }  </li><li class="alt">  </li><li class="">    public void setJsms(String jsms) {  </li><li class="alt">        this.jsms = jsms == null ? null : jsms.trim();  </li><li class="">    }  </li><li class="alt">  </li><li class="">    public String getBz() {  </li><li class="alt">        return bz;  </li><li class="">    }  </li><li class="alt">  </li><li class="">    public void setBz(String bz) {  </li><li class="alt">        this.bz = bz == null ? null : bz.trim();  </li><li class="">    }  </li><li class="alt">  </li><li class="">    public Integer getJlzt() {  </li><li class="alt">        return jlzt;  </li><li class="">    }  </li><li class="alt">  </li><li class="">    public void setJlzt(Integer jlzt) {  </li><li class="alt">        this.jlzt = jlzt;  </li><li class="">    }  </li><li class="alt">  </li><li class="">    public String getGlbm() {  </li><li class="alt">        return glbm;  </li><li class="">    }  </li><li class="alt">  </li><li class="">    public void setGlbm(String glbm) {  </li><li class="alt">        this.glbm = glbm == null ? null : glbm.trim();  </li><li class="">    }  </li><li class="alt">  </li><li class="">    public String getUserid() {  </li><li class="alt">        return userid;  </li><li class="">    }  </li><li class="alt">  </li><li class="">    public void setUserid(String userid) {  </li><li class="alt">        this.userid = userid == null ? null : userid.trim();  </li><li class="">    }  </li><li class="alt">  </li><li class="">    @Override  </li><li class="alt">    public boolean equals(Object that) {  </li><li class="">        if (this == that) {  </li><li class="alt">            return true;  </li><li class="">        }  </li><li class="alt">        if (that == null) {  </li><li class="">            return false;  </li><li class="alt">        }  </li><li class="">        if (getClass() != that.getClass()) {  </li><li class="alt">            return false;  </li><li class="">        }  </li><li class="alt">        Role other = (Role) that;  </li><li class="">        return (this.getId() == null ? other.getId() == null : this.getId().equals(other.getId()))  </li><li class="alt">            && (this.getName() == null ? other.getName() == null : this.getName().equals(other.getName()))  </li><li class="">            && (this.getJsms() == null ? other.getJsms() == null : this.getJsms().equals(other.getJsms()))  </li><li class="alt">            && (this.getBz() == null ? other.getBz() == null : this.getBz().equals(other.getBz()))  </li><li class="">            && (this.getJlzt() == null ? other.getJlzt() == null : this.getJlzt().equals(other.getJlzt()))  </li><li class="alt">            && (this.getGlbm() == null ? other.getGlbm() == null : this.getGlbm().equals(other.getGlbm()))  </li><li class="">            && (this.getUserid() == null ? other.getUserid() == null : this.getUserid().equals(other.getUserid()));  </li><li class="alt">    }  </li><li class="">  </li><li class="alt">    @Override  </li><li class="">    public int hashCode() {  </li><li class="alt">        final int prime = 31;  </li><li class="">        int result = 1;  </li><li class="alt">        result = prime * result + ((getId() == null) ? 0 : getId().hashCode());  </li><li class="">        result = prime * result + ((getName() == null) ? 0 : getName().hashCode());  </li><li class="alt">        result = prime * result + ((getJsms() == null) ? 0 : getJsms().hashCode());  </li><li class="">        result = prime * result + ((getBz() == null) ? 0 : getBz().hashCode());  </li><li class="alt">        result = prime * result + ((getJlzt() == null) ? 0 : getJlzt().hashCode());  </li><li class="">        result = prime * result + ((getGlbm() == null) ? 0 : getGlbm().hashCode());  </li><li class="alt">        result = prime * result + ((getUserid() == null) ? 0 : getUserid().hashCode());  </li><li class="">        return result;  </li><li class="alt">    }  </li><li class="">}  </li></ol></div><pre class="java" name="code" style="display: none;">package com.sica.domain;

import java.io.Serializable;

public class Role implements Serializable {
private String id;

private String name;

private String jsms;

private String bz;

private Integer jlzt;

private String glbm;

private String userid;

private static final long serialVersionUID = 1L;

public String getId() {
return id;
}

public void setId(String id) {
this.id = id == null ? null : id.trim();
}

public String getName() {
return name;
}

public void setName(String name) {
this.name = name == null ? null : name.trim();
}

public String getJsms() {
return jsms;
}

public void setJsms(String jsms) {
this.jsms = jsms == null ? null : jsms.trim();
}

public String getBz() {
return bz;
}

public void setBz(String bz) {
this.bz = bz == null ? null : bz.trim();
}

public Integer getJlzt() {
return jlzt;
}

public void setJlzt(Integer jlzt) {
this.jlzt = jlzt;
}

public String getGlbm() {
return glbm;
}

public void setGlbm(String glbm) {
this.glbm = glbm == null ? null : glbm.trim();
}

public String getUserid() {
return userid;
}

public void setUserid(String userid) {
this.userid = userid == null ? null : userid.trim();
}

@Override
public boolean equals(Object that) {
if (this == that) {
return true;
}
if (that == null) {
return false;
}
if (getClass() != that.getClass()) {
return false;
}
Role other = (Role) that;
return (this.getId() == null ? other.getId() == null : this.getId().equals(other.getId()))
&& (this.getName() == null ? other.getName() == null : this.getName().equals(other.getName()))
&& (this.getJsms() == null ? other.getJsms() == null : this.getJsms().equals(other.getJsms()))
&& (this.getBz() == null ? other.getBz() == null : this.getBz().equals(other.getBz()))
&& (this.getJlzt() == null ? other.getJlzt() == null : this.getJlzt().equals(other.getJlzt()))
&& (this.getGlbm() == null ? other.getGlbm() == null : this.getGlbm().equals(other.getGlbm()))
&& (this.getUserid() == null ? other.getUserid() == null : this.getUserid().equals(other.getUserid()));
}

@Override
public int hashCode() {
final int prime = 31;
int result = 1;
result = prime * result + ((getId() == null) ? 0 : getId().hashCode());
result = prime * result + ((getName() == null) ? 0 : getName().hashCode());
result = prime * result + ((getJsms() == null) ? 0 : getJsms().hashCode());
result = prime * result + ((getBz() == null) ? 0 : getBz().hashCode());
result = prime * result + ((getJlzt() == null) ? 0 : getJlzt().hashCode());
result = prime * result + ((getGlbm() == null) ? 0 : getGlbm().hashCode());
result = prime * result + ((getUserid() == null) ? 0 : getUserid().hashCode());
return result;
}
}</pre></div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">首先讲一下业务，这里用到的 User 、Role 的对应关系是，一个用户有多个角色，也就是 User ： Role 是 1 ： n 的关系。因此，在 User 的实体中加入一个 Role 的属性，对应一对多的关系。</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">然后就是 mapper 接口和 xml 文件了：</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">mapper接口</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">UserMapper</div>
<div style="line-height:21px;"><div class="dp-highlighter bg_java"><div class="bar"><div class="tools">[java] <a href="#" class="ViewSource" title="view plain" οnclick="dp.sh.Toolbar.Command('ViewSource',this);return false;">view plain</a> <a href="#" class="CopyToClipboard" title="copy" οnclick="dp.sh.Toolbar.Command('CopyToClipboard',this);return false;">copy</a><div style="position: absolute; left: 166px; top: 5127px; width: 16px; height: 16px; z-index: 99;"><embed id="ZeroClipboardMovie_3" src="http://static.blog.csdn.net/scripts/ZeroClipboard/ZeroClipboard.swf" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="16" height="16" name="ZeroClipboardMovie_3" align="middle" allowscriptaccess="always" allowfullscreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="id=3&width=16&height=16" wmode="transparent"></div> <a href="#" class="PrintSource" title="print" οnclick="dp.sh.Toolbar.Command('PrintSource',this);return false;">print</a><a href="#" class="About" title="?" οnclick="dp.sh.Toolbar.Command('About',this);return false;">?</a></div></div><ol start="1" class="dp-j"><li class="alt"><span style="font-family:Comic Sans MS;font-size:12px;">package com.sica.mapper;  </li><li class="">  </li><li class="alt">import com.sica.domain.User;  </li><li class="">  </li><li class="alt">import java.util.List;  </li><li class="">  </li><li class="alt">public interface UserMapper {  </li><li class="">    int deleteByPrimaryKey(String id);  </li><li class="alt">  </li><li class="">    int insert(User record);  </li><li class="alt">  </li><li class="">    int insertSelective(User record);  </li><li class="alt">  </li><li class="">    User selectByPrimaryKey(String id);  </li><li class="alt">  </li><li class="">    int updateByPrimaryKeySelective(User record);  </li><li class="alt">  </li><li class="">    int updateByPrimaryKey(User record);  </li><li class="alt">  </li><li class="">    List<User> queryForList();  </li><li class="alt">}  </li></ol></div><pre class="java" name="code" style="display: none;">package com.sica.mapper;

import com.sica.domain.User;

import java.util.List;

public interface UserMapper {
int deleteByPrimaryKey(String id);

int insert(User record);

int insertSelective(User record);

User selectByPrimaryKey(String id);

int updateByPrimaryKeySelective(User record);

int updateByPrimaryKey(User record);

List<User> queryForList();
}</pre></div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">mapper xml文件</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">UserMapper</div>
<div style="line-height:21px;"><div class="dp-highlighter bg_html"><div class="bar"><div class="tools">[html] <a href="#" class="ViewSource" title="view plain" οnclick="dp.sh.Toolbar.Command('ViewSource',this);return false;">view plain</a> <a href="#" class="CopyToClipboard" title="copy" οnclick="dp.sh.Toolbar.Command('CopyToClipboard',this);return false;">copy</a><div style="position: absolute; left: 168px; top: 5661px; width: 16px; height: 16px; z-index: 99;"><embed id="ZeroClipboardMovie_4" src="http://static.blog.csdn.net/scripts/ZeroClipboard/ZeroClipboard.swf" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="16" height="16" name="ZeroClipboardMovie_4" align="middle" allowscriptaccess="always" allowfullscreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="id=4&width=16&height=16" wmode="transparent"></div> <a href="#" class="PrintSource" title="print" οnclick="dp.sh.Toolbar.Command('PrintSource',this);return false;">print</a><a href="#" class="About" title="?" οnclick="dp.sh.Toolbar.Command('About',this);return false;">?</a></div></div><ol start="1" class="dp-xml"><li class="alt"><span style="font-family:Comic Sans MS;font-size:12px;"><?xml version="1.0" encoding="UTF-8" ?>  </li><li class=""><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >  </li><li class="alt"><mapper namespace="com.sica.mapper.UserMapper">  </li><li class="">    <resultMap id="BaseResultMap" type="com.sica.domain.User">  </li><li class="alt">        <id column="id" property="id" jdbcType="VARCHAR"/>  </li><li class="">        <result column="username" property="username" jdbcType="VARCHAR"/>  </li><li class="alt">        <result column="password" property="password" jdbcType="VARCHAR"/>  </li><li class="">    </resultMap>  </li><li class="alt">  </li><li class="">    <resultMap id="queryForListMap" type="com.sica.domain.User">  </li><li class="alt">        <id column="id" property="id" jdbcType="VARCHAR"/>  </li><li class="">        <result column="username" property="username" jdbcType="VARCHAR"/>  </li><li class="alt">        <result column="password" property="password" jdbcType="VARCHAR"/>  </li><li class="">        <collection property="roles" javaType="java.util.List" ofType="com.sica.domain.Role">  </li><li class="alt">            <id column="r_id" property="id" jdbcType="VARCHAR" />  </li><li class="">            <result column="r_name" property="name" jdbcType="VARCHAR" />  </li><li class="alt">            <result column="r_jsms" property="jsms" jdbcType="VARCHAR" />  </li><li class="">            <result column="r_bz" property="bz" jdbcType="VARCHAR" />  </li><li class="alt">            <result column="r_jlzt" property="jlzt" jdbcType="INTEGER" />  </li><li class="">            <result column="r_glbm" property="glbm" jdbcType="VARCHAR" />  </li><li class="alt">        </collection>  </li><li class="">    </resultMap>  </li><li class="alt">    <select id="queryForList" resultMap="queryForListMap">  </li><li class="">        SELECT  </li><li class="alt">          u.id,  </li><li class="">          u.username,  </li><li class="alt">          u.password,  </li><li class="">          r.id r_id,  </li><li class="alt">          r.name r_name,  </li><li class="">          r.jsms r_jsms,  </li><li class="alt">          r.bz r_bz,  </li><li class="">          r.jlzt r_jlzt,  </li><li class="alt">          r.glbm r_glbm  </li><li class="">        FROM  </li><li class="alt">          user u  </li><li class="">        LEFT JOIN  </li><li class="alt">          role r  </li><li class="">        ON  </li><li class="alt">          u.id = r.userid  </li><li class="">    </select>  </li><li class="alt">    <sql id="Base_Column_List">  </li><li class="">      id, username, password  </li><li class="alt">    </sql>  </li><li class="">    <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String">  </li><li class="alt">        select  </li><li class="">        <include refid="Base_Column_List"/>  </li><li class="alt">        from user  </li><li class="">        where id = #{id,jdbcType=VARCHAR}  </li><li class="alt">    </select>  </li><li class="">    <delete id="deleteByPrimaryKey" parameterType="java.lang.String">  </li><li class="alt">    delete from user  </li><li class="">    where id = #{id,jdbcType=VARCHAR}  </li><li class="alt">    </delete>  </li><li class="">    <insert id="insert" parameterType="com.sica.domain.User">  </li><li class="alt">    insert into user (id, username, password  </li><li class="">      )  </li><li class="alt">    values (#{id,jdbcType=VARCHAR}, #{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}  </li><li class="">      )  </li><li class="alt">    </insert>  </li><li class="">    <insert id="insertSelective" parameterType="com.sica.domain.User">  </li><li class="alt">        insert into user  </li><li class="">        <trim prefix="(" suffix=")" suffixOverrides=",">  </li><li class="alt">            <if test="id != null">  </li><li class="">                id,  </li><li class="alt">            </if>  </li><li class="">            <if test="username != null">  </li><li class="alt">                username,  </li><li class="">            </if>  </li><li class="alt">            <if test="password != null">  </li><li class="">                password,  </li><li class="alt">            </if>  </li><li class="">        </trim>  </li><li class="alt">        <trim prefix="values (" suffix=")" suffixOverrides=",">  </li><li class="">            <if test="id != null">  </li><li class="alt">                #{id,jdbcType=VARCHAR},  </li><li class="">            </if>  </li><li class="alt">            <if test="username != null">  </li><li class="">                #{username,jdbcType=VARCHAR},  </li><li class="alt">            </if>  </li><li class="">            <if test="password != null">  </li><li class="alt">                #{password,jdbcType=VARCHAR},  </li><li class="">            </if>  </li><li class="alt">        </trim>  </li><li class="">    </insert>  </li><li class="alt">    <update id="updateByPrimaryKeySelective" parameterType="com.sica.domain.User">  </li><li class="">        update user  </li><li class="alt">        <set>  </li><li class="">            <if test="username != null">  </li><li class="alt">                username = #{username,jdbcType=VARCHAR},  </li><li class="">            </if>  </li><li class="alt">            <if test="password != null">  </li><li class="">                password = #{password,jdbcType=VARCHAR},  </li><li class="alt">            </if>  </li><li class="">        </set>  </li><li class="alt">        where id = #{id,jdbcType=VARCHAR}  </li><li class="">    </update>  </li><li class="alt">    <update id="updateByPrimaryKey" parameterType="com.sica.domain.User">  </li><li class="">    update user  </li><li class="alt">    set username = #{username,jdbcType=VARCHAR},  </li><li class="">      password = #{password,jdbcType=VARCHAR}  </li><li class="alt">    where id = #{id,jdbcType=VARCHAR}  </li><li class="">  </update>  </li><li class="alt"></mapper></span>  </li></ol></div><pre class="html" name="code" style="display: none;"><?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.sica.mapper.UserMapper">
<resultMap id="BaseResultMap" type="com.sica.domain.User">
<id column="id" property="id" jdbcType="VARCHAR"/>
<result column="username" property="username" jdbcType="VARCHAR"/>
<result column="password" property="password" jdbcType="VARCHAR"/>
</resultMap>

<resultMap id="queryForListMap" type="com.sica.domain.User">
<id column="id" property="id" jdbcType="VARCHAR"/>
<result column="username" property="username" jdbcType="VARCHAR"/>
<result column="password" property="password" jdbcType="VARCHAR"/>
<collection property="roles" javaType="java.util.List" ofType="com.sica.domain.Role">
<id column="r_id" property="id" jdbcType="VARCHAR" />
<result column="r_name" property="name" jdbcType="VARCHAR" />
<result column="r_jsms" property="jsms" jdbcType="VARCHAR" />
<result column="r_bz" property="bz" jdbcType="VARCHAR" />
<result column="r_jlzt" property="jlzt" jdbcType="INTEGER" />
<result column="r_glbm" property="glbm" jdbcType="VARCHAR" />
</collection>
</resultMap>
<select id="queryForList" resultMap="queryForListMap">
SELECT
u.id,
u.username,
u.password,
r.id r_id,
r.name r_name,
r.jsms r_jsms,
r.bz r_bz,
r.jlzt r_jlzt,
r.glbm r_glbm
FROM
user u
LEFT JOIN
role r
ON
u.id = r.userid
</select>
<sql id="Base_Column_List">
id, username, password
</sql>
<select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String">
select
<include refid="Base_Column_List"/>
from user
where id = #{id,jdbcType=VARCHAR}
</select>
<delete id="deleteByPrimaryKey" parameterType="java.lang.String">
delete from user
where id = #{id,jdbcType=VARCHAR}
</delete>
<insert id="insert" parameterType="com.sica.domain.User">
insert into user (id, username, password
)
values (#{id,jdbcType=VARCHAR}, #{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}
)
</insert>
<insert id="insertSelective" parameterType="com.sica.domain.User">
insert into user
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">
id,
</if>
<if test="username != null">
username,
</if>
<if test="password != null">
password,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="id != null">
#{id,jdbcType=VARCHAR},
</if>
<if test="username != null">
#{username,jdbcType=VARCHAR},
</if>
<if test="password != null">
#{password,jdbcType=VARCHAR},
</if>
</trim>
</insert>
<update id="updateByPrimaryKeySelective" parameterType="com.sica.domain.User">
update user
<set>
<if test="username != null">
username = #{username,jdbcType=VARCHAR},
</if>
<if test="password != null">
password = #{password,jdbcType=VARCHAR},
</if>
</set>
where id = #{id,jdbcType=VARCHAR}
</update>
<update id="updateByPrimaryKey" parameterType="com.sica.domain.User">
update user
set username = #{username,jdbcType=VARCHAR},
password = #{password,jdbcType=VARCHAR}
where id = #{id,jdbcType=VARCHAR}
</update>
</mapper></pre></div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">之后，我扩展了一个 Dao 接口，当然，你也可以直接使用 mapper 接口，都是一样的。</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">Dao 接口</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">IUserDao</div>
<div style="line-height:21px;"><div class="dp-highlighter bg_java"><div class="bar"><div class="tools">[java] <a href="#" class="ViewSource" title="view plain" οnclick="dp.sh.Toolbar.Command('ViewSource',this);return false;">view plain</a> <a href="#" class="CopyToClipboard" title="copy" οnclick="dp.sh.Toolbar.Command('CopyToClipboard',this);return false;">copy</a><div style="position: absolute; left: 166px; top: 7724px; width: 16px; height: 16px; z-index: 99;"><embed id="ZeroClipboardMovie_5" src="http://static.blog.csdn.net/scripts/ZeroClipboard/ZeroClipboard.swf" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="16" height="16" name="ZeroClipboardMovie_5" align="middle" allowscriptaccess="always" allowfullscreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="id=5&width=16&height=16" wmode="transparent"></div> <a href="#" class="PrintSource" title="print" οnclick="dp.sh.Toolbar.Command('PrintSource',this);return false;">print</a><a href="#" class="About" title="?" οnclick="dp.sh.Toolbar.Command('About',this);return false;">?</a></div></div><ol start="1" class="dp-j"><li class="alt"><span style="font-family:Comic Sans MS;font-size:12px;">package com.sica.dao;  </li><li class="">  </li><li class="alt">import com.sica.mapper.UserMapper;  </li><li class="">  </li><li class="alt">/** </li><li class=""> * Created by IntelliJ IDEA. </li><li class="alt"> * Package: com.sica.dao </li><li class=""> * Name: IUserDao </li><li class="alt"> * User: xiang.li </li><li class=""> * Date: 2015/5/22 </li><li class="alt"> * Time: 15:25 </li><li class=""> * Desc: To change this template use File | Settings | File Templates. </li><li class="alt"> */  </li><li class="">public interface IUserDao extends UserMapper {  </li><li class="alt">  </li><li class="">}  </li></ol></div><pre class="java" name="code" style="display: none;">package com.sica.dao;

import com.sica.mapper.UserMapper;

/**
* Created by IntelliJ IDEA.
* Package: com.sica.dao
* Name: IUserDao
* User: xiang.li
* Date: 2015/5/22
* Time: 15:25
* Desc: To change this template use File | Settings | File Templates.
*/
public interface IUserDao extends UserMapper {

}</pre></div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">下面就是 service 和实现层的代码了。</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">IUserService</div>
<div style="line-height:21px;"><div class="dp-highlighter bg_java"><div class="bar"><div class="tools">[java] <a href="#" class="ViewSource" title="view plain" οnclick="dp.sh.Toolbar.Command('ViewSource',this);return false;">view plain</a> <a href="#" class="CopyToClipboard" title="copy" οnclick="dp.sh.Toolbar.Command('CopyToClipboard',this);return false;">copy</a><div style="position: absolute; left: 166px; top: 8164px; width: 16px; height: 16px; z-index: 99;"><embed id="ZeroClipboardMovie_6" src="http://static.blog.csdn.net/scripts/ZeroClipboard/ZeroClipboard.swf" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="16" height="16" name="ZeroClipboardMovie_6" align="middle" allowscriptaccess="always" allowfullscreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="id=6&width=16&height=16" wmode="transparent"></div> <a href="#" class="PrintSource" title="print" οnclick="dp.sh.Toolbar.Command('PrintSource',this);return false;">print</a><a href="#" class="About" title="?" οnclick="dp.sh.Toolbar.Command('About',this);return false;">?</a></div></div><ol start="1" class="dp-j"><li class="alt"><span style="font-family:Comic Sans MS;font-size:12px;">package com.sica.service;  </li><li class="">  </li><li class="alt">import com.sica.domain.User;  </li><li class="">  </li><li class="alt">import java.util.List;  </li><li class="">  </li><li class="alt">/** </li><li class=""> * Created by xiang.li on 2015/1/31. </li><li class="alt"> */  </li><li class="">public interface IUserService {  </li><li class="alt">  </li><li class="">    /** </li><li class="alt">     * 根据Id查询用户对象 </li><li class="">     * @param id 编号 </li><li class="alt">     * @return 用户对象 </li><li class="">     */  </li><li class="alt">    User getUserById(String id);  </li><li class="">  </li><li class="alt">    /** </li><li class="">     * 根据用户名查询用户对象 </li><li class="alt">     * @return  List </li><li class="">     */  </li><li class="alt">    List<User> queryUserList();  </li><li class="">}  </li></ol></div><pre class="java" name="code" style="display: none;">package com.sica.service;

import com.sica.domain.User;

import java.util.List;

/**
* Created by xiang.li on 2015/1/31.
*/
public interface IUserService {

/**
* 根据Id查询用户对象
* @param id 编号
* @return 用户对象
*/
User getUserById(String id);

/**
* 根据用户名查询用户对象
* @return List
*/
List<User> queryUserList();
}</pre></div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">UserServiceImpl</div>
<div style="line-height:21px;"><div class="dp-highlighter bg_java"><div class="bar"><div class="tools">[java] <a href="#" class="ViewSource" title="view plain" οnclick="dp.sh.Toolbar.Command('ViewSource',this);return false;">view plain</a> <a href="#" class="CopyToClipboard" title="copy" οnclick="dp.sh.Toolbar.Command('CopyToClipboard',this);return false;">copy</a><div style="position: absolute; left: 166px; top: 8707px; width: 16px; height: 16px; z-index: 99;"><embed id="ZeroClipboardMovie_7" src="http://static.blog.csdn.net/scripts/ZeroClipboard/ZeroClipboard.swf" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="16" height="16" name="ZeroClipboardMovie_7" align="middle" allowscriptaccess="always" allowfullscreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="id=7&width=16&height=16" wmode="transparent"></div> <a href="#" class="PrintSource" title="print" οnclick="dp.sh.Toolbar.Command('PrintSource',this);return false;">print</a><a href="#" class="About" title="?" οnclick="dp.sh.Toolbar.Command('About',this);return false;">?</a></div></div><ol start="1" class="dp-j"><li class="alt"><span style="font-family:Comic Sans MS;font-size:12px;">package com.sica.service.impl;  </li><li class="">  </li><li class="alt">import com.sica.dao.IUserDao;  </li><li class="">import com.sica.domain.User;  </li><li class="alt">import com.sica.service.IUserService;  </li><li class="">import org.springframework.stereotype.Service;  </li><li class="alt">  </li><li class="">import javax.annotation.Resource;  </li><li class="alt">import java.util.List;  </li><li class="">  </li><li class="alt">/** </li><li class=""> * Created by xiang.li on 2015/1/31. </li><li class="alt"> */  </li><li class="">@Service("userService")  </li><li class="alt">public class UserServiceImpl implements IUserService {  </li><li class="">  </li><li class="alt">    @Resource  </li><li class="">    public IUserDao userDao;  </li><li class="alt">  </li><li class="">    @Override  </li><li class="alt">    public User getUserById(String id) {  </li><li class="">        return this.userDao.selectByPrimaryKey(id);  </li><li class="alt">    }  </li><li class="">  </li><li class="alt">    @Override  </li><li class="">    public List<User> queryUserList() {  </li><li class="alt">        return userDao.queryForList();  </li><li class="">    }  </li><li class="alt">  </li><li class="">}  </li></ol></div><pre class="java" name="code" style="display: none;">package com.sica.service.impl;

import com.sica.dao.IUserDao;
import com.sica.domain.User;
import com.sica.service.IUserService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;

/**
* Created by xiang.li on 2015/1/31.
*/
@Service("userService")
public class UserServiceImpl implements IUserService {

@Resource
public IUserDao userDao;

@Override
public User getUserById(String id) {
return this.userDao.selectByPrimaryKey(id);
}

@Override
public List<User> queryUserList() {
return userDao.queryForList();
}

}</pre></div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">当然，还有所谓的 applicationContext.xml 配置，不过，我这里叫 spring-mybatis.xml。</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="line-height:21px;"><div class="dp-highlighter bg_html"><div class="bar"><div class="tools">[html] <a href="#" class="ViewSource" title="view plain" οnclick="dp.sh.Toolbar.Command('ViewSource',this);return false;">view plain</a> <a href="#" class="CopyToClipboard" title="copy" οnclick="dp.sh.Toolbar.Command('CopyToClipboard',this);return false;">copy</a><div style="position: absolute; left: 168px; top: 9385px; width: 16px; height: 16px; z-index: 99;"><embed id="ZeroClipboardMovie_8" src="http://static.blog.csdn.net/scripts/ZeroClipboard/ZeroClipboard.swf" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="16" height="16" name="ZeroClipboardMovie_8" align="middle" allowscriptaccess="always" allowfullscreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="id=8&width=16&height=16" wmode="transparent"></div> <a href="#" class="PrintSource" title="print" οnclick="dp.sh.Toolbar.Command('PrintSource',this);return false;">print</a><a href="#" class="About" title="?" οnclick="dp.sh.Toolbar.Command('About',this);return false;">?</a></div></div><ol start="1" class="dp-xml"><li class="alt"><span style="font-family:Comic Sans MS;font-size:12px;"><?xml version="1.0" encoding="UTF-8"?>  </li><li class=""><beans xmlns="http://www.springframework.org/schema/beans"  </li><li class="alt">       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  </li><li class="">       xmlns:p="http://www.springframework.org/schema/p"  </li><li class="alt">       xmlns:context="http://www.springframework.org/schema/context"  </li><li class="">       xmlns:mvc="http://www.springframework.org/schema/mvc"  </li><li class="alt">       xsi:schemaLocation="http://www.springframework.org/schema/beans  </li><li class="">       http://www.springframework.org/schema/beans/spring-beans.xsd  </li><li class="alt">        http://www.springframework.org/schema/context  </li><li class="">        http://www.springframework.org/schema/context/spring-context.xsd  </li><li class="alt">        http://www.springframework.org/schema/mvc  </li><li class="">        http://www.springframework.org/schema/mvc/spring-mvc.xsd">  </li><li class="alt">  </li><li class="">      </li><li class="alt">    <context:component-scan base-package="com.sica"/>  </li><li class="">      </li><li class="alt">    <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"  </li><li class="">          p:location="classpath:jdbc.properties"  </li><li class="alt">          />  </li><li class="">  </li><li class="alt">      </li><li class="">      </li><li class="alt">      </li><li class="">      </li><li class="alt">      </li><li class="">      </li><li class="alt">    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"  </li><li class="">          p:driverClassName="${jdbc.driver}"  </li><li class="alt">          p:url="${jdbc.url}"  </li><li class="">          p:username="${jdbc.username}"  </li><li class="alt">          p:password="${jdbc.password}"  </li><li class="">          p:initialSize="${jdbc.initialSize}"  </li><li class="alt">          p:maxActive="${jdbc.maxActive}"  </li><li class="">          p:maxIdle="${jdbc.maxIdle}"  </li><li class="alt">          p:minIdle="${jdbc.minIdle}"  </li><li class="">          p:maxWait="${jdbc.maxWait}"  </li><li class="alt">          />  </li><li class="">  </li><li class="alt">      </li><li class="">    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean" lazy-init="default"  </li><li class="alt">          p:dataSource-ref="dataSource"  </li><li class="">          p:mapperLocations="classpath:com/sica/mapping/*.xml"  </li><li class="alt">          />  </li><li class="">  </li><li class="alt">      </li><li class="">    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"  </li><li class="alt">          p:basePackage="com.sica.dao"  </li><li class="">          p:sqlSessionFactoryBeanName="sqlSessionFactory"  </li><li class="alt">          />  </li><li class="">  </li><li class="alt">      </li><li class="">    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"  </li><li class="alt">          p:dataSource-ref="dataSource"  </li><li class="">          />  </li><li class="alt"></beans></span>  </li></ol></div><pre class="html" name="code" style="display: none;"><?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd">


<context:component-scan base-package="com.sica"/>

<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
p:location="classpath:jdbc.properties"
/>







<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"
p:driverClassName="${jdbc.driver}"
p:url="${jdbc.url}"
p:username="${jdbc.username}"
p:password="${jdbc.password}"
p:initialSize="${jdbc.initialSize}"
p:maxActive="${jdbc.maxActive}"
p:maxIdle="${jdbc.maxIdle}"
p:minIdle="${jdbc.minIdle}"
p:maxWait="${jdbc.maxWait}"
/>


<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean" lazy-init="default"
p:dataSource-ref="dataSource"
p:mapperLocations="classpath:com/sica/mapping/*.xml"
/>


<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"
p:basePackage="com.sica.dao"
p:sqlSessionFactoryBeanName="sqlSessionFactory"
/>


<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"
p:dataSource-ref="dataSource"
/>
</beans></pre></div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">最后，我用到的是 junit 进行的测试，测试代码如下。</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> 
GetUserTest </div>
<div style="line-height:21px;"><div class="dp-highlighter bg_java"><div class="bar"><div class="tools">[java] <a href="#" class="ViewSource" title="view plain" οnclick="dp.sh.Toolbar.Command('ViewSource',this);return false;">view plain</a> <a href="#" class="CopyToClipboard" title="copy" οnclick="dp.sh.Toolbar.Command('CopyToClipboard',this);return false;">copy</a><div style="position: absolute; left: 166px; top: 10541px; width: 16px; height: 16px; z-index: 99;"><embed id="ZeroClipboardMovie_9" src="http://static.blog.csdn.net/scripts/ZeroClipboard/ZeroClipboard.swf" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="16" height="16" name="ZeroClipboardMovie_9" align="middle" allowscriptaccess="always" allowfullscreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="id=9&width=16&height=16" wmode="transparent"></div> <a href="#" class="PrintSource" title="print" οnclick="dp.sh.Toolbar.Command('PrintSource',this);return false;">print</a><a href="#" class="About" title="?" οnclick="dp.sh.Toolbar.Command('About',this);return false;">?</a></div></div><ol start="1" class="dp-j"><li class="alt"><span style="font-family:Comic Sans MS;font-size:12px;">package com.sica.user;  </li><li class="">  </li><li class="alt">import com.alibaba.fastjson.JSON;  </li><li class="">import com.sica.domain.User;  </li><li class="alt">import com.sica.service.IUserService;  </li><li class="">import org.junit.Test;  </li><li class="alt">import org.junit.runner.RunWith;  </li><li class="">import org.slf4j.Logger;  </li><li class="alt">import org.slf4j.LoggerFactory;  </li><li class="">import org.springframework.test.context.ContextConfiguration;  </li><li class="alt">import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;  </li><li class="">  </li><li class="alt">import javax.annotation.Resource;  </li><li class="">import java.util.List;  </li><li class="alt">  </li><li class="">/** </li><li class="alt"> * Created by xiang.li on 2015/2/1. </li><li class=""> */  </li><li class="alt">@RunWith(SpringJUnit4ClassRunner.class)  </li><li class="">@ContextConfiguration(locations = "classpath:spring-mybatis.xml")  </li><li class="alt">public class GetUserTest {  </li><li class="">  </li><li class="alt">    private static String UUID = "3";  </li><li class="">    @Resource  </li><li class="alt">    private IUserService userService;  </li><li class="">    private static Logger logger = LoggerFactory.getLogger(GetUserTest.class);  </li><li class="alt">  </li><li class="">    @Test  </li><li class="alt">    public void test() {  </li><li class="">        User user = userService.getUserById(UUID);  </li><li class="alt">        logger.info(JSON.toJSONString(user));  </li><li class="">    }  </li><li class="alt">  </li><li class="">    /** </li><li class="alt">     * 测试联合查询 </li><li class="">     */  </li><li class="alt">    @Test  </li><li class="">    public void test2() {  </li><li class="alt">        List<User> users = userService.queryUserList();  </li><li class="">        logger.info(JSON.toJSONString(users));  </li><li class="alt">    }  </li><li class="">}  </li></ol></div><pre class="java" name="code" style="display: none;">package com.sica.user;

import com.alibaba.fastjson.JSON;
import com.sica.domain.User;
import com.sica.service.IUserService;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import javax.annotation.Resource;
import java.util.List;

/**
* Created by xiang.li on 2015/2/1.
*/
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = "classpath:spring-mybatis.xml")
public class GetUserTest {

private static String UUID = "3";
@Resource
private IUserService userService;
private static Logger logger = LoggerFactory.getLogger(GetUserTest.class);

@Test
public void test() {
User user = userService.getUserById(UUID);
logger.info(JSON.toJSONString(user));
}

/**
* 测试联合查询
*/
@Test
public void test2() {
List<User> users = userService.queryUserList();
logger.info(JSON.toJSONString(users));
}
}</pre></div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<h1 style="font-family:'微软雅黑';font-size:14px;line-height:21px;"><a name="t3"></a>测试结果</h1>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="text-align:center;font-family:'微软雅黑';font-size:14px;line-height:21px;">
<img src="https://img-blog.csdn.net/20150525114801761?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaGFwcHlsZWU2Njg4/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt=""> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">可以看到，所有的用户和用户对应的角色都全部查出来了，这说明，这次的测试很成功。</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<h1 style="font-family:'微软雅黑';font-size:14px;line-height:21px;"><a name="t4"></a>关于优化</h1>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">对于优化嘛，我这里简单的提几点，大家可以考虑一下。首先，就是对表的设计，在设计表初期，不仅仅要考虑到数据库的规范性，还好考虑到所谓的业务，以及对性能的影响，比如，如果从规范性角度考虑的话，可能就会分多个表，但是如果从性能角度来考虑的话，庞大的数据量在多表联合查询的时候，相对于单表来说，就会慢很多，这时，如果字段不是很多的话，可以考虑冗余几个字段采用单表的设计。</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">其次嘛，就是在 sql 上下功夫了，对于联合查询，sql 的优化是很有必要的，到底是采用 INNER JOIN，还是采用 LEFT JOIN 亦或是 RIGHT JOIN 、OUTTER JOIN 等，都是要在满足业务需求之后，通过测试性能得出的结论。</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">再次嘛，就是在程序中调用的时候了，是采用懒加载，还是采用非懒加载的方式，这也算是一个因素吧，具体的还是要考虑业务的需要。</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">最后嘛，就要用到数据库的缓存了，或者在数据库与程序的中间再加一层缓存。不过，还是建议用好数据库本身自带的缓存功能。</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<h1 style="font-family:'微软雅黑';font-size:14px;line-height:21px;"><a name="t5"></a>结束语</h1>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;">最后的最后，还是要提醒大家，不要因为觉得简单就引不起足够的重视，否则你会由于一点点小的失误，而浪费大把大把的时间的。我就在这上边体会过，所以，这里奉劝大家，还是小心为妙啊@！</div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
<div>
<div style="font-family:'微软雅黑';font-size:14px;line-height:21px;"> </div>
</div>
</div>
</article>