jsp+servlet+mysql实现班级信息管理的web小项目

jsp+servlet+mysql实现班级信息管理的javaweb小项目

功能描述：能够创建和查看班级列表，以及查看班级的学生信息，可以为每个班级添加学生。除此之外还实现了一个登陆界面。
在最后加上了数据库创建的sql语句
项目下载地址：https://download.youkuaiyun.com/download/qq_29924227/10349307
项目主要参考了：http://blog.youkuaiyun.com/BlueSky_USC/article/details/72803068
登陆界面为：

班级信息管理界面为：

学生信息管理界面为：

项目目录结构：

bean包里的是用来存储班级信息的ClassInfoBean,java和用来存储学生信息的StudentInfoBean,java
dao包里为两个页面的数据库操作
servlet包里为每个页面对应的逻辑处理
util包里提供对数据库操作的工具类

下面为全部代码
ClassInfoBean.java

package bean;

public class ClassInfoBean {  
    
    /** 
     * 属性和数据库中的字段相对应 
     */  
      
    private Integer cid;  
      
    private String cname;  
      
    public ClassInfoBean() {  
          
    }  
  
    public Integer getCid() {  
        return cid;  
    }  
  
    public void setCid(Integer cid) {  
        this.cid = cid;  
    }  
  
    public String getCname() {  
        return cname;  
    }  
  
    public void setCname(String cname) {  
        this.cname = cname;  
    }  
}  

StudentInfoBean.java

package bean;  
  
import java.math.BigDecimal;  
  
public class StudentInfoBean {  
      
    private Integer sno;  
      
    private String sname;  
      
    private String ssex;  
      
    private Integer sage;  
       
    private Integer cid;  
      
    private BigDecimal sbalance;  
  
    public BigDecimal getSbalance() {  
        return sbalance;  
    }  
  
    public void setSbalance(BigDecimal sbalance) {  
        this.sbalance = sbalance;  
    }  
  
    public Integer getSno() {  
        return sno;  
    }  
  
    public void setSno(Integer sno) {  
        this.sno = sno;  
    }  
  
    public String getSname() {  
        return sname;  
    }  
  
    public void setSname(String sname) {  
        this.sname = sname;  
    }  
  
    public String getSsex() {  
        return ssex;  
    }  
  
    public void setSsex(String ssex) {  
        this.ssex = ssex;  
    }  
  
    public Integer getSage() {  
        return sage;  
    }  
  
    public void setSage(Integer sage) {  
        this.sage = sage;  
    }  
  
    public Integer getCid() {  
        return cid;  
    }  
  
    public void setCid(Integer cid) {  
        this.cid = cid;  
    }  
  
}  

ClassInfoDao.java

package dao;

import java.sql.Connection;  
import java.sql.DriverManager;  
import java.sql.ResultSet;  
import java.sql.SQLException;  
import java.sql.Statement;  
import java.util.ArrayList;  
import java.util.List;  


import bean.ClassInfoBean;  
  
public class ClassInfoDao {  
  
	String CLASSFORNAME="com.mysql.jdbc.Driver";
	String SERVANDDB="jdbc:mysql://localhost:3306/studentsystem?useSSL=false";
	String USER="root";
	String PWD="123456";
   
  
    public void  addClassInfo(ClassInfoBean bean) {  
        Connection conn = null;  
        Statement stmt = null; 
        String cid,cname;
        try {
			Class.forName(CLASSFORNAME);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}  
        try {  
            // 获取数据库连接  
            conn = DriverManager  
                    .getConnection(SERVANDDB,USER,PWD);  
            // 整理一条SQL语句 
           // System.out.println(bean.getCid());
            cid=bean.getCid().toString();
            cname=bean.getCname();
            String sql = "INSERT INTO class_info (cid,cname) VALUES ('"+cid+"','"  
                    + cname + "')";  
            // 创建SQL执行对象  
            stmt = conn.createStatement();  
            // 执行sql语句  
            int row = stmt.executeUpdate(sql);  
            if (row != 1) {  
                throw new RuntimeException("新增班级失败！");  
            }  
        } catch (SQLException e) {  
            e.printStackTrace();  
        } finally {  
            if (conn != null) {  
                try {  
                    conn.close();  
                } catch (SQLException e) {  
                    e.printStackTrace();  
                }  
            }  
            if (stmt != null) {  
                try {  
                    stmt.close();  
                } catch (SQLException e) {  
                    e.printStackTrace();  
                }  
            }  
        }  
    }  
  
    public List<ClassInfoBean> findAll() {  
  
        Connection conn = null;  
        Statement stmt = null;  
        List<ClassInfoBean> classList= new ArrayList<ClassInfoBean>();  
        try {
			Class.forName(CLASSFORNAME);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}  
        try {  
            // 获取连接  
            conn = DriverManager  
                    .getConnection(SERVANDDB,USER,PWD);  
            // 整理一条SQL语句  
            String sql = "select cid,cname from class_info";  
            // 创建执行sql的对象  
            stmt = conn.createStatemen