dataImport.jsp 9.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207
  1. <%@ page language="java" pageEncoding="UTF-8" %>
  2. <html>
  3. <head>
  4. <%@ include file="../header.jspf" %>
  5. <title>数据导入首页</title>
  6. <style type="text/css" >
  7. .form-horizontal{
  8. margin-bottom: 0px;
  9. }
  10. well > ul{
  11. padding-left: 10px;
  12. }
  13. </style>
  14. </head>
  15. <body>
  16. <div class="container-fluid">
  17. <div class="row">
  18. <%@ include file="../head.jsp" %>
  19. </div>
  20. <div class="row">
  21. <div class="col-sm-2">
  22. <%@ include file="../left.jsp" %>
  23. </div>
  24. <div class="col-sm-10">
  25. <div class="panel panel-default">
  26. <div class="panel-heading">数据导入</div>
  27. <div class="panel-body" style="padding-top: 0px">
  28. <div class="row" >
  29. <div class="alert alert-warning" >导入文件前请先查看右侧的文件上传说明!文件上传前必须进行
  30. <a target="_blank"
  31. href="${pageContext.request.contextPath}/image/tqe-excel-upload-convert.jpg">格式转换</a>!
  32. </div>
  33. <div class="col-sm-9">
  34. <div class="error-message-container row">
  35. <div class="col-sm-8 col-sm-offset-2">
  36. <div class="alert alert-danger alert-dismissible" role="alert">
  37. <button type="button" class="close" data-dismiss="alert">
  38. <span aria-hidden="true">&times;</span><span class="sr-only">Close</span>
  39. </button>
  40. <span class="error-message">${error}</span>
  41. </div>
  42. </div>
  43. </div>
  44. <div class="bs-callout bs-callout-info" style="margin-top: 0px">
  45. <h4>课程信息上传</h4>
  46. <form class="form-horizontal" name="import-teacher-form"
  47. action="${pageContext.request.contextPath}/admin/dataImport/course"
  48. enctype="multipart/form-data" method="post">
  49. <div class="form-group">
  50. <label class="col-sm-3 control-label">学期</label>
  51. <div class="col-sm-3">
  52. <select name="season" class="form-control" id="season">
  53. <option value="${applicationScope.curSeason}">
  54. 当前学期:${applicationScope.curSeason}</option>
  55. <c:forEach begin="2015" end="${applicationScope.curYear+1}" step="1"
  56. var="s">
  57. <option value="${s}春">${s}春</option>
  58. <option value="${s}秋">${s}秋</option>
  59. </c:forEach>
  60. </select>
  61. </div>
  62. </div>
  63. <div class="form-group">
  64. <label for="course-file" class="col-sm-3 control-label">要上传的课程文件</label>
  65. <div class="col-sm-5">
  66. <input type="file" class="form-control" name="courseFile" id="course-file">
  67. </div>
  68. </div>
  69. <div class="form-group">
  70. <div class="col-sm-offset-2 col-sm-5">
  71. <button type="submit" class="btn btn-info">导入课程信息</button>
  72. </div>
  73. </div>
  74. </form>
  75. </div>
  76. <div class="bs-callout bs-callout-warning">
  77. <h4>学生选课信息上传</h4>
  78. <form class="form-horizontal" name="import-teacher-form"
  79. action="${pageContext.request.contextPath}/admin/dataImport/sc"
  80. enctype="multipart/form-data" method="post">
  81. <div class="form-group">
  82. <label for="sc-file" class="col-sm-3 control-label">要上传的学生选课文件</label>
  83. <div class="col-sm-5">
  84. <input type="file" class="form-control" name="scFile" id="sc-file">
  85. </div>
  86. </div>
  87. <div class="form-group">
  88. <div class="col-sm-offset-2 col-sm-5">
  89. <button type="submit" class="btn btn-warning">导入学生选课信息</button>
  90. </div>
  91. </div>
  92. </form>
  93. </div>
  94. <div class="bs-callout bs-callout-info">
  95. <h4>教师信息上传</h4>
  96. <form class="form-horizontal" name="import-teacher-form"
  97. action="${pageContext.request.contextPath}/admin/dataImport/teacher"
  98. enctype="multipart/form-data" method="post">
  99. <div class="form-group">
  100. <label for="teacher-file" class="col-sm-3 control-label">要上传的教师文件</label>
  101. <div class="col-sm-5">
  102. <input type="file" class="form-control" name="teacherFile"
  103. id="teacher-file">
  104. </div>
  105. </div>
  106. <div class="form-group">
  107. <div class="col-sm-offset-2 col-sm-5">
  108. <button type="submit" class="btn btn-info">导入教师信息</button>
  109. </div>
  110. </div>
  111. </form>
  112. </div>
  113. <div class="bs-callout bs-callout-warning">
  114. <h4>学生信息上传</h4>
  115. <form class="form-horizontal" name="import-teacher-form"
  116. action="${pageContext.request.contextPath}/admin/dataImport/student"
  117. enctype="multipart/form-data" method="post">
  118. <div class="form-group">
  119. <label for="student-file" class="col-sm-3 control-label">要上传的学生文件</label>
  120. <div class="col-sm-5">
  121. <input type="file" class="form-control" name="studentFile" id="student-file"
  122. required="required">
  123. </div>
  124. </div>
  125. <div class="form-group">
  126. <div class="col-sm-offset-2 col-sm-5">
  127. <button type="submit" class="btn btn-warning">导入学生信息</button>
  128. </div>
  129. </div>
  130. </form>
  131. </div>
  132. </div>
  133. <div class="col-sm-3">
  134. <div class="well text-danger">
  135. 文件导入说明:
  136. <ul>
  137. <li>上传文件必须为EXCEL文件,文件以.xls后缀</li>
  138. <li>上传文件大小不能大于10MB</li>
  139. <li>从教务系统下载的EXCEL必须要转换成兼容的Excel 2003 文件</li>
  140. <li><a target="_blank"
  141. href="${pageContext.request.contextPath}/image/tqe-excel-upload-convert.jpg"
  142. class="btn btn-danger btn-sm">点我查看上传<br>格式转换说明</a></li>
  143. </ul>
  144. 常见错误说明
  145. </div>
  146. </div>
  147. </div>
  148. </div>
  149. </div>
  150. </div>
  151. </div>
  152. <%@ include file="../buttom.jsp" %>
  153. </div>
  154. <script type="text/javascript">
  155. $(function () {
  156. showErrorMessage();
  157. $("form").submit(function () {
  158. var $this = $(this);
  159. var season = $this.find("#season").val();
  160. var fileName = $this.find("input[type='file']").val();
  161. var meg = "您确定要提交表单吗?\n请您仔细核对,文件上传后不可取消!\n文件名:\t" + fileName;
  162. if (season) {
  163. meg += "\n学期:\t" + season + "!!\n";
  164. }
  165. if (!confirm(meg)) {
  166. return false;
  167. }
  168. return true;
  169. });
  170. });
  171. </script>
  172. </body>
  173. </html>