团队作业(五):冲刺总结(六)

团队作业(五):冲刺总结(五)

项目:电子公文传输系统

今日任务

  • 后端设计处理checker.java;DeleteController.java;FileController.java
  • 后端设计处理CheckerController.java;DepartmentController.java;InsertAdminController.java
  • 前端设计audit1.jsp;dep_add.jsp;dep.jsp;document_add.jsp;xiafa.jsp
  • 数据库代码处理sqlhelper.java;CRUDHelper.java
  • 前端设计document_show.jsp;document.jsp;systemuser_add.jsp

今日任务的完成情况

学号&姓名 任务 完成情况
20191304商苏赫 端设计处理checker.java;DeleteController.java 100%
20191314徐汇仁 后端设计处理CheckerController.java;DepartmentController.java 100%
20191323王予涵 前端设计audit1.jsp;dep_add.jsp;dep.jsp 100%
20191325施羿 数据库代码处理sqlhelper.java;CRUDHelper.java 92%
20191330雷清逸 前端设计document_show.jsp;document.jsp;systemuser_add.jsp 90%

任务片段

checker.c
public class Checker {
	

	public int getIntAndChar(String str){
		char c;
		int i;
		for (i = 0; i<str.length(); i++){
			c = str.charAt(i);
			if(!((c>='0' && c<='9') || (c>='a' && c<='z') || (c>='A' && c<='Z'))){
				break;
			}
		}
		if(i < str.length()){
			return -1;
		}else{
			return 0;
		}
	}
	

	public int getInt(String str){
		char c;
		int i;
		for (i = 0; i<str.length(); i++){
			c = str.charAt(i);
			if(!(c>='0' && c<='9')){
				break;
			}
		}
		if(i < str.length()){
			return -1;
		}else{
			return 0;
		}
	}
	

	public boolean getLawlessChar(String str){
		boolean flag = false;
		char c;
		for(int i = 0;i < str.length();i++){
			c = str.charAt(i);
			switch(c){
			case '<' : flag = true; break;
			case '>' : flag = true; break;
			case '"' : flag = true; break;
			case '&' : flag = true; break;
			case ' ' : flag = true; break;
			}
		}
		return flag;
	}
	

	public String htmlspecialchars(String str) {
		str = str.replaceAll("&", "&amp;");
		str = str.replaceAll("<", "&lt;");
		str = str.replaceAll(">", "&gt;");
		str = str.replaceAll("\"", "&quot;");
		return str;
	}
	

	public String getUnicode(String str) {
		if(str != null){
			try {
				return new String(str.getBytes("iso8859_1"),"gb2312");
			} catch (UnsupportedEncodingException e) {

				e.printStackTrace();
				return str;
			}
		}else{
			return null;
		}
	}
	

	public String getGb2312(String str) {
		if(str != null){
			try {
				return new String(str.getBytes("gb2312"),"iso8859_1");
			} catch (UnsupportedEncodingException e) {

				e.printStackTrace();
				return str;
			}
		}else{
			return null;
		}
	}
	

	public String getSystemDate(){
		SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		Date date = new Date();
		return df.format(date);
	}
	

	public float getRround(float f,int precision){
		int n = 1;
		for(int i = 1;i <= precision;i++){
			n *= 10;
		}
		int tem = (int)(f*n+0.5);
		float ff = ((float)tem/n);
		return ff;
	}
}
dep.jsp
</head>
<body class="" style="overflow-y: hidden" scroll="no" resizable="false">
	<div id="north" region="north" split="false" border="false"
		style='height: 78px;'>
		<jsp:include page="/admin/head.jsp"></jsp:include>
	</div>

	<div id="left-menuss" style='width: 180px;display:inline-block'>
		<jsp:include page="/admin/left.jsp"></jsp:include>
	</div>

	<div id='main' style="background: #f7f7f7; padding: 5px;display:inline-block;border:1px solid red;float:right">
  <table width="100%" class="table table-hover">
    <thead>
      <tr>
        <td colspan="3" align="center" style="padding:5px;">学院部门管理</td>
      </tr>
      <tr>
        <td colspan="3" style="padding:5px;"><a href="<%=path %>/admin/dep_add.jsp"  class="btn btn-info">添加学院部门</a></td>
      </tr>
      <tr class="thead">
        <td align="center">序号</td>
        <td align="center">学院部门名称</td>
        <td align="center">操作</td>
      </tr>
    </thead>
    <tbody class="tbody">
    <%
    if(dep != null && dep.size() != 0){
	    for(int i = 0;i < dep.size();i++){
	    	ArrayList alRow = (ArrayList)dep.get(i);
    %>
      <tr>
        <td align="center"><%=i+1 %></td>
        <td align="center"><%=alRow.get(1) %></td>
        <td align="center"><a href="<%=path %>/DelServlet?dep=<%=alRow.get(0) %>"  class="btn btn-danger">删除</a></td>
      </tr>
      <%}} %>
    </tbody>
  </table>
  
  	<div class="modal fade" style="top: 13%;" tabindex="-1" role="dialog"
		id="showModal">

		<div class="modal-dialog" role="document">

			<div class="modal-content"></div>

		</div>

	</div>
</div>
</body>
sqlHelper.java
public class SqlHelper {
	DBHelper sb = new DBHelper();
	ArrayList al = null;

	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;
	}
}

明日任务如下

学号&姓名 任务
20191304商苏赫 后端设计处理PasswordController.java LeaderController.java
20191314徐汇仁 后端设计处理RemoveController.java DepartmentController.java
20191323王予涵 前端设计systemuser.jsp
20191325施羿 数据库代码处理 SQLConnection.java
20191330雷清逸 前端设计left.jsp

会议合照

燃尽图

posted @ 2021-12-10 23:35  1913新生代农民工  阅读(68)  评论(0编辑  收藏  举报