jdbctemplate实例

1、准备数据库

2、创建web工程JdbcTemplate，添加spring和mysql驱动的jar包。

目录结构如下

3、源代码

Book.java

package com.pojo;

public class Book {
	private Integer id;
	private String book_name;
	
	public Book() {
	}

	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getBook_name() {
		return book_name;
	}
	public void setBook_name(String bookName) {
		book_name = bookName;
	}
}

BookDao.java

package com.dao;

import java.util.List;

import com.pojo.Book;

public interface BookDao {
	public List<Book> findAllBooks();
}

BookDaoImpl.java

package com.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowCallbackHandler;

import com.dao.BookDao;
import com.pojo.Book;

public class BookDaoImpl implements BookDao {
	private JdbcTemplate jdbcTemplate;
	
	public List<Book> findAllBooks() {
		String sql = "select * from book";
		final List<Book> listAllBook = new ArrayList<Book>();
		jdbcTemplate.query(sql,new RowCallbackHandler() {
			public void processRow(ResultSet rs) throws SQLException {
				Book b = new Book();
				b.setId(rs.getInt("id"));
				b.setBook_name(rs.getString("book_name"));
				listAllBook.add(b);
			}
		});
		return listAllBook;
	}

	public JdbcTemplate getJdbcTemplate() {
		return jdbcTemplate;
	}
	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}
}

测试类Test.java

package com.test;

import java.util.List;

import org.springframework.beans.factory.BeanFactory;
import org.springframework.beans.factory.xml.XmlBeanFactory;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.Resource;

import com.dao.BookDao;
import com.pojo.Book;

public class Test {
	public static void main(String[] args) {
		Resource resource = new ClassPathResource("applicationContext.xml");
		BeanFactory factory = new XmlBeanFactory(resource);
		BookDao dao = (BookDao)factory.getBean("bookDao");
		List<Book> listbook = dao.findAllBooks();
		System.out.println(listbook.get(0).getId() + ":" + listbook.get(0).getBook_name());
	}
}

applicationContext.xml

<?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="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource">
			<ref local="dataSource" />
		</property>
	</bean>
	<bean id="bookDao" class="com.dao.impl.BookDaoImpl">
		<property name="jdbcTemplate">
			<ref bean="jdbcTemplate"/>
		</property>
	</bean>
 	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName">
			<value>com.mysql.jdbc.Driver</value>
		</property>
		<property name="url">
			<value>jdbc:mysql://localhost:3306/test</value>
		</property>
		<property name="username">
			<value>root</value>
		</property>
		<property name="password">
			<value>zzy</value>
		</property>
	</bean>
</beans>

ok,各位可以试试啦！