WebRoot/updown/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="java.sql.ResultSet"/>
<jsp:directive.page import="com.orm.Tstu"/>
<jsp:directive.page import="com.service.liuService"/>
<%
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">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
  </head>
  
  <body> 
      <% 
      
            List stuList=new ArrayList();
			String sql="select * from t_stu where del='no'";
			Object[] params={};
			DB mydb=new DB();
			try
			{
				mydb.doPstm(sql, params);
				ResultSet rs=mydb.getRs();
				while(rs.next())
				{
					Tstu stu=new Tstu();
					stu.setXuehao(rs.getString("xuehao"));
					stu.setName1(rs.getString("name1"));
					stu.setSex(rs.getString("sex"));
					stu.setAge(rs.getInt("age"));
					stu.setBanji_id(rs.getInt("banji_id"));
					stu.setBanji_name(liuService.getBanjiName(rs.getInt("banji_id")));
					stu.setRuxueshijian(rs.getString("ruxueshijian"));
					stuList.add(stu);
			    }
				rs.close();
			}
			catch(Exception e)
			{
				e.printStackTrace();
			}
			mydb.closed();
      
            
      
            HSSFWorkbook wb = new HSSFWorkbook();
			HSSFSheet sheet = wb.createSheet("new sheet");
			
			HSSFRow row = sheet.createRow(0);
			HSSFCell cell=row.createCell((short)0);