dbSource.jsp 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180
  1. <%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
  2. <%@include file="/context/mytags.jsp"%>
  3. <!DOCTYPE html>
  4. <html>
  5. <head>
  6. <title><t:mutiLang langKey="common.datasource.manage"/></title>
  7. <t:base type="jquery,easyui,tools"></t:base>
  8. <script type="text/javascript">
  9. var sourceType = '${dbSourcePage.dbType}';
  10. var sourceURL = '${dbSourcePage.url}';
  11. $(function(){
  12. $('#dbType').change(function(){
  13. var dbType = $("#dbType").val();
  14. $.ajax({
  15. type: "POST",
  16. url: "dynamicDataSourceController.do?getDynamicDataSourceParameter",
  17. data: "dbType=" + dbType,
  18. success: function(msg){
  19. $('#driverClass').val(jQuery.parseJSON(msg).obj.driverClass);
  20. if(dbType != sourceType){
  21. $.ajax({
  22. type: "POST",
  23. url: "dynamicDataSourceController.do?getDynamicDataSourceParameter",
  24. data: "dbType=" + dbType,
  25. success: function(msg){
  26. $('#url').val(jQuery.parseJSON(msg).obj.url);
  27. }
  28. });
  29. }else{
  30. $('#url').val(sourceURL);
  31. }
  32. }
  33. });
  34. });
  35. });
  36. </script>
  37. </head>
  38. <body style="overflow-y: hidden" scroll="no">
  39. <t:formvalid formid="formobj" dialog="true" usePlugin="password" layout="table" action="dynamicDataSourceController.do?save">
  40. <input id="id" name="id" type="hidden" value="${dbSourcePage.id }">
  41. <table style="width: 600px;" cellpadding="0" cellspacing="1" class="formtable">
  42. <tr>
  43. <td align="right">
  44. <label class="Validform_label">
  45. <t:mutiLang langKey="common.dbtype"/>:
  46. </label>
  47. </td>
  48. <td class="value">
  49. <input class="inputxt" id="dbKey" name="dbKey"
  50. value="${dbSourcePage.dbKey}" datatype="*">
  51. <span class="Validform_checktip"></span>
  52. </td>
  53. </tr>
  54. <tr>
  55. <td align="right">
  56. <label class="Validform_label">
  57. <t:mutiLang langKey="common.description"/>:
  58. </label>
  59. </td>
  60. <td class="value">
  61. <input class="inputxt" id="description" name="description"
  62. value="${dbSourcePage.description}" datatype="*">
  63. <span class="Validform_checktip"></span>
  64. </td>
  65. </tr>
  66. <tr>
  67. <td align="right">
  68. <label class="Validform_label">
  69. <t:mutiLang langKey="common.dbtype"/>:
  70. </label>
  71. </td>
  72. <td class="value">
  73. <t:dictSelect id="dbType" field="dbType" typeGroupCode="dbtype" hasLabel="false" defaultVal="${dbSourcePage.dbType}"></t:dictSelect>
  74. <span class="Validform_checktip"></span>
  75. </td>
  76. </tr>
  77. <tr>
  78. <td align="right">
  79. <label class="Validform_label">
  80. <t:mutiLang langKey="common.driverclass"/>:
  81. </label>
  82. </td>
  83. <td class="value">
  84. <textarea id="driverClass" name="driverClass" rows="2" cols="50" datatype="*" readonly="readonly">${dbSourcePage.driverClass}</textarea>
  85. <span class="Validform_checktip"></span>
  86. </td>
  87. </tr>
  88. <tr>
  89. <td align="right">
  90. <label class="Validform_label">
  91. <t:mutiLang langKey="common.datasrouce.url"/>:
  92. </label>
  93. </td>
  94. <td class="value">
  95. <textarea id="url" name="url" rows="3" cols="50" datatype="*">${dbSourcePage.url}</textarea>
  96. <span class="Validform_checktip"></span>
  97. </td>
  98. </tr>
  99. <tr>
  100. <td align="right">
  101. <label class="Validform_label">
  102. <t:mutiLang langKey="common.dbname"/>:
  103. </label>
  104. </td>
  105. <td class="value">
  106. <input class="inputxt" id="dbName" name="dbName"
  107. value="${dbSourcePage.dbName}" datatype="*">
  108. <span class="Validform_checktip"></span>
  109. </td>
  110. </tr>
  111. <tr>
  112. <td align="right">
  113. <label class="Validform_label">
  114. <t:mutiLang langKey="common.dbuser"/>:
  115. </label>
  116. </td>
  117. <td class="value">
  118. <input class="inputxt" id="dbUser" name="dbUser"
  119. value="${dbSourcePage.dbUser}" datatype="*">
  120. <span class="Validform_checktip"></span>
  121. </td>
  122. </tr>
  123. <tr>
  124. <td align="right">
  125. <label class="Validform_label">
  126. <t:mutiLang langKey="common.dbpassword"/>:
  127. </label>
  128. </td>
  129. <td class="value">
  130. <!-- update-begin--Author:xuelin Date:20170329 for:[#1821]【bug】多数据源管理,密码采用加密方式存储,加密解密总报错-------------------- -->
  131. <input type="password" class="inputxt" id="dbPassword" name="dbPassword" ignore="ignore"
  132. value="${showDbPassword}">
  133. <!-- update-end--Author:xuelin Date:20170329 for:[#1821]【bug】多数据源管理,密码采用加密方式存储,加密解密总报错---------------------- -->
  134. <span class="Validform_checktip"></span>
  135. <!-- //---update-begin------author:chenj-----date:20160801----for:TASK #1246 【改进】多数据源增加测试有效功能 -->
  136. <a href="#" id="dbtest" >
  137. [<label class="Validform_label">测试</label>]
  138. </a>
  139. <span class="Validform_checktip" id="dbmsg"></span>
  140. <!-- //---update-end------author:chenj-----date:20160801----for:TASK #1246 【改进】多数据源增加测试有效功能 -->
  141. </td>
  142. </tr>
  143. </table>
  144. </t:formvalid>
  145. <script type="text/javascript">
  146. $(function(){
  147. //---update-begin------author:chenj-----date:20160801----for:TASK #1246 【改进】多数据源增加测试有效功能
  148. var formobj=$("#formobj").Validform();
  149. $('#dbtest').click(function(){//点击测试
  150. formobj.config({
  151. //url:"dynamicDataSourceController.do?testConnection",
  152. ajaxpost:{
  153. //可以传入$.ajax()能使用的,除dataType外的所有参数;
  154. success:function(data,object){
  155. //data是返回的json数据;
  156. //obj是当前表单的jquery对象;
  157. //alert(data.obj.msg);
  158. $("#dbmsg").html("<font color='red'>"+data.obj.msg+"</font>");
  159. formobj.config({
  160. ajaxpost:{url:"dynamicDataSourceController.do?save"}
  161. });
  162. }
  163. }
  164. });
  165. formobj.ajaxPost(false,false,"dynamicDataSourceController.do?testConnection");
  166. });
  167. //---update-end------author:chenj------date:20160801----for:TASK #1246 【改进】多数据源增加测试有效功能
  168. });
  169. </script>
  170. </body>