Last Modified 2022.9.28
Simple Spring MyBatis Example
C:\Users\john>sqlplus SQL*Plus: Release 11.2.0.2.0 Production on Sun SEP 25 11:53:25 2022 Copyright (c) 1982, 2011, Oracle. All rights reserved. Enter user-name: scott Enter password: Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production SQL>
create table music ( no number, content varchar2(4000), constraint PK_MTV PRIMARY KEY(no) ); create sequence SEQ_MUSIC increment by 1 start with 1;
mybatismusic
├── pom.xml
├── src
│ └── main
│ ├── java
│ │ └── net
│ │ └── java_school
│ │ ├── mybatis
│ │ │ └── MusicVideoMapper.java
│ │ └── mybatismusic
│ │ ├── HomeController.java
│ │ ├── MusicVideo.java
│ │ ├── MusicVideoService.java
│ │ └── MusicVideoServiceImpl.java
│ ├── resources
│ │ ├── commons-logging.properties
│ │ ├── log4j2.xml
│ │ └── net
│ │ └── java_school
│ │ └── mybatis
│ │ ├── Configuration.xml
│ │ └── MusicVideoMapper.xml
│ └── webapp
│ ├── WEB-INF
│ │ ├── applicationContext.xml
│ │ ├── mybatismusic-servlet.xml
│ │ ├── views
│ │ │ └── index.jsp
│ │ └── web.xml
│ └── resources
│ └── js
│ └── jquery-3.6.1.min.js
pom.xml
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>net.java_school</groupId> <artifactId>mybatismusic</artifactId> <version>1.0-SNAPSHOT</version> <packaging>war</packaging> <name>mybatismusic Maven Webapp</name> <url>http://localhost:8080/mybatismusic</url> <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <jdk.version>11</jdk.version> <spring.version>5.3.33</spring.version> </properties> <dependencies> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.11</version> <scope>test</scope> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>javax.servlet-api</artifactId> <version>4.0.1</version> <scope>provided</scope> </dependency> <dependency> <groupId>jstl</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc6</artifactId> <version>11.2.0.2.0</version> </dependency> <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>2.0.7</version> </dependency> <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.10</version> </dependency> <!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp --> <dependency> <groupId>commons-dbcp</groupId> <artifactId>commons-dbcp</artifactId> <version>1.4</version> </dependency> <!-- https://mvnrepository.com/artifact/org.apache.logging.log4j/log4j-api --> <dependency> <groupId>org.apache.logging.log4j</groupId> <artifactId>log4j-api</artifactId> <version>2.18.0</version> </dependency> <!-- https://mvnrepository.com/artifact/org.apache.logging.log4j/log4j-core --> <dependency> <groupId>org.apache.logging.log4j</groupId> <artifactId>log4j-core</artifactId> <version>2.18.0</version> </dependency> <!-- https://mvnrepository.com/artifact/org.apache.logging.log4j/log4j-jcl --> <dependency> <groupId>org.apache.logging.log4j</groupId> <artifactId>log4j-jcl</artifactId> <version>2.18.0</version> </dependency> </dependencies> <build> <finalName>mybatismusic</finalName> <pluginManagement> <plugins> <plugin> <artifactId>maven-compiler-plugin</artifactId> <version>3.10.1</version> <configuration> <source>${jdk.version}</source> <target>${jdk.version}</target> <compilerArgument></compilerArgument> <encoding>UTF-8</encoding> </configuration> </plugin> <plugin> <artifactId>maven-clean-plugin</artifactId> <version>3.2.0</version> <configuration> <filesets> <fileset> <directory>src/main/webapp/WEB-INF/classes</directory> </fileset> <fileset> <directory>src/main/webapp/WEB-INF/lib</directory> </fileset> </filesets> </configuration> </plugin> </plugins> </pluginManagement> </build> </project>
src/main/resources
commons-logging.properties
org.apache.commons.logging.Log = org.apache.commons.logging.impl.Log4JLogger
log4j2.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE configuration> <Configuration> <Appenders> <File name="MyBatisMusic" fileName="/var/log/tomcat9/MyBatisMusic.log" append="false"> <PatternLayout pattern="%t %-5p %c{2} - %m%n" /> </File> <Console name="STDOUT" target="SYSTEM_OUT"> <PatternLayout pattern="%d %-5p [%t] %C{2} (%F:%L) - %m%n" /> </Console> </Appenders> <Loggers> <Logger name="net.java_school" level="DEBUG"> <AppenderRef ref="MyBatisMusic" /> </Logger> <Root level="INFO"> <AppenderRef ref="STDOUT" /> </Root> </Loggers> </Configuration>
src/main/resources/net/java_school/mybatis
Configuration.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"> <configuration> <settings> <setting name="logImpl" value="LOG4J2"/> </settings> <typeAliases> <typeAlias type="net.java_school.mybatismusic.MusicVideo" alias="MusicVideo" /> </typeAliases> </configuration>
MusicVideoMapper.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"> <mapper namespace="net.java_school.mybatis.MusicVideoMapper"> <select id="selectCountOfVideos" resultType="int"> SELECT count(*) FROM music </select> <select id="selectVideos" parameterType="hashmap" resultType="MusicVideo"> SELECT content FROM ( SELECT rownum R,A.* FROM ( SELECT content FROM music ORDER BY no DESC ) A ) WHERE R BETWEEN #{start} AND #{end} </select> <insert id="insert"> insert into music values (seq_music.nextval, #{content}) </insert> </mapper>
src/main/java/net/java_school/mybatis
MusicVideoMapper.java
package net.java_school.mybatis; import java.util.HashMap; import java.util.List; import net.java_school.mybatismusic.MusicVideo; import org.apache.ibatis.annotations.Param; public interface MusicVideoMapper { public int selectCountOfVideos(); public List<MusicVideo> selectVideos(HashMap<String, String> hashmap); public void insert(@Param("content") String content); }
src/main/java/net/java_school/mybatismusic
MusicVideo.java
package net.java_school.mybatismusic; public class MusicVideo { private int no; private String content; public MusicVideo() {} public MusicVideo(int no, String content) { this.no = no; this.content = content; } public int getNo() { return no; } public void setNo(int no) { this.no = no; } public String getContent() { return content; } public void setContent(String content) { this.content = content; } }
MusicVideoService.java
package net.java_school.mybatismusic; import java.util.List; public interface MusicVideoService { public int getTotalRecords(); public List<MusicVideo> getVideos(Integer startRecord, Integer endRecord); public void add(String content); }
MusicVideoServiceImpl.java
package net.java_school.mybatismusic; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; import java.util.HashMap; import net.java_school.mybatis.MusicVideoMapper; @Service public class MusicVideoServiceImpl implements MusicVideoService { @Autowired private MusicVideoMapper musicVideoMapper; @Override public int getTotalRecords() { return musicVideoMapper.selectCountOfVideos(); } @Override public List<MusicVideo> getVideos(Integer startRecord, Integer endRecord) { HashMap<String, String> hashmap = new HashMap<String, String>(); hashmap.put("start", startRecord.toString()); hashmap.put("end", endRecord.toString()); return musicVideoMapper.selectVideos(hashmap); } @Override public void add(String content) { musicVideoMapper.insert(content); } }
HomeController.java
package net.java_school.mybatismusic; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.ResponseBody; import java.util.List; import java.util.Map; import java.util.HashMap; @Controller public class HomeController { @Autowired private MusicVideoService musicVideoService; private Map<String, Integer> getNumbersForPaging(int totalRecord, int page, int numPerPage, int pagePerBlock) { Map<String, Integer> map = new HashMap<String, Integer>(); int totalPage = totalRecord / numPerPage; if (totalRecord % numPerPage != 0) totalPage++; int totalBlock = totalPage / pagePerBlock; if (totalPage % pagePerBlock != 0) totalBlock++; int block = page / pagePerBlock; if (page % pagePerBlock != 0) block++; int firstPage = (block - 1) * pagePerBlock + 1; int lastPage = block * pagePerBlock; int prevPage = 0; if (block > 1) prevPage = firstPage - 1; int nextPage = 0; if (block < totalBlock) nextPage = lastPage + 1; if (block >= totalBlock) lastPage = totalPage; int listItemNo = totalRecord - (page - 1) * numPerPage; int startRecord = (page - 1) * numPerPage + 1; int endRecord = page * numPerPage; map.put("totalPage", totalPage); map.put("firstPage", firstPage); map.put("lastPage", lastPage); map.put("prevPage", prevPage); map.put("nextPage", nextPage); map.put("startRecord", startRecord); map.put("endRecord", endRecord); return map; } @GetMapping("/") public String index(Integer page, Model model) { if (page == null) return "redirect:/?page=1"; int numPerPage = 4; int pagePerBlock = 50; int totalRecord = musicVideoService.getTotalRecords(); Map<String, Integer> map = getNumbersForPaging(totalRecord, page, numPerPage, pagePerBlock); Integer startRecord = map.get("startRecord"); Integer endRecord = map.get("endRecord"); List<MusicVideo> list = musicVideoService.getVideos(startRecord, endRecord); Integer prevPage = map.get("prevPage"); Integer nextPage = map.get("nextPage"); Integer firstPage = map.get("firstPage"); Integer lastPage = map.get("lastPage"); Integer totalPage = map.get("totalPage"); model.addAttribute("list", list); model.addAttribute("prevPage", prevPage); model.addAttribute("nextPage", nextPage); model.addAttribute("firstPage", firstPage); model.addAttribute("lastPage", lastPage); model.addAttribute("totalPage", totalPage); return "index"; } @PostMapping("/") @ResponseBody public void add(String content) { musicVideoService.add(content); } }
web.xml
<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd" version="4.0"> <display-name>MyBatis Music</display-name> <context-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/applicationContext.xml</param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <filter> <filter-name>encodingFilter</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>UTF-8</param-value> </init-param> <init-param> <param-name>forceEncoding</param-name> <param-value>true</param-value> </init-param> </filter> <filter-mapping> <filter-name>encodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <servlet> <servlet-name>mybatismusic</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>mybatismusic</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> </web-app>
mybatismusic-servlet.xml
<?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:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:mybatis="http://mybatis.org/schema/mybatis-spring" 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 http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd"> <mvc:resources location="/resources/" mapping="/resources/**" /> <mvc:annotation-driven /> <context:component-scan base-package="net.java_school.mybatismusic" /> <mybatis:scan base-package="net.java_school.mybatis" /> <bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" /> <property name="prefix" value="/WEB-INF/views/" /> <property name="suffix" value=".jsp" /> </bean> </beans>
applicationContext.xml
<?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" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd"> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" /> <property name="url" value="jdbc:oracle:thin:@localhost:1521:XE" /> <property name="username" value="scott" /> <property name="password" value="tiger" /> <property name="maxActive" value="100" /> <property name="maxWait" value="1000" /> <property name="poolPreparedStatements" value="true" /> <property name="defaultAutoCommit" value="true" /> <property name="validationQuery" value=" SELECT 1 FROM DUAL" /> </bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="configLocation" value="classpath:net/java_school/mybatis/Configuration.xml" /> </bean> </beans>
src/main/webapp/WEB-INF/views
index.jsp
<%@ 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> <html lang="en"> <head> <meta charset="UTF-8" /> <title>MyBatis Music</title> <meta name="viewport" content="width=device-width, initial-scale=1" /> <meta name="Keywords" content="MyBatis Music App Test" /> <meta name="Description" content="This is test web app for MyBatis Music Video" /> <style> html, body { margin: 0; padding: 0; background-color: #FFF; font-family: "Liberation Sans", Helvetica, sans-serif; } #videos .iframe { float: left; } #paging { width: 640px; float: left; font-size: 1em; } form { display: flex; } textarea { display: inline-block; width: 85%; resize: none; } #submit { display: inline-block; width: 10%; margin-bottom: -10px; } </style> <script src="resources/js/jquery-3.6.1.min.js"></script> <script> $(document).ready(function() { $("#addForm").submit(function (event) { event.preventDefault(); var $form = $(this); var content = $('#addForm-ta').val(); content = $.trim(content); if (content.length === 0) { $('#addForm-ta').val(''); return false; } var dataToBeSent = $form.serialize(); var url = $form.attr("action"); var posting = $.post(url, dataToBeSent); posting.done(function () { $('#addForm-ta').val(''); }); }); var originWidth = $('#videos > iframe').width(); var originHeight = $('#videos > iframe').height(); var width = $('#paging').width(); var height = originHeight * width / originWidth; $('#videos > iframe').attr('width', width); $('#videos > iframe').attr('height', height); $('#videos > iframe').attr('allowFullScreen', ''); }); </script> </head> <body> <div id="videos"> <c:forEach var="video" items="${list }" varStatus="status"> ${video.content } </c:forEach> </div> <div id="paging"> <c:if test="${prevPage > 0}"> <a href="?page=1" title="1">[First]</a> <a href="?page=${prevPage }" title="${prevPage }">[Prev]</a> </c:if> <c:forEach var="i" begin="${firstPage }" end="${lastPage }" varStatus="status"> <c:choose> <c:when test="${param.page == i}"> <strong>${i }</strong> </c:when> <c:otherwise> <a href="?page=${i }" title="${i }">${i }</a> </c:otherwise> </c:choose> </c:forEach> <c:if test="${nextPage > 0 }"> <a href="?page=${nextPage }" title="${nextPage }">[Next]</a> <a href="?page=${totalPage }" title="${totalPage }">[Last]</a> </c:if> <form id="addForm" action="./"> <textarea id="addForm-ta" name="content" cols="30" rows="1"></textarea> <input id="submit" type="submit" value="Send" /> </form> </div> </body> </html>
https://jquery.com/download/
src/main/webapp/resources/js/jquery-3.6.1.min.js
sudo service tomcat9 stop
sudo nano /etc/tomcat9/Catalina/localhost/mybatismusic.xml
<?xml version="1.0" encoding="UTF-8"?> <Context docBase="/home/john/mybatismusic/src/main/webapp" reloadable="true"> </Context>
mvn compile war:inplace
sudo service tomcat9 restart
Source:
https://github.com/kimjonghoon/mybatismusic