edu.swjtu.excel.ExportConCarData.java Source code

Introduction

Here is the source code for edu.swjtu.excel.ExportConCarData.java

Source

package edu.swjtu.excel;

import java.io.IOException;
import java.io.OutputStream;
import java.io.PrintStream;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import edu.swjtu.impl.CarDaoImpl;
import edu.swjtu.impl.UserDaoImpl;
import edu.swjtu.model.Car;
import edu.swjtu.util.DBUtil;

public class ExportConCarData extends HttpServlet {
    DBUtil db = new DBUtil();
    UserDaoImpl udi = new UserDaoImpl();

    /**
     * Constructor of the object.
     */
    public ExportConCarData() {
        super();
    }

    /**
     * Destruction of the servlet. <br>
     */
    public void destroy() {
        super.destroy(); // Just puts "destroy" string in log
        // Put your code here
    }

    /**
     * The doGet method of the servlet. <br>
     *
     * This method is called when a form has its tag value method equals to get.
     * 
     * @param request the request send by the client to the server
     * @param response the response send by the server to the client
     * @throws ServletException if an error occurred
     * @throws IOException if an error occurred
     */
    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        this.doPost(request, response);
    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        // webbookExcel
        HSSFWorkbook wb = new HSSFWorkbook();
        // webbooksheet,Excelsheet
        HSSFSheet sheet = wb.createSheet("?");
        // sheet0,??poiExcel?short
        HSSFRow row = sheet.createRow((int) 0);
        // ? 
        HSSFCellStyle style = wb.createCellStyle();
        style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // ?

        HSSFCell cell = row.createCell(0);
        cell.setCellValue("??");
        cell.setCellStyle(style);
        cell = row.createCell(1);
        cell.setCellValue("?");
        cell.setCellStyle(style);
        cell = row.createCell(2);
        cell.setCellValue("?");
        cell.setCellStyle(style);
        cell = row.createCell(3);
        cell.setCellValue("");
        cell.setCellStyle(style);
        cell = row.createCell(4);
        cell.setCellValue("?");
        cell.setCellStyle(style);
        cell = row.createCell(5);
        cell.setCellValue("?");
        cell.setCellStyle(style);
        cell = row.createCell(6);
        cell.setCellValue("?");
        cell.setCellStyle(style);
        cell = row.createCell(7);
        cell.setCellValue("??");
        cell.setCellStyle(style);
        cell = row.createCell(8);
        cell.setCellValue("?");
        cell.setCellStyle(style);
        cell = row.createCell(9);
        cell.setCellValue("?");
        cell.setCellStyle(style);

        // ? ??
        Connection con = null;
        try {
            con = db.getCon();
        } catch (ClassNotFoundException | SQLException e1) {
            e1.printStackTrace();
        }

        String condition = request.getParameter("condition");
        String sea_condition = request.getParameter("sea_condition");
        String search_cho = null;

        ArrayList<Car> list = null;
        CarDaoImpl carr = new CarDaoImpl();

        if (condition.equals("0")) {
            list = carr.getAllCar(con);
            search_cho = "All";
        } else if (condition.equals("1")) {
            list = carr.getCarByLicensePlate_V(sea_condition, con);
            search_cho = "LicensePlate";
        } else if (condition.equals("2")) {
            list = carr.getCarByBrand_V(sea_condition, con);
            search_cho = "Brand";
        } else if (condition.equals("3")) {
            list = carr.getCarByDriver_V(sea_condition, con);
            search_cho = "Driver";
        } else if (condition.equals("4")) {
            list = carr.getCarByArrangeId_V(sea_condition, con);
            search_cho = "ArrangeId";
        } else if (condition.equals("5")) {
            list = carr.getCarByNumber_V(sea_condition, con);
            search_cho = "Number";
        } else if (condition.equals("6")) {
            list = carr.getCarByDrivingLicense_V(sea_condition, con);
            search_cho = "DrivingLicenseber";
        } else if (condition.equals("7")) {
            list = carr.getCarByLicense_V(sea_condition, con);
            search_cho = "License";
        } else {
        }

        for (int i = 0; i < list.size(); i++) {
            row = sheet.createRow((int) i + 1);
            Car car = (Car) list.get(i);
            // ?
            row.createCell(0).setCellValue(i + 1);
            row.createCell(1).setCellValue(car.getLicensePlate());
            row.createCell(2).setCellValue(car.getBrand());
            row.createCell(3).setCellValue(car.getRegistrationDate());
            row.createCell(4).setCellValue(car.getInsuranceDate());
            row.createCell(5).setCellValue(car.getDrivingLicense());
            row.createCell(6).setCellValue(car.getLicense());
            row.createCell(7).setCellValue(car.getArrangeId());
            row.createCell(8).setCellValue(car.getDriver());
            row.createCell(9).setCellValue(car.getNumber());
        }

        String myexcel = search_cho + "_Car";

        //?
        OutputStream out = response.getOutputStream();
        //??
        response.reset();
        //Excel?
        response.setContentType("application/vnd.ms-excel");
        response.setHeader("Content-Disposition", "attachment;filename=" + myexcel + ".xls");

        wb.write(out);
        out.close();

        //?
        System.setOut(new PrintStream(out));
        //?
        out.flush();
        //?
        if (out != null) {
            out.close();
        }

        try {
            db.closeCon(con);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }

    /**
     * Initialization of the servlet. <br>
     *
     * @throws ServletException if an error occurs
     */
    public void init() throws ServletException {
        // Put your code here
    }

}