目 录 第一章 项目需求分析 1 1.1业务流程图 1.2功能性需求 1.1系统功能模块图 第二章 技术说明 第三章 项目数据库设计 3.1 E-R图 3.2数据库表 第四章 项目实现情况 4.1核心代码 4.2系统运行

第一章 项目需求分析 1.1业务流程图 一、注册流程 二、登录流程

三、学生信息管理流程

1.2功能性需求 学生信息管理系统具有注册登录功能 对学生信息进行增删改查操作。

1.3系统功能模块图 第二章 技术说明 注册界面，登录界面，信息管理界面， 使用html引用css样式。 使用html以及其他元素嵌入jsp操作。 使用MVC模型框架 通过jsp，servlet,javabean在前端界面对后台数据库进行操作。

第三章 项目数据库设计 3.1 E-R图

3.2数据库表

第四章 项目实现情况 4.1核心代码 一、M层设计 entity包下 Student.java 代码： package entity;

public class Student { private String studentNumber; private String studentName; private String studentClass; private String studentMajor; private String studentAge; public String getStudentNumber() { return studentNumber; } public void setStudentNumber(String studentNumber) { this.studentNumber = studentNumber; } public String getStudentName() { return studentName; } public void setStudentName(String studentName) { this.studentName = studentName; } public String getStudentClass() { return studentClass; } public void setStudentClass(String studentClass) { this.studentClass = studentClass; } public String getStudentMajor() { return studentMajor; } public void setStudentMajor(String studentMajor) { this.studentMajor = studentMajor; } public String getStudentAge() { return studentAge; } public void setStudentAge(String studentAge) { this.studentAge = studentAge; } }

User.java 代码： package entity;

public class User { private String name; private String password; private String iphone; 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 String getIphone() { return iphone; } public void setIphone(String iphone) { this.iphone = iphone; } }

dao 包下 StudentDao.java 代码： package dao;

import java.sql.*; import java.util.ArrayList; import java.util.List; import entity.Student; import tool.DBCon;

public class StudentDao { // 查询所有的学生信息 public List getAllStudent() { List List = new ArrayList(); Connection conn = DBCon.getConnection(); String sql = “select * from sinfo”; try { PreparedStatement pstmt = conn.prepareStatement(sql); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { Student s = new Student(); s.setStudentNumber(rs.getString(“studentNumber”)); s.setStudentName(rs.getString(“studentName”)); s.setStudentClass(rs.getString(“studentClass”)); s.setStudentMajor(rs.getString(“studentMajor”)); s.setStudentAge(rs.getString(“studentAge”)); List.add(s); } rs.close(); pstmt.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return List; } // 增添学生信息 public boolean addStudent(Student s) { String sql = “insert into sinfo(studentNumber,studentName,studentClass,studentMajor,studentAge) values(?,?,?,?,?)”; Connection conn = DBCon.getConnection(); try { PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, s.getStudentNumber()); pstmt.setString(2, s.getStudentName()); pstmt.setString(3, s.getStudentClass()); pstmt.setString(4, s.getStudentMajor()); pstmt.setString(5, s.getStudentAge()); int count = pstmt.executeUpdate(); pstmt.close(); return count > 0 ? true : false; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return false; }

//修改学生信息 public boolean updateStudent(Student s) { String sql = “update sinfo set studentName=?,studentClass=?,studentMajor=?,studentAge=? where studentNumber=?”; Connection conn = DBCon.getConnection(); try { PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, s.getStudentName()); pstmt.setString(2, s.getStudentClass()); pstmt.setString(3, s.getStudentMajor()); pstmt.setString(4, s.getStudentAge()); pstmt.setString(5, s.getStudentNumber()); int count = pstmt.executeUpdate(); pstmt.close(); return count > 0 ? true : false; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return false; }

// 删除学生信息 public boolean deleteStudent(String studentNumber) { String sql = “delete from sinfo where studentNumber=?”; Connection conn = DBCon.getConnection(); try { PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, studentNumber); int count = pstmt.executeUpdate(); pstmt.close(); return count > 0 ? true : false; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return false; } public Student selectStudentByNumber(String number) { Connection conn = DBCon.getConnection(); String sql = “select * from sinfo where studentNumber=”+number; Student s = null; try { PreparedStatement pstmt = conn.prepareStatement(sql); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { s = new Student(); s.setStudentName(rs.getString(“studentName”)); s.setStudentNumber(rs.getString(“studentNumber”)); s.setStudentClass(rs.getString(“studentClass”)); s.setStudentMajor(rs.getString(“studentMajor”)); s.setStudentAge(rs.getString(“studentAge”)); } rs.close(); pstmt.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return s; } // 查询基于某个条件的学生信息 public List selectStudentByName(String studentName) { List List = new ArrayList(); Connection conn = DBCon.getConnection(); String sql = “select * from sinfo where studentName=?”; Student s = null; try { PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, studentName); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { s = new Student(); s.setStudentNumber(rs.getString(“studentNumber”)); s.setStudentName(rs.getString(“studentName”)); s.setStudentClass(rs.getString(“studentClass”)); s.setStudentMajor(rs.getString(“studentMajor”)); s.setStudentAge(rs.getString(“studentAge”)); List.add(s); } rs.close(); pstmt.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return List; }

UserDao.java 代码： package dao;

import java.sql.*;

import com.mysql.jdbc.Connection;

import entity.User; import tool.DBCon;

public class UserDao {

public boolean addUser(User s) { String sql = “insert into tb_user(name, password, iphone) values(?,?,?)”; Connection conn = (Connection) DBCon.getConnection(); try { PreparedStatement pstmt = conn.prepareStatement(sql);

//byte b[] = s.getName().getBytes(“ISO-8859-1”); // s.setName(new String(b, “UTF-8”)); pstmt.setString(1, s.getName()); pstmt.setString(2, s.getPassword()); pstmt.setString(3, s.getIphone()); int count = pstmt.executeUpdate(); pstmt.close(); return count > 0 ? true : false; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } /catch (UnsupportedEncodingException e) { // TODO Auto-generated catch block e.printStackTrace(); }/ return false; } public int selectUserByName(String name) { Connection conn = (Connection) DBCon.getConnection(); String sql = “select * from tb_user where name = ?”; int resultout=0; try { PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, name); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { resultout=1; } rs.close(); pstmt.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return resultout; }

tool包下 DBCon.java 代码： package tool;

import java.sql.*; public class DBCon { private static String url=“jdbc:mysql://localhost:3306/jdbc3”; private static String username=“root”; private static String password=“123456”; private static Connection conn=null; public static Connection getConnection() { if(null==conn) { try { Class.forName(“com.mysql.jdbc.Driver”); conn = DriverManager.getConnection(url, username, password); }catch(ClassNotFoundException e) { e.printStackTrace(); }catch(SQLException e) { e.printStackTrace(); } } return conn; } public static void main(String[] args) { System.out.println(getConnection()); } public ResultSet query(String sql, Object[] objs) { // TODO Auto-generated method stub return null; }

}

二、V层设计 1.regist.html 代码:

2.login.html 代码：

3.first.css 代码： @charset “UTF-8”;

input { width:100px; height:50px; border: 0; outline: none; background-color:rgba(0,0,0,0)

}

4.list.jsp

代码：

主界面

7.add.jsp 代码：

Delete.java

StudentList.java StudentListByName.java

系统运行截图