环境搭建
创建项目动态网络工程
引入jar包
- 全部jar包,包含MySql和Oracle驱动包
db.properties配置数据库连接文件
oracle_driver=oracle.jdbc.driver.OracleDriver
oracle_url=jdbc:oracle:thin:@localhost:1521:XE
oracle_username=system
oracle_password=dhee
- mybatis-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration SYSTEM "com/dhee/dtd/mybatis-3-config.dtd" >
<configuration>
<settings>
<!-- 开启驼峰命名规则,如果表中的列名为:employee_id,则mybatis可以自动对应到类中名为employeeId的成员变量 -->
<setting name="mapUnderscoreToCamelCase" value="true"/>
</settings>
</configuration>
- springmvc.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: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.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd">
<!-- 配置自动扫描的包 -->
<context:component-scan base-package="com.dhee.ssm"></context:component-scan>
<!-- 配置视图解析器 如何把handler 方法返回值解析为实际的物理视图 -->
<bean
class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/views/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
<mvc:annotation-driven></mvc:annotation-driven>
<mvc:default-servlet-handler></mvc:default-servlet-handler>
</beans>
- applicationContext.xml加载数据源,在Spring添加mybatis,使用Spring的事务管理,
<?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: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.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
<!-- 加载db.properties -->
<context:property-placeholder location="classpath:db.properties" />
<!-- 配置数据源 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
<property name="driverClass" value="${oracle_driver}" />
<property name="jdbcUrl" value="${oracle_url}" />
<property name="user" value="${oracle_username}" />
<property name="password" value="${oracle_password}" />
</bean>
<!-- sqlSessionFactory(在Spring中添加mybatis) -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- 需要修改mybatis配置文件路径 -->
<property name="configLocation" value="classpath:mybatis/mybatis-config.xml" />
</bean>
<!-- mapper扫描器(配置mybatis生成的接口与xxxMapper.xml文件的位置) -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!-- 需要修改位置,可能需要创建包 -->
<property name="basePackage" value="com.dhee.ssm.mapper"></property>
</bean>
<!-- 使用spring的事务管理 -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<!-- 通知 -->
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<!-- 以下3种方法出现异常时需要rollback -->
<tx:method name="insert*" propagation="REQUIRED" read-only="false"
rollback-for="java.lang.Exception" />
<tx:method name="delete*" propagation="REQUIRED" read-only="false"
rollback-for="java.lang.Exception" />
<tx:method name="update*" propagation="REQUIRED" read-only="false"
rollback-for="java.lang.Exception" />
<!-- 以下4种方法不需要进行事务管理 -->
<tx:method name="find*" propagation="SUPPORTS" read-only="true" />
<tx:method name="get*" propagation="SUPPORTS" read-only="true" />
<tx:method name="select*" propagation="SUPPORTS" read-only="true" />
<tx:method name="list*" propagation="SUPPORTS" read-only="true" />
</tx:attributes>
</tx:advice>
<!-- aop,需要修改位置 -->
<aop:config>
<aop:advisor advice-ref="txAdvice"
pointcut="execution(* com.dhee.springmvc.service.*.*(..))" />
</aop:config>
<!-- 自动扫描Service,需要修改位置 -->
<!-- <context:component-scan base-package="com.dhee.springmvc.service"></context:component-scan> -->
</beans>
- web.xml配置Spring,配置前端控制器,配置Spring自带的解决乱码的过滤器
<?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"
id="WebApp_ID" version="3.0">
<display-name>testsystem</display-name>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<!-- 配置Spring -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring/applicationContext.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- SpringMVC自带用于解决乱码的过滤器 -->
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<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>
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:/spring/springmvc.xml</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
- 用例驱动
- 向items表中插入输入的数据,成功跳转到success页面,页面显示success
- 页面定义
- index.jsp
<body>
<!-- name的命名必须和定义的实体类一致,
其中实体类属性的命名要和数据库的保持一致 -->
<form action="items/insertItems" method="post">
<input type="text" name="itemsName"/>
<input type="text" name="itemsPrice"/>
<input type="text" name="itemsDetails"/>
<input type="submit" value="插入"/>
</form>
- 实体类创建
- Items.java
public class Items {
private Short itemsId;
private String itemsName;
private BigDecimal itemsPrice;
private String itemsDetails;
- mapper定义
- ItemsCustomMapper.java
public interface ItemsCustomMapper {
public void insert(Items items) throws Exception;
}
- mapper对应的xml文件定义
- ItemsCustomMapper.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" >
<!-- namespace:指向对应的mapper接口 -->
<mapper namespace="com.dhee.ssm.mapper.ItemsCustomMapper" >
<!-- id要和mapper接口定义的方法名保持一致
parameterType:接收的数据类型 -->
<insert id = "insert" parameterType="com.dhee.ssm.po.Items">
insert into items (items_id,items_name,items_price,items_details)
values (items_id_seq.nextval,#{itemsName},#{itemsPrice},#{itemsDetails})
</insert>
</mapper>
- service和controller的定义
@Service
public class ItemsInsertService {
@Autowired
private ItemsCustomMapper mapper;
public void insert(Items items) throws Exception{
mapper.insert(items);
}
}
public class ItemsController {
@Autowired
private ItemsInsertService service;
@RequestMapping(value="/insert")
public String insert(Items record){
try {
service.insert(record);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return "success";
}
}
- END