📄 setup-datasource-standard.jsp
字号:
<body>
<h1>
<fmt:message key="setup.datasource.standard.title" />
</h1>
<p>
<fmt:message key="setup.datasource.standard.info" /> <fmt:message key="title" />.
</p>
<p>
<b><fmt:message key="setup.datasource.standard.info2" /> </b><fmt:message key="setup.datasource.standard.info3" /> <tt>[Wildfire_HOME]/resources/database</tt>.
</p>
<% if (errors.size() > 0) { %>
<div class="error">
<% if (errors.get("general") != null) { %>
<%= errors.get("general") %>
<% } else { %>
<fmt:message key="setup.datasource.standard.failed_connect" />
<% } %>
</div>
<% } %>
<!-- BEGIN jive-contentBox -->
<div class="jive-contentBox">
<% // DB preset data
List<String[]> presets = new ArrayList<String []>();
presets.add(new String[]{"MySQL","com.mysql.jdbc.Driver","jdbc:mysql://[host-name]:3306/[database-name]"});
presets.add(new String[]{"Oracle","oracle.jdbc.driver.OracleDriver","jdbc:oracle:thin:@[host-name]:1521:[SID]"});
presets.add(new String[]{"Microsoft SQLServer","net.sourceforge.jtds.jdbc.Driver","jdbc:jtds:sqlserver://[host-name]/[database-name];appName=jive"});
presets.add(new String[]{"PostgreSQL","org.postgresql.Driver","jdbc:postgresql://[host-name]:5432/[database-name]"});
presets.add(new String[]{"IBM DB2","COM.ibm.db2.jdbc.app.DB2Driver","jdbc:db2:[database-name]"});
%>
<script language="JavaScript" type="text/javascript">
var data = new Array();
<% for (int i=0; i<presets.size(); i++) {
String[] data = presets.get(i);
%>
data[<%= i %>] = new Array('<%= data[0] %>','<%= data[1] %>','<%= data[2] %>');
<% } %>
function populate(i) {
document.dbform.driver.value=data[i][1];
document.dbform.serverURL.value=data[i][2];
}
var submitted = false;
function checkSubmit() {
if (!submitted) {
submitted = true;
return true;
}
return false;
}
</script>
<form action="setup-datasource-standard.jsp" method="post" name="dbform" onsubmit="return checkSubmit();">
<table cellpadding="3" cellspacing="2" border="0">
<tr>
<td nowrap align="right"><fmt:message key="setup.datasource.standard.label" />:</td>
<td>
<select size="1" name="presets" onchange="populate(this.options[this.selectedIndex].value)">
<option value=""><fmt:message key="setup.datasource.standard.pick_database" />
<% for (int i=0; i<presets.size(); i++) {
String[] data = presets.get(i);
%>
<option value="<%= i %>"> • <%= data[0] %>
<% } %>
</select>
</td>
</tr>
<tr valign="top">
<td nowrap align="right">
<fmt:message key="setup.datasource.standard.jdbc" />
</td>
<td>
<input type="text" name="driver" size="50" maxlength="150"
value="<%= ((driver != null) ? driver : "") %>">
<span class="jive-setup-helpicon" onmouseover="domTT_activate(this, event, 'content', '<fmt:message key="setup.datasource.standard.jdbc_info" />', 'styleClass', 'jiveTooltip', 'trail', true, 'delay', 300, 'lifetime', 8000);"></span>
<% if (errors.get("driver") != null) { %>
<span class="jive-error-text">
<%= errors.get("driver") %>
</span>
<% } %>
</td>
</tr>
<tr valign="top">
<td nowrap align="right">
<fmt:message key="setup.datasource.standard.url" />
</td>
<td>
<input type="text" name="serverURL" size="50" maxlength="250"
value="<%= ((serverURL != null) ? serverURL : "") %>">
<span class="jive-setup-helpicon" onmouseover="domTT_activate(this, event, 'content', '<fmt:message key="setup.datasource.standard.valid_url" />', 'styleClass', 'jiveTooltip', 'trail', true, 'delay', 300, 'lifetime', 8000);"></span>
<% if (errors.get("serverURL") != null) { %>
<span class="jive-error-text">
<%= errors.get("serverURL") %>
</span>
<% } %>
</td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr valign="top">
<td nowrap align="right">
<fmt:message key="setup.datasource.standard.username" />
</td>
<td>
<input type="text" name="username" size="20" maxlength="50"
value="<%= ((username != null) ? username : "") %>">
<span class="jive-setup-helpicon" onmouseover="domTT_activate(this, event, 'content', '<fmt:message key="setup.datasource.standard.username_info" />', 'styleClass', 'jiveTooltip', 'trail', true, 'delay', 300, 'lifetime', 8000);"></span>
<% if (errors.get("username") != null) { %>
<span class="jive-error-text">
<%= errors.get("username") %>
</span>
<% } %>
</td>
</tr>
<tr valign="top">
<td nowrap align="right">
<fmt:message key="setup.datasource.standard.password" />
</td>
<td>
<input type="password" name="password" size="20" maxlength="50"
value="<%= ((password != null) ? password : "") %>">
<span class="jive-setup-helpicon" onmouseover="domTT_activate(this, event, 'content', '<fmt:message key="setup.datasource.standard.password_info" />', 'styleClass', 'jiveTooltip', 'trail', true, 'delay', 300, 'lifetime', 8000);"></span>
<% if (errors.get("password") != null) { %>
<span class="jive-error-text">
<%= errors.get("password") %>
</span>
<% } %>
</td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr valign="top">
<td nowrap align="right">
<%--<fmt:message key="setup.datasource.standard.connect" />--%>
Minimum Connections:
</td>
<td>
<input type="text" name="minConnections" size="5" maxlength="5" value="<%= ((minConnections != -1) ? ""+minConnections : "") %>">
<span class="jive-setup-helpicon" onmouseover="domTT_activate(this, event, 'content', '<fmt:message key="setup.datasource.standard.pool" />', 'styleClass', 'jiveTooltip', 'trail', true, 'delay', 300, 'lifetime', 8000);"></span>
<% if (errors.get("minConnections") != null) { %>
<span class="jive-error-text">
<%= errors.get("minConnections") %>
</span>
<% } %>
</td>
</tr>
<tr valign="top">
<td nowrap align="right">
<%--<fmt:message key="setup.datasource.standard.connect" />--%>
Maximum Connections:
</td>
<td>
<input type="text" name="maxConnections" size="5" maxlength="5" value="<%= ((maxConnections != -1) ? ""+maxConnections : "") %>">
<span class="jive-setup-helpicon" onmouseover="domTT_activate(this, event, 'content', '<fmt:message key="setup.datasource.standard.pool" />', 'styleClass', 'jiveTooltip', 'trail', true, 'delay', 300, 'lifetime', 8000);"></span>
<% if (errors.get("maxConnections") != null) { %>
<span class="jive-error-text">
<%= errors.get("maxConnections") %>
</span>
<% } %>
</td>
</tr>
<tr valign="top">
<td nowrap align="right">
<fmt:message key="setup.datasource.standard.timeout" />
</td>
<td>
<input type="text" name="connectionTimeout" size="5" maxlength="5"
value="<%= connectionTimeout %>"> <span style="display: block; float: left; padding: 2px 5px 0px 2px;">Days</span>
<span class="jive-setup-helpicon" onmouseover="domTT_activate(this, event, 'content', '<fmt:message key="setup.datasource.standard.timeout_info" />', 'styleClass', 'jiveTooltip', 'trail', true, 'delay', 300, 'lifetime', 8000);"></span>
<% if (errors.get("connectionTimeout") != null) { %>
<span class="jive-error-text">
<%= errors.get("connectionTimeout") %>
</span>
<% } %>
</td>
</tr>
</table>
<br>
<div align="right"><div class="jive-description" style="padding-bottom:10px;">
<fmt:message key="setup.datasource.standard.note" /></div>
<input type="Submit" name="continue" value="<fmt:message key="global.continue" />" id="jive-setup-save" border="0">
</div>
</form>
</div>
<!-- END jive-contentBox -->
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -