dao

最新推荐文章于 2024-11-09 17:02:07 发布

原创最新推荐文章于 2024-11-09 17:02:07 发布 · 143 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#DAO #SQL #UP

本文详细介绍了数据库中医疗信息的插入、修改和通过有效性的修改方法，包括使用PreparedStatement进行参数化查询，确保数据安全性和操作效率。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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();
    }
}