团队作业（五）：冲刺总结（四）

项目：电子公文传输系统

今日任务

对昨日安排任务进行总结，分享，讨论，同时对代码进行整合，各自人员认领昨日任务进行学习。
主要是完善前端及后端遗留的各种问题，同时继续学习bootstrap，并开会讨论明日任务。

今日任务的完成情况

学号姓名	任务	完成情况
20211207封雅婷	后端设计；	85％
20211214刘蕾	后端设计；	85％
20211218刘泓姗	login.jsp;head.jsp代码编写	83%
20211219侯坤瑞	数据库查询编写	87%
20211227丁煜薇	bootstrap样式引入修改	86%

任务片段

数据库查询

public ArrayList getAllAdmin(String id) {
String sql = "select * from admin where id!=1 and id!=" + id + " order by id desc";
String args[] = { "id", "name", "pwd", "type", "status" };
al = sb.select(sql, args);
System.out.print("--------------" + sql);
;
return al;
}
public ArrayList getDep() {
String sql = "select * from dep order by id desc";
String args[] = { "id", "name" };
al = sb.select(sql, args);
System.out.print("--------------" + sql);
;
return al;
}
public ArrayList getDep(String id) {
String sql = "select * from dep where id=" + id;
String args[] = { "id", "name" };
al = sb.selectRow(args, sql);
System.out.print("--------------" + sql);
;
return al;
}
public ArrayList getDocument() {
String sql = "select * from document order by id desc";
String args[] = { "id", "admin", "title", "content", "mode", "dep", "dates", "lingdao", "taohong" };
al = sb.select(sql, args);
System.out.print("--------------" + sql);
;
return al;
}
public ArrayList getDocument(String id) {
String sql = "select * from document where id=" + id;
String args[] = { "id", "admin", "title", "content", "mode", "dep", "dates", "lingdao", "taohong" };
al = sb.selectRow(args, sql);
System.out.print("--------------" + sql);
;
return al;
}
public ArrayList getDocumentUser(String admin) {
String sql = "select * from document where admin='" + admin + "' order by id desc";
String args[] = { "id", "admin", "title", "content", "mode", "dep", "dates", "lingdao", "taohong" };
al = sb.select(sql, args);
System.out.print("--------------" + sql);
;
return al;
}
public ArrayList getDocumentDep(String dep) {
String sql = "select * from document where dep='" + dep + "' order by id desc";
String args[] = { "id", "admin", "title", "content", "mode", "dep", "dates", "lingdao", "taohong" };
al = sb.select(sql, args);
System.out.print("--------------" + sql);
;
return al;
}
public ArrayList getExamine() {
String sql = "select * from examine order by id desc";
String args[] = { "id", "document", "dep", "state" };
al = sb.select(sql, args);
System.out.print("--------------" + sql);
;
return al;
}
public ArrayList getExamine(String id) {
String sql = "select * from examine where id=" + id;
String args[] = { "id", "document", "dep", "state" };
al = sb.selectRow(args, sql);
System.out.print("--------------" + sql);
;
return al;
}
public ArrayList getExamineDocument(String document) {
String sql = "select * from examine where document=" + document + " order by id desc";
String args[] = { "id", "document", "dep", "state" };
al = sb.select(sql, args);
System.out.print("--------------" + sql);
;
return al;
}
public ArrayList getExamineDep(String dep) {
String sql = "select * from examine where dep=" + dep + " order by id desc";
String args[] = { "id", "document", "dep", "state" };
al = sb.select(sql, args);
System.out.print("--------------" + sql);
;
return al;
}
}

login.jsp

<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
ArrayList adminlogin = (ArrayList)session.getAttribute("adminlogin");
boolean closed = false;
ArrayList admin = null;
if(adminlogin != null && adminlogin.size() != 0){
 closed = true;
 admin = array.getAllAdmin(adminlogin.get(0).toString());
}
%>

明日任务如下

学号&姓名	任务
20211207封雅婷	后端设计处理login.jsp,left.jsp发回数据，
20211214刘蕾	后端设计处理head.jsp,audit.jsp发回数据
20211218刘泓姗	前端设计left.jsp;audit.jsp;
20211219侯坤瑞	数据库代码处理
20211227丁煜薇	前端设计password.jsp;systemuser.jsp