Spring JdbcTemplate 学习_基本使用_1
?
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd"> <bean id="springDSN" value="root"></property> <property name="password" value="root"></property> </bean> <bean id="jdbcTemplate" abstract="false" lazy-init="false" autowire="default" dependency-check="default"> <property name="dataSource"> <ref bean="springDSN" /> </property> </bean></beans>
?public final class SpringUtil {private static ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml");public static Object getBean(String beanName) {return ctx.getBean(beanName);}}public class TestDao { private JdbcTemplate jdbcT = (JdbcTemplate) SpringUtil.getBean("jdbcTemplate");public List findALL() {String sql = "select * from test";return jdbcT.queryForList(sql);}public List<Test> findALLBooks() {String sql = "select * from test";List list = jdbcT.queryForList(sql);Iterator iterator = list.iterator();Book book = null;while (iterator.hasNext()) {Map map = (Map) iterator.next();System.out.println((String)map.get("id"));System.out.println((String)map.get("name"));}return null;}public int delete(int bid) {String sql = "delete from BookInfo where bid =?";return jdbcT.update(sql, new Object[] { bid });}public static void main(String[] args) {new TestDao().findALLBooks();}}