jdbctemplate实例

来源：互联网发布：语音广告播放软件编辑：程序博客网时间：2024/05/19 10:14

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,各位可以试试啦！

0 0