create database ssm;
create table account(
id int primary key auto_increment,
name varchar(100),
money double(7,2)
);

public class Account {
private int id ;
private String name ;
private double money ;
//省略getter和setter方法
}
课堂问答1.1 原始方式整合
public interface AccountMapper {
// 保存账户数据
void save(Account account);
// 查询账户数据
List findAll();
}

public interface AccountService {
void save(Account account); // 保存账户数据
List findAll(); // 查询账户数据
}

@Service ("accountService")
public class AccountServiceImpl implements AccountService {
public void save(Account account) {
SqlSession sqlSession = MyBatisUtils.openSession();
AccountMapper accountMapper = sqlSession.getMapper(AccountMapper. class );
accountMapper.save(account);
sqlSession.commit();
sqlSession.close();
}
public List<Account> findAll() {
SqlSession sqlSession = MyBatisUtils.openSession();
AccountMapper accountMapper = sqlSession.getMapper(AccountMapper.class);
return accountMapper.findAll();
}
}

@Controller
public class AccountController {
@Autowired
private AccountService accountService ;
@RequestMapping ("/save")
@ResponseBody
public String save(Account account){
accountService .save(account);
return "save success";
}
@RequestMapping ("/findAll")
public ModelAndView findAll(){
ModelAndView modelAndView = new ModelAndView();
modelAndView.setViewName ("accountList");
modelAndView.addObject ("accountList",accountService .findAll());
return modelAndView;
}
}

<%@ page contentType =" text/html;charset=UTF- 8 " language =" java " %>
< html >
< head >
< title >Title</ title >
</ head >
< body >
< h1 >保存账户信息表单</ h1 >
< form action="${ pageContext.request.contextPath }/save.action" method="post" >
用户名称< input type="text" name="name" >< br />
账户金额< input type="text" name="money" >< br />
< input type="submit" value=" 保存 " >< br />
</ form >
</ body >
</ html >

< table border="1" >
< tr >
< th >账户id</ th >
< th >账户名称</ th >
< th >账户金额</ th >
</ tr >
< c:forEach items =" ${ accountList } " var="account" >
< tr >
< td > ${ account.id } </ td >
< td > ${ account.name } </ td >
< td > ${ account.money } </ td >
</ tr >
</ c:forEach >
</ table >

<!--加载jdbc.properties-->
<context:property-placeholder location="classpath:jdbc.properties"/>
<!--配置数据源-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}"/>
<property name="jdbcUrl" value="${jdbc.url}"/>
<property name="user" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<!--配置MyBatis的SqlSessionFactory-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="configLocation" value="classpath:sqlMapConfig.xml"/>
</bean>

<!--配置Mapper扫描-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.itheima.mapper"/>
</bean>

<bean id="transacionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<tx:advice id="txAdvice" transaction-manager="transacionManager">
<tx:attributes>
<tx:method name="*"/>
</tx:attributes>
</tx:advice>
<aop:config>
<aop:pointcut id="txPointcut" expression="execution(*
com.itheima.service.impl.*.*(..))"/>
<aop:advisor advice-ref="txAdvice" pointcut-ref="txPointcut"/>
</aop:config>

@Service("accountService")
public class AccountServiceImpl implements AccountService {
1
2
@Autowired
private AccountMapper accountMapper;
1
2
public void save(Account account) {
accountMapper.save(account);
}
public List<Account> findAll() {
return accountMapper.findAll();
}
}