搭建springMVC+Mybatis+quartz+log4j+maven项目
- 创建maven项目(在eclipse里面);
- 利用pom.xml文件引入项目所需的jar包;
- 设置好相关的配置文件;
- 调试项目
1、创建maven项目
工程里面 右击 --new--other
点击finish就能建立一个新的maven项目了,如建立完成之后发现该项目有错误,如下图:
按照这个解决发法来办,就可以解决了,如下:
点击ok之后,该项目就不会报错了!
2、建立完成maven项目之后,我们就要通过pom.xml文件来引入相关的jar包(非常方便)
pom.xml的配置:
<projectxmlns="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.0http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>calpina</groupId>
<artifactId>test01</artifactId>
<packaging>war</packaging>
<version>0.0.1-SNAPSHOT</version>
<name>test01 Maven Webapp</name>
<url>http://maven.apache.org</url>
<!--<dependencies> <dependency> <groupId>junit</groupId><artifactId>junit</artifactId>
<version>3.8.1</version> <scope>test</scope></dependency> </dependencies> -->
<properties>
<!-- spring版本号 -->
<spring.version>4.0.2.RELEASE</spring.version>
<!-- mybatis版本号 -->
<mybatis.version>3.2.6</mybatis.version>
<!-- log4j日志文件管理包版本 -->
<slf4j.version>1.7.7</slf4j.version>
<log4j.version>1.2.17</log4j.version>
</properties>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>3.8.1</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<!-- 表示开发的时候引入,发布的时候不会加载此包 -->
<scope>test</scope>
</dependency>
<!-- spring核心包 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-oxm</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</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-aop</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- mybatis核心包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<!-- mybatis/spring包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.2</version>
</dependency>
<!-- 导入java ee jar 包 -->
<dependency>
<groupId>javax</groupId>
<artifactId>javaee-api</artifactId>
<version>7.0</version>
</dependency>
<!-- 导入Mysql数据库链接jar包-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.30</version>
</dependency>
<!-- 导入dbcp的jar包,用来在applicationContext.xml中配置数据库 -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.2.2</version>
</dependency>
<!-- JSTL标签类 -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- 日志文件管理包 -->
<!-- log start -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>${log4j.version}</version>
</dependency>
<!-- 格式化对象,方便输出日志 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.1.41</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>${slf4j.version}</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>${slf4j.version}</version>
</dependency>
<!-- log end -->
<!-- 映入JSON -->
<dependency>
<groupId>org.codehaus.jackson</groupId>
<artifactId>jackson-mapper-asl</artifactId>
<version>1.9.13</version>
</dependency>
<!-- 上传组件包 -->
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.1</version>
</dependency>
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.4</version>
</dependency>
<dependency>
<groupId>commons-codec</groupId>
<artifactId>commons-codec</artifactId>
<version>1.9</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- <dependency> <groupId>org.opensymphony.quartz</groupId><artifactId>quartz-all</artifactId>
<version>1.6.1</version></dependency> <dependency><groupId>commons-collections</groupId>
<artifactId>commons-collections</artifactId><version>3.2.1</version> </dependency> -->
<dependency>
<groupId>org.quartz-scheduler</groupId>
<artifactId>quartz</artifactId>
<version>1.8.5</version>
</dependency>
</dependencies>
<build>
<finalName>calpina01</finalName>
</build>
</project>
配置完成之后,我们就需要开始来配置spring的设置了:
上图是我们的工程项目,首先在src/main/java 下面建立这四个包(springMVC的模式),
在src/main/resources下面建立这五个配置文件,
db.properties用来配置数据库连接用;配置如下(这里用的数据库是mysql)
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/db_test
username=root
password=root
#定义初始连接数
initialSize=0
#定义最大连接数
maxActive=20
#定义最大空闲
maxIdle=20
#定义最小空闲
minIdle=1
#定义最长等待时间
maxWait=60000
配置完数据库db.properties配置文件后,我们就可以配置springMVC的配置文件spring-mvc.xml,配置如下:
<?xml version="1.0"encoding="UTF-8"?>
<beansxmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.1.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
<!-- 自动扫描该包,使SpringMVC认为包下用了@controller注解的类是控制器 -->
<context:component-scan base-package="com.fishroad.controller"/>
<!-- 扫描文件(自动将servicec层注入) -->
<context:component-scan base-package="com.fishroad.services"/>
<!--避免IE执行AJAX时,返回JSON出现下载文件 -->
<beanid="mappingJacksonHttpMessageConverter"
class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">
<property name="supportedMediaTypes">
<list>
<value>text/html;charset=UTF-8</value>
</list>
</property>
</bean>
<!-- 启动SpringMVC的注解功能,完成请求和注解POJO的映射 -->
<bean
class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
<property name="messageConverters">
<list>
<refbean="mappingJacksonHttpMessageConverter" /> <!-- JSON转换器 -->
</list>
</property>
</bean>
<!-- 定义跳转的文件的前后缀 ,视图模式配置-->
<beanclass="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!-- 这里的配置我的理解是自动给后面action的方法return的字符串加上前缀和后缀,变成一个 可用的url地址 -->
<property name="prefix" value="/WEB-INF/jsp/"/>
<property name="suffix" value=".jsp" />
</bean>
<!-- 配置文件上传,如果没有使用文件上传可以不用配置,当然如果不配,那么配置文件中也不必引入上传组件包 -->
<beanid="multipartResolver"
class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<!-- 默认编码 -->
<property name="defaultEncoding" value="utf-8" />
<!-- 文件大小最大值 -->
<property name="maxUploadSize" value="10485760000" />
<!-- 内存中的最大值 -->
<property name="maxInMemorySize" value="40960" />
</bean>
</beans>
配置完spring,我们就可以来配置mybatis,spring-mybatis.xml的配置如下:
<?xml version="1.0"encoding="UTF-8"?>
<beansxmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.1.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
<!-- 自动扫描 -->
<context:component-scanbase-package="com.fishroad" />
<!-- 引入配置文件 -->
<beanid="propertyConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location" value="classpath:db.properties"/>
</bean>
<beanid="dataSource"class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${driver}"/>
<property name="url" value="${url}" />
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
<!-- 初始化连接大小 -->
<property name="initialSize"value="${initialSize}"></property>
<!-- 连接池最大数量 -->
<property name="maxActive" value="${maxActive}"></property>
<!-- 连接池最大空闲 -->
<property name="maxIdle"value="${maxIdle}"></property>
<!-- 连接池最小空闲 -->
<property name="minIdle"value="${minIdle}"></property>
<!-- 获取连接最大等待时间 -->
<property name="maxWait"value="${maxWait}"></property>
</bean>
<!-- spring和MyBatis完美整合,不需要mybatis的配置映射文件 -->
<beanid="sqlSessionFactory"class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- <property name="configLocation"value="classpath:mybatis-config.xml"></property> -->
<!-- 自动扫描mapping.xml文件 -->
<!-- <property name="mapperLocations"value="classpath:mapper/*.xml"></property> -->
<property name="mapperLocations"value="classpath:/com/fishroad/dao/*.xml" />
</bean>
<!-- DAO接口所在包名,Spring会自动查找其下的类 -->
<beanclass="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage"value="com.fishroad.dao" />
<property name="sqlSessionFactoryBeanName"value="sqlSessionFactory"></property>
</bean>
<!-- (事务管理)transaction manager, useJtaTransactionManager for global tx -->
<beanid="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
</beans>
接下来就是配置日志文件,log4j.properties的配置如下:
log4j.rootLogger=debug,info,stdout,info,debug,error
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=[%-5p][%d{yyyy-MM-dd HH:mm:ss}] %c - %m%n
log4j.logger.info=info
log4j.appender.info=org.apache.log4j.DailyRollingFileAppender
log4j.appender.info.layout=org.apache.log4j.PatternLayout
log4j.appender.info.layout.ConversionPattern=[%-5p][%d{yyyy-MM-dd HH:mm:ss}] %c - %m%n
log4j.appender.info.datePattern='.'yyyy-MM-dd
log4j.appender.info.Threshold =INFO
log4j.appender.info.append=true
log4j.appender.info.File=${webApp.root}/logs/info.log
log4j.logger.debug=debug
log4j.appender.debug=org.apache.log4j.DailyRollingFileAppender
log4j.appender.debug.layout=org.apache.log4j.PatternLayout
log4j.appender.debug.layout.ConversionPattern=[%-5p][%d{yyyy-MM-dd HH:mm:ss}] %c - %m%n
log4j.appender.debug.datePattern='.'yyyy-MM-dd
log4j.appender.debug.Threshold =DEBUG
log4j.appender.debug.append=true
log4j.appender.debug.File=${webApp.root}/logs/debug.log
log4j.logger.error=error
log4j.appender.error=org.apache.log4j.DailyRollingFileAppender
log4j.appender.error.layout=org.apache.log4j.PatternLayout
log4j.appender.error.layout.ConversionPattern=[%-5p][%d{yyyy-MM-dd HH:mm:ss}] %c - %m%n
log4j.appender.error.datePattern='.'yyyy-MM-dd
log4j.appender.error.Threshold =ERROR
log4j.appender.error.append=true
log4j.appender.error.File=${webApp.root}/logs/error.log
最后就是配置我们的web.xml文件,配置如下:
<?xml version="1.0"encoding="UTF-8"?>
<web-appxmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://java.sun.com/xml/ns/javaee"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaeehttp://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
version="3.0">
<display-name>Archetype Created WebApplication</display-name>
<context-param>
<param-name>webAppRootKey</param-name>
<param-value>webApp.root</param-value>
</context-param>
<!-- Spring和mybatis的配置文件-->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>
classpath:spring-mybatis.xml,
classpath:spring-quartz.xml
</param-value>
</context-param>
<!-- 编码过滤器 -->
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<async-supported>true</async-supported>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- Spring监听器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 防止Spring内存溢出监听器 -->
<listener>
<listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
</listener>
<!-- SpringMVC servlet -->
<servlet>
<servlet-name>SpringMVC</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-mvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
<async-supported>true</async-supported>
</servlet>
<servlet-mapping>
<servlet-name>SpringMVC</servlet-name>
<!-- 此处可以可以配置成*.do,对应struts的后缀习惯-->
<url-pattern>/</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>/index.jsp</welcome-file>
</welcome-file-list>
</web-app>
到此,我们的所有的配置已经配置好,接下来就可以开始搭建具体的项目了:
首先我们在vo包里面建立一个java类,命名为User.java,内容如下:
package com.fishroad.vo;
public class User {
private intid;
private Stringusername;
private Stringpassword;
private intage;
public intgetId() {
return id;
}
public voidsetId(int id) {
this.id = id;
}
public StringgetUsername() {
return username;
}
public voidsetUsername(String username) {
this.username = username;
}
public StringgetPassword() {
return password;
}
public voidsetPassword(String password) {
this.password = password;
}
public intgetAge() {
return age;
}
public voidsetAge(int age) {
this.age = age;
}
}
接下来在dao包里面建立接口IUserDao.java 和 UserMapper.xml这两个文件,
IUserDao.java 内容如下:
package com.fishroad.dao;
import com.fishroad.vo.User;
public interface IUserDao {
UserqueryUser();
}
UserMapper.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">
<mappernamespace="com.fishroad.dao.IUserDao">
<selectid="queryUser" parameterType="com.fishroad.vo.User"
resultType="com.fishroad.vo.User">
select t.id as id,
t.user_name as username,
t.age as age
from
user_t t
</select>
</mapper>
然后在services包里面建立接口IUserService.java 和 UserServiceImpl.java文件
IUserService.java的内容如下:
package com.fishroad.services;
import com.fishroad.vo.User;
public interface IUserService {
public UsergetUserById(int userId);
}
UserServiceImpl.java的内容如下:
package com.fishroad.services;
import javax.annotation.Resource;
importorg.springframework.beans.factory.annotation.Autowired;
importorg.springframework.stereotype.Service;
import com.fishroad.dao.IUserDao;
import com.fishroad.vo.User;
@Service("userService")
public class UserServiceImplimplements IUserService {
@Resource
privateIUserDao userDao;
public UsergetUserById(int userId) {
// TODO Auto-generated method stub
return this.userDao.queryUser();
}
}
然后在controller包中建立UserController.java文件,其内容如下:
package com.fishroad.controller;
import javax.annotation.Resource;
importjavax.servlet.http.HttpServletRequest;
import org.springframework.stereotype.Controller;
importorg.springframework.ui.Model;
importorg.springframework.web.bind.annotation.RequestMapping;
importcom.fishroad.services.IUserService;
import com.fishroad.vo.User;
@Controller
@RequestMapping("/user")
public class UserController {
@Resource
privateIUserService userService;
@RequestMapping("/showUser")
public StringtoIndex(HttpServletRequest request,Model model){
//int userId = Integer.parseInt(request.getParameter("id"));
int userId = 0;
User user = this.userService.getUserById(userId);
model.addAttribute("user", user);
return "showUser";
}
}
由于我们要配置定时任务,所有我们在service包里面单独写了一个类来实现,QuartzService.java,其内容如下:
package com.fishroad.services;
public class QuartzService {
/**
* 定时任务
*/
public voiddoJob(){
System.out.println("---------定时任务开始-------------");
System.out.println("---------正在执行定时任务!-------------");
System.out.println("---------定时任务结束-------------");
}
}
配置定时任务的文件spring-quartz.xml的内容如下:
<?xml version="1.0"encoding="UTF-8"?>
<beansxmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns: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-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 定时任务的配置文件 -->
<!-- 第1步和第4步公用,2、3步需要自定义 -->
<!-- 第一步:启动定时任务 -->
<beanclass="org.springframework.scheduling.quartz.SchedulerFactoryBean">
<property name="triggers">
<list>
<!-- 这里可以定义多个定时任务的Bean,每一个定时任务配置一个bean -->
<refbean="actJobTask"/>
<!-- 预存话费的定时任务 -->
<!-- <refbean="prestoreTask"/> -->
</list>
</property>
</bean>
<!-- 第二步 调度act定时任务,每1分钟轮询一次,这里的id属性就是第一步定义的bean属性 -->
<beanid="actJobTask"class="org.springframework.scheduling.quartz.CronTriggerBean">
<property name="jobDetail" ref="actJobMethod"/>
<property name="cronExpression" value="0/5 * * * *?"/>
</bean>
<!-- 第三步 配置act定时任务所引用的Bean和方法名,这里的id即为第二步的返回ref属性-->
<beanid="actJobMethod"class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
<property name="targetObject"ref="quartzTask"/>
<property name="targetMethod" value="doJob"/>
</bean>
<!-- 第四步 处理定时任务的Bean-->
<beanid="quartzTask"class="com.fishroad.services.QuartzService">
<!-- <property name="sysDateDao"ref="sysDateDao"/> -->
<!-- <property name="activityService"ref="activityService"/>
<property name="chargeService"ref="chargeService"/>
<property name="httpClient"ref="httpClient"></property>
<property name="prestoreService"ref="prestoreService"></property>
<property name="prestoreWebService"ref="prestoreWebServiceImpl"></property> -->
</bean>
</beans>
由于是web项目,所以我们肯定要写jsp,所以我就在web-inf目录下建立了jsp文件夹用来保存jsp文件,
新建一个jsp文件,命名为showUser.jsp,内容如下:
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>测试</title>
</head>
<body>
${user.username}
</body>
</html>
最后建立好的工程目录如下:
接下来就可以发布到tomcat中测试一下了;
数据库脚本如下:
/*
Navicat MySQL Data Transfer
SourceServer : localhost
Source Server Version : 50624
SourceHost :localhost:3306
SourceDatabase : db_test
Target ServerType : MYSQL
Target Server Version : 50624
FileEncoding : 65001
Date: 2015-07-01 16:33:21
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for user_t
-- ----------------------------
DROP TABLE IF EXISTS `user_t`;
CREATE TABLE `user_t` (
`id` int(11) NOT NULLAUTO_INCREMENT,
`user_name` varchar(40)NOT NULL,
`password` varchar(255)NOT NULL,
`age` int(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user_t
-- ----------------------------
INSERT INTO `user_t` VALUES ('1','2222测试3333','sfasgfaf', '24');
测试结果为:
定时任务如下:
源码下载地址:http://pan.baidu.com/s/1c0109BM
http://download.csdn.net/detail/fishroad/8858779