organdao.java

来自「JSP移动商品管理平台源代码.........」· Java 代码 · 共 44 行

package imis_mate.DAO;

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

public class OrganDAO {
	private static final String SELECT_ORGANSQ_SQL = "" +
	"SELECT OrganId " +
	"FROM Organ " +
	"WHERE OrganId = ? ";
	public String getOrganSQL(int organId, String organName) {
		//根据部门编号 返回OrganSQL
		Connection connection = null;
		PreparedStatement pStatement = null;
		ResultSet rs = null;
		//int OrganId = -1;
		int supOrganID = -1;
		String sql = null;
		
		try {
			connection = DBConnection.getConnection();
			pStatement = connection.prepareStatement(SELECT_ORGANSQ_SQL);
			pStatement.setInt(1,organId);
			rs = pStatement.executeQuery();
			if(rs.next()) {
				supOrganID = rs.getInt("OrganId");
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBConnection.close(rs);
			DBConnection.close(pStatement);
			DBConnection.close(connection);
		}
		sql = 	"(SELECT organId FROM Organ "+
				"connect by prior organid = suporganid "+ 
				"start with suporganid = "+supOrganID+") " +
				"OR "+organName+"='"+supOrganID+"'";		
		return sql;
	} 
}