J2EE架构与网络编程课程设计

《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(); ca

14、tch (Exception e) e.printStackTrace();return fail;return success;public XSJYBean getXsjy(String num) throws Exception String sql = select XSJY_name,XSJY_card,XSJY_sex,XSJY_class,XSJY_professional,+ XSJY_where,XSJY_phone,XSJY_qq,XSJY_email,XSJY_teacher from tb_xsjy where XSJY_card=?;Connection conn;P

15、reparedStatement pstmt;conn = DBUtil.getConnect();pstmt = conn.prepareStatement(sql);pstmt.setString(1, num);ResultSet rs = pstmt.executeQuery();XSJYBean xsjy = new XSJYBean();while (rs.next() xsjy.setJxjy_card(rs.getString(XSJY_card);xsjy.setJxjy_class(rs.getString(XSJY_class);xsjy.setJxjy_email(rs

16、.getString(XSJY_email);xsjy.setJxjy_name(rs.getString(XSJY_name);xsjy.setJxjy_phone(rs.getString(XSJY_phone);xsjy.setJxjy_professional(rs.getString(XSJY_professional);xsjy.setJxjy_qq(rs.getString(XSJY_qq);xsjy.setJxjy_sex(rs.getInt(XSJY_sex);xsjy.setJxjy_teacher(rs.getString(XSJY_teacher);xsjy.setJx

17、jy_where(rs.getString(XSJY_where);return xsjy;public String editXsjy(String XSJY_name, String XSJY_card, int XSJY_sex,String XSJY_class, String XSJY_professional, String XSJY_where,String XSJY_qq, String XSJY_phone, String XSJY_email,String XSJY_teacher) throws Exception String sql = update tb_xsjy

18、set XSJY_name=?,XSJY_sex=?,XSJY_class=?,XSJY_professional=?,XSJY_where=?,XSJY_qq=?,XSJY_phone=?,XSJY_email=?,XSJY_teacher=? where XSJY_card=?;Connection conn;PreparedStatement pstmt;conn = DBUtil.getConnect();pstmt = conn.prepareStatement(sql);System.out.println(=+XSJY_card+-+XSJY_phone+-+XSJY_class

19、);pstmt.setString(1, XSJY_name);pstmt.setInt(2, XSJY_sex);pstmt.setString(3, XSJY_class);pstmt.setString(4, XSJY_professional);pstmt.setString(5, XSJY_where);pstmt.setString(6, XSJY_qq);pstmt.setString(7, XSJY_phone);pstmt.setString(8, XSJY_email);pstmt.setString(9, XSJY_teacher);pstmt.setString(10,

20、 XSJY_card);int i = pstmt.executeUpdate();System.out.println(-+i);if(i=1)return success;elsereturn fail;public String addXsjy(String XSJY_name, String XSJY_card, int XSJY_sex,String XSJY_class, String XSJY_professional, String XSJY_where,String XSJY_qq, String XSJY_phone, String XSJY_email,String XS

21、JY_teacher) throws ExceptionString sql = insert into tb_xsjy (XSJY_name,XSJY_card,XSJY_sex,XSJY_class,XSJY_professional,XSJY_where,XSJY_qq,XSJY_phone,XSJY_email,XSJY_teacher) values(?,?,?,?,?,?,?,?,?,?);Connection conn;PreparedStatement pstmt;conn = DBUtil.getConnect();pstmt = conn.prepareStatement(

22、sql);System.out.println(=+XSJY_card+-+XSJY_phone+-+XSJY_class);pstmt.setString(1, XSJY_name);pstmt.setString(2, XSJY_card);pstmt.setInt(3, XSJY_sex);pstmt.setString(4, XSJY_class);pstmt.setString(5, XSJY_professional);pstmt.setString(6, XSJY_where);pstmt.setString(7, XSJY_qq);pstmt.setString(8, XSJY

23、_phone);pstmt.setString(9, XSJY_email);pstmt.setString(10, XSJY_teacher);int i = pstmt.executeUpdate();System.out.println(-+i);if(i=1)return success;elsereturn fail;public ArrayList searchXsjy(String XSJY_name) throws ExceptionArrayList xsjy = new ArrayList();String sql = select XSJY_name,XSJY_card,

24、XSJY_sex,XSJY_class,XSJY_professional,+ XSJY_where,XSJY_phone,XSJY_qq,XSJY_email,XSJY_teacher from tb_xsjy where XSJY_name=?;Connection conn;PreparedStatement pstmt;conn = DBUtil.getConnect();pstmt = conn.prepareStatement(sql);pstmt.setString(1, XSJY_name);ResultSet rs = pstmt.executeQuery();while (

25、rs.next() XSJYBean bean = new XSJYBean();bean.setJxjy_card(rs.getString(XSJY_card);bean.setJxjy_class(rs.getString(XSJY_class);bean.setJxjy_email(rs.getString(XSJY_email);bean.setJxjy_name(rs.getString(XSJY_name);bean.setJxjy_phone(rs.getString(XSJY_phone);bean.setJxjy_professional(rs.getString(XSJY

26、_professional);bean.setJxjy_qq(rs.getString(XSJY_qq);bean.setJxjy_sex(rs.getInt(XSJY_sex);bean.setJxjy_teacher(rs.getString(XSJY_teacher);bean.setJxjy_where(rs.getString(XSJY_where);xsjy.add(bean);return xsjy;4. DBUtil.java界面package com.jys.util;import java.sql.Connection;import java.sql.DriverManag

27、er;import java.sql.SQLException;/* * 创建数据库连接字符串。 * author XQ * */public class DBUtil public static Connection getConnect()Connection conn;try Class.forName(com.mysql.jdbc.Driver); catch (ClassNotFoundException e) e.printStackTrace();return null;String uri = jdbc:mysql:/localhost:3306/tb_jys;try conn

28、 = DriverManager.getConnection(uri, root, 123456); catch (SQLException e) e.printStackTrace();return null;return conn;5.structs.xml文件/success.jsp/fail.jsp/upload/!- image/giftargetFilefilename=download.gif4096 -/fail.jsp/gzzd_index.jsp/xsjy_index.jsp/xsjy_edit.jsp/success.jsp/xsjy_search.jsp/success.jsp/fail.jsp/gzzd_search.jsp界面截图1.首页2.规章制度上传下载界面3学生信息管理页面截图4.添加学生信息界面截图