package jinLing.info;

import jinLing.pub.*;
import java.util.*;

public class Info extends PubDb {

    public Collection execSel(Hashtable list, String pageno, String count) {
        Collection col = null;
        String sql = "select * from TV_INFO where 1=1 " ;
        if (list.containsKey("INFO_ID")) {
          sql += " and INFO_ID="+list.get("INFO_ID").toString();
        }
        if (list.containsKey("INFO_TYPE")) {
          sql += " and INFO_TYPE="+list.get("INFO_TYPE").toString();
        }
        col = super.execSel(sql, pageno, count);
        return col;
    }

    public Collection execSel(Hashtable list) {
        return  execSel( list, "1","1000000");
    }

    public int addRec(Hashtable list) {
        int st = 1;
        int id = 0;
        String sql1 = "select max(INFO_ID) from TF_INFO";
        id = super.getMax(sql1) + 1;
        String sql2 =
                "insert into TF_INFO (INFO_ID,INFO_TYPE,INFO_CONTENT,INFO_REMARK) VALUES(" +
                id + ",'" + list.get("INFO_TYPE").toString() + "','" +
                list.get("INFO_CONTENT").toString() + "','" +
                list.get("INFO_REMARK").toString() + "')";
        st = super.execUpd(sql2);
        return st;
    }

    public int delRec(String INFO_ID) {
        int st = 0;
        String sql = "delete  from TF_INFO  where INFO_ID='" + INFO_ID + "'";
        st = super.execUpd(sql);
        return st;
    }

    public int setRec(String INFO_ID, Hashtable list) {
        int st = 0;
        String sql = "update TF_INFO SET INFO_CONTENT='" +
                     list.get("INFO_CONTENT").toString() + "',INFO_REMARK='" +
                     list.get("INFO_REMARK").toString() +"'";
        if (list.containsKey("INFO_REMARK_2")) {
          sql += " and INFO_REMARK_2="+list.get("INFO_REMARK_2").toString();
        }
        sql +=" where INFO_ID='" + INFO_ID + "'";
        st = super.execUpd(sql);
        return st;
    }

    public String getIdValue() {
        int info_id = 0;
        String id = "";
        String sql = "select max(INFO_ID) from TF_INFO";
        info_id = super.getMax(sql);
        id = String.valueOf(info_id);
        return id;
    }
}