jsp中导入导出excel，ssh框架

1 <form action="user_importTradingMoney" enctype="multipart/form-data" method="post">
2 <label>导入数据
3             <input type="file" name="tradingMoneyFile" value="选择文件">
4             <input type="submit" value="提交数据">
5             </label>
6 </form>

1 <constant name="struts.i18n.reload" value="true" />
2     <constant name="struts.configuration.xml.reload" value="true" />
3     <constant name="struts.devMode" value="true" />
4     <constant name=" struts.action.extension" value="action,," />
5     <constant name="struts.multipart.maxSize" value="102400000000000" />

 1 //导入交易金额的Excel表
 2     public String importTradingMoney(){
 3         HttpServletRequest request = ServletActionContext.getRequest();
 4         Calendar cal = Calendar.getInstance();
 5         int month = cal.get(Calendar.MONTH);
 6         int year = cal.get(Calendar.YEAR);
 7          jxl.Workbook wb=null;
 8          try {
 9             //InputStream is=new FileInputStream(tradingMoneyFile);//读取存放数据的excel表格在电脑中的路径
10             InputStream is=new FileInputStream(tradingMoneyFile);
11             wb =Workbook.getWorkbook(is);//创建workbook对象，我的理解就是这个整个的excel
12             Sheet s=wb.getSheet(0);//创建sheet，其实就是excel中的每一页，其中的每一张表，他的下标是从0开始的//这里也就是取得第一张表
13             int rsRows=s.getRows();//得到所有的行
14             int rsColumns=s.getColumns();//得到所有的列
15             for(int i=1;i<rsRows;i++){
16                 String userName=s.getCell(0, i).getContents();//(列，行)
17                 int tradingMoney=Integer.parseInt(s.getCell(1, i).getContents().toString());
18                                 TradingMoney tradingMoneyClass=new TradingMoney();
19                 tradingMoneyClass.setUserName(userName);
20                 tradingMoneyClass.setTradingMoney(tradingMoney);
21                 tradingMoneyClass.setYear(year);
22                 tradingMoneyClass.setMonth(month);
23                 userService.addTradingMoney(tradingMoneyClass);
24             }
25         } catch (FileNotFoundException e) {
26             // TODO Auto-generated catch block
27             e.printStackTrace();
28         } catch (BiffException e) {
29             // TODO Auto-generated catch block
30             e.printStackTrace();
31         } catch (IndexOutOfBoundsException e) {
32             // TODO Auto-generated catch block
33             e.printStackTrace();
34         } catch (IOException e) {
35             // TODO Auto-generated catch block
36             e.printStackTrace();
37         } catch (Exception e) {
38             // TODO Auto-generated catch block
39             e.printStackTrace();
40         }
41          List<User> userList = null;
42         try {
43             userList = userService.selectUser(null, null);
44         } catch (Exception e) {
45             // TODO Auto-generated catch block
46             e.printStackTrace();
47         }
48         request.setAttribute("userList", userList);
49         return "selectUser";
50     }

1 <%@page import="java.text.SimpleDateFormat"%>  
2   <%
3       SimpleDateFormat sf = new SimpleDateFormat("yyyyMMdd");
4       String filename = new String(("佣金明细-"+sf.format(new Date())).getBytes("utf8"),"ISO-8859-1"); 
5       response.setHeader("Content-disposition","attachment; filename="+filename+".xls"); 
6   %>

1 <input type="button" value="结果导出为Excel" style="width:120px" class="button-action" onclick="toExcel(<s:property value=‘#request.owerUser.id‘ />,‘${request.owerUser.userAccount }‘)"/>

1 var userIdvar,userAccountvar;
2         function toExcel(userIdvar,userAccountvar){
3 //脚本运行后，将在新窗体newwindow中打开，宽为100，高为400，距屏顶0象素，屏左0象素，无工具条，无菜单条，无滚动条，不可调整大小，无地址栏，无状态栏。
4 window.open(‘reportUser_selectDetailReportUser?notice=1&userId=‘+userIdvar+‘&userAccount=‘+userAccountvar,‘newwindow‘,‘height=600,width=1200,top=80,left=80,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no‘);
5         };