spring cloud实例

package monthdemo; import java.io.ByteArrayOutputStream; import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.util.Calendar; import java.util.GregorianCalendar; import javax.annotation.Resource; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; @RestController public class MonthDemo { /** * 将月历存储至本地 * @param month 指定是2018年的哪个月 * @throws IOException */ @RequestMapping(value="/rest/setNumExcel/{month}") public void exportExcel(@PathVariable String month) throws IOException{ //获取excel文件的byte数组 byte[] bytes=excel(month); //将byte数组写入到本地文件中 File file=new File("./month/"+"2018-"+month+".xlsx"); FileOutputStream fos=new FileOutputStream(file); fos.write(bytes); fos.close(); } /** * 向模板中添加日期完成月历 * @param month 指定2018年的哪个月 * @return 月历文件的byte数组 * @throws IOException */ public byte[] excel(String month) throws IOException { //读取excel模板 InputStream is = new FileInputStream(new File("./month/demo11.xlsx")); Workbook workbook = new XSSFWorkbook(is); org.apache.poi.ss.usermodel.Sheet sheet =workbook.getSheetAt(0); //向excel模板中添加日期 int mon=Integer.parseInt(month); int cell; Calendar calendar=new GregorianCalendar(); calendar.set(Calendar.YEAR, 2018); calendar.set(Calendar.MONTH,mon-1); calendar.set(Calendar.DAY_OF_MONTH,1); int maxday=calendar.getActualMaximum(Calendar.DAY_OF_MONTH); int days=calendar.get(Calendar.DAY_OF_WEEK); if(days>=2) { cell=days-2; }else { cell=6; } int day=1; for(int i=1;i>0;) { Row row=sheet.createRow(i); for(;day<maxday+1;day++) { String date=day+""; row.createCell(cell).setCellValue(date); cell++; if(cell>6) { cell=0; day++; break; } } i++; if(day==maxday+1) { break; } } //将Excel写到流中 ByteArrayOutputStream out= new ByteArrayOutputStream(); workbook.write(out); workbook.close(); out.close(); //从流中获取全部Excel的数据 byte[] bytes=out.toByteArray(); return bytes; } }