database_operation.html 3.4 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  2. <html>
  3. <head>
  4. <title>数据库操作</title>
  5. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  6. <META http-equiv=Pragma content=no-cache>
  7. <META http-equiv=Cache-Control content=no-cache>
  8. <META http-equiv=Expires content=0>
  9. <link rel="stylesheet" href="../../js/xheditor-1.1.14/common.css" type="text/css"></link>
  10. <script language="javascript" src="../../easyui/all.js"></script>
  11. <script type="text/javascript" src="../../easyui/easyui-validate.js"></script>
  12. <script type="text/javascript" src="../../easyui/datagrid-detailview.js"></script>
  13. <script type="text/javascript" src="../../commons/js/common.js"></script>
  14. <script type="text/javascript" src="../../commons/js/HospitalData.js"></script>
  15. <script type="text/javascript" src="../../commons/js/jquery.autocomplete.js"></script>
  16. <link rel="stylesheet" href="../../commons/css/jquery.autocomplete.css" type="text/css"></link>
  17. <script type="text/javascript" src="js/database_operation.js"></script>
  18. <link rel="stylesheet" href="../../easyui/themes/default/base_style.css" type="text/css"></link>
  19. </head>
  20. <body>
  21. <div id='layoutid' class="easyui-layout" data-options='fit:true' >
  22. <div
  23. data-options="region:'north',split:true,border:true,title:'医院配置'"
  24. style="height: 150px; padding: 10px;background-color: rgb(239, 245, 251);">
  25. <div
  26. style="margin-top: 5px; margin-bottom: 5px; font-size: 14px; font-family: Tahoma, Verdana, 微软雅黑, 新宋体;">
  27. <table class="queryTable" style="" border="0" cellpadding="0" cellspacing="0">
  28. <col width="90"/>
  29. <col width="160"/>
  30. <col width="80"/>
  31. <col width="160"/>
  32. <col width="80"/>
  33. <col width="160"/>
  34. <col width="40"/>
  35. <col width=""/>
  36. <tr>
  37. <td class="tdLabel">
  38. <label for="hospitalid" class="label">医院:</label>
  39. </td>
  40. <td class="tdField">
  41. <select id="hospitalid" name="filter_EQI_ghthosid" class="textWidth_100Per">
  42. </select>
  43. </td>
  44. <td class="tdLabel">
  45. <label for="insertdate" class="label">操作:</label>
  46. </td>
  47. <td class="tdField" >
  48. <select id="sqltype" name="sqltype" class="textWidth_100Per">
  49. <option value="1">查询</option>
  50. <option value="2">更新</option>
  51. <option value="3">新增</option>
  52. <option value="4">执行DDL</option>
  53. </select>
  54. </td>
  55. <td class="tdField" >
  56. <input type="text" id="sqltext" style="width:600px;height: 50px;font-size: 30px;"></input>
  57. </td>
  58. </tr>
  59. <tr>
  60. <td class="tdLabel" colspan="3">
  61. <input type="button" value="查询所有表" onclick="tianxie1()"></input>
  62. </td>
  63. <td >
  64. <input type="button" value="查询表结构" onclick="tianxie2()"></input>
  65. </td>
  66. <td >
  67. <input type="button" value="重置" onclick="chongzhi()"></input>
  68. </td>
  69. <td >
  70. <input type="button" style="width: 70px;height: 40px;" value="查询" onclick="exec()"/>
  71. </td>
  72. </tr>
  73. </table>
  74. </div>
  75. </div>
  76. <div data-options="region:'center',border:false"
  77. style="padding: 0px;">
  78. <div id='dg'></div>
  79. </div>
  80. </div>
  81. </body>
  82. </html>