J2EE架構(gòu)與網(wǎng)絡(luò)編程課程設(shè)計(jì).doc

1、.J2EE架構(gòu)與網(wǎng)絡(luò)編程課程設(shè)計(jì)項(xiàng)目名稱：教研室信息管理系統(tǒng)班 級(jí)：軟件工程2班學(xué) 號(hào)：姓 名：項(xiàng)目技術(shù)應(yīng)用30分功能齊全40分技術(shù)創(chuàng)新10分界面設(shè)計(jì)10分文檔規(guī)范10分總分得分目錄一、引言二、數(shù)據(jù)庫(kù)設(shè)計(jì)三、功能框圖四、核心代碼及界面截圖一 引言隨著信息技術(shù)的高速發(fā)展，使得信息資源實(shí)現(xiàn)了高度共享，并且從根本上改變了人們進(jìn)行信息交流的方式。對(duì)于軟件學(xué)院的學(xué)生更是如此。通過(guò)調(diào)研了解到，信息技術(shù)學(xué)院老師每學(xué)期都會(huì)有多門(mén)課程開(kāi)設(shè)，學(xué)期末有許多資料需要整理，教學(xué)上不方便，效率也較低。因此教研室管理系統(tǒng)應(yīng)運(yùn)而生。 二 數(shù)據(jù)設(shè)計(jì)規(guī)章制度表：字段描述類型長(zhǎng)度Rules_ID規(guī)章編號(hào)IntRules_Name規(guī)

2、章名Varchar50Rules_Summary規(guī)章概要Varchar200Rules_Text規(guī)章內(nèi)容（路徑）Varchar100Rules_Type規(guī)章類型SmallintRules_Time發(fā)布時(shí)間Date表1-1學(xué)生信息表字段描述類型長(zhǎng)度Stu_Name學(xué)生姓名String30Stu_ID學(xué)號(hào)String12Sex性別BooleanStu_Class班級(jí)String20Stu_Professional專業(yè)String20Stu_where就業(yè)單位或考研學(xué)校String30Phone電話String15Email郵箱String20Teacher教師String20表1-2三 功能框圖1

3、規(guī)章制度管理功能圖2學(xué)生精英功能圖四 核心代碼及界面截圖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 ArrayLis

4、t<GZZDBean> getAllMsg() throws ExceptionArrayList<GZZDBean> gzzd = new ArrayList<GZZDBean>();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

5、 = pstmt.executeQuery();while(rs.next()GZZDBean g = new GZZDBean();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<GZZDBean> searchGzzd(S

6、tring GZZD_name) throws ExceptionArrayList<GZZDBean> gzzd = new ArrayList<GZZDBean>();String sql = "select GZZD_name,GZZD_time from tb_gzzd where GZZD_name=?"Connection conn;PreparedStatement pstmt;conn = DBUtil.getConnect();pstmt = conn.prepareStatement(sql);pstmt.setString(1,

7、 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("GZZD_time");gzzd.add(g);conn.close();return gzzd;2 UploadDao.java文件package com.jys.dao;import java.sql.SQLException;impor

8、t 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) throws SQLExceptionString sql = "insert into tb_gzzd (GZZD_name,GZZD_time,GZZD_path) values(?,?,?)"Connection

9、 conn;PreparedStatement pstmt;Date d= new Date(System.currentTimeMillis();conn = DBUtil.getConnect();pstmt = conn.prepareStatement(sql);pstmt.setString(1, filename);pstmt.setString(3, filepath);pstmt.setDate(2, d);pstmt.executeUpdate();if(pstmt.executeUpdate()!=1)return "fail"elsereturn &q

10、uot;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.bean.XSJYBean;import com.jys.util.DBUtil;public class XsjyDao / http:/localhost:8080/JYS_

11、gzzdANDxsjypublic ArrayList<XSJYBean> getAllMsg() throws Exception ArrayList<XSJYBean> xsjy = new ArrayList<XSJYBean>();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_xs

12、jy;"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.

13、setJxjy_card(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("XSJ

14、Y_sex");x.setJxjy_teacher(rs.getString("XSJY_teacher");x.setJxjy_where(rs.getString("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;

15、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 String sql = "select XSJY_name,XSJY_car

16、d,XSJY_sex,XSJY_class,XSJY_professional,"+ "XSJY_where,XSJY_phone,XSJY_qq,XSJY_email,XSJY_teacher from tb_xsjy where XSJY_card=?"Connection conn;PreparedStatement pstmt;conn = DBUtil.getConnect();pstmt = conn.prepareStatement(sql);pstmt.setString(1, num);ResultSet rs = pstmt.executeQu

17、ery();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.getString("XSJY_email");xsjy.setJxjy_name(rs.getString("XSJY_name");xsjy.setJxjy_phone(rs.getS

18、tring("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.setJxjy_where(rs.getString("XSJ

19、Y_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 set XSJY_name

20、=?,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_ph

21、one+"-"+XSJY_class);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_

22、teacher);pstmt.setString(10, 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,

23、String XSJY_qq, String XSJY_phone, String XSJY_email,String XSJY_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;Prepared

24、Statement pstmt;conn = DBUtil.getConnect();pstmt = conn.prepareStatement(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.setSt

25、ring(5, XSJY_professional);pstmt.setString(6, XSJY_where);pstmt.setString(7, XSJY_qq);pstmt.setString(8, XSJY_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 "fa

26、il"public ArrayList<XSJYBean> searchXsjy(String XSJY_name) throws ExceptionArrayList<XSJYBean> xsjy = new ArrayList<XSJYBean>();String sql = "select XSJY_name,XSJY_card,XSJY_sex,XSJY_class,XSJY_professional,"+ "XSJY_where,XSJY_phone,XSJY_qq,XSJY_email,XSJY_teach

27、er 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 (rs.next() XSJYBean bean = new XSJYBean();bean.setJxjy_card(rs.getString("XSJY_car

28、d");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_professional")

29、;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.Conn

30、ection;import java.sql.DriverManager;import java.sql.SQLException;/* * 創(chuàng)建數(shù)據(jù)庫(kù)連接字符串。 * 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 ur

31、i = "jdbc:mysql:/localhost:3306/tb_jys"try conn = DriverManager.getConnection(uri, "root", "123456"); catch (SQLException e) e.printStackTrace();return null;return conn;5.structs.xml文件<struts><!- 開(kāi)發(fā)模式下使用,這樣可以打印出更詳細(xì)的錯(cuò)誤信息 -><constant name="struts.devMo

32、de" value="true" /><constant name="struts.multipart.maxSize" value="104857600" /><!- 設(shè)置上傳文件的臨時(shí)文件夾,默認(rèn)使用javax.servlet.context.tempdir -><package name="default" extends="struts-default"><action name="upload" class=

33、"com.jys.action.UploadAction"><result name="success">/success.jsp</result><result name="fail">/fail.jsp</result></action><action name="download" class="com.jys.action.DownloadAction" method="download">

34、<param name="inputPath">/upload/</param><!- <result name="success" type="stream"><param name="contentType">image/gif</param><param name="inputName">targetFile</param><param name="contentDisposition">filename="download.gif"</param><param name="bufferSize">4096</param></result> -><result name="fail"&