{"id":420,"date":"2024-08-10T23:34:03","date_gmt":"2024-08-10T15:34:03","guid":{"rendered":"https:\/\/forelink.top\/?p=420"},"modified":"2024-08-10T23:34:04","modified_gmt":"2024-08-10T15:34:04","slug":"%e7%89%87%e5%8c%ba%e8%a1%97%e9%81%93","status":"publish","type":"post","link":"https:\/\/forelink.top\/index.php\/2024\/08\/10\/%e7%89%87%e5%8c%ba%e8%a1%97%e9%81%93\/","title":{"rendered":"\u7247\u533a\u8857\u9053"},"content":{"rendered":"\n

\u7247\u533a\u8857\u9053\uff1a\u4fee\u6539\u4e86login\u8df3\u8f6c\u7f51\u5740<\/h1>\n\n\n\n

\u7247\u533a\u8857\u9053\u8868\uff1a<\/h2>\n\n\n\n
T_JD_PQ_JD_FL\n\nID\nPQID \u7247\u533aID\nJDBH \u8857\u9053\u7f16\u53f7\nJDMC \u8857\u9053\u540d\u79f0\nZXBZ \u6ce8\u9500\u6807\u5fd7\nBZ \u5907\u6ce8\nKZ1 \nKZ2\n<\/code><\/pre>\n\n\n\n
\u5efa\u8868\u8bed\u53e5\uff1a<\/h3>\n\n\n\n
create table T_JC_PQ_JD_FL\n(\n    ID          VARCHAR2(50) not null\n        constraint T_JC_PQ_JD_FL_PK\n            primary key,\n    DISTRICT_ID VARCHAR2(50),\n    STREET_CODE VARCHAR2(200),\n    STREET_NAME VARCHAR2(200),\n    DELETEFLAG  VARCHAR2(2),\n    BZ          VARCHAR2(500),\n    KZ1         VARCHAR2(4000),\n    KZ2         VARCHAR2(4000)\n)\n\n\/\ncomment on table T_JC_PQ_JD_FL is '\u7247\u533a\u8857\u9053-\u51af\u9e9f'\n\/\ncomment on column T_JC_PQ_JD_FL.ID is '\u4e3b\u952e'\n\/\ncomment on column T_JC_PQ_JD_FL.DISTRICT_ID is '\u7247\u533aID(\u53c2\u8003\u7247\u533a\u8868\u7684\u4e3b\u952e)'\n\/\ncomment on column T_JC_PQ_JD_FL.STREET_CODE is '\u8857\u9053\u7f16\u53f7'\n\/\ncomment on column T_JC_PQ_JD_FL.STREET_NAME is '\u8857\u9053\u540d\u79f0'\n\/\ncomment on column T_JC_PQ_JD_FL.DELETEFLAG is '\u6ce8\u9500\u6807\u5fd7'\n\/\ncomment on column T_JC_PQ_JD_FL.BZ is '\u5907\u6ce8'\n\/\ncomment on column T_JC_PQ_JD_FL.KZ1 is '\u6269\u5c551'\n\/\ncomment on column T_JC_PQ_JD_FL.KZ2 is '\u6269\u5c552'\n\/\n<\/code><\/pre>\n\n\n\n
\u7247\u533a\u8857\u9053\u7c7b\uff1a<\/h2>\n\n\n\n
public class DistrictStreet extends BaseEntity{\n    -------------------------------------\n    \u6210\u5458\u53d8\u91cf\uff1a\n    String:\n        id,districtId,districtName,streetCode,\n        deleteFlag,bz,kz1,kz2\n    \/\/\u5916\u90e8\u7c7b\uff0c\u7528\u4ee5\u5c01\u88c5\u53e6\u5916\u4e00\u4e2a\u8868\u4e2d\u7684\u6570\u636e\n    District:\n        district\n    -------------------------------------\n    \u6210\u5458\u65b9\u6cd5\uff1a\n    getter&setter\u65b9\u6cd5\n    toString\u65b9\u6cd5\n    \/\/setDistrict\u65b9\u6cd5\u4e2d\u83b7\u53d6District\u4e2d\u7684districtName\n    public void setDistrict(District district) {\n        this.district = district;\n        this.districtName = district.getDistrictName();\n    }\n    \n}\n<\/code><\/pre>\n\n\n\n
\u7247\u533a\u5217\u8868\u67e5\u8be2\uff1a<\/h2>\n\n\n\n
\u5217\u8868\u67e5\u8be2T_JC_PQ\u8868\u4e2d\u7247\u533a\u8857\u9053\uff0c\u5e76\u4ece\u5173\u8054\u8868T_JC_PQ_FL_1\u4e2d\u83b7\u53d6\u6570\u636e<\/p>\n\n\n\n
\u8fd4\u56de\u7684\u6570\u636e\u67e5\u8868\u4f1a\u5728\u7247\u533a\u8868\u4e2d\u5f97\u5230\u7247\u533a\u540d\u79f0<\/strong>\uff0c\u6240\u4ee5\u9700\u8981\u7ed9 \u7247\u533a\u8857\u9053\u7c7b<\/strong> \u589e\u52a0\u76f8\u5173\u7684\u53d8\u91cf\uff0c\u5e76\u63d0\u4f9b\u5bf9\u5e94\u7684\u65b9\u6cd5\u3002<\/p>\n\n\n\n
\u5b9e\u4f53\u7c7b\uff1a<\/h3>\n\n\n\n
\/\/ DistrictStreet\nprivate String districtId;\nprivate String districtName;\npublic District getDistrict() {\n    return district;\n}\n\npublic void setDistrict(District district) {\n    this.district = district;\n    this.districtName = district.getDistrictName();\n}\n<\/code><\/pre>\n\n\n\n
Controller\uff1a<\/h3>\n\n\n\n
\/\/DistrictStreetController\n\/\/shiro\u6743\u9650\u6807\u8bc6\u6ce8\u89e3\n\/\/RESTful\u8bf7\u6c42\u65b9\u5f0f\u4e0e\u8bf7\u6c42url\u6ce8\u89e3\n\/\/\u54cd\u5e94\u4f53\u6ce8\u89e3\n@RequiresPermissions(\"Estate:DistrictStreet:list\")\n@PostMapping(\"\/list\")\n@ResponseBody\npublic TableDataInfo list(DistrictStreet districtStreet)\n{\n    startPage();\n    List<DistrictStreet> list = districtStreetService.selectDistrictStreetList(districtStreet);\n    return getDataTable(list);\n}\n<\/code><\/pre>\n\n\n\n
Service\uff1a<\/h3>\n\n\n\n
\/\/DistrictStreetServiceImpl\n\/\/\u63a5\u53d7mapper\u8fd4\u56de\u7684\u6570\u636e\n@Override\npublic List<DistrictStreet> selectDistrictStreetList(DistrictStreet districtStreet)\n{\n    List<DistrictStreet> back = new ArrayList<>();\n    back =  districtStreetMapper.selectDistrictStreetList(districtStreet);\n    return back;\n}\n<\/code><\/pre>\n\n\n\n
Mapper\uff1a<\/h3>\n\n\n\n
\u9700\u8981\u5728mapperXML\u4e2d\u8857\u9053\u7684ResultMap\u4e0b\u52a0\u5165\u6807\u7b7e\uff0c\u83b7\u53d6\u7247\u533a\u8868 \u7247\u533a\u540d\u79f0\u6570\u636e\u3002\u67e5\u8be2\u65f6\u4f7f\u7528\u5de6\u8fde\u63a5\u67e5\u8be2\u8857\u9053\u4f5c\u4e3a\u4e3b\u8868\u6570\u636e\u3002<\/p>\n\n\n\n
<!-- DistrictStreetMapper.xml -->\n<resultMap type=\"com.shggc.project.forelink.Estate.District.domain.District\" id=\"DistrictResult\">\n        <result property=\"id\"    column=\"id\"    \/>\n        <result property=\"districtCode\"    column=\"district_code\"    \/>\n        <result property=\"districtName\"    column=\"district_name\"    \/>\n        <result property=\"deleteFlag\"    column=\"delete_flag\"    \/>\n        <result property=\"bz\"    column=\"bz\"    \/>\n        <result property=\"kz1\"    column=\"kz1\"    \/>\n        <result property=\"kz2\"    column=\"kz2\"    \/>\n<\/resultMap>\n    \n<resultMap id=\"DistrictStreetResult\" type=\"com.shggc.project.forelink.Estate.DistrictStreet.domain.DistrictStreet\">\n        <result property=\"id\"    column=\"id\"    \/>\n        <result property=\"districtId\"    column=\"district_id\"    \/>\n        <result property=\"streetCode\"    column=\"street_code\"    \/>\n        <result property=\"streetName\"    column=\"street_name\"    \/>\n        <result property=\"deleteflag\"    column=\"deleteflag\"    \/>\n        <result property=\"bz\"    column=\"bz\"    \/>\n        <result property=\"kz1\"    column=\"kz1\"    \/>\n        <result property=\"kz2\"    column=\"kz2\"    \/>\n        <association property=\"district\" resultMap=\"DistrictResult\"\/>\n<\/resultMap>\n\n<sql id=\"selectDistrictStreetWithDistrict\">\n        select * from t_jc_pq_jd_fl jd join t_jc_pq_fl_1 pq on jd.district_id = pq.district_code\n<\/sql>\n\n<select id=\"selectDistrictStreetList\" parameterType=\"com.shggc.project.forelink.Estate.DistrictStreet.domain.DistrictStreet\" resultMap=\"DistrictStreetResult\">\n    <include refid=\"selectDistrictStreetWithDistrict\"\/>\n    <where>\n        <if test=\"districtId != null  and districtId != ''\"> and district_id = #{districtId}<\/if>\n        <if test=\"streetCode != null  and streetCode != ''\"> and street_code = #{streetCode}<\/if>\n        <if test=\"streetName != null  and streetName != ''\"> and street_name like concat(concat('%', #{streetName}), '%')<\/if>\n        <if test=\"deleteflag != null  and deleteflag != ''\"> and deleteflag = #{deleteflag}<\/if>\n        <if test=\"bz != null  and bz != ''\"> and bz = #{bz}<\/if>\n        <if test=\"kz1 != null  and kz1 != ''\"> and kz1 = #{kz1}<\/if>\n        <if test=\"kz2 != null  and kz2 != ''\"> and kz2 = #{kz2}<\/if>\n        <if test=\"districtName != null and districtName != ''\"> and district_name like  concat(concat('%', #{districtName}), '%') <\/if>\n    <\/where>\n<\/select>\n<\/code><\/pre>\n\n\n\n
\u524d\u7aef\u9875\u9762\uff1a<\/h3>\n\n\n\n
\u5728columns\u4e2d\u6dfb\u52a0\u5143\u7d20<\/p>\n\n\n\n
\/\/DistrictStreet.html\n{\n    field: 'districtName', \/\/\u5143\u7d20\u540d\u79f0 \u4f20\u53c2\u65f6\u9700\u8981\u4e0e\u53d8\u91cf\u540d\u76f8\u5339\u914d\n    title: '\u5f52\u5c5e\u7247\u533a', \/\/\n    sortable : true\n}\n<\/code><\/pre>\n\n\n\n
\u5237\u65b0\u540e\uff0c\u5373\u53ef\u6b63\u786e\u663e\u793a\u5305\u542b\u7247\u533a\u540d\u79f0\u7684\u8857\u9053\u4fe1\u606f\u3002<\/p>\n\n\n\n
\u7247\u533a\u6761\u4ef6\u67e5\u8be2\uff1a<\/h2>\n\n\n\n
\u7247\u533a\u6dfb\u52a0\uff1a<\/h2>\n\n\n\n
\u7247\u533a\u540d\u79f0\u4e0b\u62c9\u6846\uff1a<\/h3>\n\n\n\n
\u200b    \u5728\u6dfb\u52a0\u9875\u9762\uff0c\u9700\u8981\u83b7\u53d6\u76ee\u524d\u6709\u7684\u7247\u533a\u540d\u79f0\uff0c\u5e76\u5c55\u793a\u5728\u53ef\u9009\u62e9\u7684\u4e0b\u62c9\u6846\u4e2d<\/p>\n\n\n\n
Controller\uff1a<\/h4>\n\n\n\n
\u9700\u8981\u7ed9\u524d\u7aef\u4f20\u9001\u5305\u542b\u6240\u6709\u7247\u533aid\u4e0e\u540d\u79f0\u7684\u6570\u636e\uff0c\u7ed9\u524d\u7aef\u83b7\u53d6\u67e5\u770b\u4e0e\u53d1\u9001id\u4e0e\u540d\u79f0\u6b63\u786e\u5bf9\u5e94\u7684\u8868\u5355\u3002<\/p>\n\n\n\n
@GetMapping(\"\/add\")\npublic String add(ModelMap modelMap)\n{\n       \/\/ \u901a\u8fc7Thymeleaf \u4e2d\u7684ModelMap\u5bb9\u5668\u6765\u5b58\n    modelMap.put(\"DistrictSelect\",districtStreetService.selectDistrictAll());\n    return \"Estate\/DistrictStreet\/add\";\n}\n<\/code><\/pre>\n\n\n\n
Service\uff1a<\/h4>\n\n\n\n
\u200b    \u5c01\u88c5\u6570\u636e\uff0c\u8c03\u7528mapper\u63a5\u53e3\u5e76\u5c06\u83b7\u53d6\u7684\u6570\u636e\u4f20\u7ed9\u524d\u7aef\u3002<\/p>\n\n\n\n
\/\/\u89c4\u5b9a\u8fd4\u56de\u7684\u7c7b\u578b\u4e3a List<District>\n@Override\npublic List<District> selectDistrictAll() {\n    return districtStreetMapper.selectDistrictAll();\n}\n<\/code><\/pre>\n\n\n\n
Mapper\uff1a<\/h4>\n\n\n\n
<select id=\"selectDistrictAll\" resultType=\"com.shggc.project.forelink.Estate.District.domain.District\">\n    select district_Code as districtCode , district_name as districtName , id , delete_flag as deleteFlag, bz from t_jc_pq_fl_1\n<\/select>\n<\/code><\/pre>\n\n\n\n
\u524d\u7aef\u9875\u9762\uff1a<\/h4>\n\n\n\n
<!-- \u4e0b\u62c9\u6846\u5143\u7d20\u503c\u4f1a\u88abdistrictId\u643a\u5e26\u4f20\u7ed9\u670d\u52a1\u5668 -->\n<select id=\"districtSelect\" name=\"districtId\" class=\"form-control select2-single required\" required>\n    <option value=\"\" disabled selected>-- \u8bf7\u9009\u62e9\u6240\u5c5e\u7684\u7247\u533a --<\/option>\n    <!-- th:each\u904d\u5386\u65b9\u6cd5 \u8bbe\u7f6e\u4e34\u65f6\u53d8\u91cfD\u83b7\u53d6ModelMap\u4e2dkey\u4e3aDistrictSelect\u7684value -->\n    <!-- th:text=\"\u4e0b\u62c9\u6846\u6587\u672c\" th:value=\"\u4e0b\u62c9\u6846\u5143\u7d20\u503c\" -->\n    <!-- \u63d0\u4ea4\u8868\u5355\u65f6\uff0c\u53ea\u6709th:value\u4e2d\u7684\u503c\u88ab\u4f20\u7ed9\u4e86\u670d\u52a1\u5668 -->\n    <option th:each=\"D : ${DistrictSelect}\" th:text=\"${D.districtName}\" th:value=\"${D.districtCode}\"><\/option>\n<\/select>\n<\/code><\/pre>\n\n\n\n
\u7247\u533a\u4fee\u6539\uff1a\u6ca1\u505a\u5b8c<\/h2>\n\n\n\n
\u6570\u636e\u56de\u663e\uff1a<\/h3>\n\n\n\n
\u9700\u6c42\uff1a<\/h4>\n\n\n\n
1. \u8fd4\u56de\u5305\u542b\u4ee5\u4e0b\u6570\u636e\u7684\u7c7b\n    \u7247\u533a\u540d\u79f0\n    \u8857\u9053\u7f16\u53f7\n    \u8857\u9053\u540d\u79f0\n    \u6ce8\u9500\u6807\u5fd7\n    \u5907\u6ce8\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u7247\u533a\u8857\u9053\uff1a\u4fee\u6539\u4e86login\u8df3\u8f6c\u7f51\u5740 \u7247\u533a\u8857\u9053\u8868\uff1a \u5efa\u8868\u8bed\u53e5\uff1a \u7247\u533a\u8857\u9053\u7c7b\uff1a \u7247\u533a\u5217\u8868\u67e5\u8be2\uff1a \u5217\u8868\u67e5\u8be2T_JC_ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[32,33,31],"tags":[],"class_list":["post-420","post","type-post","status-publish","format-standard","hentry","category-shggc","category-33","category-31"],"_links":{"self":[{"href":"https:\/\/forelink.top\/index.php\/wp-json\/wp\/v2\/posts\/420","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/forelink.top\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/forelink.top\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/forelink.top\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/forelink.top\/index.php\/wp-json\/wp\/v2\/comments?post=420"}],"version-history":[{"count":1,"href":"https:\/\/forelink.top\/index.php\/wp-json\/wp\/v2\/posts\/420\/revisions"}],"predecessor-version":[{"id":421,"href":"https:\/\/forelink.top\/index.php\/wp-json\/wp\/v2\/posts\/420\/revisions\/421"}],"wp:attachment":[{"href":"https:\/\/forelink.top\/index.php\/wp-json\/wp\/v2\/media?parent=420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/forelink.top\/index.php\/wp-json\/wp\/v2\/categories?post=420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/forelink.top\/index.php\/wp-json\/wp\/v2\/tags?post=420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}