整合 SSM 框架

Bertha 。 2022-08-30 15:58 421阅读 0赞

文章目录

  • 整合 MyBatis
    • Dao 层
    • Service 层
  • 整合 Spring
  • 整合 SpringMVC

整合 MyBatis

创建数据库

  1. CREATE DATABASE `library`;
  3. USE `library`;
  5. DROP TABLE IF EXISTS `books`;
  7. CREATE TABLE `books` (
  8.   `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '书id',
  9.   `name` varchar(100) NOT NULL COMMENT '书名',
  10.   `counts` int(11) NOT NULL COMMENT '数量',
  11.   `detail` varchar(200) NOT NULL COMMENT '描述',
  12.   `price` double DEFAULT NULL COMMENT '价格',
  13.   `imagePath` varchar(200) DEFAULT NULL COMMENT '图片路径',
  14.   PRIMARY KEY (`id`)
  15. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  18. DROP TABLE IF EXISTS `users`;
  20. CREATE TABLE `users` (
  21.   `id` int(11) NOT NULL AUTO_INCREMENT,
  22.   `name` varchar(30) DEFAULT NULL,
  23.   `password` varchar(30) DEFAULT NULL,
  24.   PRIMARY KEY (`id`),
  25.   UNIQUE KEY `UNIQUE` (`name`)
  26. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

创建 Maven JavaWeb 项目

Maven 导入所用 jar 包的依赖

  1. <dependencies>
  2.     <!--Junit 单元测试依赖-->
  3.     <dependency>
  4.         <groupId>junit</groupId>
  5.         <artifactId>junit</artifactId>
  6.         <version>4.12</version>
  7.     </dependency>
  8.     <!--MySQL 数据库驱动 依赖-->
  9.     <dependency>
  10.         <groupId>mysql</groupId>
  11.         <artifactId>mysql-connector-java</artifactId>
  12.         <version>5.1.47</version>
  13.     </dependency>
  14.     <!--Druid 数据库连接池 依赖-->
  15.     <dependency>
  16.         <groupId>com.alibaba</groupId>
  17.         <artifactId>druid</artifactId>
  18.         <version>1.2.6</version>
  19.     </dependency>
  20.     <dependency>
  21.         <groupId>org.aspectj</groupId>
  22.         <artifactId>aspectjweaver</artifactId>
  23.         <version>1.9.6</version>
  24.     </dependency>
  25.     <!--Servlet - JSP 依赖 -->
  26.     <dependency>
  27.         <groupId>javax.servlet</groupId>
  28.         <artifactId>servlet-api</artifactId>
  29.         <version>2.5</version>
  30.     </dependency>
  31.     <dependency>
  32.         <groupId>javax.servlet.jsp</groupId>
  33.         <artifactId>jsp-api</artifactId>
  34.         <version>2.2</version>
  35.     </dependency>
  36.     <dependency>
  37.         <groupId>javax.servlet</groupId>
  38.         <artifactId>jstl</artifactId>
  39.         <version>1.2</version>
  40.     </dependency>
  41.     <!--Mybatis 依赖-->
  42.     <dependency>
  43.         <groupId>org.mybatis</groupId>
  44.         <artifactId>mybatis</artifactId>
  45.         <version>3.5.6</version>
  46.     </dependency>
  47.     <dependency>
  48.         <groupId>org.mybatis</groupId>
  49.         <artifactId>mybatis-spring</artifactId>
  50.         <version>2.0.6</version>
  51.     </dependency>
  52.     <!--Spring 依赖-->
  53.     <dependency>
  54.         <groupId>org.springframework</groupId>
  55.         <artifactId>spring-webmvc</artifactId>
  56.         <version>5.3.5</version>
  57.     </dependency>
  58.     <dependency>
  59.         <groupId>org.springframework</groupId>
  60.         <artifactId>spring-jdbc</artifactId>
  61.         <version>5.3.5</version>
  62.     </dependency>
  63.     <!--Lombok 依赖-->
  64.     <dependency>
  65.         <groupId>org.projectlombok</groupId>
  66.         <artifactId>lombok</artifactId>
  67.         <version>1.18.12</version>
  68.     </dependency>
  69.     <!--Log4j 日志文件依赖-->
  70.     <dependency>
  71.         <groupId>log4j</groupId>
  72.         <artifactId>log4j</artifactId>
  73.         <version>1.2.17</version>
  74.     </dependency>
  75.     <!--处理 JSON 字符串依赖-->
  76.     <!--jackson-->
  77.     <dependency>
  78.         <groupId>com.fasterxml.jackson.core</groupId>
  79.         <artifactId>jackson-core</artifactId>
  80.         <version>2.12.3</version>
  81.     </dependency>
  82.     <dependency>
  83.         <groupId>com.fasterxml.jackson.core</groupId>
  84.         <artifactId>jackson-databind</artifactId>
  85.         <version>2.12.3</version>
  86.     </dependency>
  87.     <dependency>
  88.         <groupId>com.fasterxml.jackson.core</groupId>
  89.         <artifactId>jackson-annotations</artifactId>
  90.         <version>2.12.3</version>
  91.     </dependency>
  92.     <!--fastjson -->
  93.     <dependency>
  94.         <groupId>com.alibaba</groupId>
  95.         <artifactId>fastjson</artifactId>
  96.         <version>1.2.75</version>
  97.     </dependency>
  98.     <!--email 依赖 -->
  99.     <dependency>
  100.         <groupId>org.springframework</groupId>
  101.         <artifactId>spring-context-support</artifactId>
  102.         <version>5.3.8</version>
  103.     </dependency>
  104.     <dependency>
  105.         <groupId>javax.mail</groupId>
  106.         <artifactId>mail</artifactId>
  107.         <version>1.4.7</version>
  108.     </dependency>
  109. </dependencies>

Maven 配置静态资源导出

  1. <!--静态资源导出-->
  2. <build>
  3.     <resources>
  4.         <resource>
  5.             <directory>src/main/java</directory>
  6.             <includes>
  7.                 <include>**/*.properties</include>
  8.                 <include>**/*.xml</include>
  9.             </includes>
  10.             <filtering>false</filtering>
  11.         </resource>
  12.         <resource>
  13.             <directory>src/main/resources</directory>
  14.             <includes>
  15.                 <include>**/*.properties</include>
  16.                 <include>**/*.xml</include>
  17.             </includes>
  18.             <filtering>false</filtering>
  19.         </resource>
  20.     </resources>
  21. </build>

Dao 层

创建 pojo 包下的实体类 Books

  1. package pojo;
  3. import lombok.AllArgsConstructor;
  4. import lombok.Data;
  5. import lombok.NoArgsConstructor;
  7. @Data
  8. @AllArgsConstructor
  9. @NoArgsConstructor
  10. public class Books { 
  12.     private int id; //id
  13.     private String name; //书名 
  14.     private int counts; //数量
  15.     private String detail; //描述
  16.     private double price; //价格
  17.     private String imagePath; //图片路径
  19.     public Books(String name, int counts, String detail, double price, String imagePath) { 
  20.         this.name = name;
  21.         this.counts = counts;
  22.         this.detail = detail;
  23.         this.price = price;
  24.         this.imagePath = imagePath;
  25.     }
  27. }

编写接口类 BookMapper

  1. package dao;
  3. import org.apache.ibatis.annotations.Param;
  4. import pojo.Books;
  6. import java.util.List;
  8. public interface BookMapper { 
  10.     /** * 增加一本书 * * @param books 书籍 * @return 返回-1表示失败，返回其他则表示成功 */
  11.     int addBook(Books books);
  13.     /** * 通过 id 删除书籍 * * @param id 书籍id * @return 返回-1表示失败，返回其他则表示成功 */
  14.     int deleteBookById(int id);
  16.     /** * 通过 id 修改书籍 * * @param books 书籍 * @return 返回-1表示失败，返回其他则表示成功 */
  17.     int updateBook(Books books);
  19.     /** * 根据 id 查询一本书 * * @param id 书籍id * @return 书籍 */
  20.     Books queryBookById(int id);
  22.     /** * 查询全部的书 * * @return 全部书籍的集合 */
  23.     List<Books> queryAllBooks();
  25.     /** * 根据 name 查询书籍 * * @param name 书名 * @return 书籍的集合 */
  26.     List<Books> queryBookByName(String name);
  28.     /** * 分页查询，如果 name 不为空则根据 name分页；反之，则根据全部数据分页 * * @param name 书名 * @param begin 开始 * @param size 页大小 * @return 当前页的数据 */
  29.     List<Books> limitBook(@Param("name") String name, @Param("begin") int begin, @Param("size") int size);
  31.     /** * 根据 name 模糊查询行数，如果 name 为空则查询所有行数 * * @return 行数 */
  32.     int queryRow(@Param("name") String name);
  34. }

编写 BookMapper.xml 绑定 BookMapper 接口

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  4. <!--设置 namespace 绑定 BookMapper 接口-->
  5. <mapper namespace="dao.BookMapper">
  7.     <!--配置缓存 eviction： 定义回收的策略，常见的有 FIFO，LRU。 flushInterval： 配置一定时间自动刷新缓存，单位是毫秒。 size： 最多缓存对象的个数。 readOnly： 是否只读，若配置可读写，则需要对应的实体类能够序列化。 -->
  8.     <cache eviction="FIFO" flushInterval="60000" size="512" readOnly="true"/>
  10.     <insert id="addBook" parameterType="Books">
  11.         insert into books(name, counts, detail, price, imagePath)
  12.         values (#{name}, #{counts}, #{detail}, #{price}, #{imagePath})
  13.     </insert>
  15.     <delete id="deleteBookById" parameterType="int">
  16.         delete
  17.         from books
  18.         where id = #{id}
  19.     </delete>
  21.     <update id="updateBook" parameterType="Books">
  22.         update books
  23.         set name=#{name},
  24.             counts=#{counts},
  25.             detail=#{detail},
  26.             price=#{price},
  27.             imagePath=#{imagePath}
  28.         where id = #{id}
  29.     </update>
  31.     <select id="queryBookById" resultType="Books">
  32.         select *
  33.         from books
  34.         where id = #{id}
  35.     </select>
  37.     <!--queryAllBooks 方法-->
  38.     <select id="queryAllBooks" resultType="Books">
  39.         select *
  40.         from books
  41.     </select>
  43.     <!--queryBookByName 方法-->
  44.     <select id="queryBookByName" resultType="Books">
  45.         select *
  46.         from books
  47.         where name = #{name}
  48.     </select>
  50.     <!--queryRow 方法 SQL：select count(*) from books 如果 name !=null and name !='' 时 SQL：select count(*) from books where name like "%"#{name}"%" -->
  51.     <select id="queryRow" resultType="_int">
  52.         select count(*) from books
  53.         <where>
  54.             <if test=" name !=null and name !=''">
  55.                 name like "%"#{name}"%"
  56.             </if>
  57.         </where>
  58.     </select>
  60.     <!--limitBook 方法 SQL：select * from books limit #{begin}, #{size} 如果 name !=null and name !='' 时 SQL：select * from books where name like "%"#{name}"%" limit #{begin}, #{size} -->
  61.     <select id="limitBook" resultType="Books">
  62.         select *
  63.         from books
  64.         <where>
  65.             <if test=" name !=null and name !=''">
  66.                 name like "%"#{name}"%"
  67.             </if>
  68.         </where>
  69.         limit #{begin}, #{size}
  70.     </select>
  72. </mapper>

编写 mybatis-config.xml 文件

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
  3. <configuration>
  5.     <!--设置日志 log4j，开启二级缓存-->
  6.     <settings>
  7.         <setting name="logImpl" value="LOG4J"/>
  8.         <setting name="cacheEnabled" value="true"/>
  9.     </settings>
  11.     <!--设置 pojo 包下的别名-->
  12.     <typeAliases>
  13.         <package name="pojo"/>
  14.     </typeAliases>
  16.     <!--注册绑定 Mapper-->
  17.     <mappers>
  18.         <mapper class="dao.BookMapper"/>
  19.     </mappers>
  21. </configuration>

这里 mybatis 日志决定采用 log4j，从网上找了一个实现只保留7天日志的的方法，需要自定义类继承 FileAppender 类进行扩展

编写工具类 MyDailyRollingFileAppender

  1. package utils;
  3. import java.io.File;
  4. import java.io.FileFilter;
  5. import java.io.IOException;
  6. import java.io.InterruptedIOException;
  7. import java.text.ParseException;
  8. import java.text.SimpleDateFormat;
  9. import java.util.Arrays;
  10. import java.util.Calendar;
  11. import java.util.Date;
  12. import java.util.GregorianCalendar;
  13. import java.util.Locale;
  14. import java.util.TimeZone;
  16. import org.apache.log4j.FileAppender;
  17. import org.apache.log4j.Layout;
  18. import org.apache.log4j.helpers.LogLog;
  19. import org.apache.log4j.spi.LoggingEvent;
  21. /** * Log4j的扩展-保留最近指定个数的日志文件 */
  22. public class MyDailyRollingFileAppender extends FileAppender { 
  23.     static final int TOP_OF_TROUBLE = -1;
  24.     static final int TOP_OF_MINUTE = 0;
  25.     static final int TOP_OF_HOUR = 1;
  26.     static final int HALF_DAY = 2;
  27.     static final int TOP_OF_DAY = 3;
  28.     static final int TOP_OF_WEEK = 4;
  29.     static final int TOP_OF_MONTH = 5;
  31.     /** * 默认设置："'.'yyyy-MM-dd" * 设置说明：按天循环打印日志 */
  32.     private String datePattern = "'.'yyyy-MM-dd";
  33.     private int maxBackupIndex = 1;
  34.     private String scheduledFilename;
  35.     /** * 下一次Rolling日志文件的时间 */
  36.     private long nextCheck = System.currentTimeMillis() - 1;
  37.     Date now = new Date();
  38.     SimpleDateFormat sdf;
  39.     RollingCalendar rc = new RollingCalendar();
  40.     int checkPeriod = TOP_OF_TROUBLE;
  41.     /** * 获取当前环境所处的时区 * 仅供computeCheckPeriod方法使用 */
  42.     static final TimeZone gmtTimeZone = TimeZone.getTimeZone("GMT");
  44.     public MyDailyRollingFileAppender() { 
  45.     }
  47.     public MyDailyRollingFileAppender(Layout layout, String filename, String datePattern) throws IOException { 
  48.         super(layout, filename, true);
  49.         this.datePattern = datePattern;
  50.         activateOptions();
  51.     }
  53.     public String getDatePattern() { 
  54.         return datePattern;
  55.     }
  57.     public void setDatePattern(String pattern) { 
  58.         this.datePattern = pattern;
  59.     }
  61.     public int getMaxBackupIndex() { 
  62.         return maxBackupIndex;
  63.     }
  65.     public void setMaxBackupIndex(int maxBackupIndex) { 
  66.         this.maxBackupIndex = maxBackupIndex;
  67.     }
  69.     /** * activateOptions译名为激活操作 * 意思是按照配置的参数进行初始化 * scheduledFilename为log的最后一次修改时间 */
  70.     @Override
  71.     public void activateOptions() { 
  72.         super.activateOptions();
  74.         if (datePattern != null && fileName != null) { 
  75.             now.setTime(System.currentTimeMillis());
  76.             sdf = new SimpleDateFormat(datePattern);
  77.             int type = computeCheckPeriod();
  78.             printPeriodicity(type);
  79.             rc.setType(type);
  80.             File file = new File(fileName);
  81.             scheduledFilename = fileName + sdf.format(new Date(file.lastModified()));
  82.         } else { 
  83.             LogLog.error("Either File or DatePattern options are not set for appender [" + name + "].");
  84.         }
  85.     }
  88.     int computeCheckPeriod() { 
  89.         RollingCalendar rollingCalendar = new RollingCalendar(gmtTimeZone, Locale.getDefault());
  90.         //设置初始时间为格林尼治时间：1970-01-01 00:00:00 GMT
  91.         Date epoch = new Date(0);
  92.         if (datePattern != null) { 
  93.             for (int i = TOP_OF_MINUTE; i <= TOP_OF_MONTH; i++) { 
  94.                 //将所示的时间格式化为当前时区
  95.                 SimpleDateFormat simpleDateFormat = new SimpleDateFormat(datePattern);
  96.                 simpleDateFormat.setTimeZone(gmtTimeZone);
  98.                 String r0 = simpleDateFormat.format(epoch);
  99.                 rollingCalendar.setType(i);
  100.                 Date next = new Date(rollingCalendar.getNextCheckMillis(epoch));
  101.                 String r1 = simpleDateFormat.format(next);
  102.                 //System.out.println("Type = "+i+", r0 = "+r0+", r1 = "+r1);
  103.                 if (r0 != null && r1 != null && !r0.equals(r1)) { 
  104.                     return i;
  105.                 }
  106.             }
  107.         }
  108.         return TOP_OF_TROUBLE; // Deliberately head for trouble...
  109.     }
  111.     /** * 按照周期将当前日志文件转存为日期文件 * * @throws IOException */
  112.     void rollOver() throws IOException { 
  114.         if (datePattern == null) { 
  115.             errorHandler.error("Missing DatePattern option in rollOver().");
  116.             return;
  117.         }
  119.         String datedFilename = fileName + sdf.format(now);
  121.         //如果最后一次的修改时间为当前时间 ，则不做任何任何操作
  122.         if (scheduledFilename.equals(datedFilename)) { 
  123.             return;
  124.         }
  126.         // 关闭当前文件，重命名为日期文件
  127.         this.closeFile();
  129.         File target = new File(scheduledFilename);
  130.         if (target.exists()) { 
  131.             target.delete();
  132.         }
  134.         File file = new File(fileName);
  135.         boolean result = file.renameTo(target);
  136.         if (result) { 
  137.             LogLog.debug(fileName + " -> " + scheduledFilename);
  138.         } else { 
  139.             LogLog.error("Failed to rename [" + fileName + "] to [" + scheduledFilename + "].");
  140.         }
  142.         //获取日志文件列表，控制数量，实现清理策略
  143.         if (file.getParentFile().exists()) { 
  144.             File[] files = file.getParentFile().listFiles(new LogFileFilter(file.getName()));
  145.             Long[] dateArray = new Long[files.length];
  146.             for (int i = 0; i < files.length; i++) { 
  147.                 File fileItem = files[i];
  148.                 String fileDateStr = fileItem.getName().replace(file.getName(), "");
  149.                 Date filedate = null;
  150.                 try { 
  151.                     filedate = sdf.parse(fileDateStr);
  152.                     long fileDateLong = filedate.getTime();
  153.                     dateArray[i] = fileDateLong;
  154.                 } catch (ParseException e) { 
  155.                     LogLog.error("Parse File Date Throw Exception : " + e.getMessage());
  156.                 }
  157.             }
  158.             Arrays.sort(dateArray);
  159.             if (dateArray.length > maxBackupIndex) { //需要清理多余日志文件了
  160.                 for (int i = 0; i < dateArray.length - maxBackupIndex; i++) { 
  161.                     String dateFileName = file.getPath() + sdf.format(dateArray[i]);
  162.                     File dateFile = new File(dateFileName);
  163.                     if (dateFile.exists()) { 
  164.                         dateFile.delete();
  165.                     }
  166.                 }
  167.             }
  168.         }
  170.         try { 
  171.             this.setFile(fileName, true, this.bufferedIO, this.bufferSize);
  172.         } catch (IOException e) { 
  173.             errorHandler.error("setFile(" + fileName + ", true) call failed.");
  174.         }
  175.         scheduledFilename = datedFilename;
  176.     }
  178.     /** * 写入日志之前判断是否需要新起一个日志来记录 */
  179.     @Override
  180.     protected void subAppend(LoggingEvent event) { 
  181.         long n = System.currentTimeMillis();
  182.         if (n >= nextCheck) { 
  183.             now.setTime(n);
  184.             nextCheck = rc.getNextCheckMillis(now);
  185.             try { 
  186.                 rollOver();
  187.             } catch (IOException ioe) { 
  188.                 if (ioe instanceof InterruptedIOException) { 
  189.                     Thread.currentThread().interrupt();
  190.                 }
  191.                 LogLog.error("rollOver() failed.", ioe);
  192.             }
  193.         }
  194.         super.subAppend(event);
  195.     }
  197.     /** * 文件过滤器 */
  198.     class LogFileFilter implements FileFilter { 
  199.         private String logName;
  201.         public LogFileFilter(String logName) { 
  202.             this.logName = logName;
  203.         }
  205.         @Override
  206.         public boolean accept(File file) { 
  207.             if (logName == null || file.isDirectory()) { 
  208.                 return false;
  209.             } else { 
  210.                 LogLog.debug(file.getName());
  211.                 return file.getName().startsWith(logName);
  212.             }
  213.         }
  214.     }
  216.     /** * 根据type打印做出日志打印 * * @param type */
  217.     void printPeriodicity(int type) { 
  218.         switch (type) { 
  219.             case TOP_OF_MINUTE:
  220.                 LogLog.debug("Appender [" + name + "] to be rolled every minute.");
  221.                 break;
  222.             case TOP_OF_HOUR:
  223.                 LogLog.debug("Appender [" + name + "] to be rolled on top of every hour.");
  224.                 break;
  225.             case HALF_DAY:
  226.                 LogLog.debug("Appender [" + name + "] to be rolled at midday and midnight.");
  227.                 break;
  228.             case TOP_OF_DAY:
  229.                 LogLog.debug("Appender [" + name + "] to be rolled at midnight.");
  230.                 break;
  231.             case TOP_OF_WEEK:
  232.                 LogLog.debug("Appender [" + name + "] to be rolled at start of week.");
  233.                 break;
  234.             case TOP_OF_MONTH:
  235.                 LogLog.debug("Appender [" + name + "] to be rolled at start of every month.");
  236.                 break;
  237.             default:
  238.                 LogLog.warn("Unknown periodicity for appender [" + name + "].");
  239.         }
  240.     }
  242.     /** * 内部类 * * @author 日志Rolling日历, 获取下一次日志Rolling时间 */
  243.     class RollingCalendar extends GregorianCalendar { 
  244.         private static final long serialVersionUID = -3560331770601814177L;
  246.         int type = MyDailyRollingFileAppender.TOP_OF_TROUBLE;
  248.         /** * RollingCalendar默认构造器 */
  249.         RollingCalendar() { 
  250.             super();
  251.         }
  253.         /** * RollingCalendar构造器 * 根据地点时区 ，获取对应的日历Calendar * * @param tz * @param locale */
  254.         RollingCalendar(TimeZone tz, Locale locale) { 
  255.             super(tz, locale);
  256.         }
  258.         void setType(int type) { 
  259.             this.type = type;
  260.         }
  262.         public long getNextCheckMillis(Date now) { 
  263.             return getNextCheckDate(now).getTime();
  264.         }
  267.         /** * 根据所传入的时间以及时间类型获取下一个时间 * * @param now * @return */
  268.         public Date getNextCheckDate(Date now) { 
  269.             this.setTime(now);
  271.             switch (type) { 
  272.                 case MyDailyRollingFileAppender.TOP_OF_MINUTE:
  273.                     this.set(Calendar.SECOND, 0);
  274.                     this.set(Calendar.MILLISECOND, 0);
  275.                     this.add(Calendar.MINUTE, 1);
  276.                     break;
  277.                 case MyDailyRollingFileAppender.TOP_OF_HOUR:
  278.                     this.set(Calendar.MINUTE, 0);
  279.                     this.set(Calendar.SECOND, 0);
  280.                     this.set(Calendar.MILLISECOND, 0);
  281.                     this.add(Calendar.HOUR_OF_DAY, 1);
  282.                     break;
  283.                 case MyDailyRollingFileAppender.HALF_DAY:
  284.                     this.set(Calendar.MINUTE, 0);
  285.                     this.set(Calendar.SECOND, 0);
  286.                     this.set(Calendar.MILLISECOND, 0);
  287.                     int hour = get(Calendar.HOUR_OF_DAY);
  288.                     if (hour < 12) { 
  289.                         this.set(Calendar.HOUR_OF_DAY, 12);
  290.                     } else { 
  291.                         this.set(Calendar.HOUR_OF_DAY, 0);
  292.                         this.add(Calendar.DAY_OF_MONTH, 1);
  293.                     }
  294.                     break;
  295.                 case MyDailyRollingFileAppender.TOP_OF_DAY:
  296.                     this.set(Calendar.HOUR_OF_DAY, 0);
  297.                     this.set(Calendar.MINUTE, 0);
  298.                     this.set(Calendar.SECOND, 0);
  299.                     this.set(Calendar.MILLISECOND, 0);
  300.                     this.add(Calendar.DATE, 1);
  301.                     break;
  302.                 case MyDailyRollingFileAppender.TOP_OF_WEEK:
  303.                     this.set(Calendar.DAY_OF_WEEK, getFirstDayOfWeek());
  304.                     this.set(Calendar.HOUR_OF_DAY, 0);
  305.                     this.set(Calendar.MINUTE, 0);
  306.                     this.set(Calendar.SECOND, 0);
  307.                     this.set(Calendar.MILLISECOND, 0);
  308.                     this.add(Calendar.WEEK_OF_YEAR, 1);
  309.                     break;
  310.                 case MyDailyRollingFileAppender.TOP_OF_MONTH:
  311.                     this.set(Calendar.DATE, 1);
  312.                     this.set(Calendar.HOUR_OF_DAY, 0);
  313.                     this.set(Calendar.MINUTE, 0);
  314.                     this.set(Calendar.SECOND, 0);
  315.                     this.set(Calendar.MILLISECOND, 0);
  316.                     this.add(Calendar.MONTH, 1);
  317.                     break;
  318.                 default:
  319.                     throw new IllegalStateException("Unknown periodicity type.");
  320.             }
  321.             return getTime();
  322.         }
  323.     }
  324. }

编写 log4j.porperties 对 log4j 进行配置

  1. #将等级为DEBUG的日志信息输出到console和file这两个目的地，console和file的定义在下面的代码
  2. log4j.rootLogger=DEBUG,console,file
  3. #控制台输出的相关设置
  4. log4j.appender.console=org.apache.log4j.ConsoleAppender
  5. log4j.appender.console.Target=System.out
  6. log4j.appender.console.Threshold=DEBUG
  7. log4j.appender.console.layout=org.apache.log4j.PatternLayout
  8. log4j.appender.console.layout.ConversionPattern=[%c]-%m%n
  9. #文件输出的相关设置
  10. log4j.appender.file=utils.MyDailyRollingFileAppender
  11. #日志文件路径
  12. log4j.appender.file.File=./logs/log.log
  13. log4j.appender.file.Encoding=utf-8
  14. log4j.appender.file.Append=true
  15. log4j.appender.file.Threshold=DEBUG
  16. log4j.appender.file.layout=org.apache.log4j.PatternLayout
  17. #设置日志文件名为日期并按天生成日志文件
  18. log4j.appender.file.datePattern='.'yyyy-MM-dd
  19. #保留7天的日志文件
  20. log4j.appender.file.maxBackupIndex=7
  21. log4j.appender.file.layout.ConversionPattern=[%d{yyyy-MM-dd HH:mm:ss,SSS}][%c]%m%n
  22. #日志输出级别
  23. log4j.logger.org.mybatis=DEBUG
  24. log4j.logger.java.sql=DEBUG
  25. log4j.logger.java.sql.Statement=DEBUG
  26. log4j.logger.java.sql.ResultSet=DEBUG
  27. log4j.logger.java.sql.PreparedStatement=DEBUG

配置好之后，在进行单元测试的时候就可以查看输出的日志文件

Service 层

Service 层调用 Dao 层提供的方法

1、编写接口 BookService

  1. package service;
  3. import pojo.Books;
  5. import java.awt.print.Book;
  6. import java.util.List;
  8. public interface BookService { 
  10.     /** * 增加一本书 * * @param books 书籍 * @return 返回-1表示失败，返回其他则表示成功 */
  11.     int addBook(Books books);
  13.     /** * 通过 id 删除书籍 * * @param id 书籍id * @return 返回-1表示失败，返回其他则表示成功 */
  14.     int deleteBookById(int id);
  16.     /** * 通过 id 修改书籍 * * @param books 书籍 * @return 返回-1表示失败，返回其他则表示成功 */
  17.     int updateBook(Books books);
  19.     /** * 根据 id 查询一本书 * * @param id 书籍id * @return 书籍 */
  20.     Books queryBookById(int id);
  22.     /** * 查询全部的书 * * @return 全部书籍的集合 */
  23.     List<Books> queryAllBooks();
  25.     /** * 根据 name 查询书籍 * * @param name 书名 * @return 书籍的集合 */
  26.     List<Books> queryBookByName(String name);
  28.     /** * 分页查询，如果 name 不为空则根据 name分页；反之，则根据全部数据分页 * * @param name 书名 * @param begin 开始 * @param size 页大小 * @return 当前页的数据 */
  29.     List<Books> limitBook(String name, int begin, int size);
  31.     /** * 根据 name 模糊查询行数，如果 name 为空则查询所有行数 * * @return 行数 */
  32.     int queryRow(String name);
  34. }

2、编写接口 BookService 实现类 BookServiceImpl

  1. package service;
  3. import dao.BookMapper;
  4. import pojo.Books;
  6. import java.util.List;
  8. public class BookServiceImpl implements BookService { 
  10.     /** * service 层调用 Dao层 */
  11.     private BookMapper bookMapper;
  13.     public void setBookMapper(BookMapper bookMapper) { 
  14.         this.bookMapper = bookMapper;
  15.     }
  17.     @Override
  18.     public int addBook(Books books) { 
  19.         return bookMapper.addBook(books);
  20.     }
  22.     @Override
  23.     public int deleteBookById(int id) { 
  24.         return bookMapper.deleteBookById(id);
  25.     }
  27.     @Override
  28.     public int updateBook(Books books) { 
  29.         return bookMapper.updateBook(books);
  30.     }
  32.     @Override
  33.     public Books queryBookById(int id) { 
  34.         return bookMapper.queryBookById(id);
  35.     }
  37.     @Override
  38.     public List<Books> queryAllBooks() { 
  39.         return bookMapper.queryAllBooks();
  40.     }
  42.     @Override
  43.     public List<Books> queryBookByName(String name) { 
  44.         return bookMapper.queryBookByName(name);
  45.     }
  47.     @Override
  48.     public int queryRow(String name) { 
  49.         return bookMapper.queryRow(name);
  50.     }
  53.     @Override
  54.     public List<Books> limitBook(String name, int begin, int size) { 
  55.         return bookMapper.limitBook(name, begin, size);
  56.     }
  57. }

整合 Spring

编写 jdbc.properties 配置文件

  1. url=jdbc:mysql://localhost:3306/library?useUnicode=true&characterEncoding=utf8&useSSL=false
  2. driver=com.mysql.jdbc.Driver
  3. user=root
  4. password=123456

注：MySQL 8.0版本之后 url 需要配置时区 serverTimezone=GMT%2B8

spring-dao.xml 对 Dao 进行整合

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <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" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
  4.     <!--关联数据库配置文件-->
  5.     <context:property-placeholder location="classpath:jdbc.properties"/>
  7.     <!--Druid 数据库连接池配置-->
  8.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close" init-method="init">
  9.         <!-- 基本属性driverClassName、 url、username、password -->
  10.         <property name="driverClassName" value="${driver}"/>
  11.         <property name="url" value="${url}"/>
  12.         <property name="username" value="${user}"/>
  13.         <property name="password" value="${password}"/>
  14.         <!-- 配置初始化大小、最小、最大、获取连接等待超时的时间、连接在池中最小生存的时间 -->
  15.         <property name="initialSize" value="2"/>
  16.         <property name="minIdle" value="5"/>
  17.         <property name="maxActive" value="50"/>
  18.         <property name="maxWait" value="5000"/>
  19.         <property name="minEvictableIdleTimeMillis" value="30000"/>
  20.     </bean>
  22.     <!--sqlSessionFactory-->
  23.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  24.         <property name="dataSource" ref="dataSource"/>
  25.         <!--绑定 Mybatis 配置文件-->
  26.         <property name="configLocation" value="classpath:mybatis-config.xml"/>
  27.     </bean>
  29.     <!--配置 dao 接口扫描包，动态实现 Dao 接口注入 Spring 容器中-->
  30.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  31.         <!--注入 sqlSessionFactory-->
  32.         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
  33.         <!--扫描 dao 包-->
  34.         <property name="basePackage" value="dao"/>
  35.     </bean>
  37. </beans>

spring-service.xml 对 Service 进行整合

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
  4.     <!--扫描 service 下的包-->
  5.     <context:component-scan base-package="service"/>
  7.     <!--将所有业务类注入到 Spring ,可以通过配置或注解实现-->
  8.     <bean id="bookServiceImpl" class="service.BookServiceImpl">
  9.         <property name="bookMapper" ref="bookMapper"/>
  10.     </bean>
  12.     <!--声明式事务配置-->
  13.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  14.         <!--注入数据源-->
  15.         <property name="dataSource" ref="dataSource"/>
  16.     </bean>
  18.     <!--事务支持-->
  20.     <!--给所有方法配置事务-->
  21.     <!--配置事务的传播特性：new propagation-->
  22.     <tx:advice id="txAdvice" transaction-manager="transactionManager">
  23.         <tx:attributes>
  24.             <tx:method name="*" propagation="REQUIRED"/>
  25.         </tx:attributes>
  26.     </tx:advice>
  27.     <!--aop配置事务切入-->
  28.     <aop:config>
  29.         <aop:pointcut id="txPointCut" expression="execution(* dao.*.*(..))"/>
  30.         <aop:advisor advice-ref="txAdvice" pointcut-ref="txPointCut"/>
  31.     </aop:config>
  33. </beans>

整合 SpringMVC

1、配置 web.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <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">
  4.     <!--DispatcherServlet-->
  5.     <servlet>
  6.         <servlet-name>dispatcherServlet</servlet-name>
  7.         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  8.         <init-param>
  9.             <param-name>contextConfigLocation</param-name>
  10.             <param-value>classpath:applicationContext.xml</param-value>
  11.         </init-param>
  12.         <load-on-startup>1</load-on-startup>
  13.     </servlet>
  14.     <servlet-mapping>
  15.         <servlet-name>dispatcherServlet</servlet-name>
  16.         <url-pattern>/</url-pattern>
  17.     </servlet-mapping>
  19.     <!-- 乱码过滤 -->
  20.     <filter>
  21.         <filter-name>encoding</filter-name>
  22.         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  23.         <init-param>
  24.             <param-name>encoding</param-name>
  25.             <param-value>utf-8</param-value>
  26.         </init-param>
  27.     </filter>
  28.     <filter-mapping>
  29.         <filter-name>encoding</filter-name>
  30.         <url-pattern>/*</url-pattern>
  31.     </filter-mapping>
  33.     <!--Session-->
  34.     <session-config>
  35.         <session-timeout>15</session-timeout>
  36.     </session-config>
  38.     <!--欢迎页面-->
  39.     <welcome-file-list>
  40.         <welcome-file>/WEB-INF/jsp/index.jsp</welcome-file>
  41.     </welcome-file-list>
  42.     <!--错误页面-->
  43.     <error-page>
  44.         <error-code>404</error-code>
  45.         <location>/WEB-INF/jsp/404.jsp</location>
  46.     </error-page>
  48. </web-app>

2、配置 springmvc.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
  4.     <!--注解驱动-->
  5.     <mvc:annotation-driven/>
  6.     <!--静态资源过滤-->
  7.     <mvc:default-servlet-handler/>
  8.     <!--扫描包：controller-->
  9.     <context:component-scan base-package="controller"/>
  10.     <!--视图解析器-->
  11.     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  12.         <property name="prefix" value="/WEB-INF/jsp/"/>
  13.         <property name="suffix" value=".jsp"/>
  14.     </bean>
  16.     <mvc:annotation-driven>
  17.         <mvc:message-converters register-defaults="true">
  18.             <!-- 启动Spring MVC的注解功能，完成请求和注解POJO的映射 注解请求映射 默认是ISO-88859-1，避免乱码这里设置为UTF-8 -->
  19.             <bean class="org.springframework.http.converter.StringHttpMessageConverter">
  20.                 <property name="supportedMediaTypes" value="text/html;charset=UTF-8"/>
  21.             </bean>
  22.             <!-- 启动JSON格式的配置,自动将格式转换成JSON格式，不需要其他类 -->
  23.             <bean id="jacksonMessageConverter" class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
  24.                 <property name="supportedMediaTypes" value="application/json;charset=UTF-8"/>
  25.             </bean>
  26.         </mvc:message-converters>
  27.     </mvc:annotation-driven>
  29. </beans>

3、配置 applicationContext.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
  4.     <import resource="spring-dao.xml"/>
  5.     <import resource="spring-service.xml"/>
  6.     <import resource="spring-mvc.xml"/>
  8. </beans>

一个基本的SSM框架就搭建好了，可以再其上添加业务了

发表评论

表情：
评论列表 （有 0 条评论，421人围观）

还没有评论，来说两句吧...

相关阅读

    相关 SSM框架整合

    1.创建maven项目，准备实体表 idea创建一个maven项目，选用骨架webapp。创建后边验证要用的数据库和实体表。 create database s

    悠悠悠悠/ 0 赞/ 108 阅读

    相关 SSM框架整合

    最近接触了不少的项目，从SSM到SSH都接触到了，然而对于这几个项目的架构还是一知半解，我自己花费了一些时间，整理下，写了一个SSM的框架的demo，后期我会给出SSH的一个d

    冷不防冷不防/ 0 赞/ 385 阅读

    相关 SSM框架整合

    1、Dao层： Mybatis的配置文件：SqlMapConfig.xml 不需要配置任何内容，需要有文件头。文件必须存在。 applicationContext-d

    心已赠人心已赠人/ 0 赞/ 398 阅读

    相关 ssm框架整合

    整合思路 1、Dao层： Mybatis的配置文件：SqlMapConfig.xml 不需要配置任何内容，需要有文件头。文件必须存在。 application

    野性酷女野性酷女/ 0 赞/ 397 阅读