@RunWith(SpringJUnit4Cla***unner.class)
@ContextConfiguration(locations = { "classpath*:/resource/springmvc-dao.xml" })
@TransactionConfiguration(defaultRollback = true)
public class TestSpringJDBC {
@Autowired
private JdbcTemplate template;
@Test
public void TestDB() throws SQLException{
System.err.println("template.getDataSource().getConnection()======="+template.getDataSource().getConnection());
}
@Test
public void queryUsers(){
String selSQL ="select * from usr_test " ;
List userlist= (List) template.query(selSQL, new BeanPropertyRowMapper(User.class));
System.err.println("userlist.Size()=========="+userlist.size());
for (int i = 0; i < userlist.size(); i++) {
User user=(User)userlist.get(i);
System.err.println("第"+i+"名字是:"+user.getName());
}
}
}
文章题目:springjdbctemplate操作数据库
地址分享:
http://cdxtjz.cn/article/gdppsj.html