spring MVC一

meiyx

浏览: 183626 次
性别:
来自: 北京

最近访客更多访客>>

fybing1986

lesliehanhan

wtm_mac

wjj0320223

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

Spring MVC Oracle JBoss JDBC

下面我以我完成的web项目讲下spring的mvc以方便我以后忘记使用以及能够帮助大家！
1 配置web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
	http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
	<welcome-file-list>
		<welcome-file>index.jsp</welcome-file>
	</welcome-file-list>

	<!-- Log4j listener config -->
	<context-param>
		<param-name>log4jConfigLocation</param-name>
		<param-value>/WEB-INF/log4j.xml</param-value>
	</context-param>
	<context-param>
		<param-name>webAppRootKey</param-name>
		<param-value>epscc.root</param-value>
	</context-param>
	<listener>
		<listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
	</listener>

	<!--  Spring 服务层的配置文件 -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>
        	classpath:cpcms-config.xml  
        	classpath:cpcms-mq-producer.xml  	
        </param-value>
	</context-param>
	<!--  Spring 容器启动监听器 -->
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>

	<servlet>
		<servlet-name>spring</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<load-on-startup>1</load-on-startup>
	</servlet>
	<servlet-mapping>
		<servlet-name>spring</servlet-name>
		<url-pattern>/</url-pattern>
	</servlet-mapping>
	
	<filter>
		<filter-name>SecurityFilter</filter-name>
		<filter-class>com.lenovo.lps.epub.cc.util.SecurityFilter</filter-class>		
	</filter>
	<filter-mapping>
		<filter-name>SecurityFilter</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>
	
	
	<!-- 编码过滤-->
	<filter>
		<filter-name>springCharacterEncodingFilter</filter-name>
		<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
		<init-param>
			<param-name>forceEncoding</param-name>
			<param-value>true</param-value>
		</init-param>
		<init-param>
			<param-name>encoding</param-name>
			<param-value>UTF-8</param-value>
		</init-param>
	</filter>
	<filter-mapping>
		<filter-name>springCharacterEncodingFilter</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>

	<!-- 获取分页参数 -->
	<filter>
		<filter-name>pageFilter</filter-name>
		<filter-class>com.lenovo.lps.epub.cc.util.PageFilter</filter-class>
	</filter>
	<filter-mapping>
		<filter-name>pageFilter</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>


	<filter>                                                     
		<filter-name>HiddenHttpMethodFilter</filter-name>
		<filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>
	</filter>
	<filter-mapping>
		<filter-name>HiddenHttpMethodFilter</filter-name>
		<servlet-name>spring</servlet-name>
	</filter-mapping>

	<servlet-mapping>
		<servlet-name>default</servlet-name>
		<url-pattern>*.js</url-pattern>
		<url-pattern>*.css</url-pattern>
		<url-pattern>*.gif</url-pattern>
		<url-pattern>*.jpg</url-pattern>
		<url-pattern>*.png</url-pattern>
		<url-pattern>*.bmp</url-pattern>
		<url-pattern>*.ico</url-pattern>
		<url-pattern>*.html</url-pattern>
	</servlet-mapping>


	<error-page>
		<error-code>404</error-code>
		<location>/jsp/error/error.jsp</location>
	</error-page>

	<error-page>
		<error-code>500</error-code>
		<location>/jsp/error/error.jsp</location>
	</error-page>
</web-app>
以上的具体含义就不解释了，干这行的估计一看就明白了

因为我们将DispatcherServlet命名为spring,所以我们需要在web-inf目录下面简历一个名为：spring-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: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.0.xsd   
           http://www.springframework.org/schema/context    
           http://www.springframework.org/schema/context/spring-context-3.0.xsd
           http://www.springframework.org/schema/mvc 
		   http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">


	<!--  启动Spring MVC的注解功能，完成请求和注解POJO的映射 即控制控制层的方法，使一个action中可以配置多个请求路径 -->
	<bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter" />
	
	<!--全文扫描-->
	<context:component-scan base-package="com.lenovo.lps.epub.cc.controller"/>
	

	<!--  对模型视图名称的解析，在请求时模型视图名称添加前后缀-->
	<bean
		class="org.springframework.web.servlet.view.InternalResourceViewResolver"
		p:prefix="/jsp/" p:suffix=".jsp" />
	  
	<!-- 异常处理 -->
    <bean id="exceptionResolver" class="org.springframework.web.servlet.handler.SimpleMappingExceptionResolver">
	  <property name="exceptionMappings">
	     <props>
	        <prop key="java.lang.Exception">error/error</prop>
	    </props>
	  </property>
	</bean>
		
	<!-- 文件上传-->
	<bean id="multipartResolver"
		class="org.springframework.web.multipart.commons.CommonsMultipartResolver"
		p:defaultEncoding="utf-8"/>
</beans>

<context:component-scan/> 配置项不但启用了对类包进行扫描以实施注释驱动 Bean 定义的功能，同时还启用了注释驱动自动注入的功能（即还隐式地在内部注册了 AutowiredAnnotationBeanPostProcessor 和 CommonAnnotationBeanPostProcessor），因此当使用 <context:component-scan/> 后，就可以将 <context:annotation-config/> 移除了。

<context:component-scan/> 的 base-package 属性指定了需要扫描的类包，类包及其递归子包中所有的类都会被处理。

spring-servlet.xml主要是对controller的控制，InternalResourceViewResolver
类告诉大家在controller方法中 return "XX"首先会在/jsp下查找XX.jsp。如果有则跳转到该页面，没有报异常。

我们在web.xml中告诉大家 Spring 容器启动监听器 ContextLoadListener,那么我们还差一两个重要的配置文件，一个是数据库配置文件一个是config.xml配置文件，数据配置文件我们可以直接在容器jboss和tomcat中配置jndi，然后在config.xml中指定相应的数据源和SimpleJdbcTemplate。
jboss-jndi-c3p0配置.txt：

1.将c3p0-0.9.1.2.jar和ojdbc6.jar拷贝到%JBOSS_HOME%/server/default/lib

2.在应用服务器（jboss）添加c3p0-service.xml文件，路径：%JBOSS_HOME%/server/default/deploy/，内容如下

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

<server>
   <mbean code="com.mchange.v2.c3p0.mbean.C3P0PooledDataSource" name="jboss:service=C3P0PooledDataSource_blog">
      <attribute name="JndiName">jdbc/pool_blog</attribute>
      <attribute name="JdbcUrl">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.100.120.158)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=rac1.lenovomm.com)(SERVER=DEDICATED)))</attribute>
      <attribute name="DriverClass">oracle.jdbc.driver.OracleDriver</attribute>
      <attribute name="User">EPSBLOG</attribute>
      <attribute name="Password">lenovo</attribute>
      <attribute name="MinPoolSize">1</attribute>
      <attribute name="MaxPoolSize">200</attribute>
      <attribute name="AcquireIncrement">10</attribute>
      <attribute name="IdleConnectionTestPeriod">120</attribute>
      <attribute name="CheckoutTimeout">1800</attribute>
      <depends>jboss:service=Naming</depends>
   </mbean>

	 <mbean code="com.mchange.v2.c3p0.mbean.C3P0PooledDataSource" name="jboss:service=C3P0PooledDataSource_biz">
      <attribute name="JndiName">jdbc/pool_biz</attribute>
      <attribute name="JdbcUrl">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.100.120.158)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=rac1.lenovomm.com)(SERVER=DEDICATED)))</attribute>
      <attribute name="DriverClass">oracle.jdbc.driver.OracleDriver</attribute>
      <attribute name="User">EPSBIZ</attribute>
      <attribute name="Password">lenovo</attribute>
      <attribute name="MinPoolSize">1</attribute>
      <attribute name="MaxPoolSize">200</attribute>
      <attribute name="AcquireIncrement">10</attribute>
      <attribute name="IdleConnectionTestPeriod">120</attribute>
      <attribute name="CheckoutTimeout">1800</attribute>
      <depends>jboss:service=Naming</depends>
   </mbean>
   
   <mbean code="com.mchange.v2.c3p0.mbean.C3P0PooledDataSource" name="jboss:service=C3P0PooledDataSource_bill">
      <attribute name="JndiName">jdbc/pool_bill</attribute>
      <attribute name="JdbcUrl">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.100.120.158)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=rac1.lenovomm.com)(SERVER=DEDICATED)))</attribute>
      <attribute name="DriverClass">oracle.jdbc.driver.OracleDriver</attribute>
      <attribute name="User">EPSBILL</attribute>
      <attribute name="Password">lenovo</attribute>
      <attribute name="MinPoolSize">1</attribute>
      <attribute name="MaxPoolSize">200</attribute>
      <attribute name="AcquireIncrement">10</attribute>
      <attribute name="IdleConnectionTestPeriod">120</attribute>
      <attribute name="CheckoutTimeout">1800</attribute>
      <depends>jboss:service=Naming</depends>
   </mbean>

