mybatis笔记整理

最新推荐文章于 2024-07-27 19:04:04 发布

pshdhx_albert

最新推荐文章于 2024-07-27 19:04:04 发布

阅读量7.7k

点赞数

分类专栏： # JavaWeb

本文链接：https://blog.csdn.net/pshdhx/article/details/90707316

版权

JavaWeb 专栏收录该内容

26 篇文章 1 订阅

订阅专栏

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

2、xml核心配置文件详解

3、数据库连接池

4、编码问题

三种查询方式

log4j

mapper.xml中的parameterType属性

分页

别名

新增和事务讲解

测试网页分页

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

动态sql

threadlocal

缓存

mybatis注解

运行原理

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

Mybatis.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration

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

"http://mybatis.org/dtd/mybatis-3-config.dtd">

</dataSource>

</environment>

</environments>

</mappers>

</configuration>

Mapper.xml

<?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">

select * from flower

</select>

</mapper>

Test.java

package com.pshdhx.test;

import java.io.IOException;

import java.io.InputStream;

import java.util.List;

import org.apache.ibatis.io.Resources;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.pshdhx.pojo.Flower;

public class Test {

public static void main(String[] args) throws IOException{

InputStream is = Resources.getResourceAsStream("mybatis.xml");

SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);

SqlSession session = factory.openSession();

List<Flower> list = session.selectList("a.b.selAll");

for(Flower flower:list){

System.out.println(flower.toString());

}

session.close();

}

2、Xml核心配置文件详解

3、数据库连接池：

4、编码问题

res.setContentType("text/html;charset=utf-8");

记住：是request，是text形式请求

三种查询方式：

Session.selectList()

Session.selectOne()

Session.selectMap()

测试people输出到jsp页面

有pojo实体类，xml核心配置文件，xml映射文件，service，servlet

package com.pshdhx.service.impl;

import java.io.IOException;

import java.io.InputStream;

