《J2EE架构与网络编程课程设计》由会员分享，可在线阅读，更多相关《J2EE架构与网络编程课程设计（14页珍藏版）》请在金锄头文库上搜索。
1、J2EE架构与网络编程课程设计项目名称：教研室信息管理系统班 级：软件工程2班学 号：姓 名：项目技术应用30分功能齐全40分技术创新10分界面设计10分文档规范10分总分得分目录一、引言二、数据库设计三、功能框图四、核心代码及界面截图一 引言随着信息技术的高速发展，使得信息资源实现了高度共享，并且从根本上改变了人们进行信息交流的方式。对于软件学院的学生更是如此。通过调研了解到，信息技术学院老师每学期都会有多门课程开设，学期末有许多资料需要整理，教学上不方便，效率也较低。因此教研室管理系统应运而生。 二 数据设计规章制度表：字段描述类型长度Rules_ID规章编号IntRules_Name规章
2、名Varchar50Rules_Summary规章概要Varchar200Rules_Text规章内容（路径）Varchar100Rules_Type规章类型SmallintRules_Time发布时间Date表1-1学生信息表字段描述类型长度Stu_Name学生姓名String30Stu_ID学号String12Sex性别BooleanStu_Class班级String20Stu_Professional专业String20Stu_where就业单位或考研学校String30Phone电话String15Email邮箱String20Teacher教师String20表1-2三 功能框图1规
3、章制度管理功能图2学生精英功能图四 核心代码及界面截图1.GzzdDao.java文件 package com.jys.dao;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.ArrayList;import com.jys.bean.GZZDBean;import com.jys.bean.XSJYBean;import com.jys.util.DBUtil;public class GzzdDao public ArrayList
4、 getAllMsg() throws ExceptionArrayList gzzd = new ArrayList();String sql = select GZZD_name,GZZD_time,GZZD_path from tb_gzzd;Connection conn;PreparedStatement pstmt;conn = DBUtil.getConnect();pstmt = conn.prepareStatement(sql);ResultSet rs = pstmt.executeQuery();while(rs.next()GZZDBean g = new GZZDB
5、ean();g.setGzzd_name(rs.getString(GZZD_name);g.setGzzd_path(rs.getString(GZZD_path);g.setGzzd_time(rs.getDate(GZZD_time);gzzd.add(g);conn.close();return gzzd;public ArrayList searchGzzd(String GZZD_name) throws ExceptionArrayList gzzd = new ArrayList();String sql = select GZZD_name,GZZD_time from tb
6、_gzzd where GZZD_name=?;Connection conn;PreparedStatement pstmt;conn = DBUtil.getConnect();pstmt = conn.prepareStatement(sql);pstmt.setString(1, GZZD_name);ResultSet rs = pstmt.executeQuery();while(rs.next()GZZDBean g = new GZZDBean();g.setGzzd_name(rs.getString(GZZD_name);g.setGzzd_time(rs.getDate(
7、GZZD_time);gzzd.add(g);conn.close();return gzzd;2 UploadDao.java文件package com.jys.dao;import java.sql.SQLException;import java.sql.Connection;import java.sql.Date;import java.sql.PreparedStatement;import com.jys.util.DBUtil;public class UploadDao public String upLoad(String filename,String filepath)
8、 throws SQLExceptionString sql = insert into tb_gzzd (GZZD_name,GZZD_time,GZZD_path) values(?,?,?);Connection conn;PreparedStatement pstmt;Date d= new Date(System.currentTimeMillis();conn = DBUtil.getConnect();pstmt = conn.prepareStatement(sql);pstmt.setString(1, filename);pstmt.setString(3, filepat
9、h);pstmt.setDate(2, d);pstmt.executeUpdate();if(pstmt.executeUpdate()!=1)return fail;elsereturn success;3. XsjyDao.java文件ackage com.jys.dao;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import com.jys.be
10、an.XSJYBean;import com.jys.util.DBUtil;public class XsjyDao / http:/localhost:8080/JYS_gzzdANDxsjypublic ArrayList getAllMsg() throws Exception ArrayList xsjy = new ArrayList();String sql = select XSJY_name,XSJY_card,XSJY_sex,XSJY_class,XSJY_professional,+ XSJY_where,XSJY_phone,XSJY_qq,XSJY_email,XS
11、JY_teacher from tb_xsjy;Connection conn;PreparedStatement pstmt;conn = DBUtil.getConnect();pstmt = conn.prepareStatement(sql);ResultSet rs = pstmt.executeQuery();while (rs.next() XSJYBean x = new XSJYBean();x.setJxjy_class(rs.getString(XSJY_class);x.setJxjy_email(rs.getString(XSJY_email);x.setJxjy_c
12、ard(rs.getString(XSJY_card);x.setJxjy_name(rs.getString(XSJY_name);x.setJxjy_phone(rs.getString(XSJY_phone);x.setJxjy_professional(rs.getString(XSJY_professional);x.setJxjy_qq(rs.getString(XSJY_qq);x.setJxjy_sex(rs.getInt(XSJY_sex);x.setJxjy_teacher(rs.getString(XSJY_teacher);x.setJxjy_where(rs.getS
13、tring(XSJY_where);xsjy.add(x);conn.close();return xsjy;public String deleteXsjy(String snum) String sql = delete from tb_xsjy where XSJY_card=?;Connection conn;PreparedStatement pstmt;conn = DBUtil.getConnect();try pstmt = conn.prepareStatement(sql);pstmt.setString(1, snum);pstmt.executeUpdate(); catch (Exception e) e.printStackTrace();return fail;return success;public XSJYBean getXsjy(String num) throws Exception
