user.java

这是我上次报java培训时

package jinLing.user;

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

public class User extends PubDb {

    public Collection execSel(Hashtable list, String pageno, String count) {
        Collection col = null;
        String sql = "select * from TV_USER where 1=1 ";
        if (list.containsKey("USER_ID"))
            sql += " and USER_ID =" + list.get("USER_ID").toString();
        if (list.containsKey("USER_NO"))
            sql += " and USER_NO ='" + list.get("USER_NO").toString() + "'";
        if (list.containsKey("USER_SN"))
            sql += " and USER_SN='" + list.get("USER_SN").toString() + "'";
        if (list.containsKey("DEPARTMENT_ID"))
            sql += " and DEPARTMENT_ID='" + list.get("DEPARTMENT_ID").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;
        try {
            String sql1 = "select max(USER_ID) from TF_USER";
            id = super.getMax(sql1) + 1;
            System.out.println(id);
            String sql2 =
                    "insert into TF_USER (USER_ID,DEPARTMENT_ID,USER_NO,USER_NAME,USER_SN";
            if (list.containsKey("USER_TEL"))
                sql2 += ",USER_TEL";
            if (list.containsKey("USER_EMAIL"))
                sql2 += ",USER_EMAIL";
            sql2 += ") VALUES(" +
                    id + ",'" + list.get("DEPARTMENT_ID").toString() + "','" +
                    list.get("USER_NO").toString() + "','" +
                    list.get("USER_NAME").toString() + "','" +
                    list.get("USER_SN").toString() + "'";
            if (list.containsKey("USER_TEL"))
                sql2 += ",'" + list.get("USER_TEL").toString() + "'";
            if (list.containsKey("USER_EMAIL"))
                sql2 += ",'" + list.get("USER_EMAIL").toString() + "'";
            sql2 += ")";
            st = super.execUpd(sql2);
        } catch (Exception ex) {
            st = 0;
            ex.printStackTrace();
        }
        return st;
    }

    public int setRec(String USER_ID, Hashtable list) {
        int st = 0;
        String sql = "update TF_USER SET DEPARTMENT_ID='" +
                     list.get("DEPARTMENT_ID").toString() +
                     "',USER_NO='" + list.get("USER_NO").toString() +
                     "',USER_NAME='" + list.get("USER_NAME").toString() +
                     "',USER_SN='" + list.get("USER_SN").toString()+"'";

        if (list.containsKey("USER_TEL"))
            sql += ",USER_TEL='" + list.get("USER_TEL").toString()+"'";
        if (list.containsKey("USER_EMAIL"))
            sql += ",USER_EMAIL='" + list.get("USER_EMAIL").toString()+"'";
        sql += " where USER_ID='" + USER_ID + "'";
        st = super.execUpd(sql);
        return st;
    }

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