mybatis+spring+struts2 整合的简单实例

自己写的 mybatis+spring+struts2

<!--l version="1.0" encoding="UTF-8-->

<!-- 导入属性配置文件 -->

<?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:aop="http://www.springframework.org/schema/aop"      
      xmlns:tx="http://www.springframework.org/schema/tx"       
      xmlns:jdbc="http://www.springframework.org/schema/jdbc"       
      xmlns:context="http://www.springframework.org/schema/context"      
      xsi:schemaLocation="       
      http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd       
      http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd       
      http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-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"      
     default-autowire="byName">
   <context:annotation-config />
	<!-- 导入属性配置文件 -->
	<context:property-placeholder location="classpath:mysql.properties" />
    <context:component-scan base-package="com.dou.book" />
	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="${jdbc.driverClassName}" />
		<property name="url" value="${jdbc.url}" />
	</bean>

	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource" />
	</bean>

	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="configLocation" value="classpath:mybatis-config.xml" />
		<property name="dataSource" ref="dataSource" />
	</bean>
  <bean id="bookMapper" class="org.mybatis.spring.MapperFactoryBean">
        <property name="sqlSessionFactory" ref="sqlSessionFactory" />
	    <property name="mapperInterface" value="com.dou.book.data.ISBookMapper"/>		
	</bean>
	

   
	
</beans>

 

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4" xmlns="http://java.sun.com/xml     /ns/j2ee"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee   http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">

	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>

	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>/WEB-INF/applicationContext-*.xml,classpath*:applicationContext-*.xml</param-value>
	</context-param>
	
	  <context-param>
	    <param-name>log4jConfigLocation</param-name>
	    <param-value>/WEB-INF/log4j.properties</param-value>
	  </context-param>	
  <!-- 每隔60秒检测一下Lo4j配置文件 -->
	  <context-param>   
	  	<param-name>log4jRefreshInterval</param-name>   
	    <param-value>60000</param-value>   
	  </context-param>  

	  <listener>   
	  	<listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>   
	  </listener> 
	<filter>
		<filter-name>struts-cleanup</filter-name>
		<filter-class>
			org.apache.struts2.dispatcher.ActionContextCleanUp
		</filter-class>
	</filter>
	<filter>
		<filter-name>struts2.0</filter-name>
		<filter-class>org.apache.struts2.dispatcher.FilterDispatcher</filter-class>
	</filter>
	<filter-mapping>
		<filter-name>struts-cleanup</filter-name>
		<url-pattern>*.do</url-pattern>
		<url-pattern>*.htm</url-pattern>
		<url-pattern>*.action</url-pattern>
		<url-pattern>*.jsp</url-pattern>
	</filter-mapping>

	<filter-mapping>
		<filter-name>struts2.0</filter-name>
		<url-pattern>*.do</url-pattern>
		<url-pattern>*.htm</url-pattern>
		<url-pattern>*.action</url-pattern>
		<url-pattern>*.jsp</url-pattern>
	</filter-mapping>
	
	<servlet>
		<servlet-name>RandImg</servlet-name>
		<servlet-class>com.web.PictureCheckCode</servlet-class>
	</servlet>
	<servlet-mapping>
		<servlet-name>RandImg</servlet-name>
		<url-pattern>/RandImg</url-pattern>
	</servlet-mapping>
	
	
	<welcome-file-list>
		<welcome-file>index.jsp</welcome-file>
	</welcome-file-list>
	<login-config>
		<auth-method>BASIC</auth-method>
	</login-config>
</web-app>

 SQL

CREATE TABLE `sbook` (
  `id` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(50) COLLATE utf8_general_ci DEFAULT NULL,
  `author` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL,
  `total` INTEGER(11) DEFAULT NULL,
  `price` FLOAT DEFAULT NULL,
  `isbn` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL,
  `publisher` VARCHAR(50) COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
)ENGINE=InnoDB
AUTO_INCREMENT=13 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
COMMENT='InnoDB free: 11264 kB';

 

评论

6 楼 STC89C52 2012-11-09  

不错。。

5 楼 bjsoftwarefxs 2011-09-19  

不错，我给你顶下呵呵

4 楼 tony_jingzhou 2011-09-08  

你的struts？处理类？代码没贴完 ？

3 楼 一点粉红 2011-05-21  

我下载了解下～

2 楼 yanxunjian 2011-05-02  

怎么没有人发表自己的意见呢？

1 楼 yanxunjian 2011-05-02  

怎么没有人 参与呢？
自己先顶顶自己