</server>

3.修改各子系统中spring的xml中关于dataSource的定义，如下：

<bean id="dataSource_blog" class="org.springframework.jndi.JndiObjectFactoryBean">   
		<property name="jndiName" value="jdbc/pool_blog"/>   
</bean>

<bean id="dataSource_bill" class="org.springframework.jndi.JndiObjectFactoryBean">   
		<property name="jndiName" value="jdbc/pool_bill"/>   
</bean>

<bean id="dataSource_biz" class="org.springframework.jndi.JndiObjectFactoryBean">   
		<property name="jndiName" value="jdbc/pool_biz"/>   
</bean>

注：value="jdbc/pool_blog"，与c3p0-service.xml里定义的JndiName对应。

4.删除各项目中原bean id="dataSource_blog",bean id="dataSource_biz",bean id="dataSource_bill"等定义，
  删除数据库文件引用<value>classpath*:jdbc.properties</value>，<value>classpath*:jdbc_*.properties</value>等
  删除相应的数据库属性文件jdbc_*.properties，jdbc.properties等

config.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:tx="http://www.springframework.org/schema/tx"
	xmlns:aop="http://www.springframework.org/schema/aop"

	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/tx   
      	   http://www.springframework.org/schema/tx/spring-tx-3.0.xsd   
       	   http://www.springframework.org/schema/aop   
      	   http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">

	<!-- 配置事务bean -->
	<bean id="transactionManager"
		class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource_biz" />
	</bean>
	<tx:annotation-driven proxy-target-class="true" />

	<bean id="propertyConfigurer"
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="locations">
			<list>
				<value>classpath*:sql_cc.properties</value>
				<value>classpath*:pagination.properties</value>
				<value>classpath*:fileupload.properties</value>
			</list>
		</property>
	</bean>

	<!-- datasource -->
	<bean id="dataSource_biz" class="org.springframework.jndi.JndiObjectFactoryBean">
		<property name="jndiName" value="jdbc/pool_biz" />
	</bean>

	<bean id="dataSource_bill" class="org.springframework.jndi.JndiObjectFactoryBean">
		<property name="jndiName" value="jdbc/pool_bill" />
	</bean>

	<bean id="dataSource_blog" class="org.springframework.jndi.JndiObjectFactoryBean">
		<property name="jndiName" value="jdbc/pool_blog" />
	</bean>

	<!-- biz jdbctemplate -->
	<bean id="jdbcTemplate_biz" class="org.springframework.jdbc.core.simple.SimpleJdbcTemplate">
		<constructor-arg index="0" ref="dataSource_biz" />
	</bean>

	<!-- blog jdbctemplate -->
	<bean id="jdbcTemplate_blog" class="org.springframework.jdbc.core.simple.SimpleJdbcTemplate">
		<constructor-arg index="0" ref="dataSource_blog" />
	</bean>

	<!-- bill jdbctemplate -->
	<bean id="jdbcTemplate_bill" class="org.springframework.jdbc.core.simple.SimpleJdbcTemplate">
		<constructor-arg index="0" ref="dataSource_bill" />
	</bean>

	

	<!-- 请放置在文件末尾 -->
	<context:component-scan base-package="com.lenovo.lps.epub.cc.*">
		<!--
			<context:exclude-filter type="regex" expression=".*Controller$" />
		-->
		<context:exclude-filter type="annotation"
			expression="org.springframework.stereotype.Controller" />
	</context:component-scan>

</beans>

属性文件时根据项目需要放在classpath中的，我这里一个是读取数据库sql的文件，一个是有关分页的，另一个是和文件上传相关的。
接下来就可以写代码了。

分享到：