librarydaoimp.java

spring入门 spring入门spri ng入门 spring入门

package de.laliluna.library;

import java.sql.Types;
import java.util.List;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.support.incrementer.DataFieldMaxValueIncrementer;

public class LibraryDaoImp implements LibraryDao {
	private JdbcTemplate jdbcTemplate;
	private DataFieldMaxValueIncrementer bookIncrementer;
	public void setJdbcTemplate(JdbcTemplate jdbcTemplate){
	this.jdbcTemplate = jdbcTemplate;
	}
	public void setBookIncrementer(DataFieldMaxValueIncrementer bookIncrementer) {
	this.bookIncrementer = bookIncrementer;
	}
	public Book insertBook(Book book) {
//	get next autoincrement value
	//Integer id = new Integer(bookIncrementer.nextIntValue());
	//book.setId(id);
	String sql = "insert into book ( title, author) values (?,?)";
	Object args []= new Object[] {book.getTitle(), book.getAuthor() };
	int types[] = new int[] {Types.VARCHAR, Types.VARCHAR };
	jdbcTemplate.update(sql, args, types);
	return book;
	}
	public void updateBook(Book book) {
	String sql = "update book set title=?, author=?, borrowedby=? where id = ?";
	Object args []= new Object[] { book.getTitle(), book.getAuthor(),
	book.getBorrowedBy(), book.getId() };
	int types[] = new int[] { Types.VARCHAR, Types.VARCHAR, Types.INTEGER,
	Types.INTEGER };
	jdbcTemplate.update(sql, args, types);
	}
	public void deleteBook(Book book) {
	String sql = "delete from book where id = ?";
	Object params[] = new Object[] {book.getId()};
	int types[] = new int [] {Types.INTEGER};
	jdbcTemplate.update(sql, params, types);
	}
	public List getBooks() {
		String sql = "select * from book";
		return jdbcTemplate.query(sql, new BookRowMapper());
		}

}