package common;

import java.sql.*;

public class GetUrl {
	/**
	 * 
	 * @author 隋玉杰 E-mail: suiyj1158@hotmail.com
	 * @version 創建時間：Nov 20, 2008 10:04:04 AM 
	 * 根據typeid找到文件夾路徑
	 */
	public static String geturl(int id) {
		String url = "";
		if (id == 0) {
			return "";
		}
		Connection conn = DAO.getConnection();
		try {
			Statement stmt = conn.createStatement();
			String sql = "select c_type_name,c_fid from t_type where c_id="
					+ id;
			ResultSet rs = stmt.executeQuery(sql);
			if (rs.next()) {
				if (rs.getInt("c_fid") == 0) {
					url = "soft\\" + rs.getString("c_type_name") + "\\"
							+ url;
				} else {
					url = GetUrl.geturl(rs.getInt("c_fid"))
							+ rs.getString("c_type_name") + "\\" + url;
				}
			}
			rs.close();
			stmt.close();
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return url;
	}
}