concemservice.java

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

package cn.dang.service;

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

import cn.dang.dao.AllDAO;
import cn.dang.entity.Book;
import cn.dang.entity.Concem;


public class ConcemService {
private AllDAO allDAO=new AllDAO();
	
	public int getConcemIdByName(String concemName) throws Throwable{
		String sql="select cid from bookconcem where concemname='"+concemName+"'";
		List list=allDAO.getConcemDAO().queryConcem(sql);
		Concem concem=new Concem();
		if(list.size()>0){
			return (Integer.parseInt(((String[])list.get(0))[0]));
			
		}
		return 0;
	}
	
	public int setConcemInfo(ArrayList values_list) throws Throwable{
		String sql="insert into bookconcem(concemname) values(?)";
		allDAO.getConcemDAO().nonQueryConcem(sql, values_list);
		return this.getConcemId(values_list.get(0).toString());
	}
	
	//跟新出版社表名字信息
	public void updateConcem(ArrayList values_list) throws Throwable{
		String sql="update bookconcem set concemname=? where cid=?";
		allDAO.getAuthorDAO().nonQueryAuthor(sql, values_list);
	}
	
	private int getConcemId(String concemName) throws Throwable{
		int aid=allDAO.getConcemDAO().queryConcemId("select cid from bookconcem where concemname='"+concemName+"'");
		return aid;
	}
	
	public List<Concem> getConcemInfoAll() throws Throwable{
		String sql="select * from bookconcem";
		return allDAO.getConcemDAO().querConcemAll(sql);
	}
	
	// 操作出版社信息的方法
	public int getConcemIdByName(ArrayList values_list)
			throws Throwable {
		// 根据出版社名称查询处出版社id
		int cid = this.getConcemIdByName(values_list.get(0).toString());
		//如果不存在则进行插入并查询出ID
		if (cid == 0) {
			cid=this.setConcemInfo(values_list);
		} 
		return cid;
	}
	public int getConcemIdByNameAndUpdate(ArrayList values_list) throws Throwable{
		// 根据出版社名称查询处出版社id
		int cid = this.getConcemIdByName(values_list.get(0).toString());
		//如果不存在则进行插入并查询出ID
		if (cid == 0) {
			cid=this.setConcemInfo(values_list);
		} else{
			values_list.add(cid);
			this.updateConcem(values_list);
		}
		return cid;
	}
	
	// 查询出版社表的信息
	public Concem getConcemInfo(int id) throws Throwable {
		String sql = "select * from bookconcem where cid=" + id;
		return allDAO.getConcemDAO().queryConcemInfo(sql);
	}
}