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
版权申诉
113 浏览量
2023-06-22
11:24:46
上传
评论
收藏 29.86MB ZIP 举报
基于ssm+mysql的编程类在线答题系统源码数据库.zip （503个子文件） 
Info.class 18KB db.class 14KB ShijuanxinxiController.class 13KB XueshengxinxiController.class 10KB JiaoshixinxiController.class 9KB YonghuzhuceController.class 9KB VeDate.class 9KB DuoxuantiController.class 8KB TiankongtiController.class 7KB PanduantiController.class 7KB AllusersController.class 7KB ShoucangjiluController.class 7KB KechengxinxiController.class 7KB DanxuantiController.class 7KB LiuyanbanController.class 7KB BianchengtiController.class 7KB XinwentongzhiController.class 7KB YouqinglianjieController.class 6KB PinglunController.class 6KB Shijuanxinxi.class 5KB Yonghuzhuce.class 4KB StrUtil.class 4KB Duoxuanti.class 3KB Danxuanti.class 3KB LiuyanbanServerImpi.class 3KB YouqinglianjieServerImpi.class 3KB XueshengxinxiServerImpi.class 3KB JiaoshixinxiServerImpi.class 3KB KechengxinxiServerImpi.class 3KB ShijuanxinxiServerImpi.class 3KB YonghuzhuceServerImpi.class 3KB TiankongtiServerImpi.class 3KB DanxuantiServerImpi.class 3KB DuoxuantiServerImpi.class 3KB PanduantiServerImpi.class 3KB XinwentongzhiServerImpi.class 3KB AllusersServerImpi.class 3KB Xinwentongzhi.class 2KB Xueshengxinxi.class 2KB Liuyanban.class 2KB BianchengtiServerImpi.class 2KB ShoucangjiluServerImpi.class 2KB PinglunServerImpi.class 2KB Jiaoshixinxi.class 2KB hsgloginController.class 2KB Pinglun.class 2KB Bianchengti.class 2KB Tiankongti.class 2KB Panduanti.class 2KB Shoucangjilu.class 2KB Md5.class 2KB SetChar.class 2KB IndexController.class 2KB Youqinglianjie.class 2KB Allusers.class 2KB PageBean.class 1KB PageInfo.class 1KB testFilter.class 1KB Kechengxinxi.class 1KB YouqinglianjieMapper.class 1KB XueshengxinxiMapper.class 1020B XinwentongzhiMapper.class 1020B LiuyanbanMapper.class 1016B KechengxinxiMapper.class 1009B ShijuanxinxiMapper.class 1009B JiaoshixinxiMapper.class 1009B YonghuzhuceMapper.class 998B TiankongtiMapper.class 987B PanduantiMapper.class 976B DuoxuantiMapper.class 976B DanxuantiMapper.class 976B CheckCode.class 922B AllusersMapper.class 898B ShoucangjiluMapper.class 898B YouqinglianjieServer.class 896B BianchengtiMapper.class 890B XueshengxinxiServer.class 885B ShijuanxinxiServer.class 874B JiaoshixinxiServer.class 874B KechengxinxiServer.class 874B YonghuzhuceServer.class 863B LiuyanbanServer.class 860B PinglunMapper.class 858B TiankongtiServer.class 852B DuoxuantiServer.class 841B PanduantiServer.class 841B DanxuantiServer.class 841B XinwentongzhiServer.class 796B AllusersServer.class 763B ShoucangjiluServer.class 763B BianchengtiServer.class 755B PinglunServer.class 723B Constant.class 674B .classpath 1KB org.eclipse.wst.common.component 601B org.eclipse.wst.jsdt.ui.superType.container 49B common.css 136KB common.css 136KB bootstrap.min.css 119KB common.css 118KB共 503 条
- 1
- 2
- 3
- 4
- 5
- 6
资源评论
