templatedb.java

云网论坛CWBBS 源码,内容丰富,学习,参考,教学的好资料,具体见内说明,

package cn.js.fan.module.cms;

import com.cloudwebsoft.framework.base.*;
import com.cloudwebsoft.framework.db.JdbcTemplate;
import cn.js.fan.db.ResultIterator;
import java.util.Vector;
import java.sql.SQLException;
import com.cloudwebsoft.framework.util.LogUtil;
import cn.js.fan.db.ResultRecord;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class TemplateDb extends QObjectDb {
    public TemplateDb() {
    }

    public Vector getTemplatesOfLeaf(String dirCode) {
        String sql = "select id from " + table.getName() + " where type_code=?";
        JdbcTemplate jt = new JdbcTemplate();
        ResultIterator ir = null;
        Vector v = new Vector();
        try {
            ir = jt.executeQuery(sql, new Object[] {dirCode});
            while (ir.hasNext()) {
                ResultRecord rr = (ResultRecord)ir.next();
                v.addElement(getQObjectDb(new Integer(rr.getInt(1))));
            }
        }
        catch (SQLException e) {
            LogUtil.getLog(getClass()).error("getTemplatesOfLeaf:" + e.getMessage());
        }
        return v;
    }
}