finddept.java

实现统一的人员日志管理系统管理后台

package com.tb.log.dwr;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.tb.log.factory.*;



public class FindDept {
	Connection coon = null;
	PreparedStatement psm = null;
	ResultSet rs = null;
	
	public String FindDeptName(String supper_id) {
		//System.out.println(supper_id);
		String outPut = "";
		String out="<SELECT id=dept_name name=dept_id>";
		coon = OracleDAOFactory.getConnection();
		try {
			psm = coon.prepareStatement("select dept_name,dept_id from t_department where supper_id=?");
			psm.setString(1, supper_id);
			ResultSet rs = psm.executeQuery();
			while(rs.next()){
				outPut = outPut+"<OPTION value='"+rs.getInt(2)+"'>"+rs.getString(1)+"</OPTION>";
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			try {
				if(rs != null) rs.close();
				if(psm != null ) psm.close();
				if(coon != null) coon.close();
			} catch (Exception e) {
				System.out.println(" 登陆数据库验证异常 ！");
				e.printStackTrace();
			}
		}
		//System.out.println(outPut);
		return out+outPut+"</SELECT>";
	}
	public static void main(String[] args) {
		System.out.println(new FindDept().FindDeptName("TB08009"));
	}
}