bookdaoimpl.java

Spring+acegi+ext2.0+mysql 开发 acegi做权限控制 ext2.0做前台显示 spring 做控制层 mysql 做数据库

package com.mypro.impl.system;

import java.util.List;

import org.springframework.jdbc.core.JdbcTemplate;

import com.mypro.dao.system.StrutsDAO;
import com.mypro.handler.system.BookHanlder;
/**
 * 处理book的Manager
 * @author Administrator
 *
 */
public class BookDAOImpl implements StrutsDAO{
	JdbcTemplate jdbcTemplate; 
	public  List getList(){
		BookHanlder bh=new BookHanlder();
		String sql="select t.id,t.name,a.name as author,s.name as sort ,t.bookdate from book as t left join authors as a on t.author=a.id left join booksort as s on t.sort=s.id";
		jdbcTemplate.query(sql, bh);
		return bh.nlist;
	}
	public JdbcTemplate getJdbcTemplate() {
		return jdbcTemplate;
	}
	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}
}