package com.ischoolbar.programmer.dao; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.ischoolbar.programmer.model.Clazz; import com.ischoolbar.programmer.model.Course; import com.ischoolbar.programmer.model.Page; import com.ischoolbar.programmer.util.StringUtil; /** * * @author llq *课程数据库操作类 */ public class CourseDao extends BaseDao { public boolean addCourse(Course course){ String sql = "insert into s_course values(null,'"+course.getName()+"',"+course.getTeacherId()+",'"+course.getCourseDate()+"',0,"+course.getMaxNum()+",'"+course.getInfo()+"') "; return update(sql); } public List<Course> getCourseList(Course course,Page page){ List<Course> ret = new ArrayList<Course>(); String sql = "select * from s_course "; if(!StringUtil.isEmpty(course.getName())){ sql += "and name like '%" + course.getName() + "%'"; } if(course.getTeacherId() != 0){ sql += " and teacher_id = " + course.getTeacherId() + ""; } sql += " limit " + page.getStart() + "," + page.getPageSize(); ResultSet resultSet = query(sql.replaceFirst("and", "where")); try { while(resultSet.next()){ Course cl = new Course(); cl.setId(resultSet.getInt("id")); cl.setName(resultSet.getString("name")); cl.setTeacherId(resultSet.getInt("teacher_id")); cl.setCourseDate(resultSet.getString("course_date")); cl.setSelectedNum(resultSet.getInt("selected_num")); cl.setMaxNum(resultSet.getInt("max_num")); cl.setInfo(resultSet.getString("info")); ret.add(cl); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return ret; } public int getCourseListTotal(Course course){ int total = 0; String sql = "select count(*)as total from s_course "; if(!StringUtil.isEmpty(course.getName())){ sql += "and name like '%" + course.getName() + "%'"; } if(course.getTeacherId() != 0){ sql += " and teacher_id = " + course.getTeacherId() + ""; } ResultSet resultSet = query(sql.replaceFirst("and", "where")); try { while(resultSet.next()){ total = resultSet.getInt("total"); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return total; } public boolean editCourse(Course course) { // TODO Auto-generated method stub String sql = "update s_course set name = '"+course.getName()+"',teacher_id = "+course.getTeacherId()+",course_date = '"+course.getCourseDate()+"',max_num = "+course.getMaxNum()+" ,info = '"+course.getInfo()+"' where id = " + course.getId(); return update(sql); } public boolean deleteCourse(String ids) { // TODO Auto-generated method stub String sql = "delete from s_course where id in("+ids+")"; return update(sql); } /** * 检查该课程是否已选满 * @param courseId * @return */ public boolean isFull(int courseId){ boolean ret = false; String sql = "select * from s_course where selected_num >= max_num and id = " + courseId; ResultSet query = query(sql); try { if(query.next()){ return true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return ret; } /** * 更新课程已选人数 * @param courseId */ public void updateCourseSelectedNum(int courseId ,int num){ String sql = ""; if(num > 0){ sql = "update s_course set selected_num = selected_num + "+ num + " where id = " + courseId; }else{ sql = "update s_course set selected_num = selected_num - " + Math.abs(num) + " where id = " + courseId; } update(sql); } /** * 获取制定id范围内的课程列表 * @param ids * @return */ public List<Course> getCourse(String ids){ List<Course> ret = new ArrayList<Course>(); String sql = "select * from s_course where id in("+ids+")"; ResultSet query = query(sql); try { while(query.next()){ Course cl = new Course(); cl.setId(query.getInt("id")); cl.setName(query.getString("name")); cl.setTeacherId(query.getInt("teacher_id")); cl.setCourseDate(query.getString("course_date")); cl.setSelectedNum(query.getInt("selected_num")); cl.setMaxNum(query.getInt("max_num")); cl.setInfo(query.getString("info")); ret.add(cl); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return ret; } /** * 获取指定的课程 * @param id * @return */ public Course getCourse(int id){ Course course = null; String sql = "select * from s_course where id = " + id; ResultSet query = query(sql); try { while(query.next()){ course = new Course(); course.setId(query.getInt("id")); course.setName(query.getString("name")); course.setTeacherId(query.getInt("teacher_id")); course.setCourseDate(query.getString("course_date")); course.setSelectedNum(query.getInt("selected_num")); course.setMaxNum(query.getInt("max_num")); course.setInfo(query.getString("info")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return course; } }
最近下载更多
最近浏览更多
fkjafjkkfo LV2
昨天
lzx602 LV3
4月15日
ruo12138 LV1
4月14日
jiuyin0919 LV1
4月1日
dameir
3月26日
暂无贡献等级
alphaeix
3月18日
暂无贡献等级
微信网友_6906962132258816 LV6
3月16日
WBelong LV7
3月8日
潘潘123456 LV2
3月2日
杨豫川 LV12
1月12日