authordao.java

一套网上书店系统采用JAVABEAN+SERVLET+JSP

package cn.dang.dao;

import ghy_db.DB_operate_interface;

import java.util.ArrayList;
import java.util.List;

import cn.dang.entity.Author;

public class AuthorDAO {
	private DB_operate_interface dbRef;
	public AuthorDAO(DB_operate_interface dbRef){
		super();
		this.dbRef=dbRef;
	}
	
	public List queryAuthor(String sql) throws Throwable{
		//返回查询出的Author表的id
		return dbRef.query(sql);
	}
	
	public void nonQueryAuthor(String sql,ArrayList values_list) throws Throwable{
		//插入作者信息
		dbRef.update(sql, values_list);
	}
	
	public int queryAuthorId(String sql) throws Throwable{
		//获得AuthorId
		return Integer.parseInt(((String[])dbRef.query(sql).get(0))[0]);
	}
	public Author queryAuthorInfo(String sql) throws Throwable{
		List list=dbRef.query(sql);
		Author a=new Author();
		if(list.size()>0){
			String[] s=(String[])list.get(0);
			a.setAid(Integer.parseInt(s[0]));
			a.setAuthorName(s[1]);
		}
		return a;
	}
}