Java学习宝典随书源码

package sms.bean; import java.io.Serializable; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.Hashtable; import java.util.List; import javax.servlet.jsp.tagext.TryCatchFinally; import sms.db.DBAccess; public class CourseBean implements Serializable { public ArrayList queryByCourseId(String courseType, String term, String courseId) { String sql = "select a.course_id,a.course_name,a.type,b.name teachername,b.id " + "teacher_id,a.term,a.week,a.period,a.begintime,a.endtime,a.classroom," + "a.description from course_info a,teach_info b where a.teach_id=b.id"; if (courseId != null) { sql += " and a.course_id='" + courseId + "'"; } if (courseType != null) { sql += " and a.type='" + courseType + "'"; } if (term != null) { sql += " and a.term=" + term; } sql += " order by a.course_id"; DBAccess dba = new DBAccess(); try { dba.getConnection(); ArrayList arrayList = new ArrayList(); ResultSet rs = null; rs = dba.query(sql); if (rs != null) { while (rs.next()) { CourseBean courseBean = new CourseBean(); courseBean.setBeginTime(rs.getInt("begintime")); courseBean.setClassRoom(rs.getString("classroom")); courseBean.setCourseId(rs.getString("course_id")); courseBean.setCourseName(rs.getString("course_name")); courseBean.setCourseType(rs.getString("type")); courseBean.setDescription(rs.getString("description")); courseBean.setEndTime(rs.getInt("endtime")); courseBean.setPeriod(rs.getInt("period")); courseBean.setTeacherName(rs.getString("teachername")); courseBean.setTeacherId(rs.getString("teacher_id")); courseBean.setTerm(rs.getInt("term")); courseBean.setWeek(rs.getInt("week")); arrayList.add(courseBean); } return arrayList; } } catch (SQLException ex) { return null; } finally { dba.closeConnection(); } return null; } public Hashtable queryCourseScheme(String classId, String studentId, String term) { String sql = "select a.course_id,a.course_name,a.type,b.name teachername," + "b.id teacher_id,a.term,a.week,a.period,a.begintime,a.endtime,a.classroom," + "a.description from course_info a,teach_info b,selective_course_scheme c" + " where a.type!='A' and a.teach_id=b.id and a.course_id=c.course_id and a.term=" + term + " and c.stu_id=" + studentId; // 此SQL语句从course_info得到非必修课的信息 String sql2 = "select a.course_id,a.course_name,a.type,b.name teachername," + "a.teach_id teacher_id,a.term,a.week,a.period,a.begintime,a.endtime, " + "a.classroom, a.description from course_info a,teach_info b," + "required_course_scheme c where a.type='A' and a.teach_id=b.id and " + "a.course_id=c.course_id " + "and a.term=" + term + " and c.class_id=" + classId; // 此SQL语句从course_info得到必修课的信息 DBAccess dba = new DBAccess(); try { dba.getConnection(); Hashtable courseHTable = new Hashtable(); ResultSet rs = null; rs = dba.query(sql); String key = null; if (rs != null) { while (rs.next()) { CourseBean courseBean = new CourseBean(); courseBean.setBeginTime(rs.getInt("begintime")); courseBean.setClassRoom(rs.getString("classroom")); courseBean.setCourseId(rs.getString("course_id")); courseBean.setCourseName(rs.getString("course_name")); courseBean.setCourseType(rs.getString("type")); courseBean.setDescription(rs.getString("description")); courseBean.setEndTime(rs.getInt("endtime")); courseBean.setPeriod(rs.getInt("period")); courseBean.setTeacherName(rs.getString("teachername")); courseBean.setTeacherId(rs.getString("teacher_id")); courseBean.setTerm(rs.getInt("term")); courseBean.setWeek(rs.getInt("week")); key = rs.getString("week").trim() + "-" + rs.getString("period").trim(); courseHTable.put(key, courseBean); } } rs = null; rs = dba.query(sql2); if (rs != null) { while (rs.next()) { CourseBean courseBean = new CourseBean(); courseBean.setBeginTime(rs.getInt("begintime")); courseBean.setClassRoom(rs.getString("classroom")); courseBean.setCourseId(rs.getString("course_id")); courseBean.setCourseName(rs.getString("course_name")); courseBean.setCourseType(rs.getString("type")); courseBean.setDescription(rs.getString("description")); courseBean.setEndTime(rs.getInt("endtime")); courseBean.setPeriod(rs.getInt("period")); courseBean.setTeacherName(rs.getString("teachername")); courseBean.setTeacherId(rs.getString("teacher_id")); courseBean.setTerm(rs.getInt("term")); courseBean.setWeek(rs.getInt("week")); key = rs.getString("week").trim() + "-" + rs.getString("period").trim(); courseHTable.put(key, courseBean); } return courseHTable; } } catch (SQLException ex) { return null; } finally { dba.closeConnection(); } return null; } @SuppressWarnings("unchecked") public List queryCanChooseCourse(String term, String week, String period) { List result = new ArrayList(); String sql = String.format("select * from course_info where term = %d and week = %d and period = %d", Integer.valueOf(term), Integer.valueOf(week), Integer.valueOf(period)); DBAccess dba = new DBAccess(); try { dba.getConnection(); ResultSet rs = dba.query(sql); while (rs.next()) { CourseBean courseBean = new CourseBean(); courseBean.setBeginTime(rs.getInt("begintime")); courseBean.setClassRoom(rs.getString("classroom")); courseBean.setCourseId(rs.getString("course_id")); courseBean.setCourseName(rs.getString("course_name")); courseBean.setCourseType(rs.getString("type")); courseBean.setDescription(rs.getString("description")); courseBean.setEndTime(rs.getInt("endtime")); courseBean.setPeriod(rs.getInt("period")); courseBean.setTeacherName(rs.getString("teachername")); courseBean.setTeacherId(rs.getString("teacher_id")); courseBean.setTerm(rs.getInt("term")); courseBean.setWeek(rs.getInt("week")); result.add(courseBean); } } catch (SQLException sqle) { sqle.printStackTrace(); } finally { dba.closeConnection(); } return result; } public Integer getBeginTime() { return beginTime; } public void setBeginTime(Integer beginTime) { this.beginTime = beginTime; } public Integer getEndTime() { return endTime; } public void setEndTime(Integer endTime) { this.endTime = endTime; } public Integer getPeriod() { return period; } public void setPeriod(Integer period) { this.period = period; } public Integer getTerm() { return term; } public void setTerm(Integer term) { this.term = term; } public Integer getWeek() { return week; } public void setWeek(Integer week) { this.week = week; } public String getClassRoom() { return classRoom; } public void setClassRoom(String classRoom) { this.classRoom = classRoom; } public String getCourseId() { return courseId; } public void setCourseId(String courseId) { this.courseId = courseId; } public String getCourseName() { return courseName; } public void setCourseName(String courseName) { this.courseName = courseName; } public String getCourseType() { return courseType; } public void setCourseType(String courseType) { this.courseType = courseType; } public String getDescription() { return description; } public void setDescription(String description) { this.description = description; } public String getTeacherName() { return teacherName; } public void setTeacherName(String teacherName) { this.teacherName = teacher