accept.java

这是我上次报java培训时

package jinLing.accept;

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

public class Accept extends PubDb {

    public String get_department_id(String ACCEPT_ID) {
        String id = null;
        String sql = "select DEPARTMENT_ID from TF_ACCEPT where ACCEPT_ID='" +
                     ACCEPT_ID + "'";
        id = super.execSelSingle(sql, "DEPARTMENT_ID");
        return id;
    }

    public Collection execSel(Hashtable list) {
        Collection col = null;
        String sql = "select * from TV_ACCEPT where INFO_ID=" +
                     list.get("INFO_ID").toString();
        col = super.execSel(sql);
        return col;
    }

    public String getInitData(Hashtable list) {
        String sql =
                "select DEPARTMENT_NAME, ACCEPT_ID from TV_ACCEPT where INFO_ID=" +
                list.get("INFO_ID").toString();
        String str = super.getInitData("DEPARTMENT_NAME", "ACCEPT_ID", sql,
                                       "---------请选择---------", "");
        return str;
    }

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

    public int setRec(String ACCEPT_ID, Hashtable list) {
        int st = 0;
        String sql = "update TF_ACCEPT SET USER_ID='" +
                     list.get("USER_ID").toString() + "',IF_ACCEPT='" +
                     list.get("IF_ACCEPT").toString() + "' where ACCEPT_ID='" +
                     ACCEPT_ID + "'";
        st = super.execUpd(sql);
        return st;
    }
}