WebRoot/admin/xbgs/daochuExc.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="com.jspsmart.upload.*" %>
<%@ page import="org.apache.poi.hssf.usermodel.*" %>
<%@ page import="java.io.*" %>
<jsp:directive.page import="com.dao.DB"/>
<jsp:directive.page import="com.orm.TXuesheng"/>
<jsp:directive.page import="java.sql.ResultSet"/>
<jsp:directive.page import="com.service.GetListService"/>
<%
String path = request.getContextPath();
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
  </head>
  
  <body> 
      <% 
     		String sql="select * from t_xuesheng";
     		GetListService gl = new GetListService();
	 		List xueshengList = gl.getXueshengList(sql);
			
			
            HSSFWorkbook wb = new HSSFWorkbook();
			HSSFSheet sheet = wb.createSheet("new sheet");
			
			HSSFRow row = sheet.createRow(0);
			HSSFCell cell=row.createCell((short)0);
			cell.setCellValue("学号");
					
			cell=row.createCell((short)1);
			cell.setCellValue("姓名");
					
			cell=row.createCell((short)2);
			cell.setCellValue("性别");
			
			cell=row.createCell((short)3);
			cell.setCellValue("入学日期");
			
			cell=row.createCell((short)4);
			cell.setCellValue("身份证号");
			
			cell=row.createCell((short)5);
			cell.setCellValue("所在院系");
			
			cell=row.createCell((short)6);
			cell.setCellValue("联系电话");
			
			cell=row.createCell((short)7);
			cell.setCellValue("添加时间");
			
			cell=row.createCell((short)8);
			cell.setCellValue("当前状态");
			
			for(int i=0;i<xueshengList.size();i++)
			{