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项目-物流管理系统的Java毕业设计(源码+演示视频+数据库).rar 【项目技术】 开发语言:Java 框架:ssm 架构:B/S 数据库:mysql 【实现功能】 系统主要是分为管理员端设计与用户端设计。 主要包括系统用户管理模块、司机信息模块、车辆信息管理、货物库存管理、货物入库管理、登录模块、和退出模块等。
资源推荐
资源详情
资源评论
收起资源包目录
SSM项目-物流管理系统的Java毕业设计(源码+演示视频+数据库).rar (717个子文件)
Info.class 18KB
db.class 13KB
DinggouController.class 10KB
YonghuzhuceController.class 9KB
VeDate.class 9KB
HuowuxinxiController.class 8KB
PeisongsijiController.class 8KB
CheliangxinxiController.class 8KB
AllusersController.class 7KB
ShoucangjiluController.class 7KB
YonghuxinxiController.class 7KB
YonghufankuiController.class 7KB
WuliugongsiController.class 7KB
LiuyanbanController.class 7KB
XinwentongzhiController.class 6KB
RukuController.class 6KB
ChukuController.class 6KB
YouqinglianjieController.class 6KB
PinglunController.class 6KB
CangkuxinxiController.class 5KB
Yonghuzhuce.class 4KB
Dinggou.class 4KB
StrUtil.class 4KB
LiuyanbanServerImpi.class 3KB
YouqinglianjieServerImpi.class 3KB
CheliangxinxiServerImpi.class 3KB
YonghufankuiServerImpi.class 3KB
PeisongsijiServerImpi.class 3KB
YonghuzhuceServerImpi.class 3KB
CangkuxinxiServerImpi.class 3KB
WuliugongsiServerImpi.class 3KB
YonghuxinxiServerImpi.class 3KB
HuowuxinxiServerImpi.class 3KB
DinggouServerImpi.class 3KB
XinwentongzhiServerImpi.class 3KB
ChukuServerImpi.class 3KB
RukuServerImpi.class 3KB
AllusersServerImpi.class 3KB
Peisongsiji.class 2KB
Liuyanban.class 2KB
ShoucangjiluServerImpi.class 2KB
Xinwentongzhi.class 2KB
PinglunServerImpi.class 2KB
Yonghuxinxi.class 2KB
hsgloginController.class 2KB
Cheliangxinxi.class 2KB
Chuku.class 2KB
Ruku.class 2KB
Huowuxinxi.class 2KB
Wuliugongsi.class 2KB
Pinglun.class 2KB
Shoucangjilu.class 2KB
Md5.class 2KB
SetChar.class 2KB
Yonghufankui.class 2KB
Youqinglianjie.class 2KB
Allusers.class 2KB
PageBean.class 1KB
PageInfo.class 1KB
testFilter.class 1KB
Cangkuxinxi.class 1KB
YouqinglianjieMapper.class 1KB
XinwentongzhiMapper.class 1020B
CheliangxinxiMapper.class 1020B
LiuyanbanMapper.class 1016B
YonghufankuiMapper.class 1009B
PeisongsijiMapper.class 998B
YonghuxinxiMapper.class 998B
CangkuxinxiMapper.class 998B
YonghuzhuceMapper.class 998B
WuliugongsiMapper.class 998B
HuowuxinxiMapper.class 987B
DinggouMapper.class 954B
ChukuMapper.class 932B
CheckCode.class 922B
RukuMapper.class 921B
AllusersMapper.class 898B
ShoucangjiluMapper.class 898B
YouqinglianjieServer.class 896B
CheliangxinxiServer.class 885B
YonghufankuiServer.class 874B
YonghuzhuceServer.class 863B
WuliugongsiServer.class 863B
PeisongsijiServer.class 863B
YonghuxinxiServer.class 863B
CangkuxinxiServer.class 863B
LiuyanbanServer.class 860B
PinglunMapper.class 858B
HuowuxinxiServer.class 852B
DinggouServer.class 819B
ChukuServer.class 797B
XinwentongzhiServer.class 796B
RukuServer.class 786B
AllusersServer.class 763B
ShoucangjiluServer.class 763B
PinglunServer.class 723B
Constant.class 674B
.classpath 7KB
org.eclipse.wst.common.component 580B
org.eclipse.wst.jsdt.ui.superType.container 49B
共 717 条
- 1
- 2
- 3
- 4
- 5
- 6
- 8
资源评论
岛上程序猿
- 粉丝: 2578
- 资源: 4154
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 大创项目编程示例开发案列优质学习资料资源工具与案列应用场景开发文档教程资料.txt
- 树莓派智能车编程实例开发案列优质学习资料资源工具与案列应用场景开发文档教程资料.txt
- 电子设计竞赛(Electronic Design Contest) 开发案列优质学习资料资源工具与案列应用场景开发文档教程资料
- Cpu-Z 是一款计算机的CPU检测软件
- 美国大学生数学建模竞赛 开发案列优质学习资料资源工具与案列应用场景开发文档教程资料.txt
- 最新版点微同城源码34.7+全套插件+小程序前后端附图片
- 计算机二级 开发案列优质学习资料资源工具与案列应用场景开发文档教程资料.txt
- Python 编程示例开发案列优质学习资料资源工具与案列应用场景开发文档教程资料.txt
- Java学生管理系统数列开发案列优质学习资料资源工具与案列应用场景开发文档教程资料.txt
- dysbb_121970.apk
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功