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
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
java项目之羽毛球交流平台系统源码(ssm+mysql+文档+lw) 系统源码包含ssm后端+前端+mysql数据库完整项目代码,能正常运行。 一、主界面:1、场地信息维护模块2、场地预约模块3、预约申请审核模块4、场地评价模块5、场地实时状态管理模块 二、场地信息维护模块:1.发布场地信息:营业时间、价格、展示图片 2.修改场地信息 3.删除场地信息 三、场地预约模块:1.预约场地 2.修改预约 3.删除预约 四、预约申请审核模块:1.管理员审核预约请求 2.根据审核结果实时显示预约情况 五、场地评价模块:1.消费之后可以提交评价 2.修改评价3.删除评价 六、场地实时状态管理模块:1.更新场地预约情况 2.更新场地实时使用情况
资源推荐
资源详情
资源评论
收起资源包目录
java项目之羽毛球交流平台系统源码(ssm+mysql+文档+lw).zip (1061个子文件)
Info.class 18KB
db.class 13KB
YonghuzhuceController.class 9KB
VeDate.class 9KB
AllusersController.class 7KB
XinwentongzhiController.class 7KB
LiuyanbanController.class 7KB
YouqinglianjieController.class 6KB
PinglunController.class 6KB
ChangdiController.class 5KB
YuyueController.class 5KB
TupianController.class 5KB
Yonghuzhuce.class 4KB
StrUtil.class 4KB
LiuyanbanServerImpi.class 3KB
YonghuzhuceServerImpi.class 3KB
XinwentongzhiServerImpi.class 3KB
AllusersServerImpi.class 3KB
YouqinglianjieServerImpi.class 2KB
Liuyanban.class 2KB
Xinwentongzhi.class 2KB
PinglunServerImpi.class 2KB
ChangdiServerImpi.class 2KB
TupianServerImpi.class 2KB
hsgloginController.class 2KB
Yuyue.class 2KB
Pinglun.class 2KB
YuyueServerImpi.class 2KB
Md5.class 2KB
Changdi.class 2KB
SetChar.class 2KB
IndexController.class 2KB
Youqinglianjie.class 2KB
Allusers.class 2KB
PageBean.class 1KB
Tupian.class 1KB
PageInfo.class 1KB
testFilter.class 1KB
XinwentongzhiMapper.class 1020B
LiuyanbanMapper.class 1016B
YonghuzhuceMapper.class 998B
YouqinglianjieMapper.class 953B
CheckCode.class 922B
AllusersMapper.class 898B
YonghuzhuceServer.class 863B
LiuyanbanServer.class 860B
PinglunMapper.class 858B
YouqinglianjieServer.class 818B
XinwentongzhiServer.class 796B
AllusersServer.class 763B
ChangdiMapper.class 739B
TupianMapper.class 733B
PinglunServer.class 723B
YuyueMapper.class 697B
Constant.class 674B
ChangdiServer.class 604B
TupianServer.class 598B
YuyueServer.class 562B
.classpath 1KB
org.eclipse.wst.common.component 588B
org.eclipse.wst.jsdt.ui.superType.container 49B
ace.min.css 329KB
bootstrap.min.css 94KB
samples.css 66KB
easyui.css 59KB
style3.css 58KB
font-awesome-ie7.min.css 37KB
ace-rtl.min.css 36KB
editor_ie8.css 36KB
editor_iequirks.css 36KB
editor_ie.css 35KB
editor_gecko.css 34KB
editor.css 34KB
font-awesome.css 32KB
font-awesome.min.css 27KB
ace-skins.min.css 26KB
jquery-ui-1.10.3.full.min.css 24KB
font-awesome.min.css 22KB
bootstrap-editable.css 21KB
select2.css 19KB
style.css 18KB
dialog_ie8.css 15KB
layer.css 14KB
dialog_iequirks.css 14KB
dialog_ie.css 14KB
chosen.css 13KB
dialog.css 13KB
ui.jqgrid.css 12KB
icheck.css 12KB
dropzone.css 11KB
fullcalendar.css 11KB
datepicker.css 10KB
codemirror.css 8KB
echartsHome.css 8KB
codemirror.css 8KB
ace-ie.min.css 7KB
zTreeStyle.css 6KB
laydate.css 6KB
sample.css 5KB
daterangepicker.css 5KB
共 1061 条
- 1
- 2
- 3
- 4
- 5
- 6
- 11
资源评论
风月歌
- 粉丝: 1251
- 资源: 2529
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功