SSM整合开发的小Demo----毕业设计管理系统之管理员模块

柔光的暖阳◎ 2022-06-05 05:28 149阅读 0赞

系统简介: 本系统是本人花了四个晚上开发的一套简易的系统,逻辑简单易懂,工程层次分明,适合新人练手学习.后台使用SpringMVC+MyBatis+Spring+Shiro技术,前端使用了Bootstrap+JFreeChart+JQuery技术.系统分为三个角色登录,学生,教师,管理员,其结构图如下所示

![Center][]

现在先介绍管理员模块的功能,其结构图如下:

![Center 1][]

先看看结果怎样,一睹为快

![Center 2][]

![Center 3][]

![Center 4][]

![Center 5][]

![Center 6][]

![Center 7][]

![Center 8][]

![Center 9][]

![Center 10][]

![Center 11][]

示例代码(附件的上传下载):

\#数据模型层

package com.east.entity;
    
    import java.io.Serializable;
    import java.sql.Timestamp;
    import java.util.Arrays;
    
    public class Fufile implements Serializable {
       private Integer f_id;                //附件id
       private String  f_name;              //附件名称
       private byte[]  f_file;              //文件
       private Timestamp f_time;            //上传时间
    public Integer getF_id() {
    	return f_id;
    }
    public void setF_id(Integer f_id) {
    	this.f_id = f_id;
    }
    public String getF_name() {
    	return f_name;
    }
    public void setF_name(String f_name) {
    	this.f_name = f_name;
    }
    public byte[] getF_file() {
    	return f_file;
    }
    public void setF_file(byte[] f_file) {
    	this.f_file = f_file;
    }
    public Timestamp getF_time() {
    	return f_time;
    }
    public void setF_time(Timestamp f_time) {
    	this.f_time = f_time;
    }
    @Override
    public String toString() {
    	return "Fufile [f_id=" + f_id + ", f_name=" + f_name + ", f_file=" + Arrays.toString(f_file) + ", f_time=" + f_time
    			+ "]";
    }
       
    }

package com.east.entity;
    
    import java.sql.Timestamp;
    
    import org.springframework.web.multipart.MultipartFile;
    /*
     * 在前台html中，form的enctype为multipart/form-data。注意input、select的name要和FufileForm中成员一一对应。
     * 上传的url为Upload，此action方法的参数中使用FufileForm来映射提交的数据。此时就可以获取到提交的文件的数据。然后我们就对文件进行操作。
     */
    public class FufileForm {
    	 private Integer f_id;                //附件id
    	 private String  f_name;              //附件名称
    	 private MultipartFile f_file;
    	 private Timestamp f_time;            //上传时间
    	public Integer getF_id() {
    		return f_id;
    	}
    	public void setF_id(Integer f_id) {
    		this.f_id = f_id;
    	}
    	public String getF_name() {
    		return f_name;
    	}
    	public void setF_name(String f_name) {
    		this.f_name = f_name;
    	}
    	public MultipartFile getF_file() {
    		return f_file;
    	}
    	public void setF_file(MultipartFile f_file) {
    		this.f_file = f_file;
    	}
    	public Timestamp getF_time() {
    		return f_time;
    	}
    	public void setF_time(Timestamp f_time) {
    		this.f_time = f_time;
    	}
    	 
    }

\#数据访问层

package com.east.dao;
    
    import java.util.List;
    
    import org.apache.ibatis.annotations.Insert;
    import org.apache.ibatis.annotations.Options;
    import org.apache.ibatis.annotations.Param;
    import org.apache.ibatis.annotations.Select;
    
    import com.east.entity.Fufile;
    
    public interface FufileDao {
        /*
         * 上传附件
         */
    	@Insert("insert into fufile(f_name,f_file) values(#{f_name},#{f_file,javaType=byte[],jdbcType=BLOB,typeHandler=org.apache.ibatis.type.BlobTypeHandler})")
    	@Options(useGeneratedKeys = true,keyProperty="f_id")
    	void AddFile(Fufile fufile);
    	
    	/*
    	 * 所有附件
    	 */
    	@Select("select * from fufile")
    	List<Fufile> findAll();
    	
    	/*
    	 * 下载某个id的文件
    	 */
    	@Select("select * from fufile where f_id = #{f_id}")
    	Fufile findById(Integer f_id);
    }

