typeservice.java

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

package cn.dang.service;

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

import cn.dang.dao.AllDAO;
import cn.dang.entity.BookType;
import cn.dang.entity.Type;
import cn.dang.service.face.TypeServiceInterface;

public class TypeService implements TypeServiceInterface{
	private AllDAO allDAO = new AllDAO();
	
	public List<Type> getTypeInfo() throws Throwable {
		// TODO Auto-generated method stub
		//调用DAO层方法查询处类型信息保存到List的泛型容器中
		List<Type> list=allDAO.getTypeDAO().queryTypeInfo("select * from onetype");
		//循环查询处每个小类的信息保存到BookType
		for(int i=0;i<list.size();i++){
			List<BookType> bookTypes=allDAO.getDtDAO().querySmallType("select * from twotype where oid="+list.get(i).getId()+"");
				list.get(i).setBookType(bookTypes);
		}
		return list;
	}
	
	// 查询大类的信息
	public Type getTypeInfo(int id) throws Throwable {
		String sql = "select * from onetype where oid=" + id;
		return allDAO.getTypeDAO().queryType(sql);
	}
	//更新大类的信息
	public void updateTypeInfo(ArrayList values_list) throws Throwable{
		String sql="update onetype set typename=? where oid=?";
		allDAO.getTypeDAO().updateType(sql, values_list);
	}
	//更新大类信息
	public String searchAndUpdateInfo(ArrayList values_list) throws Throwable{
		String sql="select * from onetype where typename='"+values_list.get(0)+"'";
		String id=values_list.get(1).toString();
		if(allDAO.getTypeDAO().queryType(sql).getId()>0){
			this.updateTypeInfo(values_list);
		}else{
			ArrayList ay=new ArrayList();
			ay.add(values_list.get(0));
			this.insertTypeInfo(ay);
			id=this.searchTypeIdByName(ay.get(0).toString());
		}
		return id;
	}
	//插入大类信息
	public void insertTypeInfo(ArrayList values_list) throws Throwable{
		String sql="insert into onetype(typename) values(?)";
		allDAO.getTypeDAO().updateType(sql, values_list);
	}
	//根据名字查询大类ID
	public String searchTypeIdByName(String typeName) throws Throwable{
		String sql="select * from onetype where typename='"+typeName+"'";
		String id=String.valueOf(allDAO.getTypeDAO().queryType(sql).getId());
		return id;
	}
	//删除大类
	public void deleteTypeInfoById(ArrayList values_list) throws Throwable{
		String sql="delete from onetype where oid=?";
		allDAO.getTypeDAO().updateType(sql, values_list);
	}
	
	
	public List<Type> getTypeInfoAll(String sql) throws Throwable {
		// TODO Auto-generated method stub
		//调用DAO层方法查询处类型信息保存到List的泛型容器中
		List<Type> list=allDAO.getTypeDAO().queryTypeInfo(sql);
		//循环查询处每个小类的信息保存到BookType
		for(int i=0;i<list.size();i++){
			List<BookType> bookTypes=allDAO.getDtDAO().querySmallType("select * from twotype where oid="+list.get(i).getId()+"");
				list.get(i).setBookType(bookTypes);
		}
		return list;
	}
	
}