package 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("2016-04-04 11:19", "2016-04-04 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("/productsys/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="";
for(HashMap permap:new CommDAO().select("select * from "+tablename+" where "+where+" order by id desc")){
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
仓库管理系统 (1851个子文件)
0032ab06187e0c0edbb7b04b30f16b42538a58 11KB
00aad96d1343f96c64256c61a8f8a5a04597b8 574B
011bf64ed33c4c04b923088e3cd466b9579edc 99B
01610598357437e56219ca4755585701051476 3KB
01b35d53009c358a531102ea792a25ad34ed5e 740B
01f0bc9e407022adc725bc637611f7dbc1d19b 1KB
020beb97cfa2ec6e918962036b5bcdd58120d4 326B
02f0b60e5f30062aa4754e713d3602e18c619b 89B
03061ec0c680ad177c02a291cbb11c6d5ace97 1KB
033e3c6c83ee314b0eba6f20e56beee9c66cb6 176B
03819404024526e6181901806c55f0d80c5933 259B
0395a53219ae3113e8ecb6361e7b77733944b2 2KB
03d0e4c42919ddb8080d1e590b97436c6367bd 2KB
03e64c9db72bd1d071f63f507e264d6d1829c2 188B
03f20fb1197edf0433ff99759cb6399d0f99f9 2KB
04266a027ca55fc548f2f9f705ea7d9081a473 277B
045338f2ea48762e2a0d451a6c8e0d07af8c43 1KB
04650d1266541778d07e55ef7a73a882d78d57 3KB
04d2632a36de38aa10c2d70a418fce25c8e947 15KB
04da6a3792152f4c1161876265073ad6238447 686B
055b65df79e83434a49b12e921b80557987de7 195B
055de35048faa004e009869661b7abb7ac9810 3KB
056a0db02d6d72173e4a8d8c19ddda10c2248c 232B
0580b22cae07026877658153f51f03914ba94f 6KB
0597e97da94f3c0a159275598070f85c515b87 19KB
05bafbaa62532ba5eb59f4ddd70fc50159829d 11KB
05ccf3838eed31e63ab07808072a8ee2791afe 3KB
067c50e37bebcca7c790739ff44244a6f7d4c5 522B
06a98bc0b1118d324737eb89fac340397f0499 726B
07271518be39d15568b2f2e8f36a29ea4531bf 3KB
074a37c8b0eff86dd801cb32c1277a529f4ead 314B
0759e9b0e1db626954eacccf44cf0f454892fb 3KB
07668e0db5b77d6ce85392a5609f850e5d0694 1KB
0783e06a4a88a3d872db9c29bd19f6d2babd0b 995B
07b10bd2af5a5943c1578d6642736fae8e358c 88B
07b710c4e6d68231dbdd393a0b9ffdadb9cbb8 3KB
07e379386cecbd7e7b84b4d66cd70a39c79967 719B
082c36a6b2a1fa72fcd5dfd0e6587ddc02ce64 1KB
084aad15f822978189dfeee1e9898097abb265 84B
087f846329e656b8cf508f9396eadcbfcafdde 498B
088470d08ee0a1da3501a6314fcfed3727ffda 16KB
0911f1f635982aa278f572bba74bd76c112793 8KB
09d4bb71e2982b77d0a69da361e13330abcc5e 468KB
09e6ddd887ad391f29162c3f6d26d73fe0690a 263B
0a3907a531ba21f736400fac28c88d4ea7e5f9 6KB
0aad87aa3ad44546077a7cbad5843c0e9bc6d8 144B
0af60d9a4ea15dcb4f2e30f72eaf32bb1f1d4e 1010B
0b131aab14241cf93b5d5824bb455882ed06d0 1KB
0b5416a6a92c2697cb61ccb762ea80030fe64b 2KB
0b8352d7770e6be4b6f3cbc61f7ee21ae3e4da 452B
0bbcad4325e58382a2b2cca4f524d7bc5e4aad 53B
0bcb63d9177b5513bb52bdc7c63c2dfbdf208b 3KB
0c449207be7c1628fbd57e9564b6391ef319bc 2KB
0c706beaa5edc56ba90b9eee9c1c6253464376 872B
0c750a714ef9e2da5a338b593a15748fc3a1d5 301B
0cbebc6cbbf047593da717cc1fd07c99ee3dab 20KB
0cc58da76079cec9ef654d66bc88a3c9f28a17 3KB
0d5d096845e1e6d71cdf7326a0e87ab79abd92 120B
0d67470eda5ac1a018188f3cb6d2d87247fe7d 239B
0d73a85fc121510ae247b8f9d071d35183b74c 1KB
0db144bae9a80782f1a0b7c3b4d08e0ec4b23f 8KB
0e3571fe339ca46af462582e4c6f5cb752c8b4 1KB
0e4bbbcceac98ebaac28a6662c1cc09ed42008 118B
0f2ca34f213601fcb40f4a38e170bbf0c2d002 2KB
0f6eb83e2f0bc163d94b8274d38edb00a28e69 8KB
0f72387d2ffe514889115f47d5564c472284f9 8KB
0fc592935bf58aaca662c6dd5d71b04aced728 1021B
0fd82c32772624564705ddd72b98221513b7f2 365B
0fda534915854dab85572623a30a72a2efadd8 312B
105fb4a7aefa6a41bfb44dde24811348fd0b87 369B
10b6a056ecd3d86233882d05a507f62913d533 15KB
1102500d411de55f4fe32684ac77e7eba11e59 12KB
118847f99aebe57e8af2f6995ac7be361efe34 3KB
11b80ced86c2230565330c6d89450aec8b22d1 4KB
11dc82c55cd8fffc9d152b22571d1041de0605 49B
123d0e69310db17f0c248cd291009a3cb2dd93 1KB
1291a94f76571ab921fb814859893b16d378d7 24KB
129763dcea0dc1916b7e934fdce2fd8770c380 347B
139a87dcd3aa8829998a7a025dc59d3a012a57 1KB
13b1a6752a2dd2a61d1344444ccd4b0dadda5e 14KB
13bc40a60d3d85d32e594fa74c29f18c3371f7 87B
1471d96c84af193a2165e3ad0c775648d70c0b 11KB
14b324f4817040a18c280f53f160fc6cc0c10f 3KB
15815501f0733c38c244f986e4985cfe56ae10 583B
15d96ac5934a62d8957dc2717f5223bc17589f 754B
1648c679c3328587b3f8e0621af30b17f8baac 3KB
1675041f6631cdc860edff1a9a56480ae91eda 3KB
16c06df2d691de5ff645244334be0614bdf0f9 1KB
171153d9bc9c9e102ecbedc57522564a959b51 62B
172bc781cad1a3df1324105a9370c1d108b75b 3KB
1763458e2a38880e8a67ca1cf48ee09ce7ca46 1KB
179a34c9d7c6fafbd03b49447c2b74eb862a41 1KB
17accc809bb9f0b057fe6cca892e5966071c56 19KB
182d4390346e517366f9c4ab62e079a167f86b 6KB
1861a3924db2db57f1a9fa2bede13a19db9c8a 727B
1891018ebc6db1c3fd90fd10c78fdd52ef5f30 3KB
19074c98897cf9152a2bbbd8f9696ac8aaa081 299B
19875d5ad20471ffcdaf8581928e7904ca0839 3KB
19d55d44f5b6d46e6c626d79f4fd8fc93a49c0 145B
19dbea6f7d0698c9114eb7a4405798cf207f79 56B
共 1851 条
- 1
- 2
- 3
- 4
- 5
- 6
- 19
资源评论
- qq_407404002018-01-18怎么用啊?___Will丶2018-02-02下载下来,直接导入eclipse可以直接使用
- 小太阳大班班草2018-01-09用的好像是JavaScript实现的,反正就是页面的java代码实现的,萌新的我看得很蒙
___Will丶
- 粉丝: 5
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功