002——Spring事物操作

1.       引入jar包：

 

2.      在根目录src下创建spring.xml文件：

3.       业务逻辑处理层：

 

package com.sinosoft.manage;

 

import java.util.Iterator;

import java.util.List;

import java.util.Map;

 

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.stereotype.Service;

 

@Service

public class UserManage {

 

   @Autowired

   private JdbcTemplate jdbcTemplate;

   private String sql;

  

   public void testJDBC(){

     

      jdbcTemplate.execute("insert into t_user(uname,pwd) values('xsy','123')");

      jdbcTemplate.update("update t_user t set t.uname='xsy' where t.uname='xsy'");

     

      List list = jdbcTemplate.queryForList("select t.* from t_user t");

  

      for (Iterator iterator = list.iterator(); iterator.hasNext();) {

         Map map = (Map) iterator.next();//一个map表示一行数据

         System.out.println(map.get("uname"));

      }

     

//    this.sql = "select count(*) from t_user";

//    int count = jdbcTemplate.queryForInt(this.sql);

//    System.out.println(count);

     

      this.sql = "select t.uname from t_user t where t.id = ?";

      String uname = jdbcTemplate.queryForObject(this.sql, new Object[]{6}, String.class);

      System.out.println(uname);

   }

  

}

 

4.       测试操作：

package test;

import org.junit.Test;

import org.junit.runner.RunWith;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.test.context.ContextConfiguration;

import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

 

import com.sinosoft.manage.UserManage;

 

@RunWith(SpringJUnit4ClassRunner.class)

@ContextConfiguration("classpath:sp*.xml")

public class SpringTest {

  

   @Autowired

   private UserManage userManage;

  

   @Test

   public void test(){

      userManage.testJDBC();

   }

}