SOURCE

function addBank(fatherId, bankName, lng, lat, address) {
  if (isEmpty(bankName) || isEmpty(address) || !fatherId) {
    alert("请完整填写支行名称、地址、父级支行");
    return;
  }
  fatherId = isEmpty(fatherId) ? NULL: fatherId;
  var bank = {
    "bank": bankName,
    "fatherId": fatherId,
    "lng": lng,
    "lat": lat,
    "address": address
  };

  $("#yhAccSql").append($("#bankSql").html().format(bank)).append("<br/>");
}
// addBank("支行1", "地址1", 1, 12.22, 13.33);
// addAccount("南方", "15367", 123)

function addAccount(realName, phone, bankId) {
  if (isEmpty(realName) || isEmpty(phone) || isEmpty(bankId)) {
    alert("请完整填写姓名、手机号、支行ID");
    return;
  }
  var acc = {
    "name": realName,
    "phone": phone,
    "bankId": bankId
  }

  $("#yhAccSql").append($("#accSql").html().format(acc)).append("<br/>");
  
}

$("#yhBankBt").click(function() {
  var d = $("#yhBank").css("display");
  if (d === "none") {
    $("#yhBank").show();
  } else {
    $("#yhBank").hide();
  }
});
$("#yhAccountBt").click(function() {
  var d = $("#yhAccount").css("display");
  if (d === "none") {
    $("#yhAccount").show();
  } else {
    $("#yhAccount").hide();
  }
});

<button id="yhBankBt">添加支行</button><button id="yhAccountBt">添加账号</button>

<div id="yhBank">
  <h3>添加支行</h3>
  <span>名称：<input/></span>
  <span>地址：<input/></span>
  <span>经度：<input/></span>
  <span>纬度：<input/></span>
</div>
<div id="yhAccount">
  <h3>添加账号</h3>
  <span>姓名：<input/></span>
  <span>手机号：<input/></span>
  <span>支行ID：<input/></span>
</div>
<div id="yhAccSql">
  
</div>

<p id="bankSql" style="display:none;">
  INSERT INTO `manage_bank`(`father_id`, `bank`, `type`, `lng`, `lat`,`address`, `is_delete`) VALUES({fatherId}, '{bank}', 4, {lng}, {lat}, '{address}', 0);
</p>
<p id="accSql" style="display:none;">
  INSERT INTO `manage_account`(`name`, `phone`, `account`, `is_test`, `acc_type`, `cid`, `password`, `salt`, `is_valid`, `is_delete`) VALUES('{name}', '{phone}', '{phone}', 0, 1, '1', '1', '1', 1, 0);<br/>
INSERT INTO `manage_account_bank`(`acc_id`, `bank_id`, `type`, `is_delete`) VALUES <br/>
((SELECT ma.`id` FROM `manage_account` ma WHERE ma.`phone` = '{phone}'), 1, 1, 0),<br/>
((SELECT ma.`id` FROM `manage_account` ma WHERE ma.`phone` = '{phone}'), 2, 2, 0),<br/>
((SELECT ma.`id` FROM `manage_account` ma WHERE ma.`phone` = '{phone}'), (SELECT mb.`father_id` FROM `manage_bank` mb WHERE mb.`id` = {bankId} AND mb.`type` = 4), 3, 0),<br/>
((SELECT ma.`id` FROM `manage_account` ma WHERE ma.`phone` = '{phone}'), {bankId}, 4, 0);
</p>

#yhBank,
#yhAccount {
  display: none;
}
button {
  padding: 5px;
  margin: 5px;
  border-radius: 6px;
  background-color: green;
  border: solid 1px green;
  color: whitesmoke;
}
input {
  border-radius: 5px;
  min-height: 25px;
  border: solid 1px graytext;
}