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_137_mysql_数据结构课堂学生考勤管理系统_.zip
共516个文件
class:83个
java:83个
jsp:81个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 105 浏览量
2024-08-14
21:09:22
上传
评论
收藏 29.3MB ZIP 举报
温馨提示
结合用户角色的不同主要的功能需求内容如下: 1、系统管理员用户 系统管理员用户可以通过系统后台录入学生及教师信息,包括学号、工号以及个人基础资料,同时可以通过课程管理添加课程信息,通过后台基本信息的录入实现学生请假及学生签到基础内容的添加,管理员可以通过后台查看到学生请假及学生签到信息内容。 2、学生用户 学生用户可以通过个人后台修改个人资料,同时可以结合课程信息内容实现在线学生签到提交,通过后台的学生请假管理模块提交请假申请内容。 3、教师用户 教师用户可以通过管理界面及时查看到学生请假信息,结合学生用户申请内容进行在线审批,查看学生用户在线签到信息及课程安排。
资源推荐
资源详情
资源评论
收起资源包目录
ssm_137_mysql_数据结构课堂学生考勤管理系统_.zip (516个子文件)
Info.class 18KB
db.class 14KB
XueshengqiandaoController.class 11KB
JiaoshixinxiController.class 10KB
XueshengxinxiController.class 10KB
KaoqintongjiController.class 10KB
KechengxinxiController.class 9KB
YonghuzhuceController.class 9KB
VeDate.class 9KB
XueshengqingjiaController.class 9KB
JiaoshiqingjiaController.class 9KB
AllusersController.class 7KB
ShoucangjiluController.class 7KB
LiuyanbanController.class 7KB
XinwentongzhiController.class 6KB
YouqinglianjieController.class 6KB
PinglunController.class 6KB
Yonghuzhuce.class 4KB
StrUtil.class 4KB
Kaoqintongji.class 4KB
Xueshengqiandao.class 3KB
Kechengxinxi.class 3KB
Jiaoshixinxi.class 3KB
Xueshengxinxi.class 3KB
Jiaoshiqingjia.class 3KB
LiuyanbanServerImpi.class 3KB
XueshengqingjiaServerImpi.class 3KB
XueshengqiandaoServerImpi.class 3KB
JiaoshiqingjiaServerImpi.class 3KB
YouqinglianjieServerImpi.class 3KB
Xueshengqingjia.class 3KB
XueshengxinxiServerImpi.class 3KB
JiaoshixinxiServerImpi.class 3KB
KechengxinxiServerImpi.class 3KB
KaoqintongjiServerImpi.class 3KB
YonghuzhuceServerImpi.class 3KB
XinwentongzhiServerImpi.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
SetChar.class 2KB
IndexController.class 2KB
Youqinglianjie.class 2KB
Allusers.class 2KB
PageBean.class 1KB
PageInfo.class 1KB
testFilter.class 1KB
XueshengqiandaoMapper.class 1KB
XueshengqingjiaMapper.class 1KB
YouqinglianjieMapper.class 1KB
JiaoshiqingjiaMapper.class 1KB
XueshengxinxiMapper.class 1020B
XinwentongzhiMapper.class 1020B
LiuyanbanMapper.class 1016B
JiaoshixinxiMapper.class 1009B
KaoqintongjiMapper.class 1009B
KechengxinxiMapper.class 1009B
YonghuzhuceMapper.class 998B
CheckCode.class 922B
XueshengqiandaoServer.class 907B
XueshengqingjiaServer.class 907B
ShoucangjiluMapper.class 898B
AllusersMapper.class 898B
YouqinglianjieServer.class 896B
JiaoshiqingjiaServer.class 896B
XueshengxinxiServer.class 885B
KechengxinxiServer.class 874B
KaoqintongjiServer.class 874B
JiaoshixinxiServer.class 874B
YonghuzhuceServer.class 863B
LiuyanbanServer.class 860B
PinglunMapper.class 858B
XinwentongzhiServer.class 796B
ShoucangjiluServer.class 763B
AllusersServer.class 763B
PinglunServer.class 723B
Constant.class 674B
.classpath 1KB
org.eclipse.wst.common.component 598B
org.eclipse.wst.jsdt.ui.superType.container 49B
common.css 136KB
common.css 136KB
style.css 135KB
style(2).css 135KB
bootstrap.min.css 119KB
common.css 118KB
bootstrap.min.css 115KB
style.min862f.css 97KB
animate.css 67KB
style.css 56KB
animate.min.css 46KB
font-awesome.min.css 30KB
ry-ui.css 22KB
ry-ui(1).css 22KB
共 516 条
- 1
- 2
- 3
- 4
- 5
- 6
资源评论
Java资深爱好者
- 粉丝: 1214
- 资源: 2577
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功