dorado5 上传源码

1首先我先改了一下，user-config

<property name="picture-path" value="D:/drd/LoginDemo/work" /> 

2然后 编写view

<?xml version="1.0" encoding="UTF-8"?> <view> <Datasets> <Dataset id="dsTest" wrappedType="Sql" type="Wrapper" autoLoadData="false"                  listener="ExcelImport_dsTestListener" dataSource="js_kh" keyFields="testcol"> <MasterLink /> <Fields> <Field name="testcol" dataType="string" originField="testcol"> <Properties /> </Field> </Fields> <Parameters /> <Properties /> <sql>select * from kh_test</sql> </Dataset> </Datasets> <Controls> <Control id="tbTest" type="DataTable" dataset="dsTest" /> <Control id="buttonUpload" type="Button" value="上传" width="70"> <Events> <Event name="onClick">if(document.getElementById("dataFile").value){                             document.getElementById("excelForm").submit(); }</Event> </Events> </Control> <Control id="subwindowUpload" type="SubWindow" height="100" width="300" /> </Controls> <Properties /> </view>当然 我这边换成了sqlDataset 并且之前也将datasource配好了  3 将sample下面的fileController copy到我的项目下 4 编写我自己的ExcelController 
 import java.io.File; import java.io.InputStream;  import javax.servlet.http.HttpServletRequest;  import org.apache.commons.fileupload.FileUploadBase;    import com.bstek.dorado.common.UserConfig; import com.bstek.dorado.utils.MetaData;   /**  * ExcelController  */ public class ExcelController extends FileController {         public static final String UPLOAD_WORK_PATH = UserConfig.getString("picture-path");  protected File getUploadWorkDirectory(HttpServletRequest request,MetaData parameters) { return new File(UPLOAD_WORK_PATH); }  protected String getStoreFileName(HttpServletRequest request, String fileName, MetaData parameters) { int pos = fileName.lastIndexOf("."); String extName; if (pos > 0) { extName = fileName.substring(pos); } else { extName = ""; } String storeFileName=System.currentTimeMillis() + extName; request.setAttribute("fileName", storeFileName); return storeFileName; }  protected String getDownLoadFileName(HttpServletRequest request) { return "kh_test.xls"; }  protected InputStream getDownloadFileInputStream(HttpServletRequest request) throws Exception { return this.getClass().getResourceAsStream(getDownLoadFileName(request)); }  protected void initFileUpload(HttpServletRequest request, FileUploadBase fileUpload) { fileUpload.setHeaderEncoding("UTF-8"); }   } 5 新建mapping 
<mapping prefix=""> <forwards /> <exceptions /> <controllers> <controller name="excel" clazz="ExcelController"> <action name="upload"> <forward name="success" contextRelative="false" path="/success-upload.jsp" /> </action> </controller> </controllers> </mapping>
并注册到global
 Code:
<units> <unit name="dorado" /> <unit name="login" /> <unit name="excel" /> </units>

 结果上传不了
 问题
 1.上传的模板：如何生成？生成后放哪 我现在自己新建一个xls 是放在/web下的  下载下来0字节
 2.download.d的路径 看了sample mapping 好像没有。。
 上述编写有问题么

为什么我 
 
 Code:
        List testList = parse(path);          dataset.fromDO(testList);         System.out.println(">>>list.size():="+testList.size());         dataset.setPossibleRecordCount(testList.size());         System.out.println(">>>dataset.setPossibleRecordCount:="+dataset.getPossibleRecordCount()); 

 
 结果
 >>>list.size():=2
 >>>dataset.setPossibleRecordCount:=2
 
 但是js <script>
 var fileName = "<%=request.getAttribute("fileName")%>";
 var ds = parent.dsTest;
 ds.parameters().setValue("fileName",fileName);
 alert(ds.parameters().getValue("fileName"));
 ds.flushDataAsync(function(success){
   if(success){
     alert("成功上传" + ds.getPossibleRecordCount()+"条记录.");
   }
 });
 </script> 却是0记录

但是仅限于保存在客户端的dataset里面，没有和后台真正的交互。
 因此需要写入Code:
public  List parse(String path) throws Exception {         System.out.println("parse_path in parse:"+path); List testList = new ArrayList(); File excelFile = new File(path);  System.out.println("excelFile in parse:"+excelFile.getName()); if(excelFile.exists()){   System.out.println(">>>"+excelFile.exists()); Workbook workbook = Workbook.getWorkbook(excelFile); System.out.println(">>>wb:"+workbook); Sheet sheet = workbook.getSheet(0); for (int i = 1; i < sheet.getRows(); i++) { testList.add(getTestcol(sheet.getRow(i))); System.out.println(">>>sheet.getRow:"+sheet.getRow(i)); } System.out.println("sheet.getRows(): "+sheet.getRows()+" sheet.getColumns():"+sheet.getColumns()); // try {           Class.forName("com.informix.jdbc.IfxDriver");                         String url = "jdbc:informix-sqli://ip:17100/js_kh:informixserver=pnaj2;NEWCODESET=gb2312,8859-1,819";                  Connection conn = DriverManager.getConnection(url,"user","pwd");   //Statement stmt = conn.createStatement();           PreparedStatement pstmt = null;                     for (int i = 1; i < sheet.getRows(); i++) {                     for (int j = 0; j < sheet.getColumns(); j++) {                     //获取单元格内容                     Cell cell1  =  sheet.getCell(j, i);                                         //插入                 String sql = "insert into kh_test(testcol) values(?);";                 System.out.println(">>>sql:"+sql);                                  System.out.println(">>>cell1.getContents().toString()"+cell1.getContents().toString());                         pstmt=(PreparedStatement)conn.prepareStatement(sql);                         pstmt.setString(1,cell1.getContents().toString());                 System.out.println(">>>pstmt"+pstmt);                 pstmt.executeUpdate();                                  pstmt.close();                                     }                            }                                   conn.close();   }catch(Exception e){           e.printStackTrace();   } workbook.close(); //excelFile.delete(); } return testList; }