SSM配置文件之applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       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/aop http://www.springframework.org/schema/aop/spring-aop.xsd
       http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
">
<!--配置扫描的基本包-->
    <context:component-scan base-package="com.yoso"/>
    <!--引入数据源配置文件-->
    <context:property-placeholder location="classpath:db.properties"/>
    <!--配置数据源-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>

    <!--配置事务管理器-->
    <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <!--配置SQLSession-->
    <bean id="sqlSession" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="configLocation" value="classpath:mybatis.xml"/>
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <!--配置MapperScannerConfigurer-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="sqlSession"/>
        <property name="basePackage" value="com.yoso.mapper"/>
    </bean>
    <!--配置事务增强-->
    <aop:config>
        <aop:pointcut id="mycut" expression="execution(* com.yoso.service..*.*(..))"/>
        <aop:advisor advice-ref="txAdvice" pointcut-ref="mycut"/>
    </aop:config>
    <tx:advice id="txAdvice" transaction-manager="txManager">
        <tx:attributes>
            <tx:method name="*add" propagation="REQUIRED"/>
            <tx:method name="*del" propagation="REQUIRED"/>
            <tx:method name="*update" propagation="REQUIRED"/>
            <tx:method name="*" read-only="true"/>
        </tx:attributes>
    </tx:advice>
</beans>
  • 1
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
好的,我知道了。以下是对应的代码实现: Product.java ```java public class Product { private int id; private String name; private double price; private int stock; // getter and setter methods } ``` ProductDao.java ```java public interface ProductDao { Product getProductById(int id); List<Product> getAllProducts(); void addProduct(Product product); void updateProduct(Product product); void deleteProduct(int id); } ``` ProductMapper.xml ```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="com.example.dao.ProductDao"> <resultMap id="productResultMap" type="com.example.model.Product"> <id column="id" property="id"/> <result column="name" property="name"/> <result column="price" property="price"/> <result column="stock" property="stock"/> </resultMap> <select id="getProductById" resultMap="productResultMap"> SELECT * FROM product WHERE id = #{id} </select> <select id="getAllProducts" resultMap="productResultMap"> SELECT * FROM product </select> <insert id="addProduct"> INSERT INTO product(name, price, stock) VALUES(#{name}, #{price}, #{stock}) </insert> <update id="updateProduct"> UPDATE product SET name=#{name}, price=#{price}, stock=#{stock} WHERE id=#{id} </update> <delete id="deleteProduct"> DELETE FROM product WHERE id=#{id} </delete> </mapper> ``` applicationContext.xml ```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: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-4.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd"> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/ssm"/> <property name="username" value="root"/> <property name="password" value="root"/> </bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <property name="configLocation" value="classpath:mybatis-config.xml"/> <property name="mapperLocations" value="classpath:mappers/*.xml"/> </bean> <bean id="productDao" class="org.mybatis.spring.mapper.MapperFactoryBean"> <property name="mapperInterface" value="com.example.dao.ProductDao"/> <property name="sqlSessionFactory" ref="sqlSessionFactory"/> </bean> </beans> ``` mybatis-config.xml ```xml <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd" > <configuration> <settings> <setting name="cacheEnabled" value="true"/> <setting name="lazyLoadingEnabled" value="true"/> <setting name="multipleResultSetsEnabled" value="true"/> <setting name="useColumnLabel" value="true"/> <setting name="useGeneratedKeys" value="false"/> <setting name="defaultExecutorType" value="SIMPLE"/> <setting name="defaultStatementTimeout" value="25"/> <setting name="jdbcTypeForNull" value="NULL"/> <setting name="logImpl" value="STDOUT_LOGGING"/> </settings> </configuration> ``` ProductController.java ```java @Controller public class ProductController { @Autowired private ProductDao productDao; @RequestMapping(value = "/test", method = RequestMethod.GET) public String test() { Product product = new Product(); product.setName("Test Product"); product.setPrice(100.0); product.setStock(10); productDao.addProduct(product); product.setPrice(200.0); productDao.updateProduct(product); Product product2 = productDao.getProductById(product.getId()); System.out.println(product2.getName()); List<Product> productList = productDao.getAllProducts(); for (Product p : productList) { System.out.println(p.getName()); } productDao.deleteProduct(product.getId()); return "test"; } } ``` ProductControllerTest.java ```java @RunWith(SpringJUnit4ClassRunner.class) @ContextConfiguration(locations = {"classpath:applicationContext.xml"}) public class ProductControllerTest { @Autowired private ProductController productController; @Test public void test() { productController.test(); } } ```

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值