Spring的JdbcTemplate使用 (二)

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:spring.xml")
public class Test2 {

    @Resource(name="jdbcTemplate")
    private JdbcTemplate jdbcTemplate;


    @Test
    public void testExecute(){
        jdbcTemplate.execute("create table user2(id int,name varchar(20))");

    }
    @Test
    public void  testUpdate(){
        String sql="insert into student(name,sex) values(?,?)";

        jdbcTemplate.update(sql,new Object[]{"张飞","男"});

    }

    @Test
    public void  testUpdate2(){
        String sql="update  student set sex=? where id=?";

        jdbcTemplate.update(sql,"女","1");

    }

    @Test
    public void  testBatchUpdate(){

        String[] sqls={
                "insert into student(name,sex) values('张三','女')",
                "insert into student(name,sex) values('李四','男')",
                "update  student set sex='男' where id=3"

        };


        jdbcTemplate.batchUpdate(sqls);

    }


    @Test
    public void  testBatchUpdate1(){

        String sql="insert into  selection(student,course) values(?,?)";


        List list=new ArrayList<Object[]>();
        list.add(new Object[]{1005,1003});
        list.add(new Object[]{1005,1001});
        jdbcTemplate.batchUpdate(sql,list);

    }
}