测试类

左手的ㄟ右手 2021-12-01 23:00 245阅读 0赞

package com.test;
    
    import java.util.List;
    import java.util.Map;
    
    import javax.xml.transform.Templates;
    
    import org.junit.Before;
    import org.junit.Test;
    import org.junit.validator.PublicClassValidator;
    import org.springframework.jdbc.core.BeanPropertyRowMapper;
    import org.springframework.jdbc.core.JdbcTemplate;
    import org.springframework.jdbc.core.RowCallbackHandler;
    
    import com.entity.User;
    import com.mchange.v2.c3p0.ComboPooledDataSource;
    
    public class Test11 {
        
    	JdbcTemplate jt = null;
    	private List<User> query;
    
    	@Before
    	public void a() {
        
    		jt = new JdbcTemplate(new ComboPooledDataSource());
    	}
    
    	@Test
    	public void query() {
        
    		Map<String, Object> map = jt.queryForMap("select * from u_p where id=5");
    		System.out.println(map);
    
    	}
    
    	@Test
    	public void queryForMap() {
        
    		Map<String, Object> queryForMap = jt.queryForMap("select * from u_p", 1);
    		System.out.println(queryForMap);
    	}
    
    	@Test
    	public void queryList() {
        
    		List<Map<String, Object>> queryForList = jt.queryForList("select * from u_p");
    		System.out.println(queryForList);
    	}
    
    	@Test
    	public void query2() {
        
    //		BeanPropertyRowMapper:将数据库映射到类中
    		List<User> query = jt.query("select * from u_p", new BeanPropertyRowMapper<User>(User.class));
    		System.out.println(query);
    	}
    
    //	错误案列：query只能进行查询操作
    	@Test
    	public void query3() {
        
    		query = jt.query("insert into u_p values(null,?,?)", new BeanPropertyRowMapper<User>(User.class), "隔壁老王",
    				"当一天和尚撞一天钟");
    		System.out.println("成功了");
    	}
    
    	@Test
    	public void query4() {
        
    		List<User> query2 = jt.query("select * from u_p where id=5", new BeanPropertyRowMapper<User>(User.class));
    		System.out.println(query2);
    	}
    
    	@Test
    	public void query5() {
        
    		List<User> query2 = jt.query("select * from u_p", new BeanPropertyRowMapper<User>(User.class));
    		System.out.println(query2.get(5));
    	}
    
    	@Test
    	public void query6() {
        
    		User queryForObject = jt.queryForObject("select * from u_p where id=?",
    				new BeanPropertyRowMapper<User>(User.class), 13);
    		System.out.println(queryForObject);
    	}
    
    //	聚合函数的使用
    	@Test
    	public void query7() {
        
    		Integer queryForObject = jt.queryForObject("select count(*) from u_p", Integer.class);
    		System.out.println(queryForObject);
    	}
    }