学生成绩管理系统内容.doc

装订线长 春 大 学 课程设计纸一、设计目的：2二、功能介绍：2三、程序流程：3四、设计步骤：44.1 数据结构44.2 用户登录模块设计与实现54.3核心代码64.3.1用户注册64.3.2注册用户登录74.3.3学生成绩录入84.3.4删除数据104.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.parseDouble(student.getEnglish()+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);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 Exceptionif(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.getEnglish()+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 useBean.User;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 useBean.User;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();out.println(alert(对不起，您删除学生成绩失败！););out.println(window.location=CheckStudent.jsp;);out.println();elseout.println();out.println(alert(删除成功！););out.println(window.location=right.jsp;);out.println();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();out.println(alert(学生成绩录入失败！););out.println(window.location=StudentLuRu.jsp;);out.println();elseout.println();out.println(alert(学生成绩录入成绩！););out.println(window.location=right.jsp;);out.println();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 useBean.User;import .javaBean.UserLoginJavaBean;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);elserequest.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 j