//设置可有可无 字段 加一个必有字段

     String optionals = "hospital_id ";

     String biyou = map.get("biyou") ;

     String optionalVal =  DataUtil.addFieldBlank(biyou) + ",";

     if(map.get("birthdate").toString().length()>) {

      optionals += ",birthdate";

      optionalVal +=DataUtil.addFieldBraces(map.get("birthdate")) + ",";

     }

     if(map.get("visit_time").toString().length()>) {

      optionals += ",visit_time";

      optionalVal +=DataUtil.addFieldBraces(map.get("visit_time")) + ",";

     }

        String visit_id = map.get("visit_id") == null ? "''" : String.valueOf(map.get("visit_id"));

        String sql = "INSERT INTO medical_record ("+ optionals + ",cid" +",doctor_code"

        + ") VALUES ("

        //

   +optionalVal     

  + DataUtil.addFieldBlank(map.get("cid")) + ","

  + DataUtil.addFieldBlank(diagnosis) + "," 

  + DataUtil.addFieldBlank(doctor_name)

        + ")";

        return update(sql, map);