departmentmanager.java

基于J2EE的网络物流系统 用户操作： 1． 录入出库商品信息 2． 查询出库单信息 3． 录入入库商品信息 4． 查询入库单信息 5． 查询商品位置信息 6． 查询商品信息 7． 查

package com.logistic.business;

import com.logistic.dao.IDepartmentDAO;
import com.logistic.data.DataConnect;
import java.util.Vector;
import java.sql.ResultSet;
import java.sql.Statement;
import com.logistic.model.DepartmentInfo;

public class DepartmentManager implements IDepartmentDAO{
	
	DataConnect dc=new DataConnect();
	Statement   stat=null;
	ResultSet   rs=null;
	
	//添加部门信息
	public int AddDepartment(String depaid,String depaname){
		
		int flag=0;
		
		try{
			
			String id=depaid;
			String name=depaname;
			String strsqls="insert into departmentinfotable(DepartmentId,DepartmentName)values('"+id+"','"+name+"')";
			
			flag=dc.updata(strsqls);
			if(flag>0){
				
				System.out.println("部门信息插入成功!");
				
			}else{
				
				System.out.println("部门信息插入失败!");
			}
		}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
		
		return flag;		
	}
	
	//取得部门信息列表
	public Vector DepartmentSearch(String strsql,int page){
		
		Vector items=new Vector();
		try{
			
			stat=dc.getStmtread();
			rs=stat.executeQuery(strsql);
			PageAble pgb=new PageAble(rs);
			pgb.setPagesize(5);
			pgb.setCurrentpage(1);
			pgb.gotoPage(page);
			
			rs.absolute(pgb.getRowscount());
			int i=0;
			do{
				items.add(new DepartmentInfo(rs.getString("DepartmentId"),rs.getString("DepartmentName")));
			  
			   }while(rs.next()&&i<pgb.getCurrentPageRowsCount());
	
			}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
			
		return items;
	}

	//根据部门编号删除指定部门
	public int DelDepartment(String depaid){
		
		String deldepartment="delete from departmentinfotable where DepartmentId="+depaid;
		
		int flag=0;
		
		try{
			flag=dc.updata(deldepartment);
			if(flag>0){
				System.out.println("部门信息删除成功，编号:"+depaid);
			   }else{
				System.out.println("部门信息删除失败，编号:"+depaid);
			         }
		    }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
			
	    return flag;
	}

}