接着上一篇写。到上一篇为止jar包和环境都已经ok,那么就是写代码了。
maven的工程有些奇怪,我熟悉了一下才习惯。首先看项目结构,这个项目结构和web项目结构比起来多了个resources。这个resources用来存放xml文件和配置文件,其路径相当于classes。
好了,现在就是关键的地方,新增spring-core.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"
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">
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName">
<value>oracle.jdbc.OracleDriver</value>
</property>
<property name="url">
<value>jdbc:oracle:thin:@localhost:1521:testdev</value>
</property>
<property name="username">
<value>test</value>
</property>
<property name="password">
<value>test</value>
</property>
<property name="maxActive">
<value>5</value>
</property>
<property name="maxWait">
<value>5000</value>
</property>
</bean>
</beans>
如你所见,上面是数据库连接配置文件,我将数据库文件与MyBatis的配置分开,主要是因为数据库不一样。
<?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"
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-scan base-package="com.test" />
<!-- spring和MyBatis完美整合,不需要mybatis的配置映射文件 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- 自动扫描mapping.xml文件 -->
<property name="mapperLocations" value="classpath:com/test/mapping/*.xml"></property>
</bean>
<!-- DAO接口所在包名,Spring会自动查找其下的类 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.test.dao" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>
<!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<span style="white-space:pre"> </span><tx:annotation-driven transaction-manager="transactionManager" />
<span style="white-space:pre"> </span><!-- 事务传播属性 -->
<span style="white-space:pre"> </span><tx:advice id="transactionAdvice" transaction-manager="transactionManager">
<span style="white-space:pre"> </span><tx:attributes>
<span style="white-space:pre"> </span><tx:method name="get*" read-only="true" propagation="REQUIRED" />
<span style="white-space:pre"> </span><tx:method name="find*" read-only="true" propagation="REQUIRED" />
<span style="white-space:pre"> </span><tx:method name="save*" propagation="REQUIRED" />
<span style="white-space:pre"> </span><tx:method name="update*" propagation="REQUIRED" />
<span style="white-space:pre"> </span><tx:method name="remove*" propagation="REQUIRED" />
<span style="white-space:pre"> </span><tx:method name="add*" propagation="REQUIRED" />
<span style="white-space:pre"> </span><tx:method name="*" />
<span style="white-space:pre"> </span></tx:attributes>
<span style="white-space:pre"> </span></tx:advice>
<span style="white-space:pre"> </span><!-- 切面,将事物用在哪些对象上 -->
<span style="white-space:pre"> </span><aop:config>
<span style="white-space:pre"> </span><aop:pointcut id="transactionPointcut"
<span style="white-space:pre"> </span>expression="execution(* cn.test.facade.*Facade.*(..))" />
<span style="white-space:pre"> </span><aop:advisor pointcut-ref="transactionPointcut"
<span style="white-space:pre"> </span>advice-ref="transactionAdvice" />
<span style="white-space:pre"> </span></aop:config>
</beans>
好了,配置完成这个基本上就没有啥配置文件了,事实上整合也完成了,如你所见就是这么简单,剩下的就是验证工作。
数据库我用的我现成的oracle,随便挑了一张有数据的表b_jg0101。中间的字段也无所谓。只需要bo中的字段与其对应就行。写完代码解构如下:
我这里卡住了不少时间,主要是mybatis配置文件这一块。Bjg0101.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,namespace的值习惯上设置成包名+sql映射文件名,这样就能够保证namespace的值是唯一的
例如namespace="me.gacl.mapping.userMapper"就是me.gacl.mapping(包名)+userMapper(userMapper.xml文件去除后缀)
-->
<mapper namespace="com.test.dao.Bjg0101Dao">
<!-- 在select标签中编写查询的SQL语句, 设置select标签的id属性为getUser,id属性值必须是唯一的,不能够重复
使用parameterType属性指明查询时使用的参数类型,resultType属性指明查询返回的结果集类型
resultType="me.gacl.domain.User"就表示将查询结果封装成一个User类的对象返回
User类就是users表所对应的实体类
-->
<!--
根据id查询得到一个bo对象
-->
<select id="findBjByPk" parameterType="int" resultType="com.test.bo.BJg0101">
select * from b_jg0101 where jzgbh=#{jzgbh}
</select>
</mapper>
dao文件如下,这里dao其实按mybatis的说法应该叫mapper
package com.test.dao;
import com.test.bo.BJg0101;
public interface Bjg0101Dao {
//此处方法名称必须和select 的id一致 方法参数需要和parameterType类型一致 返回值与resultType一致
public BJg0101 findBjByPk(Integer jzgbh);
}
写好这个对于myBatis就没啥了,看下能否拿到bean还是要写service,service接口和实现如下:
package com.test.service;
import com.test.bo.BJg0101;
public interface QueryDateService {
public BJg0101 findBj0101(String name);
}
package com.test.service.impl;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import com.test.bo.BJg0101;
import com.test.dao.Bjg0101Dao;
import com.test.service.QueryDateService;
@Service("queryDateService")
public class QueryDateServiceImpl implements QueryDateService{
@Resource
private Bjg0101Dao bjg0101Dao;
@Override
public BJg0101 findBj0101(String name) {
return this.bjg0101Dao.findBjByPk(Integer.valueOf(name));
}
}
这里并没有什么需要注意的,唯一麻烦的就是junit测试类了。如下
package one;
import javax.annotation.Resource;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import com.alibaba.fastjson.JSON;
import com.test.bo.BJg0101;
import com.test.service.QueryDateService;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = {"classpath*:/core/spring-core.xml","classpath*:/core/spring-mybatis.xml"})
public class TestMyBatis {
private ApplicationContext ac = null;
@Resource
private QueryDateService queryDateService;
@Before
public void before() {
ac = new ClassPathXmlApplicationContext("/core/spring-core.xml","/core/spring-mybatis.xml");
queryDateService = (QueryDateService) ac.getBean("queryDateService");
}
@Test
public void test1() {
BJg0101 user = queryDateService.findBj0101("7847");
System.out.println(JSON.toJSONString(user));
}
}
spring加载bean然后去调用,直接返回结果。请注意,我这里全部没有throw异常,所以如果发现程序跑不通,bebug进去或者抛异常出来都可以。
我为了调试还是加了个log4j.properties,在引用log4j的jar包之后只需要加入log4j配置即可生效。
#\u5B9A\u4E49LOG\u8F93\u51FA\u7EA7\u522B
log4j.rootLogger=INFO,Console,File
#\u5B9A\u4E49\u65E5\u5FD7\u8F93\u51FA\u76EE\u7684\u5730\u4E3A\u63A7\u5236\u53F0
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.Target=System.out
#\u53EF\u4EE5\u7075\u6D3B\u5730\u6307\u5B9A\u65E5\u5FD7\u8F93\u51FA\u683C\u5F0F\uFF0C\u4E0B\u9762\u4E00\u884C\u662F\u6307\u5B9A\u5177\u4F53\u7684\u683C\u5F0F
log4j.appender.Console.layout = org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=[%c] - %m%n
#\u6587\u4EF6\u5927\u5C0F\u5230\u8FBE\u6307\u5B9A\u5C3A\u5BF8\u7684\u65F6\u5019\u4EA7\u751F\u4E00\u4E2A\u65B0\u7684\u6587\u4EF6
log4j.appender.File = org.apache.log4j.RollingFileAppender
#\u6307\u5B9A\u8F93\u51FA\u76EE\u5F55
log4j.appender.File.File = logs/ssm.log
#\u5B9A\u4E49\u6587\u4EF6\u6700\u5927\u5927\u5C0F
log4j.appender.File.MaxFileSize = 10MB
# \u8F93\u51FA\u6240\u4EE5\u65E5\u5FD7\uFF0C\u5982\u679C\u6362\u6210DEBUG\u8868\u793A\u8F93\u51FADEBUG\u4EE5\u4E0A\u7EA7\u522B\u65E5\u5FD7
log4j.appender.File.Threshold = ALL
log4j.appender.File.layout = org.apache.log4j.PatternLayout
log4j.appender.File.layout.ConversionPattern =[%p] [%d{yyyy-MM-dd HH\:mm\:ss}][%c]%m%n
好了,到目前为止,spring和mybatis的整合测试已经完成,看起来这么简单一点东西,硬是一天没搞完,周末已经过去,还好以前做过spirng mvc配置配一下,上班之后抽时间测试一下好了。
新增一个spring-mvc.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"
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.test" />
<!--避免IE执行AJAX时,返回JSON出现下载文件 -->
<bean id="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>
<ref bean="mappingJacksonHttpMessageConverter" /> <!-- JSON转换器 -->
</list>
</property>
</bean>
<!-- 定义跳转的文件的前后缀 ,视图模式配置-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!-- 这里的配置我的理解是自动给后面action的方法return的字符串加上前缀和后缀,变成一个 可用的url地址 -->
<property name="prefix" value="/" />
<property name="suffix" value=".jsp" />
</bean>
<!-- 配置文件上传,如果没有使用文件上传可以不用配置,当然如果不配,那么配置文件中也不必引入上传组件包 -->
<bean id="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>
配置web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://java.sun.com/xml/ns/javaee"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
version="3.0">
<display-name>Archetype Created Web Application</display-name>
<!-- Spring和mybatis的配置文件 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:core/spring-core.xml,classpath:core/spring-mybatis.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>
<!-- Spring MVC 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:core/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>*.go</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>/index.jsp</welcome-file>
</welcome-file-list>
</web-app>
看样子已经可以启动了。
好吧,还是报错了。
java.lang.ClassNotFoundException: org.springframework.web.util.IntrospectorCleanupListener
纳闷的错误,看起来是包没放在serves服务器上面,检查下自动编译,无意中点了下add,发现竟然有个maven的东西。
选中项目->右键Properties->选择Deployment Assemby->选择Add->选中Java Build Path Entries->Next->选择Maven Dependencies->Finish->Apply->OK
意料以外的错误,再启动。ok
结果正确。好了目前为止整合是完成了,但是没有加事物管理,没有加公司框架。嗯,慢慢来。
我们来看下最终结果的文件
嗯,最后增加了一个testAction.java和test.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>
${abc.jgms}
</body>
</html>
package com.test.web;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import com.test.bo.BJg0101;
import com.test.service.QueryDateService;
@Controller
@RequestMapping("/testAction")
public class TestAction {
@Resource
private QueryDateService queryDateService;
@RequestMapping("/show")
public String toIndex(HttpServletRequest request,Model model){
String jzgbh = request.getParameter("jzgbh");
BJg0101 bo = this.queryDateService.findBj0101(jzgbh);
model.addAttribute("abc", bo);
return "common/test";
}
}
嗯,除了bo的代码没有公布,其他代码都贴出来了。ok。ssm的整合笔记到此为止了,剩下的就是实战了。