dao

public boolean insert(String medId, String medName, String spell, String medContent, String medException, String medUnit, String medMemo, String valid, String medLevel, String upMedId, String medType, String medRate, String areaSid)
  {
    String wb = "";
    Object[] array = { medId, medName, spell, medContent, medException,
      medUnit, medMemo, valid, medLevel, upMedId, medType, wb,
      medRate, areaSid };
    String sql = "insert into s_medical_info a values(";
    for (int i = 0; i < array.length; ++i) {
      if (i == array.length - 1)
        sql = sql + "?)";
      else
        sql = sql + "?,";
    }
    return executeBypreparedParameter(sql, array);
  }

  public boolean modify(String medId, String medName, String spell, String medContent, String medException, String medUnit, String medMemo, String medLevel, String upMedId, String s, String medType, String medRate)
  {
    String wb = "";
    Object[] array = { medName, spell, medContent, medException, medUnit,
      medMemo, medLevel, upMedId, medType, wb, medRate, medId };
    Object[] array1 = { medId, medName, spell, medContent, medException,
      medUnit, medMemo, medLevel, upMedId, medType, wb, medRate, s };
    StringBuffer sql = new StringBuffer();
    sql
      .append("update s_medical_info set ")
      .append(
      "med_name=?,spell=?,med_Content=?,med_Exception=?,med_unit=?,med_Memo=?,med_Level=?,up_Med_Id=?,med_type=?,wbCode=?,med_rate=? ")
      .append("where med_id=?");
    StringBuffer sql1 = new StringBuffer();
    sql1
      .append("update s_medical_info set ")
      .append(
      "med_id=?,med_name=?,spell=?,med_Content=?,med_Exception=?,med_unit=?,med_Memo=?,med_Level=?,up_Med_Id=?,med_type=?,wbCode=?,med_rate=? ")
      .append("where med_id=?");
    if ((s == null) || (s.equals("")))
      return executeBypreparedParameter(sql.toString(), array);
    return executeBypreparedParameter(sql1.toString(), array1);
  }

  public boolean modifyByValid(String medId, String valid)
  {
    Object[] array = { valid, medId };
    String sql = "update s_medical_info set valid=? where med_Id=?";
    return executeBypreparedParameter(sql, array);
  }

  private boolean executeBypreparedParameter(String sql, Object[] array) {
    DBOperator operator = getDBOperator();
    try {
      return operator.executeByPreparedParameter(sql.toString(), array);
    } catch (Exception ex) {
      ex.printStackTrace();
      return false;
    } finally {
      operator.closeConn();
    }
  }