当前位置: 代码迷 >> MySQL >> spring4 学习四 spring MVC+mybatis+Mysql
  详细解决方案

spring4 学习四 spring MVC+mybatis+Mysql

热度:409   发布时间:2016-05-05 16:28:33.0
spring4 学习4 spring MVC+mybatis+Mysql

在前面搭建的基础上,引入新的jar包如下:

aopalliance-1.0.jar
aspectjweaver-1.8.8.jar
mybatis-3.3.0.jar
mybatis-spring-1.2.3.jar
mysql-connector-java-5.1.31.jar
spring-aop-4.2.4.RELEASE.jar
spring-aspects-4.2.4.RELEASE.jar
spring-jdbc-4.2.4.RELEASE.jar
spring-orm-4.2.4.RELEASE.jar
spring-oxm-4.2.4.RELEASE.jar
spring-tx-4.2.4.RELEASE.jar

代码结构如下:下载地址 

 


localConfig.properties

Java代码  收藏代码
  1. #datasource properties  
  2. jdbc.url=jdbc:mysql://localhost:3306/world  
  3. jdbc.username=root  
  4. jdbc.password=root  

 

spring-dataSource.xml

 

Java代码  收藏代码
  1. <?xml version="1.0" encoding="UTF-8"?>  
  2. <beans xmlns="http://www.springframework.org/schema/beans"  
  3.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"   
  4.     xmlns:tx="http://www.springframework.org/schema/tx"  
  5.     xmlns:aop="http://www.springframework.org/schema/aop"  
  6.     xsi:schemaLocation="http://www.springframework.org/schema/beans   
  7.     http://www.springframework.org/schema/beans/spring-beans-4.1.xsd  
  8.     http://www.springframework.org/schema/aop   
  9.     http://www.springframework.org/schema/aop/spring-aop-4.1.xsd    
  10.     http://www.springframework.org/schema/tx   
  11.     http://www.springframework.org/schema/tx/spring-tx-4.1.xsd">  
  12.   
  13.     <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">  
  14.         <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>  
  15.         <property name="url" value="${jdbc.url}"></property>  
  16.         <property name="username" value="${jdbc.username}"></property>  
  17.         <property name="password" value="${jdbc.password}"></property>  
  18.     </bean>  
  19.       
  20.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
  21.         <property name="dataSource" ref="dataSource" />  
  22.     </bean>  
  23.   
  24.     <bean id="transactionManager"  
  25.         class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
  26.         <property name="dataSource" ref="dataSource" />  
  27.     </bean>  
  28.     <tx:advice id="txAdvice" transaction-manager="transactionManager">  
  29.         <tx:attributes>  
  30.             <tx:method name="*" />  
  31.         </tx:attributes>  
  32.     </tx:advice>  
  33.     <aop:config>  
  34.         <aop:pointcut expression="execution(* com.xx.demo.bsh.*.*.*(..))"  
  35.             id="myPointcut" />  
  36.         <aop:advisor advice-ref="txAdvice" pointcut-ref="myPointcut" />  
  37.     </aop:config>  
  38. </beans>  

           配置玩事务后先检查一下mysql中的表的存储引擎是否是innoDB。若是MyISAM,要改成InnoDB,因为MyISAM是事务不安全的。

          查看命令:show create table city;

          修改命令:alter table city engine = InnoDB;

spring-applicationContext.xml

Java代码  收藏代码
  1. <beans xmlns="http://www.springframework.org/schema/beans"  
  2.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"  
  3.     xsi:schemaLocation="http://www.springframework.org/schema/beans  
  4.              http://www.springframework.org/schema/beans/spring-beans-4.1.xsd  
  5.              http://www.springframework.org/schema/context  
  6.              http://www.springframework.org/schema/context/spring-context-4.1.xsd">  
  7.     <context:annotation-config />  
  8.     <context:component-scan base-package="com.xx.demo.dao"/>  
  9.     <context:component-scan base-package="com.xx.demo.bsh" />  
  10.     <context:property-placeholder location="classpath:config/env/localConfig.properties" />    
  11.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">    
  12.         <property name="basePackage" value="com.xx.demo.dao" />    
  13.     </bean>   
  14.     <import resource="classpath:config/spring-dataSource.xml"/>  
  15. </beans>  

 ICityDao.java

