基于Servlet+EasyUI+Mysql的学生信息系统开源

深碍√TFBOYSˉ_ 2021-08-30 15:33 273阅读 0赞

知识点：jsp servlet，MySQL数据库的基本操作，前端easyui框架。

适合人群：Java初学者、在校学生，（已经学过Java基础语法，对html有简单的了解，熟悉js、jquery语法）。

用到的工具：eclipse、MySQL

首先看下系统的截图

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdjaHVhbjY2NjY_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdjaHVhbjY2NjY_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdjaHVhbjY2NjY_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdjaHVhbjY2NjY_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdjaHVhbjY2NjY_size_16_color_FFFFFF_t_70 4][]

dao层的代码如下 所示：

package com.ischoolbar.programmer.dao;
    
    import java.sql.ResultSet;
    import java.sql.SQLException;
    
    import com.ischoolbar.programmer.model.Admin;
    import com.ischoolbar.programmer.model.Clazz;
    
    /**
     * 
     * 公众号：springmeng
     *管理员数据库操作封装
     */
    public class AdminDao extends BaseDao {
    	
    	public Admin login(String name ,String password){
    		String sql = "select * from s_admin where name = '" + name + "' and password = '" + password + "'";
    		ResultSet resultSet = query(sql);
    		try {
    			if(resultSet.next()){
    				Admin admin = new Admin();
    				admin.setId(resultSet.getInt("id"));
    				admin.setName(resultSet.getString("name"));
    				admin.setPassword(resultSet.getString("password"));
    				admin.setStatus(resultSet.getInt("status"));
    				return admin;
    			}
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    		return null;
    	}
    	public boolean editPassword(Admin admin,String newPassword) {
    		// TODO Auto-generated method stub
    		String sql = "update s_admin set password = '"+newPassword+"' where id = " + admin.getId();
    		return update(sql);
    	}
    }

filter层 的代码如下所示：

package com.ischoolbar.programmer.filter;
    
    import java.io.IOException;
    
    import javax.servlet.Filter;
    import javax.servlet.FilterChain;
    import javax.servlet.FilterConfig;
    import javax.servlet.ServletException;
    import javax.servlet.ServletRequest;
    import javax.servlet.ServletResponse;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    /**
     * 
     * 公众号：springmeng
     *拦截用户未登录状态下的操作
     */
    public class LoginFilter implements Filter {
    
    	@Override
    	public void destroy() {
    		// TODO Auto-generated method stub
    
    	}
    
    	@Override
    	public void doFilter(ServletRequest req, ServletResponse rep,
    			FilterChain chain) throws IOException, ServletException {
    		// TODO Auto-generated method stub
    		HttpServletRequest request = (HttpServletRequest)req;
    		HttpServletResponse response = (HttpServletResponse)rep;
    		Object user = request.getSession().getAttribute("user");
    		if(user == null){
    			//未登录
    			response.sendRedirect("index.jsp");
    			return;
    		}else{
    			chain.doFilter(request, response);
    		}
    	}
    
    	@Override
    	public void init(FilterConfig arg0) throws ServletException {
    		// TODO Auto-generated method stub
    
    	}
    
    }

model层的代码如下所示：

package com.ischoolbar.programmer.model;
    /**
     * 
     * 公众号：springmeng
     *管理员实体类
     */
    public class Admin {
    	private int id;
    	private String name;
    	private String password;
    	private int status = 1;
    	public int getId() {
    		return id;
    	}
    	public void setId(int id) {
    		this.id = id;
    	}
    	public String getName() {
    		return name;
    	}
    	public void setName(String name) {
    		this.name = name;
    	}
    	public String getPassword() {
    		return password;
    	}
    	public void setPassword(String password) {
    		this.password = password;
    	}
    	public int getStatus() {
    		return status;
    	}
    	public void setStatus(int status) {
    		this.status = status;
    	}
    	
    }

公中号端回复：

学生信息文档

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdjaHVhbjY2NjY_size_16_color_FFFFFF_t_70]: /images/20210827/e71542a916a141ae842868cfbd80dd44.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdjaHVhbjY2NjY_size_16_color_FFFFFF_t_70 1]: /images/20210827/9447c387a10249149cc0b01ee3c28f16.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdjaHVhbjY2NjY_size_16_color_FFFFFF_t_70 2]: /images/20210827/710ec486fe0e4ef783b24e996912099f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdjaHVhbjY2NjY_size_16_color_FFFFFF_t_70 3]: /images/20210827/1dec9321d79b49ffa5652bab25e661a4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21lbmdjaHVhbjY2NjY_size_16_color_FFFFFF_t_70 4]: /images/20210827/a8ab9276be04481ca71e524fb161a54a.png