imgstorefiledb.java

来自「cwbbs 云网论坛源码」· Java 代码 · 共 199 行

package cn.js.fan.module.cms;

import java.io.*;
import java.sql.*;

import cn.js.fan.db.*;
import cn.js.fan.util.*;
import cn.js.fan.web.*;
import com.cloudwebsoft.framework.base.*;
import com.cloudwebsoft.framework.db.*;
import com.cloudwebsoft.framework.util.*;
import com.redmoon.forum.*;
import java.util.Vector;

public class ImgStoreFileDb extends ObjectDb {
    long id;
    String name;
    String diskName;
    String visualPath;

    public ImgStoreFileDb() {
        init();
    }

    public ImgStoreFileDb(long id) {
        init();
        this.id = id;
        load(new JdbcTemplate());
    }

    public void initDB() {
        this.tableName = "cws_cms_img_store_file";
        primaryKey = new PrimaryKey("id", PrimaryKey.TYPE_LONG);
        objectCache = new ImgStoreFileCache(this);

        QUERY_CREATE = "insert into cws_cms_img_store_file (id, dir_code, name, disk_name, visual_path, file_size, ext, upload_date) values (?, ?,?,?,?,?,?,?)";
        QUERY_LIST = "select id from cws_cms_img_store_file order by upload_date desc";
        QUERY_DEL = "delete from cws_cms_img_store_file where id=?";

        QUERY_SAVE = "update cws_cms_img_store_file set name=? WHERE id=?";
        QUERY_LOAD = "SELECT dir_code, name, disk_name, visual_path, file_size, upload_date FROM cws_cms_img_store_file WHERE id=?";
        isInitFromConfigDB = false;
    }

    public IObjectDb getObjectRaw(PrimaryKey pk) {
        return new ImgStoreFileDb(pk.getLongValue());
    }

    public ImgStoreFileDb getImgStoreFileDb(long id) {
        return (ImgStoreFileDb)getObjectDb(new Long(id));
    }

    public boolean create(JdbcTemplate jt) throws ErrMsgException,
            ResKeyException {
        id = SequenceMgr.nextID(SequenceMgr.CMS_IMG_STORE_FILE);
        try {
            jt.executeUpdate(QUERY_CREATE, new Object[]{new Long(id), dirCode, name, diskName, visualPath, new Long(size), ext, "" + System.currentTimeMillis()});
        }
        catch (SQLException e) {
            LogUtil.getLog(getClass()).error("create:" + e.getMessage());
            throw new ResKeyException("err_db");
        }
        return false;
    }

    public boolean del(JdbcTemplate jt) {
        boolean re = false;
        try {
            re = jt.executeUpdate(QUERY_DEL, new Object[] {new Long(id)})==1;
        }
        catch (SQLException e) {
            LogUtil.getLog(getClass()).error("del:" + e.getMessage());
            return false;
        }

        
        File fl = new File(Global.getRealPath() + visualPath + "/" + diskName);
        fl.delete();
        return re;
    }

    public boolean save(JdbcTemplate jt) {
        boolean re = false;
        try {
            re = jt.executeUpdate(QUERY_SAVE, new Object[] {name, new Long(id)})==1;
        }
        catch (SQLException e) {
            LogUtil.getLog(getClass()).error("save:" + e.getMessage());
            return false;
        }
        return re;
    }

    public long getId() {
        return this.id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return this.name;
    }

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

    public String getDiskName() {
        return this.diskName;
    }

    public void setDiskName(String dn) {
        this.diskName = dn;
    }

    public String getVisualPath() {
        return this.visualPath;
    }

    public boolean isLoaded() {
        return loaded;
    }

    public java.util.Date getUploadDate() {
        return uploadDate;
    }

    public String getDirCode() {
        return dirCode;
    }

    public long getSize() {
        return size;
    }

    public String getExt() {
        return ext;
    }

    public void setVisualPath(String vp) {
        this.visualPath = vp;
    }

    public void setUploadDate(java.util.Date uploadDate) {
        this.uploadDate = uploadDate;
    }

    public void setDirCode(String dirCode) {
        this.dirCode = dirCode;
    }

    public void setSize(long size) {
        this.size = size;
    }

    public void setExt(String ext) {
        this.ext = ext;
    }

    public void load(JdbcTemplate jt) {
        try {
            ResultIterator ri = jt.executeQuery(QUERY_LOAD,
                                                new Object[] {new Long(id)});
            if (id==0) {
                Exception e = new Exception();
                e.printStackTrace();
            }

            while (ri.hasNext()) {
                ResultRecord rr = (ResultRecord) ri.next();
                dirCode = rr.getString(1);
                name = rr.getString(2);
                diskName = rr.getString(3);
                visualPath = rr.getString(4);
                size = rr.getLong(5);
                uploadDate = DateUtil.parse(rr.getString(6));
                primaryKey.setValue(new Long(id));
                loaded = true;
            }
        }
        catch (SQLException e) {
            LogUtil.getLog(getClass()).error("load:" + e.getMessage());
        }
    }

    public Vector listOfDir(String dirCode) {
        String sql = "select id from cws_cms_img_store_file where dir_code=" + StrUtil.sqlstr(dirCode);
        return list(sql);
    }

    private boolean loaded = false;
    private java.util.Date uploadDate;
    private String dirCode;
    private long size;
    private String ext;
}