课程设计报告课程名称《JAVAWEB程序设计》课题名称学生信息管理系统专业计算机科学与技术班级学号学号指导教师李远辉陈多年月日湖南工程学院课程设计任务书课程名称《JAVAWEB程序设计》课题学生信息管理系统专业班级学生姓名学号指导老师李远辉陈多审批李远辉陈多任务书下达日期任务完成日期目录一．设计说明 (1)1.功能结构 (1)2. 数据库设计................. 错误！未定义书签。
二．功能实现 (2)1.系统主界面 (2)2. 添加学生信息 (2)3. 查看学生信息 (2)4. 修改学生信息 (2)三．心得体会 (3)四．附录 (4)1. 源代码 (4)1)Index.jsp (4)2)addStudent.jsp (7)3)updateStudent.jsp (8)4)viewStudent.jsp (10)5)Student.java (11)6)StudentManager.java (13)7)StudentServlet.java (16)8)Web.xml (18)五．评分表 (20)一．设计说明1.功能结构图1-1 2.数据库设计图1-2二．功能实现1.系统主界面图2-1 2.添加学生信息图2-2 3.查看学生信息图2-3 4.修改学生信息图2-4三．心得体会经过一个星期的课程设计，收获颇多。
也明白了自己在java语言上自己存在的一些问题，也解决了一些一直困恼我的问题。
以前自己觉得程序很简单，不放在心上。
经过课程设计才使我明白做程序需要的东西是很多的，你既要懂程序而且还要有耐心和恒心。
课程设计是对我的一次全面的测试，它既锻炼了我的动手的能力也磨练了我的心理素质。
设计这个系统，我们复习巩固java语言的基础知识，进一步加深对java 语言编程的理解和掌握。
了解深入java语言编程的方法和环境。
利用所学知识，把理论和实际结合，利用资源，采用模块化的结构，学会使用模仿、修改、自主设计相结合的方法。
通过设计学生成绩管理系统，掌握结构化的程序设计思想，实现系统的正常运行，并且提高学生综合分析问题的素质和解决实际问题的编程能力。
培养学生在项目开发中的求知精神、团队合作精神、创新意识以及实战能力。
作为java语言课程结课设计，验证自身的学习效果，同时希望利用所学的基本知识和技能，进行简单数据库应用程序设计。
在这一个星期的课程设计中，也让我看到了一些java方面薄弱的地方，在接下来的时间里我要好好的巩固这些方面的知识，争取学好这一门课程，熟练掌握java。
四．附录1.源代码1)Index.jsp<%@page contentType="text/html" pageEncoding="UTF-8" language="java"%><%@page import="db.StudentManager"%><%@page import="db.Student"%><%@page import="java.util.ArrayList"%><html><head><link rel="stylesheet" href="https:///bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTs z/K68vbdEjh4u" crossorigin="anonymous"><link href="style.css" rel="stylesheet" type="text/css"> <title>学生信息管理</title></head><body style="background: url(11.jpg)" ><div class="box col-md-12" ><div class="box-inner"><div class="box-header well" data-original-title=""style="background: url(11.jpg)"><h2><i class="glyphicon glyphicon-leaf"></i> 学生管理系统</h2><div class="box-icon" align="right"><a href="addStudent.jsp" class="btn btn-minimize btn-round btn-default"><iclass="glyphiconglyphicon-chevron-up"></i>添加学生</a></div></div><div class="box-content"><table class="table table-striped table-bordered responsive" width="80%" table class="table table-hover"><table class="table table-hover"><thead><tr><thclass="center"> 学号</th><thclass="center"> 姓名</th><th> 年龄</th><th> 性别</th><th> 专业</th><th> 学院</th><th> 简介</th><th> 操作</th> </tr></thead><tbody><tr><% ArrayList students=StudentManager.getAllStudents();for(int i=0;i<students.size();i++){Studentstudent=(Student)students.get(i);%><tdclass="center"> <%=student.getId() %></td> <tdclass="center"> <%=student.getName() %></td> <tdclass="center"> <%=student.getAge()%></td> <% if(student.getSex()==1){%><tdclass="center"> 男</td><%}else{ %> <tdclass="center"> 女</td><%} %><tdclass="center"> <%=student.getMajor()%></td><tdclass="center"> <%=student.getCollege()%></td> <tdclass="center"> <%=student.getIntroduction()%> ...</td><td ><a class="btn btn-success"href="viewStudent.jsp?id=<%=student.getId()%>"><i class="glyphicon glyphicon-zoom-in icon-white"></i><button type="button" class="btn btn-primary">查看</button></a><a class="btn btn-info" href="updateStudent.jsp?id=<%=student.getId()%>"><i class="glyphicon glyphicon-edit icon-white"></i><button type="button" class="btn btn-primary">修改</button></a><a class="btn btn-danger" href="deleteStudent?id=<%=student.getId()%>"><i class="glyphicon glyphicon-trash icon-white"></i><button type="button" class="btn btn-primary">删除</button></a></td></tr></tbody><% } %></table></div></div></div></body></html>2)addStudent.jsp<%@page contentType="text/html" pageEncoding="UTF-8"%><%@page import="db.StudentManager"%><%@page import="db.Student"%><%@page import="java.util.ArrayList" %><!DOCTYPE html><html><head><link rel="stylesheet" href="https:///bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous"><link href="style.css" rel="stylesheet" type="text/css"><title>添加学生信息</title> <a href="index.jsp" ><h4 align="right"class="btn btn-danger ">返回</h4></a></head><body align="center"style="background: url(11.jpg)"><div class="box col-md-4"></div><div class="box col-md-4"><div class="box-inner"><div class="box-header well" data-original-title=""><h2><i class="glyphicon glyphicon-star"></i>学生信息</h2></div><div class="box-content"><form action="addStudent" method="post" role="form" > <div class="form-group"><div class="form-group has-error"><input type="text" class="form-control primary" name="id" placeholder="学号"><p class="help-block">必填</p><input type="text" class="form-control" name="name" placeholder="姓名"><p class="help-block">必填</p><input type="text" class="form-control" name="age" placeholder="年龄"><p class="help-block">必填</p><select class="form-control" name="sex"><option value="1" >性别</option><option value="1">男</option><option value="0">女</option></select><p class="help-block">必填</p><input type="text" class="form-control" name="major" placeholder="专业"><p class="help-block">必填</p><input type="text" class="form-control" name="college" placeholder="学院"><p class="help-block">必填</p><label for="exampleInputEmail1">简介</label><textarea type="text" class="form-control" rows="5" name="introduction" style="resize: none;" ></textarea><p class="help-block">选填</p></div><button type="submit" class="btn btn-danger">提交</button></form></div></div></div></body></html>3)updateStudent.jsp<%@page contentType="text/html" pageEncoding="UTF-8"%><%@page import="db.StudentManager"%><%@page import="db.Student"%><%@page import="java.util.ArrayList" %><!DOCTYPE html><html><head><link rel="stylesheet" href="https:///bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous"><link href="style.css" rel="stylesheet" type="text/css"><title>修改学生信息</title> <a href="index.jsp" ><h4 align="right"class="btn btn-danger ">返回</h4></a></head><body style="background: url(12.jpg)"><%String id=request.getParameter("id");Student student=StudentManager.getStudent(id);%><div class="box col-md-4"></div><div class="box col-md-4"><div class="box-inner" style="background: url(12.jpg)"><div class="box-header well" data-original-title="学生信息"><h2><i class="glyphicon glyphicon-edit"></i>修改学生信息</h2></div><div class="box-content"><form action="updateStudent" method="post" role="form"><div class="form-group"><div class="form-group has-error"><label>学号</label><input type="text" class="form-control" name="id" placeholder="<%=student.getId() %>"><label>姓名</label><input type="text" class="form-control" name="name" value="<%=student.getName() %>"><label>年龄</label> <input type="text" class="form-control" name="age" value="<%=student.getAge() %>"><label>性别</label><% if(student.getSex()==1){%>男<%}else{ %>女<%} %><select class="form-control" name="sex"><option value="1">性别</option><option value="1">男</option><option value="0">女</option></select><label>专业</label> <input type="text" class="form-control" name="major" value="<%=student.getMajor()%>"><label>学院</label> <input type="text" class="form-control" name="college" value="<%=student.getCollege()%>"><label for="exampleInputEmail1">简介</label> <textarea class="form-control" rows="5" name="introduction" placeholder=" <%=student.getIntroduction()%>" style="resize: none;" ><%=student.getIntroduction()%></textarea></div><button type="submit" class="btn btn-success"><i class="glyphicon glyphicon-bell"></i>更新信息</button></form></div></div></div></div></body></html>4)viewStudent.jsp<%@page contentType="text/html" pageEncoding="UTF-8"%><%@page import="db.StudentManager"%><%@page import="db.Student"%><%@page import="java.util.ArrayList" %><!DOCTYPE html><html><head><link rel="stylesheet" href="https:///bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTs z/K68vbdEjh4u" crossorigin="anonymous"><link href="style.css" rel="stylesheet" type="text/css"><title>查看学生信息</title></head><body><%String id=request.getParameter("id");Student student=StudentManager.getStudent(id);%>4<div class="box col-md-4"></div><div class="box col-md-4"><div class="box-inner"><div class="box-header well" data-original-title="学生信息"><h2><i class="glyphicon glyphicon-edit"></i>学生信息</h2> <a href="index.jsp" ><h4 align="right">返回</h4></a></div><div class="box-content"><form action="#" method="post" role="form"><div class="form-group"><label>学号</label><input type="text" class="form-control"name="id" placeholder="<%=student.getId() %>" readonly="readonly"><label>姓名</label><input type="text" class="form-control" name="name" placeholder="<%=student.getName() %>" readonly="readonly"> <label>年龄</label> <input type="text" class="form-control" name="age" placeholder="<%=student.getAge() %>" readonly="readonly"><label>性别</label><% if(student.getSex()==1){%><input type="text" class="form-control" placeholder="男" readonly="readonly"><%}else{ %><input type="text" class="form-control" placeholder="女" readonly="readonly"></td><%} %><label>专业</label> <input type="text" class="form-control" name="major" placeholder="<%=student.getMajor()%>" readonly="readonly"><label>学院</label> <input type="text" class="form-control" name="college" placeholder="<%=student.getCollege()%>" readonly="readonly"><label for="exampleInputEmail1">简介</label> <textarea type="text" class="form-control" rows="5" name="introduction" placeholder=" <%=student.getIntroduction()%>" style="resize: none;" readonly="readonly"></textarea></div></form></div></div></div></body></html>5)Student.javapublic class Student {private String id;//学号private String name;//姓名private int age;//年龄private int sex;//性别private String major;//专业private String college;//学院private String introduction;//简介public String getId() {return id;}public String getName() {return name;}public int getAge() {return age;}public int getSex() {return sex;}public String getMajor() {return major;}public String getCollege() {return college;}public String getIntroduction() { return introduction;}public void setId(String id) {this.id = id;}public void setName(String name) { = name;}public void setAge(int age) {this.age = age;}public void setSex(int sex) {this.sex = sex;}public void setMajor(String major) {this.major = major;}public void setCollege(String college) {this.college = college;}public void setIntroduction(String introduction) {this.introduction = introduction;}}6)StudentManager.javaimport java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.ArrayList;public class StudentManager {private static Connection getConnection() throws Exception{String url="jdbc:derby://localhost:1527/test";String user="root";String pwd="root";Connection conn=DriverManager.getConnection(url,user,pwd);return conn;}/**添加学生信息*/public static boolean addStudent(String id,String name,int age,int sex,String major,String college,String introduction){try{Connection conn=getConnection();PreparedStatement st=conn.prepareStatement("insert into student values(?,?,?,?,?,?,?)");st.setString(1, id);st.setString(2, name);st.setInt(3, age);st.setInt(4, sex);st.setString(5, major);st.setString(6, college);st.setString(7, introduction);st.execute();conn.close();return true;}catch(Exception e){return false;}}/**修改学生信息*/public static boolean updateStudent(String id,String name,int age,int sex,String major,String college,String introduction){try{Connection conn=getConnection();PreparedStatement st=conn.prepareStatement("update student set name=?,age=?,sex=?,major=?,college=?,introduction=? where id=?"); st.setString(1, name);st.setInt(2, age);st.setInt(3, sex);st.setString(4, major);st.setString(5, college);st.setString(6, introduction);st.setString(7, id);st.execute();conn.close();return true;}catch(Exception e){return false;}}public static boolean deleteStudent(String id){try{Connection conn=getConnection();PreparedStatement st=conn.prepareStatement("delete from student where id=?");st.setString(1, id);st.execute();conn.close();return true;}catch(Exception e){return false;}}public static Student getStudent(String id){Student student=null;try{Connection conn=getConnection();PreparedStatement st=conn.prepareStatement("select * from student where id=?");st.setString(1, id);st.execute();ResultSet rs=st.getResultSet();if(rs.next()){student=new Student();student.setId(rs.getString("id"));student.setName(rs.getString("name"));student.setAge(rs.getInt("age"));student.setSex(rs.getInt("sex"));student.setMajor(rs.getString("major"));student.setCollege(rs.getString("college"));student.setIntroduction(rs.getString("introduction"));}conn.close();}catch(Exception e){}return student;}public static ArrayList<Student> getAllStudents(){ArrayList<Student> students=new ArrayList<Student>();try{Connection conn=getConnection();PreparedStatement st=conn.prepareStatement("select * from student");st.execute();ResultSet rs=st.getResultSet();while(rs.next()){Student student=new Student();student.setId(rs.getString("id"));student.setName(rs.getString("name"));student.setAge(rs.getInt("age"));student.setSex(rs.getInt("sex"));student.setMajor(rs.getString("major"));student.setCollege(rs.getString("college"));student.setIntroduction(rs.getString("introduction"));students.add(student);}conn.close();}catch(Exception e){}return students;}}7)StudentServlet.javaimport java.io.IOException;import javax.servlet.RequestDispatcher;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class StudentServlet extends HttpServlet {@Overridepublic void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {doPost(request, response);}@Overridepublic void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {request.setCharacterEncoding("utf-8");if(request.getRequestURI().endsWith("/viewStudent")){RequestDispatcher dispatcher = request.getRequestDispatcher("viewstudent.jsp");dispatcher .forward(request, response);}else if(request.getRequestURI().endsWith("/addStudent")){doAddStudent(request,response);}else if (request.getRequestURI().endsWith("/updateStudent")) {doUpdateStudent(request,response);}else if (request.getRequestURI().endsWith("/deleteStudent")) {doDeleteStudent(request,response);}}private void doAddStudent(HttpServletRequest request, HttpServletResponse response) throws IOException{String id=request.getParameter("id");String name=request.getParameter("name");String age=request.getParameter("age");String sex=request.getParameter("sex");String major=request.getParameter("major");String college=request.getParameter("college");String introduction=request.getParameter("introduction");StudentManager.addStudent(id, name,new Integer(age), new Integer(sex), major, college, introduction);response.sendRedirect("index.jsp");}private void doUpdateStudent(HttpServletRequest request, HttpServletResponse response) throws IOException {String id=request.getParameter("id");String name=request.getParameter("name");String age=request.getParameter("age");String sex=request.getParameter("sex");String major=request.getParameter("major");String college=request.getParameter("college");String introduction=request.getParameter("introduction");StudentManager.updateStudent(id, name, new Integer(age), new Integer(sex), major, college, introduction);response.sendRedirect("index.jsp");}private void doDeleteStudent(HttpServletRequest request, HttpServletResponse response) throws IOException {String id=request.getParameter("id");StudentManager.deleteStudent(id);response.sendRedirect("index.jsp");}}8)Web.xml<web-app version="3.1" xmlns="/xml/ns/javaee" xmlns:xsi="/2001/XMLSchema-instance"xsi:schemaLocation="/xml/ns/javaee/xml/ns/javaee/web-app_3_1.xsd"><servlet><servlet-name>StudentServlet</servlet-name><servlet-class>db.StudentServlet</servlet-class></servlet><servlet><servlet-name>addStudent</servlet-name><servlet-class>db.StudentServlet</servlet-class> </servlet><servlet><servlet-name>viewStudent</servlet-name><servlet-class>db.StudentServlet</servlet-class> </servlet><servlet><servlet-name>deleteStudent</servlet-name><servlet-class>db.StudentServlet</servlet-class> </servlet><servlet><servlet-name>updateStudent</servlet-name><servlet-class>db.StudentServlet</servlet-class> </servlet><servlet-mapping><servlet-name>StudentServlet</servlet-name><url-pattern>/StudentServlet</url-pattern></servlet-mapping><servlet-mapping><servlet-name>addStudent</servlet-name><url-pattern>/addStudent</url-pattern></servlet-mapping><servlet-mapping><servlet-name>viewStudent</servlet-name><url-pattern>/viewStudent</url-pattern></servlet-mapping><servlet-mapping><servlet-name>deleteStudent</servlet-name><url-pattern>/deleteStudent</url-pattern></servlet-mapping><servlet-mapping><servlet-name>updateStudent</servlet-name><url-pattern>/updateStudent</url-pattern></servlet-mapping></web-app>五．评分表计算机与通信学院课程设计评分表教师签名：日期：。