/**

* 在数据访问层和控制器中处理异常，在service层中只抛出异常

import java.util.List;

import org.apache.ibatis.io.Resources;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.pshdhx.pojo.People;

import com.pshdhx.service.PeopleService;

public class PeopleServiceImpl implements PeopleService {

@Override

public List<People> show() throws IOException {

InputStream is = Resources.getResourceAsStream("mybatis.xml");

/**

* 前面是工厂，实例化工厂对象时使用的是构建者模式：意义：简化对象实例化的过程,就是is流的转化的过程，省去了configuration和parse过程,不用new工厂了

* 有适配器设计模式 adapter

SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);

SqlSession session = factory.openSession();

List<People> list = session.selectList("com.pshdhx.mapper.PeopleMapper.selAll");

session.close();

return list;

}

<?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">

select * from people

</select>

</mapper>

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration

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

"http://mybatis.org/dtd/mybatis-3-config.dtd">

</dataSource>

</environment>

</environments>

</mappers>

</configuration>

package com.pshdhx.servlet;

import java.io.IOException;

import java.util.List;

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 com.pshdhx.pojo.People;

import com.pshdhx.service.PeopleService;

import com.pshdhx.service.impl.PeopleServiceImpl;

@WebServlet("/show")

public class ShowServlet extends HttpServlet{

private PeopleService peopleService = new PeopleServiceImpl();

@Override

protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

// TODO Auto-generated method stub

List<People> list = peopleService.show();

req.setAttribute("list", list);

//相对路径

// /表示项目根目录即是webcontent目录。

req.getRequestDispatcher("index.jsp").forward(req, resp);

}

Log4j

log4j.rootCategory=info, CONSOLE ,LOGFILE

log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender

log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout

log4j.appender.CONSOLE.layout.ConversionPattern=%C %p %m %n

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

package com.pshdhx.test;

import org.apache.log4j.Logger;

public class Test {

public static void main(String[] args) {

Logger logger = Logger.getLogger(Test.class);

logger.debug("这是调试信息");

logger.info("这是普通信息");

}

在mybatis中的全部配置文件中使用log4j

</settings>

Mapper.xml中的parameterType属性

控制参数类型：

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

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

分页：

int pageSize = 2;

int pageNumber = 1;

Map<Object, Object> map = new HashMap<>();

map.put("pageSize", pageSize);

map.put("pageStart", pageSize*(pageNumber-1));

List<People> p = session.selectList("a.b.page",map);//查询id为2的people

System.out.println(p);

session.close();

select * from people limit #{pageStart} , #{pageSize} <!—两个参数都是map里边的key ，value值在java类类中被定义了 -->

</select>

别名：

</typeAliases>

新增和事务讲解：

People peo = new People();

peo.setName("pshdhx");

peo.setAge(23);

int index = session.insert("a.b.ins",peo);

session.commit();

if(index>0){

System.out.println("success");

}else{

System.out.println("false");

}

session.close();

Roolback放在catch里边

测试网页分页：

package com.pshdhx.servlet;

import java.io.IOException;

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 com.pshdhx.pojo.PageInfo;

import com.pshdhx.service.PeopleService;

import com.pshdhx.service.impl.PeopleServiceImpl;

@WebServlet("/page")

public class ShowPageServlet extends HttpServlet{

private PeopleService peopleService = new PeopleServiceImpl();

@Override

protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

String pageSizeStr = req.getParameter("pageSize");

int pageSize=2;

if(pageSizeStr !=null &&!pageSizeStr.equals("")){

pageSize = Integer.parseInt(pageSizeStr);

}

String pageNumberStr =req.getParameter("pageNumber");

int pageNumber=1;

if(pageNumberStr!=null&&!pageNumberStr.equals("")){

pageNumber = Integer.parseInt(pageNumberStr);

}

PageInfo pi = peopleService.showPage(pageSize, pageNumber);

req.setAttribute("PageInfo", pi);

req.getRequestDispatcher("index.jsp").forward(req, resp);

}

package com.pshdhx.service.impl;

import java.io.IOException;

import java.io.InputStream;

import java.util.HashMap;

import java.util.Map;

import org.apache.ibatis.io.Resources;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.pshdhx.pojo.PageInfo;

import com.pshdhx.service.PeopleService;

public class PeopleServiceImpl implements PeopleService {

@Override

public PageInfo showPage(int pageSize, int pageNumber) throws IOException {

InputStream is = Resources.getResourceAsStream("mybatis.xml");

SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);

SqlSession session = factory.openSession();

PageInfo pi = new PageInfo();

pi.setPageSize(pageSize);

pi.setPageNumber(pageNumber);

Map<String,Object> map = new HashMap<>();

map.put("pageStart", pageSize*(pageNumber-1));

map.put("pageSize", pageSize);

pi.setList(session.selectList("a.b.selByPage",map));

long count = session.selectOne("a.b.selCount");

pi.setTotal(count%pageSize==0?count/pageSize:count/pageSize+1);

return pi;

}

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Insert title here</title>

</head>

<body>

<tr>

</tr>

<c:forEach items="${PageInfo.list }" var="pi">

<tr>

</tr>

</c:forEach>

</table>

<a href="page?pageNumber=${PageInfo.pageNumber-1 }&pageSize=${PageInfo.pageSize}" <c:if test="${PageInfo.pageNumber<=1 }"> οnclick="javascript:return false;" </c:if>>上一页</a>

<a href="page?pageNumber=${PageInfo.pageNumber+1 }&pageSize=${PageInfo.pageSize}" <c:if test="${PageInfo.pageNumber>=PageInfo.total }"> οnclick="javascript:return false;" </c:if>>下一页</a>

</body>

</html>

转账功能：

AccountMapper.xml

<?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">

select * from account where accno=#{accNo} and password=#{password}

</select>

select * from account where accno=#{accNo} and name=#{name}

</select>

update account set balance=balance+#{balance} where accno=#{accNo}

</update>

</mapper>

loggerMapper.xml

<?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">

insert into log values(default,#{accOut},#{accIn},#{money})

</insert>

select * from log limit #{pageStart},#{pageSize}

</select>

select count(*) from log

</select>

</mapper>

Accountserviceimpl.java

public int transfer(Account accIn, Account accOut) throws IOException {

InputStream is = Resources.getResourceAsStream("mybatis.xml");

SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);

SqlSession session = factory.openSession();

//先判断帐号和密码是否匹配

Account accOutSelect = session.selectOne("a.b.selByAccnoPwd",accOut);

if(accOutSelect!=null){

if(accOutSelect.getBalance()>=accOut.getBalance()){

Account accInSelect = session.selectOne("a.b.selByAccnoName",accIn);

if(accInSelect!=null){

accIn.setBalance(accOut.getBalance());

accOut.setBalance(-accOut.getBalance());

int index = session.update("a.b.updBalanceByAccno",accOut);

index += session.update("a.b.updBalanceByAccno",accIn);

if(index==2){

//日志表记录

Log log = new Log();

log.setAccIn(accIn.getAccNo());

log.setAccOut(accOut.getAccNo());

log.setMoney(accIn.getBalance());

session.insert("a.Log.insLog",log);

//日志文件记录

Logger logger = Logger.getLogger(AccountServiceImpl.class);

logger.info(log.getAccOut()+"给"+log.getAccIn()+"在"+new Date().~~toLocaleString~~()+"转了"+log.getMoney());

session.commit();

session.close();

return SUCCESS;

}else{

session.rollback();

session.close();

return ERROR;

}

}else{

return ACCOUNT_NAME_NOT_MATCH;

}

}else{

//余额不足

return ACCOUNT_BALANCE_NOT_ENOUGH;

}

}else{

//帐号和密码不匹配

return ACCOUNT_PASSWORD_NOT_MATCH;

}

Logserviceimpl.java

package com.pshdhx.service.impl;

/**

* 这是后台的分页逻辑

import java.io.IOException;

import java.io.InputStream;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import org.apache.ibatis.io.Resources;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.pshdhx.pojo.Log;

import com.pshdhx.pojo.PageInfo;

import com.pshdhx.service.LogService;

public class LogServiceImpl implements LogService{

@Override

public PageInfo showPage(int pageSize, int pageNumber) throws IOException {

InputStream is = Resources.getResourceAsStream("mybatis.xml");

SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);

SqlSession session = factory.openSession();

Map<String,Object> map = new HashMap<>();

map.put("pageStart", pageSize*(pageNumber-1));

map.put("pageSize", pageSize);

List<Log> list = session.selectList("a.Log.selByPage",map);

long count = session.selectOne("a.Log.selCount");

PageInfo pi = new PageInfo();

pi.setList(list);

pi.setPageNumber(pageNumber);

pi.setPageSize(pageSize);

pi.setTotal(count%pageSize==0?count/pageSize:count/pageSize+1);

return pi;

}

ShowlogServlet.java

package com.pshdhx.servlet;

/**

* 此界面是对后台数据的显示，是后台对数据的响应操作，把数据表中的数据传递到前台，不需要name值，只要core，foreach即可

import java.io.IOException;

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 com.pshdhx.service.LogService;

import com.pshdhx.service.impl.LogServiceImpl;

@WebServlet("/show")

public class ShowServlet extends HttpServlet{

private LogService logService = new LogServiceImpl();

@Override

protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

// TODO Auto-generated method stub

int pageSize = 2;

String pageSizeStr = req.getParameter("pageSize");

if(pageSizeStr!=null&&!pageSizeStr.equals("")){

pageSize =Integer.parseInt(pageSizeStr);

}

int pageNumber = 1;

String pageNumberStr = req.getParameter("pageNumber");

if(pageNumberStr!=null&&!pageNumberStr.equals("")){

pageNumber = Integer.parseInt(pageNumberStr);

}

//以上都是为了pageSize和pageNumber做准备，调用了serviceimpl的方法。

req.setAttribute("pageinfo", logService.showPage(pageSize, pageNumber));

req.getRequestDispatcher("/log.jsp").forward(req, resp);

}

transferServlet.java

package com.pshdhx.servlet;

/**

* 此界面是前台写数据，后台改变数据，是前台对后台的修改操作。对应的index.jsp中的form表单中都有name的属性值，方便操作。

import java.io.IOException;

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;

import com.pshdhx.pojo.Account;

import com.pshdhx.service.AccountService;

import com.pshdhx.service.impl.AccountServiceImpl;

@WebServlet("/transfer")

public class TransferServlet extends HttpServlet{

private AccountService accountService = new AccountServiceImpl();

@Override

protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

// TODO Auto-generated method stub

req.setCharacterEncoding("utf-8");

Account accOut = new Account();

accOut.setAccNo(req.getParameter("accOutAccNo"));

accOut.setPassword(Integer.parseInt(req.getParameter("accOutPassword")));

accOut.setBalance(Double.parseDouble(req.getParameter("accOutBalance")));

Account accIn = new Account();

accIn.setAccNo(req.getParameter("accInAccNo"));

accIn.setName(req.getParameter("accInName"));

//以上一切都是为了调用serviceimpl中的方法的参数做准备。此为方法的返回值，根据返回值判断执行的状态

int index = accountService.transfer(accIn, accOut);

//转账成功之后，服务器端会给出响应，跳转到 show界面 所以是 response

if(index==AccountService.SUCCESS){

System.out.println("转账成功");

//resp.sendRedirect(req.getContextPath()+"/log.jsp");

resp.sendRedirect(req.getContextPath()+"/show");

}else{

HttpSession session = req.getSession();

session.setAttribute("code", index);

resp.sendRedirect("/bank/error/error.jsp");

System.out.println("转账失败");

}

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

public interface LogMapper {

List<Log> selAll() throws IOException;

List<Log> selByAccInAccOut(String accIn,String accOut) throws IOException;

}

<?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">

select * from log

</select>

select * from log where accin=#{param1} and accout=#{param2}

</select>

</mapper>

package com.pshdhx.test;

import java.io.IOException;

import java.io.InputStream;

import java.util.List;

import org.apache.ibatis.io.Resources;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.pshdhx.mapper.LogMapper;

import com.pshdhx.pojo.Log;

public class Test {

public static void main(String[] args) throws IOException{

InputStream is = Resources.getResourceAsStream("mybatis.xml");

SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);

SqlSession session = factory.openSession();

//实例化接口，初始化session.getMapper(接口); proxy代理模式

/**

* 接口为什么实例化？

* 需要给接口一个实例化对象 proxy jdk的动态代理模式，面向接口（必须有接口）

* mybatis的好处：每次都要写session.selectList(里边的参数不用写了，更重要的是避免了多参数的问题转为map);

LogMapper logMapper = session.getMapper(LogMapper.class);

List<Log> list = logMapper.selAll();

for(Log log:list){

System.out.println(log);

}

System.out.println("--------------------------------------------");

List<Log> list2 = logMapper.selByAccInAccOut("1", "3");

for(Log log:list2){

System.out.println(log);

}

session.close();

System.out.println("程序执行结束");

}

动态sql

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

在xml中添加逻辑判断

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

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

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

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

threadLocal

缓存：

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

Mybatis注解：

运行原理：

pshdhx_albert

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

专栏目录