purviewservice.java

基于MVC模式的文章采集检索系统

package com.liubin.service.purview;

import com.liubin.model.*;
import com.liubin.database.*;
import java.sql.*;
import java.util.*;

public class PurviewService {
	public List<Role>  getAllRole(){
		String sql="select * from t_role_privilege";
		JdbcBean bean=new JdbcBean();
		ResultSet rs=null;
		List<Role>list =new ArrayList<Role>();
		Role role=null;
		rs=bean.query(sql);
		try{
			while(rs.next()){
				role=new Role();
				role.setRole_id(rs.getInt("role_id"));
				role.setRole_name(rs.getString("role_name"));
				list.add(role);
			}
			rs.close();
		}
		catch(Exception e){
			e.printStackTrace();
		}
		bean.close();
		return list;
		
	}
	public List<Item> getAllItems(){
		String sql="select * from t_items";
		JdbcBean bean=new JdbcBean();
		ResultSet rs=null;
		Item item=null;
		List<Item>list=new ArrayList<Item>();
		rs=bean.query(sql);
		try{
			while(rs.next()){
				item=new Item();
				item.setItem_id(rs.getString("item_id"));
				item.setItem_name(rs.getString("item_name"));
				list.add(item);
			}
			rs.close();
		}
		catch(Exception e){
			e.printStackTrace();
		}
		bean.close();
		return list;
		
	}
	public List<SubItem> getAllSubs(){
		String  sql="select * from t_subitems";
		JdbcBean bean=new JdbcBean();
		ResultSet rs=null;
		SubItem subItem=null;
		List<SubItem>list=new ArrayList<SubItem>();
		rs=bean.query(sql);
		try{
			while(rs.next()){
				subItem=new SubItem();
				subItem.setItem_id(rs.getString("item_id"));
				subItem.setSub_id(rs.getString("sub_id"));
				subItem.setSub_name(rs.getString("sub_name"));
				list.add(subItem);
			}
			rs.close();
		}
		catch(Exception e){
			e.printStackTrace();
		}
		bean.close();
		return list;
	}
	public List<String> getSubIdByRoleId(int role_id){
		String sql="select * from t_role_resource where role_id="+role_id;
		System.out.println(sql);
		List<String> list=new ArrayList<String>();
		JdbcBean bean=new JdbcBean();
		ResultSet rs=null;
		rs=bean.query(sql);
		try{
			while(rs.next()){
				list.add(rs.getString("sub_id"));
			}
			rs.close();
		}
		catch(Exception e){
			e.printStackTrace();
		}
		bean.close();	
		return list;
	}
	public boolean updateRole(String role_id,String[]subids){
		StringBuffer buffer=new StringBuffer("insert into t_role_resource values");
		String sql=null;
		String sql1="delete from t_role_resource where role_id="+role_id;
		JdbcBean bean=new JdbcBean();
		bean.update(sql1);
		for(int i=0;i<subids.length;i++){
			if(i!=subids.length-1){
			buffer.append("("+role_id+" ,'"+subids[i]+"'),");
			}else
			{
				buffer.append("("+role_id+" ,'"+subids[i]+"')");
			}
		}
		System.out.println(buffer.toString());
		if(bean.update(buffer.toString())>0)
		return true;
		else
			return false;
	}
	

}