dispclass.java

利用当前管理信息系统科学的、实用的理论

/**
*  Title  财务管理系统
*  @author: trowa
*  Company: http://www.upol.cn
*  Copyright: Copyright (c) 2004
*  @version 1.0
*  栏目表中的一些查询操作
*/
package com.haizi.struts.order;

import java.sql.*;
import java.util.*;

import com.haizi.struts.datebase.DBConnect;

public class DispClass extends IClass{

public ResultSet rs;

public DispClass(){};

/*
* 得到所有栏目
*/
public Vector allClass() {
	DBConnect dbc = null;
	Vector allClassVector = new Vector();
	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT * FROM dep_info order by dep_no");
		rs = dbc.executeQuery();
			while(rs.next()){
			IClass iclass = new IClass();
			iclass.setDep_no(rs.getString("dep_no"));
			iclass.setDep_name(rs.getString("dep_name"));
			allClassVector.add(iclass);
		}
	}catch(Exception e){
		System.err.println(e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return allClassVector;
}

/*
* 根据ID得到栏目
*/
public IClass idToClass() {
	DBConnect dbc = null;
	IClass iclass = new IClass();
	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT * FROM dep_info WHERE dep_no = ?");
		dbc.setString(1,getDep_no());
		rs = dbc.executeQuery();
			if(rs.next()){
			iclass.setDep_no(rs.getString("dep_no"));
			iclass.setDep_name(rs.getString("dep_name"));
		}
	}catch(Exception e){
		System.err.println(e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return iclass;
}

/*
* 计算栏目的总数
*/
public int classNum() {
	DBConnect dbc = null;
	int classCount = 0;
	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT count(*) FROM dep_info");
		rs = dbc.executeQuery();
		if(rs.next())	classCount = rs.getInt(1);
	}catch(Exception e){
		System.err.println(e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return classCount;
}



}