gzdaurldao.java

以前做的一个j2ee的项目

package gov.gdlt.ssgly.taxcore.taxdao.gzda;

/**
 * <p>Title: </p>
 *
 * <p>Description: 广东地税税收管理员工作平台</p>
 *
 * <p>Copyright: Copyright (c) 2005 广东省地方税务局，广州市地方税务局</p>
 *
 * <p>Company: 广州地税</p>
 *
 * @author not attributable
 * @version 1.0
 */
import gov.gdlt.ssgly.taxcore.comm.dao.*;
import gov.gdlt.ssgly.taxcore.comm.config.ApplicationContext;
import java.sql.SQLException;
import java.sql.Connection;
import gov.gdlt.ssgly.taxcore.comm.servicelocator.JDBCLocator;
import java.util.List;
public class GZDAurlDAO extends BaseDataAccessObject {
    private String url;
    private String name;
    public GZDAurlDAO() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    public List getUrlList(String url){
       //对URl进行运算

       String durl="";
       int l=getSelecrUrlLength(url);

       durl=" url='A' and "+
           " ( leve = (select max(leve) from t_gzda_filemanagerabstr "+
             "  where leve<(select leve from t_gzda_filemanagerabstr "+
             "  where url='"+url+"') and "+
             "    length(code)=2 )" ;

       for(int i=3;i<l;i++){
           durl=durl+" or leve = (select max(leve) from t_gzda_filemanagerabstr "+
           "  where leve<(select leve from t_gzda_filemanagerabstr "+
           "  where url='"+url+"') and "+
           "    length(code)="+i+" ) " ;

       }
       durl=durl+" ) order by leve" ;

       return selectAll("T_GZDA_TREE.selecturlall", durl);

    }
    //取当前根节(文档)的URL 的长度
    public int getSelecrUrlLength(String url){
       int ri=0;
       Object obj = null;

       this.getSqlMapClient(); //获取SqlMap对象

       Connection connection = null;
       try {
           connection = JDBCLocator.getInstance().getJDBCConnection();
           sqlMap.setUserConnection(connection);
           obj = sqlMap.queryForObject("T_GZDA_TREE.selecturllen", url);

       } catch (SQLException e) {

       } finally {
           try {
               if (connection != null) {
                   connection.close();
               }
           } catch (SQLException e) {

           }
       }

       if (obj == null) {
           ri=0;
       } else {
          Integer iri=(Integer)obj;
          ri=iri.intValue();
       }


       return ri;
    }
    private void jbInit() throws Exception {
    }

    public String getUrl() {
        return url;
    }

    public String getName() {
        return name;
    }

    public void setUrl(String url) {
        this.url = url;
    }

    public void setName(String name) {
        this.name = name;
    }
}