IT项目管理-教务管理系统

IT项目管理报告-湖南科技大学-08级计算机001班

课程查询主要代码： public ArrayList SearchCources(HttpServletRequest req){ ArrayList courses = null; ChStr chStr = new ChStr(); String temp = null; String type1 = \ String value1 = \ String match1 = \ temp = req.getParameter(\ if(temp != null && !temp.equals(\ type1 = chStr.chStr(temp); temp = req.getParameter(\ if(temp != null && !temp.equals(\ type2 = chStr.chStr(temp); temp = req.getParameter(\ if(temp != null && !temp.equals(\ match1 = chStr.chStr(temp); temp = req.getParameter(\ if(temp != null && !temp.equals(\ match2 = chStr.chStr(temp); temp = req.getParameter(\ if(temp != null && !temp.equals(\ value1 = chStr.chStr(temp); temp = req.getParameter(\ if(temp != null && !temp.equals(\ value2 = chStr.chStr(temp); courses = this.getCourses(type1, value1, match1, match2, type2, value2);

return courses; } 38

IT项目管理报告-湖南科技大学-08级计算机001班

3. 课程成绩查询界面：

图5-4 课程成绩查询界面

课程查询主要代码： public ArrayList getCoursesGradeByStuId(String StuId){ ArrayList courses = new ArrayList(); Course course = null; Statement stmt = null; ResultSet rs = null; DBConnection db = new DBConnection(); try{ db.getConnection(); stmt = db.conn.createStatement(); String sql = \rs = stmt.executeQuery(sql); while(rs.next()){ } System.out.println(ex.getMessage()); try{ rs.close(); stmt.close(); 39 course = new Course(); course.setId(rs.getString(1)); course.setName(rs.getString(2)); course.setScore(rs.getFloat(3)); course.setSelType(rs.getString(4)); course.setExamType(rs.getString(5)); course.setGrade(rs.getFloat(6)); courses.add(course); csg.CSG_Grade from Course c, Cou_Select_Grade csg where c.Cou_Id = csg.CSG_CouId and CSG_StuId = '\}catch(Exception ex){ }finally{ IT项目管理报告-湖南科技大学-08级计算机001班

} } return courses; } db.conn.close(); ex.printStackTrace(); }catch(Exception ex){ 4. 信息发送：

图5-5 信息发送界面

信息发送主要代码:

public int addInfo(HttpServletRequest req){

int ret= -1; String sql = \

ChStr chStr = new ChStr(); Inform info = new Inform(); String temp = null;

temp = req.getParameter(\if(temp == null){

info.setTitle(\

info.setTitle(chStr.chStr(temp.trim())); }else{

}

temp = req.getParameter(\ if(temp == null){

info.setContent(\ }else{

40

IT项目管理报告-湖南科技大学-08级计算机001班

}

}

temp = req.getParameter(\ if(temp == null){ }

temp = req.getParameter(\ info.setSenderId(temp);

temp = req.getParameter(\ info.setAccepterId(temp); temp = req.getParameter(\ if(temp == null){ }

info.setNew(1);

info.setNew(Integer.parseInt(temp));

}else{

info.setTime(\

info.setTime(chStr.chStr(temp)); }else{

info.setContent(chStr.chStr(temp.trim()));

//将发送的信息插入到数据库中

sql = \

+ \

+ info.getTitle() + \

+ info.getSenderId() + \

+ info.getAccepterId() + \

+ info.getTime() + \

+ info.getContent() + \

+ info.getNew() + \

ret = addInfo(sql); return ret ;

41