\#业务逻辑层

package com.east.service;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Isolation;
    import org.springframework.transaction.annotation.Propagation;
    import org.springframework.transaction.annotation.Transactional;
    import com.east.dao.FufileDao;
    import com.east.entity.Fufile;
    
    @Transactional(propagation=Propagation.REQUIRED,isolation=Isolation.DEFAULT)
    @Service("fufileBiz")
    public class FufileBiz {
        /*
         * 自动注入FufileDao
         */
    	@Autowired
    	private FufileDao fufileDao;
    	
    	/*
    	 * 上传附件
    	 */
    	public void AddFile(Fufile fufile){
    		fufileDao.AddFile(fufile);
    	}
    	
    	/*
    	 * 所有附件
    	 */
    	public List<Fufile> findAll(){
    		return fufileDao.findAll();
    	}
    	
    	/*
    	 * 下载某个id的文件
    	 */
    	public Fufile findById(Integer f_id){
    		return fufileDao.findById(f_id);
    	}
    }

\#控制层

package com.east.action;
    
    import java.io.BufferedOutputStream;
    import java.io.IOException;
    import java.io.InputStream;
    import java.io.OutputStream;
    import java.net.URLEncoder;
    
    import javax.servlet.http.HttpServletResponse;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.beans.factory.annotation.Qualifier;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.ModelMap;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.servlet.ModelAndView;
    
    import com.east.entity.Fufile;
    import com.east.entity.FufileForm;
    import com.east.service.FufileBiz;
    
    /*
     * 处理用户请求的控制器
     */
    @Controller
    public class FufileAction {
        //自动注入FufileBiz
    	@Autowired
    	@Qualifier("fufileBiz")
    	private FufileBiz fufileBiz;
    	
    	/*
    	 * 上传文件
    	 */
    	@RequestMapping(value="/Upload")
    	public ModelAndView Upload(String f_name,ModelMap model,FufileForm file,ModelAndView mv) throws IOException{
            
            InputStream is = file.getF_file().getInputStream();
            byte[] Data = new byte[(int) file.getF_file().getSize()];  
            is.read(Data);
            
            String FileName = file.getF_file().getOriginalFilename();     //获取文件名 
            Fufile fufile = new Fufile();
            fufile.setF_name(FileName);
    		fufile.setF_file(Data);
    		fufileBiz.AddFile(fufile);             //保存文件流
    
    		mv.setViewName("/Administrator/UploadFile");
    		return mv;      
    	}
    	
    	/*
    	 * 下载某个id的文件
    	 */
    	@RequestMapping(value="/Download")
    	public void Download(String f_id,ModelAndView mv,HttpServletResponse response) throws IOException{
    		int id = Integer.parseInt(f_id);
            Fufile fufile = fufileBiz.findById(id);
            String f_name = fufile.getF_name();
            f_name = URLEncoder.encode(f_name, "UTF-8");  
            byte[] data = fufile.getF_file();
            
            response.reset();  
            response.setHeader("Content-Disposition", "attachment; filename=\"" + f_name + "\"");  
            response.addHeader("Content-Length", "" + data.length);  
            response.setContentType("application/octet-stream;charset=UTF-8");  
            OutputStream outputStream = new BufferedOutputStream(response.getOutputStream());  
            outputStream.write(data);  
            outputStream.flush();  
            outputStream.close();   
    	}
    }

\#视图层

