spring4 学习四 spring MVC+mybatis+Mysql_MySQL

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代码

#datasource properties
jdbc.url=jdbc:mysql://localhost:3306/world
jdbc.username=root
jdbc.password=root

spring-dataSource.xml

Java代码

<?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"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.1.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.1.xsd">
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="${jdbc.url}"></property>
<property name="username" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
</bean>
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="*" />
</tx:attributes>
</tx:advice>
<aop:config>
<aop:pointcut expression="execution(* com.xx.demo.bsh.*.*.*(..))"
id="myPointcut" />
<aop:advisor advice-ref="txAdvice" pointcut-ref="myPointcut" />
</aop:config>
</beans>

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

查看命令:show create table city;

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

spring-applicationContext.xml

Java代码

<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"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.1.xsd">
<context:annotation-config />
<context:component-scan base-package="com.xx.demo.dao"/>
<context:component-scan base-package="com.xx.demo.bsh" />
<context:property-placeholder location="classpath:config/env/localConfig.properties" />
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.xx.demo.dao" />
</bean>
<import resource="classpath:config/spring-dataSource.xml"/>
</beans>

ICityDao.java

Java代码

package com.xx.demo.dao.test;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import com.xx.demo.entity.test.CityEO;
@Repository("cityDao")
public interface ICityDao {
@Select(value = "select count(1) as count from city")
public long countAll();
@Delete(value="delete from city where id=#{id}")
public void deleteCityById(long id);
@Select(value="select * from city")
public List<CityEO> getAllCitys();
}

CityEO.java

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

Java代码

public class CityEO {
private int id;
private String name;
private String countryCode;
private String district;
private long population;
...
}

TestService.java

Java代码

package com.xx.demo.bsh.test;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import com.xx.demo.dao.test.ICityDao;
import com.xx.demo.entity.test.CityEO;
@Service("testService")
public class TestService {
@Resource
private ICityDao cityDao;
public void print(){
System.out.println("这是服务层方法");
}
public long getCityCount(){
return cityDao.countAll();
}
public long deleteCityById(long id) {
cityDao.deleteCityById(id);
return id;
}
public List<CityEO> getAllCitys(){
return cityDao.getAllCitys();
}
}

TestController.java

Java代码

package com.xx.demo.web.test;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.xx.demo.bsh.test.TestService;
import com.xx.demo.entity.test.CityEO;
@Controller
public class TestController {
@Resource
private TestService testService;
@RequestMapping("/firstPage")
public String testMethod(ModelMap model){
testService.print();
model.put("msg", "velocity 测试");
return "test";
}
@RequestMapping("/getCityCount")
@ResponseBody
public String getCityCount(){
Map<String,Object> result = new HashMap<String,Object>();
long count = testService.getCityCount();
return String.valueOf(count);
}
@RequestMapping("/deleteCityById")
@ResponseBody
public String deleteCityById(HttpServletRequest request){
long id = Long.valueOf(request.getParameter("id"));
long result = testService.deleteCityById(id);
return "delete--OK--"+result;
}
@RequestMapping("/getAllCitys")
public String getAllCitys(HttpServletRequest request,ModelMap model){
List<CityEO> citys = testService.getAllCitys();
model.put("citys", citys);
return "showCitys";
}
}

运行结果：

只贴了 getAllCitys