uploadexcel.jsp 3.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118
  1. <%@ page language="java" contentType="text/html; charset=UTF-8"
  2. pageEncoding="UTF-8"%>
  3. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
  4. <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
  5. <%
  6. String path = request.getContextPath();
  7. String basePath = request.getScheme() + "://"
  8. + request.getServerName() + ":" + request.getServerPort()
  9. + path + "/";
  10. %>
  11. <!DOCTYPE html>
  12. <html lang="en">
  13. <head>
  14. <base href="<%=basePath%>">
  15. <!-- jsp文件头和头部 -->
  16. <%@ include file="../index/top.jsp"%>
  17. </head>
  18. <body class="no-skin">
  19. <!-- /section:basics/navbar.layout -->
  20. <div class="main-container" id="main-container">
  21. <!-- /section:basics/sidebar -->
  22. <div class="main-content">
  23. <div class="main-content-inner">
  24. <div class="page-content">
  25. <div class="row">
  26. <div class="col-xs-12">
  27. <form action="user/readExcel.do" name="Form" id="Form" method="post" enctype="multipart/form-data">
  28. <div id="zhongxin">
  29. <table style="width:95%;" >
  30. <tr>
  31. <td style="padding-top: 20px;"><input type="file" id="excel" name="excel" style="width:50px;" onchange="fileType(this)" /></td>
  32. </tr>
  33. <tr>
  34. <td style="text-align: center;padding-top: 10px;">
  35. <a class="btn btn-mini btn-primary" onclick="save();">导入</a>
  36. <a class="btn btn-mini btn-danger" onclick="top.Dialog.close();">取消</a>
  37. <a class="btn btn-mini btn-success" onclick="window.location.href='<%=basePath%>/user/downExcel.do'">下载模版</a>
  38. </td>
  39. </tr>
  40. </table>
  41. </div>
  42. <div id="zhongxin2" class="center" style="display:none"><br/><img src="static/images/jzx.gif" /><br/><h4 class="lighter block green"></h4></div>
  43. </form>
  44. </div>
  45. <!-- /.col -->
  46. </div>
  47. <!-- /.row -->
  48. </div>
  49. <!-- /.page-content -->
  50. </div>
  51. </div>
  52. <!-- /.main-content -->
  53. </div>
  54. <!-- /.main-container -->
  55. <!-- basic scripts -->
  56. <!-- 页面底部js¨ -->
  57. <%@ include file="../index/foot.jsp"%>
  58. <!-- ace scripts -->
  59. <script src="static/ace/js/ace/ace.js"></script>
  60. <!-- 上传控件 -->
  61. <script src="static/ace/js/ace/elements.fileinput.js"></script>
  62. <!--提示框-->
  63. <script type="text/javascript" src="static/js/jquery.tips.js"></script>
  64. <script type="text/javascript">
  65. $(top.hangge());
  66. $(function() {
  67. //上传
  68. $('#excel').ace_file_input({
  69. no_file:'请选择EXCEL ...',
  70. btn_choose:'选择',
  71. btn_change:'更改',
  72. droppable:false,
  73. onchange:null,
  74. thumbnail:false, //| true | large
  75. whitelist:'xls|xls',
  76. blacklist:'gif|png|jpg|jpeg'
  77. //onchange:''
  78. });
  79. });
  80. //保存
  81. function save(){
  82. if($("#excel").val()=="" || document.getElementById("excel").files[0] =='请选择xls格式的文件'){
  83. $("#excel").tips({
  84. side:3,
  85. msg:'请选择文件',
  86. bg:'#AE81FF',
  87. time:3
  88. });
  89. return false;
  90. }
  91. $("#Form").submit();
  92. $("#zhongxin").hide();
  93. $("#zhongxin2").show();
  94. }
  95. function fileType(obj){
  96. var fileType=obj.value.substr(obj.value.lastIndexOf(".")).toLowerCase();//获得文件后缀名
  97. if(fileType != '.xls'){
  98. $("#excel").tips({
  99. side:3,
  100. msg:'请上传xls格式的文件',
  101. bg:'#AE81FF',
  102. time:3
  103. });
  104. $("#excel").val('');
  105. document.getElementById("excel").files[0] = '请选择xls格式的文件';
  106. }
  107. }
  108. </script>
  109. </body>
  110. </html>