<%@page import="com.east.entity.Fufile"%>
    <%@page import="java.util.List"%>
    <%@page import="com.east.service.FufileBiz"%>
    <%@page
    	import="org.springframework.context.support.ClassPathXmlApplicationContext"%>
    <%@page import="org.springframework.context.ApplicationContext"%>
    <%@ page language="java" contentType="text/html; charset=UTF-8"
    	pageEncoding="UTF-8"%>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>上传附件</title>
    <link rel="stylesheet" href="../bootstrap-3.3.7/css/bootstrap.min.css">
    <link rel="stylesheet" href="bootstrap-3.3.7/css/bootstrap.min.css">
    <link rel="stylesheet" href="../bootstrap-3.3.7/css/fileinput.min.css" />
    <link rel="stylesheet" href="bootstrap-3.3.7/css/fileinput.min.css" />
    <script src="../js/jquery-3.2.1.min.js"></script>
    <script src="js/jquery-3.2.1.min.js"></script>
    <script src="../js/bootstrap.min.js"></script>
    <script src="js/bootstrap.min.js"></script>
    <script type="text/javascript" src="../js/fileinput.min.js"></script>
    <script type="text/javascript" src="js/fileinput.min.js"></script>
    <script type="text/javascript" src="../js/zh.js"></script>
    <script type="text/javascript" src="js/zh.js"></script>
    <script>
    	$(function() {
    		initFileInput("input-id");
    	})
    
    	function initFileInput(ctrlName) {
    		var control = $('#' + ctrlName);
    		control
    				.fileinput(
    						{
    							language : 'zh', //设置语言
    							uploadUrl : "${pageContext.request.contextPath }/UploadFile", //上传的地址
    							allowedFileExtensions : [ 'jpg', 'gif', 'png',
    									'doc', 'docx', 'pdf', 'ppt', 'pptx', 'txt' ],//接收的文件后缀  
    							maxFilesNum : 3,//上传最大的文件数量  
    							uploadAsync : true, //默认异步上传
    							showUpload : false, //是否显示上传按钮
    							showRemove : true, //显示移除按钮
    							showPreview : false, //是否显示预览
    							showCaption : true,//是否显示标题
    							browseClass : "btn btn-primary", //按钮样式
    							dropZoneEnabled : true,//是否显示拖拽区域
    							maxFileSize : 0,//单位为kb，如果为0表示不限制文件大小
    							maxFileCount : 1, //表示允许同时上传的最大文件个数
    							enctype : 'multipart/form-data',
    							validateInitialCount : true,
    							previewFileIcon : "<i class='glyphicon glyphicon-king'></i>",
    							msgFilesTooMany : "选择上传的文件数量({n}) 超过允许的最大数值{m}！",
    
    						})
    				.on(
    						'filepreupload',
    						function(event, data, previewId, index) { //上传中
    							var form = data.form, files = data.files, extra = data.extra, response = data.response, reader = data.reader;
    						}).on("fileuploaded",
    						function(event, data, previewId, index) { //一个文件上传成功
    							alert("文件上传成功！");
    							console.log('文件上传成功！' + data.id);
    						}).on('fileerror', function(event, data, msg) { //一个文件上传失败
    					console.log('文件上传失败！' + data.id);
    				})
    	}
    	
    	function check(){
    		var f_name = document.getElementById("f_name").value;
    		if(f_name==""){ 
    			alert("请填写文档名称 ！");
    			return false;
    		}
    	}
    </script>
    </head>
    <body>
    	<%
    		ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml");
    		FufileBiz fufileBiz = (FufileBiz) ctx.getBean("fufileBiz");
    	%>
    	
    	<div class="container-fluid row form-group">
    		<div class="panel panel-success">
    			<div class="panel-heading">
    				<strong>上传附件</strong> <span></span>
    			</div>
    			<div class="panel-body">
    				<table class="table table-hover" border="1">
    					<tr class="success">
    						<td>序号</td>
    						<td>文件名</td>
    						<td>上传时间</td>
    						<td>操作</td>
    					</tr>
    					<%
    						List<Fufile> list = fufileBiz.findAll();
    						if (list == null || list.size() < 1) {
    							out.print("<tr><td colspan='4'>对不起，暂没有任何附件信息!</td></tr>");
    						} else {
    							for (int i=0; i<list.size(); i++) {
    								Fufile fufile = list.get(i);
    					%>
    					<tr>
    						<td><%=i+1%></td>
    						<td><%=fufile.getF_name()%></td>
    						<td><%=fufile.getF_time()%></td>
    						<td><a href="${pageContext.request.contextPath }/Download?f_id=<%=fufile.getF_id()%>">下载</a></td>
    					</tr>
    					<%
    						}
    						}
    					%>
    					<tr>
    						<td colspan='4'><span style="float: right;"><a
    								href="#" data-toggle="modal" data-target="#Revert"><input
    									type="button" name="upload" id="upload" class="btn btn-primary"
    									value="上传新附件" /></a></span></td>
    					</tr>
    				</table>
    			</div>
    		</div>
    	</div>
    
    	
    	<div class="modal fade" id="Revert" tabindex="-1" role="dialog"
    		aria-labelledby="myModalLabel" aria-hidden="true">
    		<div class="modal-dialog">
    			<div class="modal-content">
    				<div class="modal-header" style="text-align: center;">
    					<button type="button" class="close" data-dismiss="modal"
    						aria-hidden="true">×</button>
    					<div class="container-fluid row form-group">
    						<ul class="nav nav-pills nav-stacked">
    							<li class="active"><a href="#" style="text-align: left;"
    								class="glyphicon glyphicon-upload" id="title">上传附件</a></li>
    						</ul>
    					</div>
    				</div>
    				<div class="modal-body">
    					<form id="form" action="${pageContext.request.contextPath }/Upload" οnsubmit="return check()"
    						  method="post" enctype="multipart/form-data">
    						<table class="table table-hover" border="1">
    							<tr style="height: 40px;" class="success">
    								<td>
    								  <label style="width: 100px; text-align: right; padding-right: 15px;">文档名称:</label>
    								  <input type="text" name="f_name" id="f_name" style="height: 32px;" />
    								</td>
    							</tr>
    							<tr style="height: 40px;">
    								<td><input id="input-id" name="f_file" type="file" /></td>
    							</tr>
    							<tr style="height: 40px;">
    								<td><input type="submit" style="width: 90px; font-size: 14px; text-align: center; float: right;"
    									       class="btn btn-primary" id="upload" value="上传课题" />
    							   </td>
    							</tr>
    						</table>
    					</form>
    				</div>
    				<div class="modal-footer">
    					<button type="button" class="btn btn-default" data-dismiss="modal">关闭
    					</button>
    				</div>
    			</div>
    			
    		</div>
    		
    	</div>
    </body>
    </html>

[Center]: /images/20220605/09e23cc90c784029a27a75988c81d52d.png
[Center 1]: /images/20220605/3ead7d4e7d1e4a23bacf2579fedde826.png
[Center 2]: /images/20220605/4d986ab0a371419a9010065e0eae5998.png
[Center 3]: /images/20220605/95ffb49e50084d0ea0f511baa69150f8.png
[Center 4]: /images/20220605/10a0a21d422d42d0b1922f3beee489c1.png
[Center 5]: /images/20220605/465e587e1391482698f2e41e2f5546aa.png
[Center 6]: /images/20220605/880f0b77aa2e4ca5af93f3e37eb0ad07.png
[Center 7]: /images/20220605/560dd0f7dba947fb9bb31bc20efc476d.png
[Center 8]: /images/20220605/938d644b475644d1858b17de43ddb89e.png
[Center 9]: /images/20220605/32aa3eab0a9d44998f27d06ce8ac59c1.png
[Center 10]: /images/20220605/24a4d6e7b643421fa4d81ef4e1933656.png
[Center 11]: /images/20220605/40d44183f17f4efca2eb9d5a3541bac3.png