计划本周结束spring与springmvc的最后一个测试:事务;那么今天的进度就是事务控制了,学过数据库的小伙伴应该都跟我一样了解了一些数据库的事务相关知识点:比如事务的提交与回滚以及数据库怎么处理三大问题?
测试环境需要导入spring,spring测试,数据库驱动,数据源C3P0,springjdbc,AOP,tx的坐标的,本次测试主要是利用JdbcTemplate实现数据库操作,特别是设计数据表时,主键的设置,搭建一个基础的测试环境的步骤如下:
1、数据表
2、pojo实体
public class Account {
private String Name;
private double Money;
public String getName() {
return Name;
}
public void setName(String name) {
this.Name = name;
}
public double getMoney() {
return Money;
}
public void setMoney(double money) {
this.Money = money;
}
@Override
public String toString() {
return "Account{" +
"Name='" + Name + '\'' +
", Money=" + Money +
'}';
}
}
3、UserDao与它的实现类
public interface UserDao {
List<Account> account();
}
public class UserDaoImpl implements UserDao{
private JdbcTemplate jdbcTemplate;
public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
@Override
public List<Account> account() {
List<Account> accountList = jdbcTemplate.query("select * from account", new BeanPropertyRowMapper<Account>(Account.class));
System.out.println(accountList);
return accountList;
}
}
3、UserService与它的实现类
public interface UserService {
List<Account> account();
}
public class UserServiceImpl implements UserService{
private UserDao userDao;
public void setUserDao(UserDao userDao) {
this.userDao = userDao;
}
@Override
public List<Account> account() {
List<Account> accountList = userDao.account();
return accountList;
}
}
4、UserController测试(本次未使用web层,所以没有视图相关的设置)
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
@Controller
public class UserController {
@Autowired
private UserService userService;
@Test
public void test1(){
userService.account();
}
}
5、applicationContext.xml
<context:component-scan base-package="com.hlc.controller"/>
<context:property-placeholder location="jdbc.properties"/>
<!-- 配置C3P0数据源-->
<bean class="com.mchange.v2.c3p0.ComboPooledDataSource" id="dataSource">
<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>
<bean class="org.springframework.jdbc.core.JdbcTemplate" id="jdbcTemplate">
<property name="dataSource" ref="dataSource"/>
</bean>
<!-- 配置实例化javabean-->
<bean class="com.hlc.dao.UserDaoImpl" id="userDao">
<property name="jdbcTemplate" ref="jdbcTemplate"/>
</bean>
<bean class="com.hlc.service.UserServiceImpl" id="userService">
<property name="userDao" ref="userDao"/>
</bean>
下午进行测试并总结具体步骤与其注意点。