<!-- Spring jdbcTemplate -->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate" abstract="false"
lazy-init="false" autowire="default" >
<property name="dataSource">
<ref bean="dataSource" />
</property>
</bean>
@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<User> userlist= (List<User>) 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());
}
}
}
转载于:https://blog.51cto.com/w51spring/1771397
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)
