junit applicationContext.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:tx="http://www.springframework.org/schema/tx"
 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
 http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd"
>

<!--
 <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
  <property name="driverClassName" value="org.apache.derby.jdbc.ClientDriver">
  </property>
  <property name="url" value="jdbc:derby://localhost:1527/myeclipse">
  </property>
  <property name="username" value="classiccars"></property>
  <property name="password" value="myeclipse"></property>
 </bean>
 
 <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
  <property name="jndiName">
   <value>java:/handpay</value>
  </property>
 </bean>-->
 
 
 <bean id="dataSource"
  class="org.apache.commons.dbcp.BasicDataSource">
  <property name="driverClassName"
   value="oracle.jdbc.driver.OracleDriver">
  </property>
  <property name="url"
   value="jdbc:oracle:thin:@10.48.196.4:1521:hpdb">
  </property>
  <property name="username" value="appl"></property>
  <property name="password" value="appl01"></property>
 </bean>
 
 <bean id="transactionManager"
  class="org.springframework.orm.hibernate3.HibernateTransactionManager">
  <property name="sessionFactory" ref="sessionFactory" />
 </bean>
 <bean id="sessionFactory"
  class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
  <property name="dataSource">
   <ref bean="dataSource" />
  </property>
   <property name="mappingResources">
   <list>
    <value>com/***/Product.hbm.xml</value>
   </list>
  </property>
  <property name="hibernateProperties">
   <props>
    <prop key="hibernate.dialect">
     org.hibernate.dialect.Oracle10gDialect
    </prop>
   </props>
  </property>
  <!-- 
  <property name="annotatedClasses">
   <list>
    <value>
     com.*.sample.hibernate.domain.Product
    </value>
   </list>
  </property>-->
 </bean>
 <bean id="productDao" class="com.***.ProductDAOImpl">
  <property name="sessionFactory">
   <ref bean="sessionFactory" />
  </property>
 </bean>
 
  <tx:annotation-driven transaction-manager="transactionManager"/>
 
 
 <!--<tx:advice id="transAdvice">
  <tx:attributes>
   <tx:method name="get*" propagation="SUPPORTS"/>
   <tx:method name="set*" propagation="SUPPORTS"/>
   <tx:method name="query*" propagation="SUPPORTS"/>
   <tx:method name="select*" propagation="SUPPORTS"/>
   <tx:method name="find*" propagation="SUPPORTS"/>
   <tx:method name="*" propagation="REQUIRED" rollback-for="com.*.core.common.exception.BaseException,java.lang.RuntimeException" no-rollback-for="" isolation="DEFAULT"/>
  </tx:attributes>
 </tx:advice>
 
 <aop:config>
  <aop:advisor advice-ref="transAdvice" pointcut="execution(* com.*.sample.hibernate.domain.*.*(..))" />
 </aop:config>
--></beans>

好的,我知道了。以下是对应的代码实现: 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、付费专栏及课程。

余额充值