package com.util;
import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Random;
import java.util.Set;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/*import dao.CommDAO;*/
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
public class Info {
//public static String popheight = "alliframe.height=document.body.clientHeight+";
public static String popheight = "alliframe.style.height=document.body.scrollHeight+";
public static HashMap getUser(HttpServletRequest request)
{
HashMap map = (HashMap)(request.getSession().getAttribute("admin")==null?request.getSession().getAttribute("user"):request.getSession().getAttribute("admin"));
return map;
}
public static int getBetweenDayNumber(String dateA, String dateB) {
long dayNumber = 0;
//1小时=60分钟=3600秒=3600000
long mins = 60L * 1000L;
//long day= 24L * 60L * 60L * 1000L;计算天数之差
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm");
try {
java.util.Date d1 = df.parse(dateA);
java.util.Date d2 = df.parse(dateB);
dayNumber = (d2.getTime() - d1.getTime()) / mins;
} catch (Exception e) {
e.printStackTrace();
}
return (int) dayNumber;
}
public static void main(String[] g )
{
System.out.print(Info.getBetweenDayNumber("2012-11-11 11:19", "2012-11-11 11:11"));
}
public static String getselect(String name,String tablename,String zdname)
{
String select = "<select name=\""+name+"\" id=\""+name+"\" >";
/*for(HashMap permap:new CommDAO().select("select * from "+tablename+" order by id desc")){
select+="<option value=\""+permap.get(zdname)+"\">"+permap.get(zdname)+"</option>";
}
select+="</select>";*/
return select;
}
public static String getselect(String name,String tablename,String zdname,String where)
{
String select = "<select name=\""+name+"\" id=\""+name+"\" >";
select+="<option value=\"\">不限</option>";
/*for(HashMap permap:new CommDAO().select("select * from "+tablename+" where "+where+" order by id desc")){
String optionstr = "";
if(zdname.split(";").length==1){
optionstr=permap.get(zdname.split("~")[0]).toString();
}else{
for(String str:zdname.split(";"))
{
String zdstr = str.split("~")[0];
String zdnamestr = str.split("~")[1].equals("无名")?"":(str.split("~")[1]+":");
optionstr+=zdnamestr+permap.get(zdstr)+" - ";
}
}
if(optionstr.indexOf(" - ")>-1)optionstr=optionstr.substring(0,optionstr.length()-3);
select+="<option value=\""+optionstr+"\">"+optionstr+"</option>";
}
select+="</select>";*/
return select;
}
public static String getradio(String name,String tablename,String zdname,String where)
{
String radio="";
int dxii = 0;
/*for(HashMap permap:new CommDAO().select("select * from "+tablename+" where "+where+" order by id desc")){
String check="";
if(dxii==0)check="checked=checked";
String optionstr = "";
for(String str:zdname.split(";"))
{
String zdstr = str.split("~")[0];
String zdnamestr = str.split("~")[1].equals("无名")?"":(str.split("~")[1]+":");
optionstr+=zdnamestr+permap.get(zdstr)+" - ";
}
if(optionstr.length()>0)optionstr=optionstr.substring(0,optionstr.length()-3);
radio+="<label><input type='radio' name='"+name+"' "+check+" value=\""+optionstr+"\">"+optionstr+"</label>\n";
dxii++;
}*/
return radio;
}
public static void writeExcel(String fileName,String prosstr,java.util.List<List> plist,HttpServletRequest request, HttpServletResponse response){
WritableWorkbook wwb = null;
String cols = "";
for(String str:prosstr.split("@"))
{
cols+=str.split("-")[0]+",";
}
cols = cols.substring(0,cols.length()-1);
String where = request.getAttribute("where")==null?"":request.getAttribute("where").toString();
/* List<List> mlist = new CommDAO().selectforlist("select "+cols+" from "+fileName+" "+where+" order by id desc");*/
fileName = request.getRealPath("/")+"/upfile/"+Info.generalFileName("a.xls");
String[] pros = prosstr.split("@");
try {
//首先要使用Workbook类的工厂方法创建一个可写入的工作薄(Workbook)对象
wwb = Workbook.createWorkbook(new File(fileName));
} catch (IOException e) {
e.printStackTrace();
}
if(wwb!=null){
//创建一个可写入的工作表
//Workbook的createSheet方法有两个参数，第一个是工作表的名称，第二个是工作表在工作薄中的位置
WritableSheet ws = wwb.createSheet("sheet1", 0);
ws.setColumnView(0,20);
ws.setColumnView(1,20);
ws.setColumnView(2,20);
ws.setColumnView(3,20);
ws.setColumnView(4,20);
ws.setColumnView(5,20);
try {
for(int i=0;i<pros.length;i++)
{
Label label1 = new Label(i, 0,"");
label1.setString(pros[i]);
ws.addCell(label1);
}
} catch (RowsExceededException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (WriteException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
//下面开始添加单元格
/*int i=1;*/
/* for(List t:mlist){
try {
Iterator it = t.iterator();
int jj=0;
while(it.hasNext())
{
Label label1 = new Label(jj, i,"");
String a = it.next().toString();
label1.setString(a);
ws.addCell(label1);
jj++;
}
i++;
} catch (RowsExceededException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (WriteException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
try {
//从内存中写入文件中
wwb.write();
//关闭资源，释放内存
wwb.close();
} catch (IOException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
try {
response.sendRedirect("/pianotrainwebstie/upload?filename="+fileName.substring(fileName.lastIndexOf("/")+1));
} catch (IOException e) {
e.printStackTrace();*/
}
}
public static String getcheckbox(String name,String tablename,String zdname,String where)
{
String checkbox="";
/* f
基于ssm+mysql的树品种资源数据管理系统源码数据库.zip （542个子文件） 
Info.class 18KB db.class 14KB GuoshixingzhuangController.class 11KB ShushizhibiaoController.class 10KB ShutizhibiaoController.class 10KB GuoshilihuazhibiaoController.class 10KB GuoshuxinxiController.class 10KB YonghuController.class 10KB HerenController.class 10KB YonghuzhuceController.class 9KB VeDate.class 9KB KangnixingController.class 9KB AllusersController.class 7KB ShoucangjiluController.class 7KB LiuyanbanController.class 7KB XinwentongzhiController.class 7KB GuoshupinzhongController.class 6KB ShengfenxinxiController.class 6KB QitaxinxiController.class 6KB YouqinglianjieController.class 6KB PinglunController.class 6KB Guoshixingzhuang.class 4KB Yonghuzhuce.class 4KB StrUtil.class 4KB Shushizhibiao.class 3KB Guoshuxinxi.class 3KB Guoshilihuazhibiao.class 3KB Shutizhibiao.class 3KB Heren.class 3KB GuoshilihuazhibiaoServerImpi.class 3KB GuoshixingzhuangServerImpi.class 3KB LiuyanbanServerImpi.class 3KB GuoshupinzhongServerImpi.class 3KB YouqinglianjieServerImpi.class 3KB ShushizhibiaoServerImpi.class 3KB ShengfenxinxiServerImpi.class 3KB ShutizhibiaoServerImpi.class 3KB YonghuzhuceServerImpi.class 3KB GuoshuxinxiServerImpi.class 3KB Yonghu.class 3KB KangnixingServerImpi.class 3KB QitaxinxiServerImpi.class 3KB XinwentongzhiServerImpi.class 3KB YonghuServerImpi.class 3KB HerenServerImpi.class 3KB AllusersServerImpi.class 3KB Xinwentongzhi.class 2KB Liuyanban.class 2KB ShoucangjiluServerImpi.class 2KB PinglunServerImpi.class 2KB hsgloginController.class 2KB Pinglun.class 2KB Shoucangjilu.class 2KB Md5.class 2KB Kangnixing.class 2KB SetChar.class 2KB IndexController.class 2KB Youqinglianjie.class 2KB Allusers.class 2KB PageBean.class 1KB PageInfo.class 1KB testFilter.class 1KB Guoshupinzhong.class 1KB Shengfenxinxi.class 1KB Qitaxinxi.class 1KB GuoshilihuazhibiaoMapper.class 1KB GuoshixingzhuangMapper.class 1KB YouqinglianjieMapper.class 1KB GuoshupinzhongMapper.class 1KB ShushizhibiaoMapper.class 1020B ShengfenxinxiMapper.class 1020B XinwentongzhiMapper.class 1020B LiuyanbanMapper.class 1016B ShutizhibiaoMapper.class 1009B GuoshuxinxiMapper.class 998B YonghuzhuceMapper.class 998B KangnixingMapper.class 987B QitaxinxiMapper.class 976B YonghuMapper.class 943B GuoshilihuazhibiaoServer.class 940B HerenMapper.class 932B CheckCode.class 922B GuoshixingzhuangServer.class 918B ShoucangjiluMapper.class 898B AllusersMapper.class 898B GuoshupinzhongServer.class 896B YouqinglianjieServer.class 896B ShushizhibiaoServer.class 885B ShengfenxinxiServer.class 885B ShutizhibiaoServer.class 874B YonghuzhuceServer.class 863B GuoshuxinxiServer.class 863B LiuyanbanServer.class 860B PinglunMapper.class 858B KangnixingServer.class 852B QitaxinxiServer.class 841B YonghuServer.class 808B HerenServer.class 797B XinwentongzhiServer.class 796B ShoucangjiluServer.class 763B共 542 条
- 1
- 2
- 3
- 4
- 5
- 6
资源评论
入伍击寇
- 粉丝: 138
- 资源: 5032
最新资源
- 废物检测70-YOLO（v5至v8）、COCO、VOC数据集合集.rar
- C语言实例-毕业设计项目：俄罗斯方块游戏开发-开题报告，论文，答辩PPT参考
- SSM 基于 Vue 的线上点餐系统设计的智能性与 Vue 实现的自动化水平提升方案
- C++语言实例-毕业设计项目：打字母游戏开发-开题报告，论文，答辩PPT参考
- C++语言实例-毕业设计项目：Windows任务管理器模拟，多线程，系统监控特点-开题报告，论文，答辩PPT参考
- C++语言实例-毕业设计项目：青蛙过河游戏开发，图形界面，实时交互-开题报告，论文，答辩PPT参考
- C语言实例-毕业设计项目：图形界面编程，交互式绘图工具-开题报告，论文，答辩PPT参考
- C++语言实例-毕业设计项目：图形界面游戏开发-开题报告，论文，答辩PPT参考
- C语言实例-毕业设计项目：多线程HTTP服务器，阻塞套接字，重叠I/O和客户端线程-开题报告，论文，答辩PPT参考
- C++语言实例-毕业设计项目：矿井逃生游戏开发-开题报告，论文，答辩PPT参考
- C语言实例-毕业设计项目：图形界面游戏开发-开题报告，论文，答辩PPT参考
- C++语言实例-毕业设计项目：仿微软经典游戏香蕉大猩猩-开题报告，论文，答辩PPT参考
- 基于 SSM 基于 Web 的流浪狗收容领养平台的志愿者管理功能 JSP 实现与优化方案
- Python 移除模拟器设备Id绑定，目前仅支持Mumu模拟器和雷电模拟器
- 大型自动驾驶道路车辆行人图像目标检测数据【已标注，约11,000张数据，YOLO 标注格式】
- Python TXT文件按条件批量删除行工具
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
