学生成绩管理系统内容

┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊一、设计目的： (2)二、功能介绍： (2)三、程序流程： (3)四、设计步骤： (4)4.1 数据结构 (4)4.2 用户登录模块设计与实现 (5)4.3核心代码 (6)4.3.1用户注册 (6)4.3.2注册用户登录 (7)4.3.3学生成绩录入 (8)4.3.4删除数据 (10)4.3.5数据查询 (12)五、设计总结： (13)六、程序清单： (14)┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊一、设计目的：在这个现代化的社会里，一款功能强大，使用方便的管理软件必不可少，于是我们设计开发了这款集学生成绩录入，查询，删除等诸多功能于一身的学生成绩管理系统。

二、功能介绍：1、用户注册功能。

2、有注册用户登录功能。

3、有学生成绩的录入功能，要求只录入各科成绩，自动计算每个学生的总成绩。

4、有数据查询功能，可以实现查询全部信息和按条件执行查询。

5、有按条件删除数据功能。

┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊三、程序流程：┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊四、设计步骤：4.1 数据结构学生信息={组成：{编号(id)、姓名(sname)、学号(sno)}}成绩表{组成：{编号(id)、姓名(sname)、学号(sno) 、数学(math)、英语(english)、java(javamark)、java课程设计(javadesign)、算法分析(suanfa)、据库原理(databasemark)、总成绩(allmark)}}登陆表={组成：用户编号(id)、密码(password)、用户名(username)}┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊4.2 用户登录模块设计与实现设计思路：为了检验登录用户是否是一个合法用户，当用户输入用户名和密码后，需要查询数据库以便验证该用户是否为非法用户。

实现功能：用户可以从登陆界面进入到学生成绩管理系统界面，然后进行一些操作。

┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊4.3核心代码4.3.1用户注册public class UserRegistJavaBean {public int regist(User user){String sql = "insert into userinfo(username,password) values ('"+user.getUsername()+"','"+user.getPassword()+"')";Conn conn = new Conn();return conn.update(sql);}}┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊4.3.2注册用户登录public class UserLoginJavaBean {public ResultSet getUser(User user) {String sql = "select username,password from userinfo where username='" + user.getUsername()+ "'";Conn conn = new Conn();ResultSet rs = conn.query(sql);return rs;}}┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊4.3.3学生成绩录入public class StudentLuRuJavaBean {public int luRu(StudentMark student) {Double allmark = new Double(0);┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊allmark=allmark+Double.parseDouble(student.getMath())+Double.pars eDouble(student.getEnglish())+Double.parseDouble(student.getJavamark())+Double.parseDouble(stud ent.getJavadesign())+Double.parseDouble(student.getSuanfa())+Double.parseDouble(studen t.getDatabasemark());String sql = "insert into studentmark(sname,sno,math,english,javamark,javadesign,suanfa,databas emark,allmark) values ('"+ student.getSname()+ "','"+ student.getSno()+ "','"+ student.getMath()+ "','"+ student.getEnglish()+ "','"+ student.getJavamark()+ "','"+ student.getJavadesign()+ "','"+student.getSuanfa()+ "','" + student.getDatabasemark()+ "','"+allmark+"')";Conn conn = new Conn();return conn.update(sql);}}┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊4.3.4删除数据public class DeleteStudentJavaBean {public int delete(String id){String sql="delete from studentmark where id='"+id+"'";┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊Conn cn = new Conn();return cn.update(sql);}}┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊4.3.5数据查询public ResultSet query(String sql) {try {stmt = conn.createStatement();rs = stmt.executeQuery(sql);System.out.println("数据库查询成功!");return rs;}catch (Exception e) {System.out.println(e.getMessage());}return rs;}┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊五、设计总结：通过这次的程序设计，我认识到自己对知识的掌握还不完善，在小组同学的共同努力下，基本实现了预期的功能。

这个系统还有许多需要完善的地方，我们都相信没有最好，只有更好，我们以后会根据不同的需要，努力的去学习，探索，把这个软件完善好，让它能更好的为我们服务，让它变得更为完善。

┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊六、程序清单：package .javaBean;import javax.naming.Context;import javax.naming.InitialContext;import javax.sql.DataSource;import java.sql.Connection;import java.sql.ResultSet;import java.sql.Statement;import java.sql.SQLException;public class Conn {private Context ctx = null; //上下文对象private DataSource ds = null; //数据源对象private Connection conn = null;private Statement stmt = null;private ResultSet rs = null;// ****************建立连接**********************public Conn() {try {ctx = new InitialContext(); //实例化上下文对象ds = (DataSource) ctx.lookup("java:/comp/env/JavaCourse"); //通过JNDI找到数据源，并返回数据源对象conn = ds.getConnection(); //从数据源中取出一个空闲连接} catch (SQLException e) {System.out.println(e.getMessage());} catch (Exception e) {System.out.println(e.getMessage());}}// ********************查询*********************public ResultSet query(String sql) {try {stmt = conn.createStatement();rs = stmt.executeQuery(sql);System.out.println("数据库查询成功!");return rs;}catch (Exception e) {System.out.println(e.getMessage());}return rs;}// ******************添加/修改/删除*************************public int update(String sql) {try {stmt = conn.createStatement();System.out.println("更新成功");int i= stmt.executeUpdate(sql);return i;} catch (Exception e) {System.out.println(e.getMessage());}return 0;┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊}public void close() throws Exception{if(rs != null) rs.close();if(stmt != null) stmt.close();if(conn != null) conn.close();}}package .javaBean;public class DeleteStudentJavaBean {public int delete(String id){String sql="delete from studentmark where id='"+id+"'";Conn cn = new Conn();return cn.update(sql);}}package .javaBean;import useBean.StudentMark;public class StudentLuRuJavaBean {public int luRu(StudentMark student) {Double allmark = new Double(0);allmark=allmark+Double.parseDouble(student.getMath())+Double.parseDouble(student.get English())+Double.parseDouble(student.getJavamark())+Double.parseDouble(student.getJavadesign()) +Double.parseDouble(student.getSuanfa())+Double.parseDouble(student.getDatabasemark()) ;String sql = "insert into studentmark(sname,sno,math,english,javamark,javadesign,suanfa,databasemark,allmark) values ('"+ student.getSname()+ "','"+ student.getSno()+ "','"+ student.getMath()+ "','"+ student.getEnglish()+ "','"+ student.getJavamark()+ "','"+ student.getJavadesign()+ "','"+student.getSuanfa()+ "','" + student.getDatabasemark()+ "','"+allmark+"')";Conn conn = new Conn();return conn.update(sql);}}┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊package .javaBean;import java.sql.ResultSet;import er;public class UserLoginJavaBean {public ResultSet getUser(User user) {String sql = "select username,password from userinfo where username='" + user.getUsername()+ "'";Conn conn = new Conn();ResultSet rs = conn.query(sql);return rs;}}package .javaBean;import er;public class UserRegistJavaBean {public int regist(User user){String sql = "insert into userinfo(username,password) values ('"+user.getUsername()+"','"+user.getPassword()+"')";Conn conn = new Conn();return conn.update(sql);}}package .servlet;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import .javaBean.DeleteStudentJavaBean;public class DeleteStudent extends HttpServlet {┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊private static final long serialVersionUID = -444090141021172392L;protected void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException {request.setCharacterEncoding("UTF-8");response.setContentType("text/html; charset=UTF-8");PrintWriter out = response.getWriter();String bid = request.getParameter("id");DeleteStudentJavaBean db = new DeleteStudentJavaBean();int k = db.delete(bid);if(k==0){out.println("<script>");out.println("alert('对不起，您删除学生成绩失败！');");out.println("window.location='CheckStudent.jsp';");out.println("</script>");}else{out.println("<script>");out.println("alert('删除成功！');");out.println("window.location='right.jsp';");out.println("</script>");}out.close();}protected void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException {doGet(request, response);}}package .servlet;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import useBean.StudentMark;import .javaBean.StudentLuRuJavaBean;public class StudentLuRu extends HttpServlet {private static final long serialVersionUID = -2706619885549549482L;protected void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException {┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊request.setCharacterEncoding("UTF-8");response.setContentType("text/html; charset=UTF-8");PrintWriter out = response.getWriter();String sname = request.getParameter("sname");String sno = request.getParameter("sno");String math = request.getParameter("math");String english = request.getParameter("english");String javamark = request.getParameter("javamark");String javadesign = request.getParameter("javadesign");String suanfa = request.getParameter("suanfa");String databasemark = request.getParameter("databasemark");StudentMark student = new StudentMark();student.setSname(sname);student.setSno(sno);student.setMath(math);student.setEnglish(english);student.setJavamark(javamark);student.setJavadesign(javadesign);student.setSuanfa(suanfa);student.setDatabasemark(databasemark);StudentLuRuJavaBean blr = new StudentLuRuJavaBean();int k = blr.luRu(student);if(k==0){out.println("<script>");out.println("alert('学生成绩录入失败！');");out.println("window.location='StudentLuRu.jsp';");out.println("</script>");}else{out.println("<script>");out.println("alert('学生成绩录入成绩！');");out.println("window.location='right.jsp';");out.println("</script>");}out.close();}protected void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException {doGet(request, response);}}package .servlet;import java.io.IOException;import java.io.PrintWriter;import java.sql.ResultSet;import java.sql.SQLException;┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import er;import erLoginJavaBean;public class userlogin extends HttpServlet {private static final long serialVersionUID = -1261688621531440503L;protected void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException {request.setCharacterEncoding("UTF-8");String uname = request.getParameter("username");String pword = request.getParameter("pword");response.setContentType("text/xml; charset=UTF-8");User user = new User();user.setUsername(uname);PrintWriter out = response.getWriter();UserLoginJavaBean login = new UserLoginJavaBean();ResultSet rs = login.getUser(user);try {if (rs.next()) {if(rs.getString("username").equals(uname)){if(rs.getString("password").equals(pword)){request.getRequestDispatcher("/main.jsp").forward(request, response);}else{request.getRequestDispatcher("/index.jsp").forward(request, response);}}} else {request.getRequestDispatcher("/index.jsp").forward(request, response);}} catch (SQLException e) {e.printStackTrace();}out.close();}protected void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException { doGet(request, response);}}package .servlet;┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import er;import erRegistJavaBean;public class userregist extends HttpServlet {private static final long serialVersionUID = 1419221483022490930L;protected void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException {request.setCharacterEncoding("UTF-8");response.setContentType("text/html; charset=UTF-8");PrintWriter out = response.getWriter();String uname = request.getParameter("uname");String password = request.getParameter("pword");User user = new User();user.setUsername(uname);user.setPassword(password);UserRegistJavaBean regist = new UserRegistJavaBean();int k = regist.regist(user);if(k==0){request.getRequestDispatcher("/regist.jsp").forward(request, response);}else{out.println("<script>");out.println("alert('恭喜您，注册成功！');");out.println("window.location='index.jsp';");out.println("</script>");}}protected void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException {doGet(request, response);}}。