mybatis笔记整理

ゝ一世哀愁。 2022-04-25 09:02 264阅读 0赞

### 1、测试mybatis在java文件中取得数据表中的内容 ###

### 2、xml核心配置文件详解 ###

### 3、数据库连接池 ###

### 4、编码问题 ###

### 三种查询方式 ###

### log4j ###

### mapper.xml中的parameterType属性 ###

### 分页 ###

### 别名 ###

### 新增和事务讲解 ###

### 测试网页分页 ###

### getMapper接口绑定方案和多参数传递 ###

### 动态sql ###

### threadlocal ###

### 缓存 ###

### mybatis注解 ###

### 运行原理 ###

# 1、测试mybatis，在java中取到数据库表内容 #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 1][]

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> Mybatis.xml </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> &lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;!DOCTYPE configuration &nbsp; PUBLIC "-//mybatis.org//DTD Config 3.0//EN" &nbsp; "http://mybatis.org/dtd/mybatis-3-config.dtd"&gt; &lt;configuration&gt; &nbsp; &lt;environments default="default"&gt; &nbsp;&nbsp;&nbsp; &lt;environment id="default"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;transactionManager type="JDBC"/&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dataSource type="POOLED"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="driver" value="com.mysql.jdbc.Driver"/&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="url" value="jdbc:mysql:///ssm1"/&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="username" value="root"/&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="password" value="123"/&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/dataSource&gt; &nbsp;&nbsp;&nbsp; &lt;/environment&gt; &nbsp; &lt;/environments&gt; &nbsp; &lt;mappers&gt; &nbsp;&nbsp;&nbsp; &lt;mapper resource="com/pshdhx/mapper/FlowerMapper.xml"/&gt; &nbsp; &lt;/mappers&gt; &lt;/configuration&gt; </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> Mapper.xml </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> &lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;!DOCTYPE mapper &nbsp; PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" &nbsp; "http://mybatis.org/dtd/mybatis-3-mapper.dtd"&gt; &lt;mapper namespace="a.b"&gt; &nbsp;&nbsp;&nbsp; &lt;select id="selAll" resultType="com.pshdhx.pojo.Flower"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select * from flower &nbsp;&nbsp;&nbsp; &lt;/select&gt; &lt;/mapper&gt; </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> Test.java </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> package com.pshdhx.test; &nbsp; import java.io.IOException; import java.io.InputStream; import java.util.List; &nbsp; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; &nbsp; import com.pshdhx.pojo.Flower; &nbsp; public class Test { &nbsp;&nbsp;&nbsp; public static void main(String[] args) throws IOException{ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; InputStream is = Resources.getResourceAsStream("mybatis.xml"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SqlSession session = factory.openSession(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List&lt;Flower&gt; list = session.selectList("a.b.selAll"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for(Flower flower:list){ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println(flower.toString()); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; session.close(); &nbsp;&nbsp;&nbsp; } } &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> &nbsp; </td> 
 </tr> 
 </tbody> 
</table>

# 2、Xml核心配置文件详解 #

# 3、数据库连接池： #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 3][]

# 4、编码问题 #

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:213.05pt;"> res.setContentType("text/html;charset=utf-8"); </td> 
 <td style="vertical-align:top;width:213.05pt;"> 记住：是request，是text形式请求 </td> 
 </tr> 
 </tbody> 
</table>

# 三种查询方式： #

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> Session.selectList() </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> <img alt="" height="120" src="https://img-blog.csdnimg.cn/20190530221611769.png" width="719"> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> Session.selectOne() </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> <img alt="" height="87" src="https://img-blog.csdnimg.cn/20190530221607492.png" width="598"> &nbsp; <img alt="" height="71" src="https://img-blog.csdnimg.cn/20190530221607519.png" width="660"> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> Session.selectMap() </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> <img alt="" height="112" src="https://img-blog.csdnimg.cn/20190530221613122.png" width="824"> <img alt="" height="93" src="https://img-blog.csdnimg.cn/20190530221614328.png" width="773"> <img alt="" height="105" src="https://img-blog.csdnimg.cn/20190530221614321.png" width="807"> </td> 
 </tr> 
 </tbody> 
