1. 前情
最近给领导做了个财务的月看板, 领导提出了个需求, 每个月的数据构成都不同, 他需要在页面上详细描述内容, 需要可以一个留言的功能.
2. 措施
使用文本框的编辑后事件, 利用js调用SQL函数, insert文本框的内容
3. 提要
使用的数据库: MYSQL8.0.24
SQL函数需要SQL语句执行的返回结果集, 所以必须使用存储过程, 在insert后返回一条结果!
4. 实施
- 在数据库中创建存储过程:
-
CREATE DEFINER=`root`@`%` PROCEDURE `ann1`(IN t VARCHAR(50))
BEGIN
INSERT INTO common (annotation1) VALUES (t);
SELECT 1;
END
- 在文本框控件的编辑事件js中, 添加如下代码:
-
// 获取文本框控件编辑后的值
var value = this.getValue();
// 拼接sql, value需要拿引号引起来, 避免字符串格式无法存储
var sql = "call ann1('" + value + "')";
// 使用SQL函数
var result = FR.remoteEvaluate('SQL("ITSM测试可写","' + sql + '",1,1)');
- 在文本框默认值中, 读取数据库值
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAR8AAACqCAYAAACUJ0s/AAAbZklEQVR4Ae2dTYskRRrH/TLWF9nvIPRlT1502wbBi6wX0YMHbZzBbi9exOs4NfQgC14aoQsHnOrxtdEedV7QHdlxHFfUEVl5licyn4gnIyKrIqM6srOy/gVFRkbG6z+f+OUTkVmVj1HL59atW/Tvfz+g+//9vSXFZkezLo/+/B++SgNoErcH6BLqwpo81oYQwKdNmSoeBhU3KAAZuqTYAOCzmC8LjwI+GGQpg4zTwFbitgLPZyFi2g/CoOIGlTogNykdbCVuK4BPO18WHoFBxQ1qk6CS2lfYStxWAJ+FiGk/CIOKG1TqgNykdLCVuK0APu18WXgEBhU3qE2CSmpfYStxWwF8FiKm/SAMKm5QqQNyk9LBVuK2Mjz4/IfombfaB31w5BOiv/2T6F5woGxEvwZ1nS48/g+6dDc8iWYQ371CTz0+oceXfbev0HfquZyzBkC/migtuP9+3z56Y7keVq836Npa68L20a0P303/QRc+Uhr++T/iuKemP/Ty7BrbytrB5+ITRH9L+XYBWAan+h5obBiPX7y+2DA+eqM344mBq7QmRgMLDIZtDeQYfArCJNb3RXF96OJAwiCKXIgatvMDXdoWWLlw7/Dhp5gXfVm4kp97/0qDyXHdiIspXg57Q2sLHzaGiPHEDOrxSQM2bDzOCJtXtUWD46yOlR5kYTtbtKq9oGsXKziF0HLg6kOzsrr8QJcuVh5tBY8rdMH3AhnOGj7sFcq+Olbl79Hz+fm/vxF/Hz58GP32AZ+Lnyi8RaZdV/5J5MNHoHXlP3VeBs4TRM/8i4jWGj750Lh2sR1afbjTZQfZAl2056PCGj4GyouOFfSUSury3fSNejp+vYaObJVeCjAMcLYTsYc4mCs7KnkhY00eGxp8GCoGIIpHGj7HbynIEJFASOAk+w2gqbLOKljSoNwVPlzr0Ybj0rGhOfe5Gd/fXL6sJgumEwoqj1RYwydcD3NeUclBxueinC7a85M1wQU6MWBZH+sxc1qZfvVnJ6LJ4OBj13TUtEnDR8OD42V6xfmsF6QTFQqXM6j6imUXTJ1x8ElzV6pm/KM/I1e8+mrOeUoPMDEo3hb9eldxU5c/jYhMu8bq+Zj+371Cl+ziccQOlGZ88bpwsV4b9NYIN3faxdOtJ4jEYxEPhj0aHz7i/fiwMTB6wk3RCnHHFFsSPgYwMm/3B5ZcqThe0sgVTebxHgDGBB+ZZphBVA+4xqDZKM+HQa89HfZ+FsHnB7o0vU6PPOjIxaKho2dDkuastjx+huH51FMpHyaydmPhU6/rJN3tKgyhkvDxT3A11bpuFqJbPZjanQ6nF25x1S/3rPfLa3KdLghg7dWcpx4y5ainFXUaPe3ydVt0bJ10MRcquSAZYGgYqTVA0Y3T1PCp8qo0/k0NneeMYTQc+OgF54i7YuFTH2OvSDwkPzmnDSDmJzqD/fIDTU1fBCyZxiAD7awHlV9eaU14sBiI6Cmp7wEqTzGl37bMMx5cWpvSulR1VdC58NEiz8dN6WXBWbeTtYjF6zRnFV5r+CzyfkYDHz3I6isWezbdDMTzDNZ2kKnFVevZRLy6BnwWXNXVVd73is5qgEk5ZeEjusgaIOCT7Fu0ejF6iuU929Oap14fWm/4iDFN3LMYHjC0u8wDh6dl8elWGF9yoJUdZMoTrPXQV2pfExn4y7acr6QmXH9JXfTaF0+nFtqBeM5Y80nm0yATljSoZQNmqMehSQjI0vAZqi0saxfbyrkvOA+SLAmNwkALBxo0CTUBfNo1AXwSQBNLgoEWGhU0CTUBfNo1AXxiZEmIw0ALjQqahJoAPu2aAD4JoIklwUALjQqahJoAPu2aAD4xsiTEYaCFRgVNQk0An3ZNAJ8E0MSSYKCFRgVNQk0An3ZNAJ8YWRLiMNBCo4ImoSaAT7smgE8CaGJJMNBCo4ImoSaAT7smgE+MLAlxGGihUUGTUBPAp10TwCcBNLEkGGihUUGTUBPAp10TwCdGloQ4DLTQqKBJqAng064J4JMAmlgSDLTQqKBJqAng064J4BMjS0IcBlpoVNAk1ATwadcE8EkATSwJBlpoVNAk1ATwadcE8ImRJSEOAy00KmgSagL4tGsC+CSAJpYEAy00KmgSagL4tGsC+MTIgjgoAAWKKwD4FJcYFUABKBBTAPCJqYI4KAAFiisA+BSXGBVAASgQUwDwiamCOCgABYorAPgUlxgVQAEoEFMA8ImpgjgoAAWKKwD4FJcYFUABKBBTAPCJqYI4KAAFiisA+BSXGBVAASgQUwDwiamCOCgABYorAPgUlxgVQAEoEFMA8ImpsuZxP//8M3399df01Vdf4QsNitsA2xrbXNcP4NNVsTVIz8bw6NGjNWgpmjgGBdjW2Oa6fgCfroqtQXr2ePCBAn0qkGNzgE+fZ6inunIMoaemoZqRKpBjcz3A55j2J9t0cC9B9XsHtD2Z0GSyT8dEdLw3of0bCfmQpKFAjiE0CsAOFOioQI7NFYYPg4dhEv9uX71vunj/6nadpoKOiTQgUvsdxdjk5EsN4cER7V4+tRI9nO3S7uyh3Sd6SEev79LRAxUVBE9purVFW43vlFypQQZEjFiBpTYX6Xsx+AhQop4Lg2XngCr0SKvu08GOwIbDi4ElubANFUgxBB84bj8CHoaVgkwFKoaPhg3n0/thuxAzXgVSbM7vfRH4GPDUcDne86ZcN/Zp0gBPG2gERK7JmIY5LRaF0gxBYMFb34Op918/IuMPMXwkfHNae0mAz6JzsGnH0myuqUoR+DSrqKZe7AExPCZ7vJoT+3A6Ac4xHagpmZmeRb2lWDmI62YIAiFft1OaCnBa4eNDC56Pr+Km7HezuUqVHuBDtHAKJmeHPSKzNtT0lDivrA1JUmwXK7DMEMTTmd7kchLhg2nXYtE3/Ogym4vJUxQ+xtNpWWxm0Dio3KeDvX3aN2s+x7TP0zKG0d6xAdf21WOzBhRdP4r1asPjUgyB13gcfHwPBtOuDTehzt1PsTm/0CLwEehs7yzwWm7sW/hU3g0Dxk27ZArmPJ8Ot+z9Xm7YfoohNOEzpVN7B0ymW7Iloti0i+OUN1Td9cK0a8NMzXY3xeZs4jpQBD5SiQOHxKitgs/xHkNH7nZVC9Di5TTKCBarVXkIWgVSDMHBp86mF5JlrUdKjMHn5pS21O369umbFILtmBVIsTm//8Xh0/aMT3Paxc0S+DSb2IBP8xD2WhRIMQSBz8PZ1DzPc3p5q56GeR4PA8bzcnZnp+YOWTVtk0a0rR3JcWzHrECKzfn9Lw4ft67jVa08n+qIBx+7AI2nnD3llu6mGALDh6dK/MwOg8d5MS3wUd6QydvwerhJgM/SEzPiBCk253e/KHz8yrDfjwIphiCeDm/Dp5vdAnTTu/HWf7g7PP2StR8FqH56ilqGokCKzfltBXx8RUawn2MII+g2unCOCuTYHOBzjiesVNU5hlCqLSh3MxTIsTnAZ4S2kWMII5QBXepRgRybA3x6PEF9VZVjCH21DfWMU4EcmwN8RmgL+BvVEZ7UAXcJf6M64JPTd9PwB/L443z2RPr64g/k+x7hqA8KQIGVFMC0ayX5kBkKQIFcBQCfXOWQDwpAgZUUAHxWkg+ZoQAUyFUA8MlVDvmgABRYSQHAZyX5kBkKQIFcBQCfXOWQDwpAgZUUAHxWkg+ZoQAUyFUA8MlVDvmgABRYSQHAZyX5kBkKQIFcBQCfXOWQDwpAgZUUAHxWkg+ZoQAUyFUA8MlVbsD58MPS/n5U2dePN4dcD35YOmAY9N00/KVG34pvdn34S43NPv+N3vNVEh8o0KcCOTa31tMufqeXvFywErp+1XKfqg+wrhxDGGA30KQ1UiDH5srA594BbQfvaN+mg3usZvV+roOrzVcpH+/Jca249y4vfUheMqje7xV9QeHecSPXJuzkGMIm6II+llMgx+bKwccMevFEGCICFwGKjmNR+F3s8q52EUnSyr7aMuACsEh9Kt0GBjsZgnkbqbxj/ZSmWxJOEE5esWze3dUhX0LRSLJeCnSyubpr5eDDns/ePu3v8HdCk4kPn4i4AVBiQKryudcoM6C4/Mh354DuR6oZe1QXQ/BfGujvL9RK4MOJgne3L8yJgyNToIvNSdfLwSfi+ezvbYeQCLwXaRpv2+DD8ROqXsXse1B1fgYZ4KPFDMMMjOAto773w/vuDab27aRtccFrlMNqETMsBW7dukW//vpra6P4GKdZ9BkWfAJPRDwfHyjKcwlAxGkln+u68Xp2ZM1I5ffrBHycaEGIobJLRw+CA5UXE0Apko6nbIBNRJj1irp79y598sknrY3mY5xm0Wc48LGtjK3BVF5L8y4VEfHCsQ+fejG58nBsoXR89YCO7YI1PB+nTBVabgiVN9N8R3uzlIez3YhX1ExDgI8nyPrufv755/TNN98EHeA4Prbss9zmwhLKTLuid6BqD4aP7WzT/lVvNSYCn+O9Ce3fiAGMCGs+4cmUmGWGEK7rxL0gA6DLp2S2wTSLvaZTmqZ4SNIwbAerwB9//EGz2Yx+/PFH20YOcxwfW/ZZZnOx/GXgY2sKwVEBhb0V786WwMeu1bjpWew2fBM+4dSMbDm2MRsT6GoIDJdFXpATzofNQzp6HXe5nD7rHWLYfPjhh7YTHNYwsgciga42x0UUgQ+DIXb3af8qP/9TQcfBo+6J9Zaq4wwpO92KgMTlx5qPbwudDIGnTtZ7YZhs0fSmX6Ls+/AhYi+qPb3kw3ZdFPj222/piy++MF8Op3462VxdaBH4mLtUfIt974DuG4/mwN4Od2s9zcVkA6x6zYfB46//mONqAbkJH3g+2kjSDSHuuZxeblmIphA+jVvsDZDpFiG8Tgp8/PHHxN8un3Sbc6UWgU81tSJqTJdkWuXqrhaZFVD4kIaQTuofq+BzYG65x7wsG+eV75c5xv1UQ9BeS7iuE5tOebfdzZ2uylvaqteG0qZvY1R9PH36/fffib9dPqk2p8ssAh9dAcL9K5BiCD5sAmjYBwhruJgF5xiQuH8CpTaPqX8NUGO/CqTYnN8iwMdXZAT7OYYwgm6jC+eoQI7NAT7neMJKVZ1jCKXagnI3Q4EcmwN8RmgbOYYwQhnQpR4VyLE5wKfHE9RXVTmG0FfbUM84FcixOcBnhLaAv1Ed4UkdcJfwN6oDPjl9Nw1/II8/kGdPpK8v/kC+7xGO+qAAFFhJAUy7VpIPmaEAFMhVAPDJVQ75oAAUWEkBwGcl+ZAZCkCBXAUAn1zlkA8KQIGVFAB8VpIPmaEAFMhVAPDJVQ75oAAUWEkBwGcl+ZAZCkCBXAUAn1zlBpwPDxn294BdXw/yrVJP7kOApU0c8Cmt8DmUj59XnIPoA64y9+cPpbsE+JRW+BzK56skPlBAKzBEmwB89BkaSXiIhjYSade2G0O0CcBnbc2pveFDNLT21uJIHwoM0SYAnz7OfM91DNHQepagW3X8znr9Z/j6BYnqddD8v9fmNUH2/60j1Zg3eExpal9BpP8DO+Gd91wft0e3oSUcqb01KtcmTk5O6LXXXqMnn3yS3nvvvdbycw4APjmqDTxPrqG5bskfwstgifxxvD9A1CDlcvjNGNWAdqXqkLyoULZmwNXvD7NvVOWB3DLw3B/eL2ir5LfvJZMWCBDUH94bAB3R0esqjvPXMOD6LHzq/rk2SLlE7hXSXIcqSyUJggZYR/RQDiyCm6TpuM21iVdeeYVeeuklU9u1a9c61ro4OeCzWJ+1PJpraFVnq8GsBxYPuq0tB6BqXw+sejCrQb4QPmqwNeBTA8zCR6lv6lTlJ7XVwGeXdn0ImPp3aXdL94FLFGCwBlM65XQt8DFpLx/REUO2BZAm3oOy6pILKj1cJDVgp+Nzwrk2wX24ebP1LZI5TbF5AB8rxXgCuYZmFKgH7NEDrUcFpOrNpDrclmax58NwsW85vTmtwg+OaDqrrv3J8FnWVnN8Skfe66Ar4B3RtIaPq68LfHTfdTjyYkXGmgG4ByoBUwt8uF2LwKZrXRbuahM7OztB3Rwnn/fff5+efvppunPnjkR13gI+nSUbfoalhuZPmeordwWE2ovZUoDQXa4H9KmOq8NmsCjvJT7tqr2KSH6JcjCQmHrwBp5PYlu5vzavBox4PlU505v6WJvns6TO2Ftda/hob9JNz+qpmm2f9FnaIvurbZfahFc8r/W888479OyzzxKH+cvw4XWfL7/80oBp1WkY4OOJPobdroYW7bMHKO2p6CmYzmuu7svg03KV1+Wkw6fO1dZWC0oGXg0aW7+Ks5XLgK8ByWm5P/UaDPdPdJCw79Hszo5oGoCkgmd3+Jyf58OSvPjii3ThwgWrzgcffEDPPfccPfXUU8Sez6ofwGdVBQeY/0zgo/tlBrEavGr9RydL8nwaXojO7cKd4eOyVgu+GjR1W7lMBocDZBM+HL87O60XieupUwJ8qqoZWrImpsOuYVX5dklZLUy3eT4ubzT04Cga3RaZYxN///vf6eDgwBb5/fffG4/n0qVLNm6VAOCzinoDzbvU0DxPQdYVzFWdj8lahO0fDyiZhvGglTAnOKUjs1bTjNcgssVwwHoejdjGTjJ8lrXVQLOGgknLd7Ok7U34nF5muNaez6zWIAE+pzO+S9UETlVWo0sd1nwqreWcxLdTOr05bVawZG+pTUTyc92ffvqpOfLgwQN64YUXiMHD8WfxAXzOQsWBlZFjaK4LTYiYeAMrWR+RxVPxhB66Oz4KWq3wMe91Fy/B1apDyfCp3xEvU6GgrRo+JszTGKlbw4fDEu8Gf2OaVK/bSF3syUwvC6ib8LFeDtdZT8FsnO6ohFU6iVq6LQyfu3fv0jPPPEO//PIL/fbbb/Tyyy/T22+/bZr1/PPPGwgtbeOSBIDPEoHW8fBq8OEeVwByV10HHquHAZJbk5jO6mdy6sFm4OPfglbrQTKIbXkqkA6fJW3V8DHeiX72SMGH05m2VeAR6PjtMMCp7zpzuLmILVrUC9UMM1uu6lwsmJpO5eX6u3y62sTh4aF5uPCvv/6iV199ld58801bHS80n4X3A/hYSccT6GpovfecB1tkUbb3dkiFZkGZ13tkSiYHGEa7dMTTMANSB2GZWhkI8THl9XFuiW+HrPOwuGwBntQcbv0LQtlp11tvvUXvvvuuucv12WefBc2RO2DBgQ4RgE8HsdYl6eDhE7v1vC7irmk7u9oEr+3M5/OivQV8isp7PoV3NbTzaSVq7VOBIdoE4NOnBfRU1xANraeuo5oWBYZoE4BPy8la5+ghGto66zmGtg/RJgCfMViW1wf8jaonyIbv4m9UN9wA+uw+/kAefyDPno588QfyfY4+1AUFoMDgFcC0a/CnCA2EAuNUAPAZ53lFr6DA4BUAfAZ/itBAKDBOBQCfcZ5X9AoKDF4BwGfwpwgNhALjVADwGed5Ra+gwOAVAHwGf4rQQCgwTgUAn3GeV/QKCgxeAcBn8KcIDYQC41QA8BnneUWvoMDgFQB8Bn+K0EAoME4FAJ8Rnlf8sNT9qFJ+XIltOU1yf7gK+IwQPvhLjRGe1AF3KfcvOwCfAZ/U3KbxVR4fKNCnAjk2B/j0eYZ6qivHEHpqGqoZqQI5NtcffG7s0/bV+0ulP96b0GQySUq7tLANTZBjCJsg1U8nM5rf0T29TfPZCf2koxDOUiDH5gYCn2Pan/jQuU8HO1Ucw6j67tNxljSblWm5Idym+fx2RJTbND+cU+wI/XRCsyDPT3QyO6TDwxmdtIxgHvCHQT6vai77kMvRXymT65jTycmMZqqS23M5rsuq0kbbT/WxO3OvHl3n4fK26uoQtgostzmb1AZ6hc9kT6Hj3gFt7xxQ5Qsd074NS9sYPho2/r6kw9ZXIMUQGAo8mA0cGoO+ORjtgL8zbwz+Kp8AgKF16HkVrlVSl4vxQhZs4okwKKRsAYqO4/wxUEpar3zetXXoY1KfjkM4R4EUm/PLLQKf+1e3a09FeTM39mky2aaDe0TE4JGwaRHg45+YVfbTDOEnOpn7U462Ad0EEnsos9nM8yDmNJ8f0mF0GuODw+udeD7zOc1n/OX6fPh4eXg3AEqs/VU+B0BuS9gf43VF2x6pF1GBAmk218xWBD66CgbR/g0i4jWfHYGS9mg4tZt2yRRr++oxPB8tZIdwJ0OQgd/i/VRrJBU8GDhq5tOhRZVn1Dr9shART6Sqbz73AbdsWtQGn6r+yotrASG3AfDpcE6bSTvZXJ21MHzUVMksODNQau+n0XZ4Pg05VtxZbAjuym+nVLa+lsFr4HBip0KNqZoasBzfXNCtC+Z1lrnLb6uTQBSAAjq/Ta79Icw4reSTwtlBmhlPzcEHno9T52xCi20uXkdR+LDXY+9wyd2uxlqPNArwESXOYptkCGYN53b7FEQ8odkJ3THrQ5y2GthuClN7KvV6UBw+FSwMlAyE4svBVb/F89EqVF5LALVYWfVisg/V2ycndNsuWMPz0eqeVTjJ5rzKysHHrOuo6ZXAh4jMmlBjgRnw8c7LSrtJhqAWkON3jhwIbvNajsDocEaN6RB7Povgw0Cw3lHLwK+h4epQaz4m/4zm/nyP4727aNzO+R3Xbi2iA6bynGyf6v7ZduqcCKcokGRzXkGF4FOt4Zi1HqlQwYejzPM8FkBN+PAxrPmIcN23SYbQgI+Giwo3BqMDhxvIyzyfiNcSgYbrYQiOCihct/cIgJRj12rc9CwGU9dm1w9Xb7143ehv4yh2liiQZHNeGUXgU8Gj+UBhYwpWN8IAiG+/Gy9JnuWZVAvUVK8X6WMWVl4vsNtQIMkQGvAJ10nMrezGYHQeQ+NOF6dp8XwYHP4UiBvqxzMYml5PBcD5CT//U0HHwaPuKsPHeC7V8UaZFkhOFpff9SOos9Fflxeh5Qok2ZxXTBH46DoMYMxDgrGF5jol34YPwKIWq3WBCC9VIMkQDDBOzBO+J41ple/56MHasuZTt4gHuLs7tujOVFWmAxN7PHyrvgJZtThdA8g+kdxcTDbAqqddDB5/CmaOK5g04ROBbQRYS4VGAqtAks3Z1FWgOHy8+rDbgwIphmAGZ+1VxKYpcc9HwWc+r55KZgBYL6Q63vBCWvvrAMTpGVqNdsi0SufnOAUUPqQhpJP6xyr4nJiHIQOPR6/9eOX7ZWI/rkCKzfk5AR9fkRHsdzWEYNDXg9F5JiMQBV0oqkBXm+PGAD5FT8n5FJ5jCOfTUtQ6FgVybA7wGcvZV/3IMQSVHUEo0FmBHJsDfDrLPPwMOYYw/F6hhUNWIMfmAJ8hn9HMtuUYQmZVyAYFjAI5Ngf4jNB4cgxhhDKgSz0qkGNzgE+PJ6ivqnIMoa+2oZ5xKpBjc4DPCG0hxxBGKAO61KMCOTb3f/8V8TvPRKhYAAAAAElFTkSuQmCC)
|