Java代码  收藏代码
  1. package com.xx.demo.dao.test;  
  2.   
  3. import java.util.List;  
  4.   
  5. import org.apache.ibatis.annotations.Delete;  
  6. import org.apache.ibatis.annotations.Select;  
  7. import org.springframework.stereotype.Repository;  
  8.   
  9. import com.xx.demo.entity.test.CityEO;  
  10.   
  11. @Repository("cityDao")   
  12. public interface ICityDao {  
  13.       
  14.     @Select(value = "select count(1) as count from city")   
  15.     public long countAll();  
  16.   
  17.     @Delete(value="delete from city where id=#{id}")  
  18.     public void deleteCityById(long id);  
  19.       
  20.     @Select(value="select * from city")  
  21.     public List<CityEO> getAllCitys();  
  22.       
  23. }  

CityEO.java

   EO类属性有数据库列名一致

Java代码  收藏代码
  1. public class CityEO {  
  2.     private int id;  
  3.     private String name;  
  4.     private String countryCode;  
  5.     private String district;  
  6.     private long population;  
  7. ...  
  8. }  

  TestService.java

Java代码  收藏代码
  1. package com.xx.demo.bsh.test;  
  2.   
  3. import java.util.List;  
  4.   
  5. import javax.annotation.Resource;  
  6.   
  7. import org.springframework.stereotype.Service;  
  8.   
  9. import com.xx.demo.dao.test.ICityDao;  
  10. import com.xx.demo.entity.test.CityEO;  
  11.   
  12. @Service("testService")  
  13. public class TestService {  
  14.       
  15.     @Resource  
  16.     private ICityDao cityDao;  
  17.       
  18.     public void print(){  
  19.         System.out.println("这是服务层方法");  
  20.     }  
  21.       
  22.     public long getCityCount(){  
  23.         return cityDao.countAll();  
  24.     }  
  25.   
  26.     public long deleteCityById(long id) {  
  27.         cityDao.deleteCityById(id);  
  28.         return id;  
  29.     }  
  30.       
  31.     public List<CityEO> getAllCitys(){  
  32.         return cityDao.getAllCitys();  
  33.     }  
  34. }  

 TestController.java

Java代码  收藏代码
  1. package com.xx.demo.web.test;  
  2.   
  3. import java.util.HashMap;  
  4. import java.util.List;  
  5. import java.util.Map;  
  6.   
  7. import javax.annotation.Resource;  
  8. import javax.servlet.http.HttpServletRequest;  
  9.   
  10. import org.springframework.stereotype.Controller;  
  11. import org.springframework.ui.ModelMap;  
  12. import org.springframework.web.bind.annotation.RequestMapping;  
  13. import org.springframework.web.bind.annotation.ResponseBody;  
  14.   
  15. import com.xx.demo.bsh.test.TestService;  
  16. import com.xx.demo.entity.test.CityEO;  
  17.   
  18. @Controller  
  19. public class TestController {  
  20.     @Resource  
  21.     private TestService testService;  
  22.       
  23.     @RequestMapping("/firstPage")  
  24.     public String testMethod(ModelMap model){  
  25.         testService.print();  
  26.         model.put("msg", "velocity 测试");  
  27.         return "test";  
  28.     }  
  29.       
  30.     @RequestMapping("/getCityCount")  
  31.     @ResponseBody  
  32.     public String getCityCount(){  
  33.         Map<String,Object> result = new HashMap<String,Object>();  
  34.         long count = testService.getCityCount();  
  35.         return String.valueOf(count);  
  36.     }  
  37.       
  38.     @RequestMapping("/deleteCityById")  
  39.     @ResponseBody  
  40.     public String deleteCityById(HttpServletRequest request){  
  41.         long id = Long.valueOf(request.getParameter("id"));  
  42.         long result = testService.deleteCityById(id);  
  43.         return "delete--OK--"+result;  
  44.     }  
  45.       
  46.     @RequestMapping("/getAllCitys")  
  47.     public String getAllCitys(HttpServletRequest request,ModelMap model){  
  48.         List<CityEO> citys = testService.getAllCitys();  
  49.         model.put("citys", citys);  
  50.         return "showCitys";  
  51.     }  
  52. }  

 

运行结果:

只贴 了 getAllCitys

 

  相关解决方案