</table>

# 测试people输出到jsp页面 #

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> 有pojo实体类，xml核心配置文件，xml映射文件，service，servlet </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> package com.pshdhx.service.impl; import java.io.IOException; import java.io.InputStream; /** &nbsp;* 在数据访问层和控制器中处理异常，在service层中只抛出异常 &nbsp;*/ import java.util.List; &nbsp; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; &nbsp; import com.pshdhx.pojo.People; import com.pshdhx.service.PeopleService; &nbsp; public class PeopleServiceImpl implements PeopleService { &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; @Override &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; public List&lt;People&gt; show() throws IOException { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; InputStream is = Resources.getResourceAsStream("mybatis.xml"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /** &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;* 前面是工厂，实例化工厂对象时使用的是&nbsp; 构建者模式：意义：简化对象实例化的过程,就是is流的转化的过程，省去了configuration和parse过程,不用new工厂了 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;* &nbsp; 有适配器设计模式 adapter &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;*/ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SqlSession session&nbsp; = factory.openSession(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List&lt;People&gt; list = session.selectList("com.pshdhx.mapper.PeopleMapper.selAll"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; session.close(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return list; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp; } </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> &lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;!DOCTYPE mapper &nbsp; PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" &nbsp; "http://mybatis.org/dtd/mybatis-3-mapper.dtd"&gt; &lt;mapper namespace="com.pshdhx.mapper.PeopleMapper"&gt; &nbsp;&nbsp;&nbsp; &lt;select id="selAll" resultType="com.pshdhx.pojo.People"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select * from people &nbsp;&nbsp;&nbsp; &lt;/select&gt; &lt;/mapper&gt; </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> &lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;!DOCTYPE configuration &nbsp; PUBLIC "-//mybatis.org//DTD Config 3.0//EN" &nbsp; "http://mybatis.org/dtd/mybatis-3-config.dtd"&gt; &lt;configuration&gt; &nbsp; &lt;environments default="default"&gt; &nbsp;&nbsp;&nbsp; &lt;environment id="default"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;transactionManager type="JDBC"/&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dataSource type="POOLED"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="driver" value="com.mysql.jdbc.Driver"/&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="url" value="jdbc:mysql:///ssm1"/&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="username" value="root"/&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="password" value="123"/&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/dataSource&gt; &nbsp;&nbsp;&nbsp; &lt;/environment&gt; &nbsp; &lt;/environments&gt; &nbsp; &lt;mappers&gt; &nbsp;&nbsp;&nbsp; &lt;mapper resource="com/pshdhx/mapper/PeopleMapper.xml"/&gt; &nbsp; &lt;/mappers&gt; &lt;/configuration&gt; </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> package com.pshdhx.servlet; &nbsp; import java.io.IOException; import java.util.List; &nbsp; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; &nbsp; import com.pshdhx.pojo.People; import com.pshdhx.service.PeopleService; import com.pshdhx.service.impl.PeopleServiceImpl; &nbsp; @WebServlet("/show") public class ShowServlet extends&nbsp; HttpServlet{ &nbsp;&nbsp;&nbsp; private PeopleService peopleService = new PeopleServiceImpl(); &nbsp;&nbsp;&nbsp; @Override &nbsp;&nbsp;&nbsp; protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // TODO Auto-generated method stub &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List&lt;People&gt; list = peopleService.show(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; req.setAttribute("list", list); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //相对路径 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // /表示项目根目录&nbsp; 即是webcontent目录。 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; req.getRequestDispatcher("index.jsp").forward(req, resp); &nbsp;&nbsp;&nbsp; } } </td> 
 </tr> 
 </tbody> 
</table>

# Log4j #

![20190530221608536.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 4][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 5][]

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> log4j.rootCategory=info, CONSOLE ,LOGFILE &nbsp; log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout log4j.appender.CONSOLE.layout.ConversionPattern=%C %p&nbsp; %m %n &nbsp; log4j.appender.LOGFILE=org.apache.log4j.FileAppender log4j.appender.LOGFILE.File=E:/my.log log4j.appender.LOGFILE.Append=true log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout log4j.appender.LOGFILE.layout.ConversionPattern=%C %m %L %n &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> package com.pshdhx.test; &nbsp; import org.apache.log4j.Logger; &nbsp; public class Test { &nbsp;&nbsp;&nbsp; public static void main(String[] args) { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Logger logger = Logger.getLogger(Test.class); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; logger.debug("这是调试信息"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; logger.info("这是普通信息"); &nbsp;&nbsp;&nbsp; } } &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> 在mybatis中的全部配置文件中使用log4j </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> &lt;configuration&gt; &nbsp;&nbsp;&nbsp; &lt;settings&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;setting name="logImpl" value="LOG4J"/&gt; &nbsp;&nbsp;&nbsp; &lt;/settings&gt; </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> &nbsp; <img alt="" height="137" src="https://img-blog.csdnimg.cn/20190530221614348.png" width="592"> </td> 
 </tr> 
 </tbody> 
</table>

# Mapper.xml中的parameterType属性 #

控制参数类型：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 6][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 7][]

## 找参数：$\{value\} 取值     \#\{index\}这是占位符 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 8][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 9][]

如果希望传递多个参数，那么是map

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 10][]

# 分页： #

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> int pageSize = 2; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int pageNumber = 1; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Map&lt;Object, Object&gt; map = new HashMap&lt;&gt;(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; map.put("pageSize", pageSize); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; map.put("pageStart", pageSize*(pageNumber-1)); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List&lt;People&gt; p = session.selectList("a.b.page",map);//查询id为2的people &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println(p); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; session.close(); </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> <img alt="" height="175" src="https://img-blog.csdnimg.cn/20190530221616283.png" width="819"> </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> &lt;select id="page" resultType="com.pshdhx.pojo.People" parameterType="map"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select * from people limit #{pageStart} , #{pageSize} &nbsp; &nbsp;&nbsp;&nbsp; &lt;!—两个参数都是map里边的key ，value值在java类类中被定义了 --&gt; &nbsp;&nbsp;&nbsp; &lt;/select&gt; </td> 
 </tr> 
 </tbody> 
</table>

# 别名： #

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> &lt;typeAliases&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;package name="com.pshdhx.pojo"/&gt; &nbsp;&nbsp;&nbsp; &lt;/typeAliases&gt; &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> <img alt="" height="362" src="https://img-blog.csdnimg.cn/20190530221619978.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA==,size_16,color_FFFFFF,t_70" width="816"> </td> 
 </tr> 
 </tbody> 
</table>

# 新增和事务讲解： #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 11][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 12][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 13][]

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> &nbsp;&nbsp;&nbsp; People peo = new People(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; peo.setName("pshdhx"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; peo.setAge(23); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int index = session.insert("a.b.ins",peo); &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; session.commit(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(index&gt;0){ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("success"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }else{ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("false"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; session.close(); </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> Roolback放在catch里边 </td> 
 </tr> 
 </tbody> 
</table>

# 测试网页分页： #

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> package com.pshdhx.servlet; &nbsp; import java.io.IOException; &nbsp; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; &nbsp; import com.pshdhx.pojo.PageInfo; import com.pshdhx.service.PeopleService; import com.pshdhx.service.impl.PeopleServiceImpl; @WebServlet("/page") public class ShowPageServlet extends HttpServlet{ &nbsp;&nbsp;&nbsp; private PeopleService peopleService = new PeopleServiceImpl(); &nbsp;&nbsp;&nbsp; @Override &nbsp;&nbsp;&nbsp; protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String pageSizeStr = req.getParameter("pageSize"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int pageSize=2; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(pageSizeStr !=null &amp;&amp;!pageSizeStr.equals("")){ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pageSize = Integer.parseInt(pageSizeStr); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String pageNumberStr =req.getParameter("pageNumber"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int pageNumber=1; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(pageNumberStr!=null&amp;&amp;!pageNumberStr.equals("")){ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pageNumber = Integer.parseInt(pageNumberStr); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PageInfo pi = peopleService.showPage(pageSize, pageNumber); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; req.setAttribute("PageInfo", pi); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; req.getRequestDispatcher("index.jsp").forward(req, resp); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; } } &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> package com.pshdhx.service.impl; &nbsp; import java.io.IOException; import java.io.InputStream; import java.util.HashMap; import java.util.Map; &nbsp; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; &nbsp; import com.pshdhx.pojo.PageInfo; import com.pshdhx.service.PeopleService; &nbsp; public class PeopleServiceImpl implements PeopleService { &nbsp; &nbsp;&nbsp;&nbsp; @Override &nbsp;&nbsp;&nbsp; public PageInfo showPage(int pageSize, int pageNumber) throws IOException { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; InputStream is = Resources.getResourceAsStream("mybatis.xml"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SqlSession session = factory.openSession(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PageInfo pi = new PageInfo(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pi.setPageSize(pageSize); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pi.setPageNumber(pageNumber); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Map&lt;String,Object&gt; map = new HashMap&lt;&gt;(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; map.put("pageStart", pageSize*(pageNumber-1)); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; map.put("pageSize", pageSize); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pi.setList(session.selectList("a.b.selByPage",map)); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; long count = session.selectOne("a.b.selCount"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pi.setTotal(count%pageSize==0?count/pageSize:count/pageSize+1); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return pi; &nbsp;&nbsp;&nbsp; } &nbsp; } </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> &lt;%@ page language="java" contentType="text/html; charset=UTF-8" &nbsp;&nbsp;&nbsp; pageEncoding="UTF-8"%&gt; &nbsp;&nbsp;&nbsp; &lt;%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%&gt; &lt;!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"&gt; &lt;html&gt; &lt;head&gt; &lt;meta http-equiv="Content-Type" content="text/html; charset=UTF-8"&gt; &lt;title&gt;Insert title here&lt;/title&gt; &lt;/head&gt; &lt;body&gt; &nbsp;&nbsp;&nbsp; &lt;table border="1"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;th&gt;编号&lt;/th&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;th&gt;姓名&lt;/th&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;th&gt;年龄&lt;/th&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/tr&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;c:forEach items="${PageInfo.list }" var="pi"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td&gt;${ pi.id}&lt;/td&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td&gt;${ pi.name}&lt;/td&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td&gt;${ pi.age}&lt;/td&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/tr&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/c:forEach&gt; &nbsp;&nbsp;&nbsp; &lt;/table&gt; &nbsp;&nbsp;&nbsp; &lt;a href="page?pageNumber=${PageInfo.pageNumber-1 }&amp;pageSize=${PageInfo.pageSize}" &lt;c:if test="${PageInfo.pageNumber&lt;=1 }"&gt; οnclick="javascript:return false;" &lt;/c:if&gt;&gt;上一页&lt;/a&gt; &nbsp;&nbsp;&nbsp; &lt;a href="page?pageNumber=${PageInfo.pageNumber+1 }&amp;pageSize=${PageInfo.pageSize}" &lt;c:if test="${PageInfo.pageNumber&gt;=PageInfo.total }"&gt; οnclick="javascript:return false;" &lt;/c:if&gt;&gt;下一页&lt;/a&gt; &lt;/body&gt; &lt;/html&gt; </td> 
 </tr> 
 </tbody> 
</table>

# 转账功能： #

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> AccountMapper.xml </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> &lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;!DOCTYPE mapper &nbsp; PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" &nbsp; "http://mybatis.org/dtd/mybatis-3-mapper.dtd"&gt; &lt;mapper namespace="a.b"&gt; &nbsp;&nbsp;&nbsp; &lt;!-- 根据帐号和密码查询账户信息 --&gt; &nbsp;&nbsp;&nbsp; &lt;select id="selByAccnoPwd" resultType="account" parameterType="account"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select * from account where accno=#{accNo} and password=#{password} &nbsp;&nbsp;&nbsp; &lt;/select&gt; &nbsp;&nbsp;&nbsp; &lt;!-- 根据帐号和姓名查询账户信息 --&gt; &nbsp;&nbsp;&nbsp; &lt;select id="selByAccnoName" resultType="account" parameterType="account"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select * from account where accno=#{accNo} and name=#{name} &nbsp;&nbsp;&nbsp; &lt;/select&gt; &nbsp;&nbsp;&nbsp; &lt;!-- 根据accNo修改账户余额 --&gt; &nbsp;&nbsp;&nbsp; &lt;update id="updBalanceByAccno" parameterType="account"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; update account set balance=balance+#{balance} where accno=#{accNo} &nbsp;&nbsp;&nbsp; &lt;/update&gt; &lt;/mapper&gt; </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> loggerMapper.xml </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> &lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;!DOCTYPE mapper &nbsp; PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" &nbsp; "http://mybatis.org/dtd/mybatis-3-mapper.dtd"&gt; &lt;mapper namespace="a.Log"&gt; &nbsp;&nbsp;&nbsp; &lt;insert id="insLog" parameterType="log"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; insert into log values(default,#{accOut},#{accIn},#{money}) &nbsp;&nbsp;&nbsp; &lt;/insert&gt; &nbsp;&nbsp;&nbsp; &lt;select id="selByPage" resultType="log" parameterType="map"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select * from log limit #{pageStart},#{pageSize} &nbsp;&nbsp;&nbsp; &lt;/select&gt; &nbsp;&nbsp;&nbsp; &lt;select id="selCount" resultType="long"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select count(*) from log &nbsp;&nbsp;&nbsp; &lt;/select&gt; &lt;/mapper&gt; </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> Accountserviceimpl.java </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> public int transfer(Account accIn, Account accOut) throws IOException { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; InputStream is = Resources.getResourceAsStream("mybatis.xml"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SqlSession session = factory.openSession();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //先判断帐号和密码是否匹配 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account accOutSelect = session.selectOne("a.b.selByAccnoPwd",accOut); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(accOutSelect!=null){ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(accOutSelect.getBalance()&gt;=accOut.getBalance()){ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account accInSelect&nbsp; = session.selectOne("a.b.selByAccnoName",accIn); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(accInSelect!=null){ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; accIn.setBalance(accOut.getBalance()); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; accOut.setBalance(-accOut.getBalance()); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int index = session.update("a.b.updBalanceByAccno",accOut); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; index += session.update("a.b.updBalanceByAccno",accIn); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(index==2){ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //日志表记录 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Log log&nbsp; = new Log(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; log.setAccIn(accIn.getAccNo()); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; log.setAccOut(accOut.getAccNo()); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; log.setMoney(accIn.getBalance()); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; session.insert("a.Log.insLog",log); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //日志文件记录 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Logger logger = Logger.getLogger(AccountServiceImpl.class); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; logger.info(log.getAccOut()+"给"+log.getAccIn()+"在"+new Date().toLocaleString()+"转了"+log.getMoney()); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; session.commit(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; session.close(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return SUCCESS; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }else{ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; session.rollback(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; session.close(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return ERROR; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }else{ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return ACCOUNT_NAME_NOT_MATCH; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }else{ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //余额不足 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; return ACCOUNT_BALANCE_NOT_ENOUGH; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }else{ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //帐号和密码不匹配 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return ACCOUNT_PASSWORD_NOT_MATCH; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp; } </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> Logserviceimpl.java &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> package com.pshdhx.service.impl; /** &nbsp;* 这是后台的分页逻辑 &nbsp;*/ import java.io.IOException; import java.io.InputStream; import java.util.HashMap; import java.util.List; import java.util.Map; &nbsp; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; &nbsp; import com.pshdhx.pojo.Log; import com.pshdhx.pojo.PageInfo; import com.pshdhx.service.LogService; &nbsp; public class LogServiceImpl implements LogService{ &nbsp; &nbsp;&nbsp;&nbsp; @Override &nbsp;&nbsp;&nbsp; public PageInfo showPage(int pageSize, int pageNumber) throws IOException { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; InputStream is = Resources.getResourceAsStream("mybatis.xml"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SqlSession session = factory.openSession(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Map&lt;String,Object&gt; map = new HashMap&lt;&gt;(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; map.put("pageStart", pageSize*(pageNumber-1)); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; map.put("pageSize", pageSize); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List&lt;Log&gt; list = session.selectList("a.Log.selByPage",map); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; long count&nbsp; = session.selectOne("a.Log.selCount"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PageInfo pi = new PageInfo(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pi.setList(list); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pi.setPageNumber(pageNumber); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pi.setPageSize(pageSize); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pi.setTotal(count%pageSize==0?count/pageSize:count/pageSize+1); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return pi; &nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp; } </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> ShowlogServlet.java </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> package com.pshdhx.servlet; /** &nbsp;* 此界面是对后台数据的显示，是后台对数据的响应操作，把数据表中的数据传递到前台，不需要name值，只要core，foreach即可 &nbsp;*/ import java.io.IOException; &nbsp; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; &nbsp; import com.pshdhx.service.LogService; import com.pshdhx.service.impl.LogServiceImpl; @WebServlet("/show") public class ShowServlet extends HttpServlet{ &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; private LogService logService = new LogServiceImpl(); &nbsp;&nbsp;&nbsp; @Override &nbsp;&nbsp;&nbsp; protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // TODO Auto-generated method stub &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int pageSize = 2; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String pageSizeStr = req.getParameter("pageSize"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(pageSizeStr!=null&amp;&amp;!pageSizeStr.equals("")){ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pageSize =Integer.parseInt(pageSizeStr); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int pageNumber = 1; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String pageNumberStr = req.getParameter("pageNumber"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(pageNumberStr!=null&amp;&amp;!pageNumberStr.equals("")){ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pageNumber = Integer.parseInt(pageNumberStr); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //以上都是为了pageSize和pageNumber做准备，调用了serviceimpl的方法。 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; req.setAttribute("pageinfo", logService.showPage(pageSize, pageNumber)); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; req.getRequestDispatcher("/log.jsp").forward(req, resp); &nbsp;&nbsp;&nbsp; } } </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> transferServlet.java </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> package com.pshdhx.servlet; /** &nbsp;* 此界面是前台写数据，后台改变数据，是前台对后台的修改操作。对应的index.jsp中的form表单中都有name的属性值，方便操作。 &nbsp;*/ import java.io.IOException; &nbsp; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; &nbsp; import com.pshdhx.pojo.Account; import com.pshdhx.service.AccountService; import com.pshdhx.service.impl.AccountServiceImpl; @WebServlet("/transfer") public class TransferServlet extends HttpServlet{ &nbsp;&nbsp;&nbsp; private AccountService accountService = new AccountServiceImpl(); &nbsp;&nbsp;&nbsp; @Override &nbsp;&nbsp;&nbsp; protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // TODO Auto-generated method stub &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; req.setCharacterEncoding("utf-8"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account accOut&nbsp; = new Account(); &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; accOut.setAccNo(req.getParameter("accOutAccNo")); &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; accOut.setPassword(Integer.parseInt(req.getParameter("accOutPassword"))); &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; accOut.setBalance(Double.parseDouble(req.getParameter("accOutBalance"))); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account accIn = new Account(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; accIn.setAccNo(req.getParameter("accInAccNo")); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; accIn.setName(req.getParameter("accInName")); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //以上一切都是为了调用serviceimpl中的方法的参数做准备。此为方法的返回值，根据返回值判断执行的状态 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int index = accountService.transfer(accIn, accOut); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //转账成功之后，服务器端会给出响应，跳转到 show界面&nbsp; 所以是 response &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(index==AccountService.SUCCESS){ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("转账成功"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //resp.sendRedirect(req.getContextPath()+"/log.jsp"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; resp.sendRedirect(req.getContextPath()+"/show"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }else{ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HttpSession session = req.getSession(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; session.setAttribute("code", index); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; resp.sendRedirect("/bank/error/error.jsp"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("转账失败"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp; } } </td> 
 </tr> 
 </tbody> 
</table>

# getMapper接口绑定方案和多参数传递 #

![20190530221619992.png][]

![20190530221617438.png][]

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> public interface LogMapper { &nbsp;&nbsp;&nbsp; List&lt;Log&gt; selAll() throws IOException; &nbsp;&nbsp;&nbsp; List&lt;Log&gt; selByAccInAccOut(String accIn,String accOut) throws IOException; } </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> &lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;!DOCTYPE mapper &nbsp; PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" &nbsp; "http://mybatis.org/dtd/mybatis-3-mapper.dtd"&gt; &lt;mapper namespace="com.pshdhx.mapper.LogMapper"&gt; &nbsp;&nbsp;&nbsp; &lt;select id="selAll" resultType="Log"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select * from log &nbsp;&nbsp;&nbsp; &lt;/select&gt; &nbsp;&nbsp;&nbsp; &lt;select id="selByAccInAccOut" resultType="Log" &gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select * from log where accin=#{param1} and accout=#{param2} &nbsp;&nbsp;&nbsp; &lt;/select&gt; &lt;/mapper&gt; </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:426.1pt;"> package com.pshdhx.test; &nbsp; import java.io.IOException; import java.io.InputStream; import java.util.List; &nbsp; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; &nbsp; import com.pshdhx.mapper.LogMapper; import com.pshdhx.pojo.Log; &nbsp; public class Test { &nbsp;&nbsp;&nbsp; public static void main(String[] args) throws IOException{ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; InputStream is = Resources.getResourceAsStream("mybatis.xml"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SqlSession session = factory.openSession(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //实例化接口，初始化session.getMapper(接口); proxy代理模式 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /** &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;* 接口为什么实例化 ？ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;* 需要给接口一个实例化对象 proxy&nbsp; jdk的动态代理模式，面向接口（必须有接口） &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;* mybatis的好处：每次都要写session.selectList(里边的参数不用写了，更重要的是避免了多参数的问题转为map); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;*/ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LogMapper logMapper = session.getMapper(LogMapper.class); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List&lt;Log&gt; list = logMapper.selAll(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for(Log log:list){ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println(log); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("--------------------------------------------"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List&lt;Log&gt; list2 = logMapper.selByAccInAccOut("1", "3"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for(Log log:list2){ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println(log); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; session.close(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("程序执行结束"); &nbsp;&nbsp;&nbsp; } } </td> 
 </tr> 
 </tbody> 
</table>

# 动态sql #

根据不同的条件需要执行不同的sql命令

在xml中添加逻辑判断

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 14][]

## Where：去掉最前边的and，加where关键字 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 15][]

![20190530221618691.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 16][]

## Set：去掉最后边的逗号，加set关键字 ##

![20190530221618895.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 17][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 18][]

## Trim：去掉前边的和后边的东西 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 19][]

## Bind:模糊查询，拼接字符串 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 20][]

![20190530221621482.png][]

![20190530221621284.png][]

# threadLocal #

![20190530221621284.png][]

# 缓存： #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 21][]

缓存的是statement对象，尽管sql语句一样，但是执行两次sql语句。

![20190530221621286.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 22][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 23][]

# Mybatis注解： #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 24][]

# 运行原理： #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 25][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 26][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 27][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 28][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70]: /images/20220125/1d0db58cd257465988b71dbc0139fa66.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 1]: /images/20220125/556d8e2d18ad41fc9ab4fea207672c10.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 2]: /images/20220125/67297eafdf1e426193881d5f51603109.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 3]: /images/20220125/dc6f552115f847be8b86cad4a7fa42cd.png
[20190530221608536.png]: /images/20220125/0fd0b555371146628f843ca673ecfa20.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 4]: /images/20220125/60b3026450e34af2afe218ac7df9c6cf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 5]: /images/20220125/aef04e9f01a644c7bbbd75fbf3ba5461.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 6]: /images/20220125/76d2c5a3c8be4db5bcc07106075ba907.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 7]: /images/20220125/77fc4d990193427182eb826b313adc09.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 8]: /images/20220125/f3e1d0fce96c44f3ae67c8628d3a1663.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 9]: /images/20220125/8b3c0b6c280b400784246ec5b404c748.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 10]: /images/20220125/5c786b790f264dfa8655a59eabf2ccd5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 11]: /images/20220125/73ee4238a86d4d0bb97eca8181008d5b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 12]: /images/20220125/6a087aa916724eea9be7e80c3c389a1f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 13]: /images/20220125/c7f9f930c40247e99b54367717991221.png
[20190530221619992.png]: /images/20220125/583aff2e5c094bcd84b73337a3bad5a6.png
[20190530221617438.png]: /images/20220125/f0a06da02659472ebf416ac946bb6da0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 14]: /images/20220125/306ab0fdf42c4f508d070bc3150fd7ae.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 15]: /images/20220125/ac4bce8a543b4ab2936eb7772d7b80a2.png
[20190530221618691.png]: /images/20220125/45546326f7fa49b5b4f84cf4a11b0ddc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 16]: /images/20220125/3a2465b4e2b447ce99044ca6a041d6b4.png
[20190530221618895.png]: /images/20220125/4531ef10e3b646cba857ea4988825265.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 17]: /images/20220125/5496298ca6bc435580a8136367a088a3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 18]: /images/20220125/09dc94e8e2bc4e1b9a3d0ea95f0eaf4f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 19]: /images/20220125/6733ebaf5c9e41bfa553ec2892335ee4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 20]: /images/20220125/28973e2811574ccc9909cf29aaa8fa32.png
[20190530221621482.png]: /images/20220125/e297ae436a734de18be815b66a867b67.png
[20190530221621284.png]: /images/20220125/a23b4535221d46608cb86cc58f7d968b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 21]: /images/20220125/8e752a61f40640a6bb512f28a2d7c934.png
[20190530221621286.png]: /images/20220125/edd9433f893c43afb7ee4f5d03936492.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 22]: /images/20220125/63b1564985a3490d9d2aa8a575d9b4ab.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 23]: /images/20220125/ef67a2928cf048efb3eb0d4a36027a3c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 24]: /images/20220125/e18a3c495d1941aeb0e123a20817ab0e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 25]: /images/20220125/8e0467db7f60423381f9b7910782f463.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 26]: /images/20220125/2ad2969508084abd8bf73a59916b6c74.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 27]: /images/20220125/0c32520972ad45bf8ee518d50b7a7bd4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3BzaGRoeA_size_16_color_FFFFFF_t_70 28]: /images/20220125/c9307dd8f87643c184bd6c9595e2c830.png