📄 exptoexcel.jsp
字号:
<%
/**
* 文件名：dataimport.jsp
* 说明：基层单位数据导入界面，用于管理员选择导入数据的时间，单位和类型进行数据导入。
* 作者：肖俊
* 更改记录：
* -------------------------------------------------------
* 改动人 时间 原因
* -------------------------------------------------------
* 肖俊 2003-11-30 创建
*/
%>
<%@ page contentType="text/html; charset=gb2312" language="java" errorPage="../error.jsp"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="dbexport.*"%>
<%! boolean rt=false ; %>
<%
if( request.getParameter( "btnExp" )!= null){
ConstDBBean db = new ConstDBBean();
String sqlString = request.getParameter("sqlString");
String filePath = request.getParameter("filePath");
String fileName = request.getParameter("fileName");
String dbIpAddress = request.getParameter("dbIpAddress");
String dbSID = request.getParameter("dbSID");
String dbPort = request.getParameter("dbPort");
String dbUser = request.getParameter("dbUser");
String dbPassword = request.getParameter("dbPassword");
BookSheet booksheet = new BookSheet();
System.out.println("jdbc:oracle:thin:@"+dbIpAddress+":"+dbPort+":"+dbSID);
System.out.println(dbUser+dbPassword);
System.out.println(sqlString);
System.out.println(filePath+"\\"+fileName);
if (dbIpAddress!=null&&dbSID!=null&&dbPort!=null){
db.setDbURL("jdbc:oracle:thin:@"+dbIpAddress+":"+dbPort+":"+dbSID);
}
if (dbUser!=null&&dbPassword!=null){
db.setDbUser(dbUser);
db.setDbPassword(dbPassword);
}
if (sqlString != null){
booksheet.setSqlString(sqlString);
}
if (filePath != null){
booksheet.setFilePath(filePath);
}
if (fileName != null){
booksheet.setFileName(fileName);
}
rt= booksheet.executeExport(db);
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>导出数据到excel表格</title>
<%
response.addHeader("Pragma" , "No-cache") ;
response.addHeader("Cache-Control", "no-cache");
response.addDateHeader("Expires", 0);
%>
</head>
<body >
<table>
<tr>
<td>
<form action="ExpToExcel.jsp" method="post" name="frmLog" id="frmLog">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25" align="right">sql语句：</td>
<td>
<input name="sqlString" type="text" id="sqlString" value="select * from emp" size="100" maxlength="100" >
</td>
</tr>
<tr>
<td height="25" align="right">导出文件路径：</td>
<td>
<input name="filePath" type="text" id="filePath" value="c:\downloads" size="30" maxlength="30" >
</td>
</tr>
<tr>
<td height="25" align="right">导出文件名称：</td>
<td>
<input name="fileName" type="text" id="fileName" value="output.xls" size="10" maxlength="30" >
</td>
</tr>
<tr>
<td height="25" align="right">服务器ip地址：</td>
<td>
<input name="dbIpAddress" type="text" id="dbIpAddress" value="127.0.0.1" size="10" maxlength="30" >
</td>
</tr>
<tr>
<td height="25" align="right">数据库端口：</td>
<td>
<input name="dbPort" type="text" id="dbPort" value="1521" size="10" maxlength="30" >
</td>
</tr>
<tr>
<td height="25" align="right">数据库sid：</td>
<td>
<input name="dbSID" type="text" id="dbSID" value="orcl" size="10" maxlength="10" >
</td>
</tr>
<tr>
<td height="25" align="right">用户名：</td>
<td>
<input name="dbUser" type="text" id="dbUser" value="scott" size="10" maxlength="10" >
</td>
</tr>
<tr>
<td height="25" align="right">口令：</td>
<td>
<input name="dbPassword" type="text" id="dbPassword" value="tiger" size="10" maxlength="10" >
</td>
</tr>
<tr>
<input name="btnExp" type="submit" id="btnExp" value=" 导出 " >
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td><%
if( request.getParameter( "btnExp")!= null){
if(rt){
out.print("导出成功。");
}else{
out.print("导出失败,请检查输入参数");
}
}
%>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -