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

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" value="${jdbc.driverClassName}" /><property name="url" value="${jdbc.url}" /></bean><bean id="transactionManager" ref="dataSource" /></bean><bean id="sqlSessionFactory" value="classpath:mybatis-config.xml" /><property name="dataSource" ref="dataSource" /></bean>  <bean id="bookMapper" 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=InnoDBAUTO_INCREMENT=13 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'COMMENT='InnoDB free: 11264 kB';

?