宿舍信息管理.docxVIP

计算机网络课设实验报告题目：宿舍管理系统同组成员：陈世博、陈旭洲刘锴、路通班 级：软件工程13级01班 姓名:雷鹏(41309050105)实验题目熟悉和掌握网络编程的基本方法和步骤； 基于B/S结构的宿舍管理系统编程语言：java、oracle设计完成与网络编程相关题目的基本功能要求；按一定的规范要求，撰写课程设计报告二、参考资料网络编程视频（java）计算机网络教程《java核心技术》三、开发环境操作系统为 WINDOWS 10开发语言为 JAVA开发环境MyEclipse，jdk1.7数据库环境 oracle数据库项目需求分析 要实现的功能，有以下几点管理宿舍房间包括宿舍房间的添加、查询、修改管理住宿信息包括住宿信息的添加、查询、修改管理学生信息包括学生添加、查询、修改系统设置密码修改 项目结构图：程序的运行和测试结果1、登陆界面2、登陆成功界面3、管理宿舍房间代码源码：Java代码主要分为dao、entity、util、web包部分源码如下：package dao;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.ArrayList;import java.util.List;import entity.accommodation;import util.DBUtil;public class accommodationDAO { public void delete (String studentNumber) throws Exception{ Connection conn = null; PreparedStatement prep = null; try { conn = DBUtil.getConnection(); prep = conn.prepareStatement( DELETE FROM accommodation WHERE studentNumber=? ); prep.setString(1,studentNumber ); prep.executeUpdate();} catch (Exception e) {e.printStackTrace();throw e;}finally{DBUtil.close(conn);} } //查找方法 public accommodation findById(String studentNumber) throws Exception{ accommodation acc = null; Connection conn = null; PreparedStatement prep = null; ResultSet rst = null; try {conn = DBUtil.getConnection();prep = conn.prepareCall( SELECT * FROM accommodation WHERE STUDENTNUMBER=? ); prep.setString(1,studentNumber); rst = prep.executeQuery(); if(rst.next()){String buildingname = rst.getString(BUILDINGNAME);String roomno = rst.getString(ROOMNO);String accommodationdate = rst.getString(ACCOMMODATIONDATE);String accommodationnotes = rst.getString(ACCOMMODATIONNOTES);String paymenoy = rst.getString(PAYMENOY);acc = new accommodation();acc.setAccommodationindate(accommodationdate);acc.setAccommodationNotes(accommodationnotes);acc.setBuildingName(buildingname);acc.setRoomNo(roomno);acc.setPaymenoy(paymenoy); }} catch (Exception e) {e.printStackTrace();throw e;}finally{DBUtil.close(conn);} return acc; }//更改 public void modify(accommodati