geturl.java

ftp管理。构造网络路径部分比较好。内部有数据库截图。。

package common;

import java.sql.*;

public class GetUrl {
	/**
	 * 
	 * @author 隋玉杰 E-mail: [e-mail]
	 * @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;
	}
}