export_1.jsp

精通tomcat书籍原代码,希望大家共同学习

<%
/*
 *  This program is free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation; either version 2 of the License, or
 *  (at your option) any later version.
 *
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU Library General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with this program; if not, write to the Free Software
 *  Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
 */
%>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<%@ taglib uri="/WEB-INF/security.tld" prefix="security" %>

<bean:parameter id="db" name="database" value=""/>

<security:isNotRoleOf role="manager">
	<jsp:include page="pages/access_deny.jsp" flush="true"/>
</security:isNotRoleOf>
<security:isRoleOf role="manager">

<bean:parameter id="driver" name="driver" value=""/>
<bean:parameter id="url" name="url" value=""/>
<bean:parameter id="username" name="username" value=""/>
<bean:parameter id="password" name="password" value=""/>

<%
	dlog4j.formbean.DatabaseForm form = new dlog4j.formbean.DatabaseForm();
	form.setDatabase(db);
	form.setDriver(driver);
	form.setUrl(url);
	form.setUsername(username);
	form.setPassword(password);
	request.setAttribute("dbForm", form);
%>
	<script language="javascript">
		document.title += ' [<bean:message key="ADMIN_DATA_MANAGER" bundle="html"/>]';
	</script>
	<jsp:include page="../mgr/admin_nav_bar.jsp" flush="true">
		<jsp:param name="sel" value="4"/>
	</jsp:include>

	<table border="0" cellspacing="4" cellpadding="4" width="100%">
	<tr>
	<td colspan=2>
	<table cellSpacing="1" cellPadding="2" width="100%" align="center" border="0">
	  <tr bgcolor='#A9C9F3'>
	    <th align=left colspan=2><bean:message key="EXPORT_DATABASE_TITLE" bundle="html"/></th>
	  </tr>
	  <tr><td colspan=2><logic:messagesPresent><font color=red><html:errors/></font></logic:messagesPresent><br/></td></tr>
	  <html:form action="/wizard/export">
	  <input type="hidden" name="eventSubmit_Validate" value="1"/>
	  <script language="javascript">
	  	function chkform(form1){
	  		if(form1.driver.value==""){
				form1.driver.focus();
				return false;
	  		}	  		
	  		if(form1.url.value==""){
				form1.url.focus();
				return false;
	  		}	  		
	  		if(form1.username.value==""){
				form1.username.focus();
				return false;
	  		}
	  		form1.submit();
	  	}
		function select_db(db){
			if("odbc" == db){
				dbForm.driver.value="sun.jdbc.odbc.JdbcOdbcDriver";
				dbForm.url.value="jdbc:odbc:[datasource]";
			}
			else
			if("oracle" == db){
				dbForm.driver.value="oracle.jdbc.driver.OracleDriver";
				dbForm.url.value="jdbc:oracle:thin:@[host]:[port]:[db]";
			}
			else
			if("db2" == db){
				dbForm.driver.value="COM.ibm.db2.jdbc.net.DB2Driver";
				dbForm.url.value="jdbc:db2://[host]:[port]/[db]";
			}
			else
			if("mssql" == db){
				dbForm.driver.value="com.microsoft.jdbc.sqlserver.SQLServerDriver";
				dbForm.url.value="jdbc:microsoft:sqlserver://[host]:[port];DatabaseName=[db];SelectMethod=cursor";
			}
			else
			if("sybase" == db){
				dbForm.driver.value="com.sybase.jdbc2.jdbc.SybDriver";
				dbForm.url.value="jdbc:sybase:Tds:[host]:[port]/[db]";
			}
			else
			if("mysql" == db){
				dbForm.driver.value="com.mysql.jdbc.Driver";
				dbForm.url.value="jdbc:mysql://[host]:[port]/[db]";
			}
			else
			if("psql" == db){
				dbForm.driver.value="org.postgresql.Driver";
				dbForm.url.value="jdbc:postgresql://[host]:[port]/[db]";
			}
			else
			if("hsql" == db){
				dbForm.driver.value="org.hsqldb.jdbcDriver";
				dbForm.url.value="jdbc:hsqldb:hsql://[host]:[port]/[db]";
			}
			else{
				dbForm.driver.value="";
				dbForm.url.value="";
			}
			dbForm.url.focus();
		}
	  </script>
	  <tr>
	    <td nowrap><bean:message key="EXPORT_DATABASE" bundle="html"/>:</td>
	    <td>
	    <select name="database" onchange="select_db(this.value);">
	    	<option value="" <logic:equal name="db" value="">selected</logic:equal>>Custom</option>
	    	<option value="odbc" <logic:equal name="db" value="odbc">selected</logic:equal>>ODBC</option>
	    	<option value="oracle" <logic:equal name="db" value="oracle">selected</logic:equal>>Oracle</option>
	    	<option value="db2" <logic:equal name="db" value="db2">selected</logic:equal>>IBM DB2</option>
	    	<option value="mssql" <logic:equal name="db" value="mssql">selected</logic:equal>>SQL SERVER</option>
	    	<option value="sybase" <logic:equal name="db" value="sybase">selected</logic:equal>>SYBASE</option>
	    	<option value="mysql" <logic:equal name="db" value="mysql">selected</logic:equal>>MySQL</option>
	    	<option value="psql" <logic:equal name="db" value="psql">selected</logic:equal>>PostgreSQL</option>
	    	<option value="hsql" <logic:equal name="db" value="hsql">selected</logic:equal>>HSQLDB</option>
	    </select>
	    </td>
	  </tr>	
	  <tr>
	    <td nowrap><bean:message key="EXPORT_DRIVER" bundle="html"/>:</td>
	    <td><html:text property="driver" size="50"/></td>
	  </tr>
	  <tr>
	    <td nowrap><bean:message key="EXPORT_URL" bundle="html"/>:</td>
	    <td><html:text property="url" size="70"/></td>
	  </tr>
	  <tr>
	    <td nowrap><bean:message key="EXPORT_USERNAME" bundle="html"/>:</td>
	    <td><html:text property="username" size="15"/></td>
	  </tr>
	  <tr>
	    <td nowrap><bean:message key="EXPORT_PASSWORD" bundle="html"/>:</td>
	    <td><html:password property="password" size="15"/></td>
	  </tr>	  
	  </html:form>
	  <tr><td colspan=2><br/></td></tr>
	</table><hr size=1 noshade color="#CCCCCC">
	</td>
	</tr>
	<tr>
  	<td align=left><form action="<html:rewrite page="/wizard/export.jspe"/>" method="post"><input class='button' type='submit' value='<< <bean:message key="LAST_STEP" bundle="html"/>'/></form></td>  	
  	<td align=right><input class='button' type='submit' value='<bean:message key="NEXT_STEP" bundle="html"/> >>' onclick="chkform(dbForm);"/></td>
  	</tr>
  	</table>
</security:isRoleOf>