使用mybatis与springMVC框架,与spring容器做一个超级简单得练习,主要就是考虑简单得业务,一个账户购买基金,然后基金账户的份额增加,银行账户里面得钱减少。
首先呢要有两个表,一个银行表一个基金表,
一个account银行账户表,一个fund基金表,建好之后,就可以进行实体类的创建
public class Account {
private String aname;
private double money;
}
其中还必须实现getset方法,与带参与无参构造,为了方便测试还可以重写toString方法
public class Fund {
private String fname;
private int count;
}
实现Mapper层的接口与xml配置文件
public interface IAccountMapper {
void insertAccount(@Param("name")String name,@Param("balance")double balance);
void update(Account account);
}
public interface IFundMapper {
void insertFund(@Param("fname")String fname,@Param("count")int count);
void updateFund(Fund fund);
}
银行账户的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.lianxi.mapper.IAccountMapper">
<insert id="insertAccount">
insert into account values(default,#{name},#{balance})
</insert>
<update id="update" parameterType="Account">
update account set balance=balance-#{money} where aname=#{aname}
</update>
</mapper>
基金账户的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.bjsxt.mapper.IFundMapper">
<insert id="insertFund">
insert into fund values(default,#{fname},#{count})
</insert>
<update id="updateFund" parameterType="Fund">
update fund set count=count+#{count} where fname=#{fname}
</update>
</mapper>
Service层的接口与实现类
public interface FundService {
void insertAccount(Account account);
void insertFund(Fund fund);
void buyFund(Account account,Fund fund);
}
因为这里面我们要采取spring注入,所以要对里面的属性进行赋予set方法
Service
public class FundServiceImpl implements FundService{
@Autowired
private IAccountMapper accountDao;
@Autowired
private IFundMapper fundDao;
public IAccountMapper getAccountDao() {
return accountDao;
}
public void setAccountDao(IAccountMapper accountDao) {
this.accountDao = accountDao;
}
public IFundMapper getFundDao() {
return fundDao;
}
public void setFundDao(IFundMapper fundDao) {
this.fundDao = fundDao;
}
@Override
public void insertAccount(Account account) {
// TODO Auto-generated method stub
accountDao.insertAccount(account.getAname(), account.getMoney());
}
@Override
public void insertFund(Fund fund) {
// TODO Auto-generated method stub
fundDao.insertFund(fund.getFname(), fund.getCount());
}
@Override
public void buyFund(Account account, Fund fund) {
// TODO Auto-generated method stub
accountDao.update(account);
fundDao.updateFund(fund);
}
}
控制器
/**
* 后端控制器
* @author yaoya
*
*/
@Controller
@RequestMapping("/springmvc")//该注解起到限定范围的作用
public class FundController{
@Autowired
private FundService fundService;
public FundService getFundService() {
return fundService;
}
public void setFundService(FundService fundService) {
this.fundService = fundService;
}
@RequestMapping("/buyFund")
public String buyFund(Account account,Fund fund){
fundService.buyFund(account, fund);
return "welcome";
}
}
因为控制器的文件也要进行spring注入,所以对里面的属性也要赋予get,set方法。
接下来就是核心配置文件了,先写web.xml文件
<?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_2_5.xsd" id="WebApp_ID" version="2.5">
<display-name>springmvc-mybaties</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.xml</param-value>
</context-param>
<!-- 配置contextServlet的监听器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 解决中文乱码问题 -->
<filter>
<filter-name>CharacterEncodingFilter</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>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>CharacterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- 配置中央控制器 -->
<servlet>
<servlet-name>springmvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springmvc.xml</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
然后是springMVC的核心配置文件
<?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"
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.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
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd">
<!-- 注册开发中要进行注册组件扫描器 -->
<context:component-scan base-package="com.lianxi.handlers"></context:component-scan>
<!-- 注解开发第二步,注册注解驱动 -->
<mvc:annotation-driven></mvc:annotation-driven>
<!-- 注册视图解析器 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!-- 视图层前缀 -->
<property name="prefix" value="/jsp/"></property>
<!-- 视图层后缀-->
<property name="suffix" value=".jsp"></property>
</bean>
<!-- 解决静态资源第二种方式 -->
<mvc:resources location="/images/" mapping="/images/**"></mvc:resources>
<!-- 解决静态资源第二种方式 -->
<mvc:resources location="/js/" mapping="/js/**"></mvc:resources>
</beans>
然后呢是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:mvc="http://www.springframework.org/schema/mvc"
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.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
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd">
<!-- 加载jdbc -->
<context:property-placeholder location="classpath:jdbc.properties" />
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${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>
<!-- 注册sqlsessionbean对象 -->
<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="typeAliasesPackage" value="com.lianxi.pojo"></property>
<property name="dataSource" ref="dataSource"></property>
<property name="configLocation" value="classpath:mybatis.xml"></property>
</bean>
<!-- 获取mapper代理对象 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactoryBean"></property>
<property name="basePackage" value="com.lianxi.mapper"></property>
</bean>
<!-- 注册开发中要进行注册组件扫描器 -->
<context:component-scan base-package="com.lianxi.service.impl"></context:component-scan>
</beans>
最后呢是myBatis的配置文件,其实这个可要可不要,因为它可以基本的写在spring的核心配置文件中,只不过有些属性你想要获取实现的话,需要加上,比如日志功能。这样基本就可以实现简单的功能了。
<?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="logImpl" value="LOG4J"/>
</settings>
</configuration>