courseclassdao.java

您的文件包然后写出其具体功能(至少要20个字)。尽量不要让站长把时间都花费在为您

package Sys.dao;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

import javax.swing.*;

import Sys.db.DatabaseTool;
import Sys.vo.*;

public class CourseClassDao {
	private static Connection conDB=null;
	public CourseClassDao(){
		conDB=DatabaseTool.conDB();
	}
	
	public void addCourseClass(CourseClass courseclass){
		PreparedStatement ps=null;
		try{
			ps=conDB.prepareStatement("insert into courseclass(coursename" +
					",classid) values(?,?)");
			ps.setString(1, courseclass.getCourseName());
			ps.setString(2, courseclass.getClassID());
			ps.executeUpdate();
		}catch(SQLException e){
			e.printStackTrace();
			JOptionPane.showMessageDialog(null, "插入课程班级失败");
			return;
		}finally{
			DatabaseTool.closeStatement(ps);
		}
		JOptionPane.showMessageDialog(null, "添加班级课程成功");
	}
	//修改班级的课程
	public void modifyCourseClass(CourseClass courseclass,String classid){
		PreparedStatement ps=null;
		try{
			ps=conDB.prepareStatement("update courseclass set coursename=?,classid=? where classid=?");
			ps.setString(1, courseclass.getCourseName());
			ps.setString(2, courseclass.getClassID());
			ps.setString(3, classid);
			ps.executeUpdate();
		}catch(SQLException e){
			e.printStackTrace();
			JOptionPane.showMessageDialog(null, "插入课程班级失败");
			return;
		}finally{
			DatabaseTool.closeStatement(ps);
		}
		JOptionPane.showMessageDialog(null, "添加班级课程成功");
	}
	
	public void delCourseClass(String coursename){
		PreparedStatement ps=null;
		try{
			ps=conDB.prepareStatement("delete from courseclass where coursename=?");
			ps.setString(1, coursename);
			ps.executeUpdate();
			JOptionPane.showMessageDialog(null, "删除成功");
		}catch(SQLException e){
			e.printStackTrace();
			JOptionPane.showMessageDialog(null, "删除失败");
		}finally{
			DatabaseTool.closeStatement(ps);
		}
	}
	
	public List<Course> getCourseForClass(String classid){//课程详细信息
		PreparedStatement ps=null;
		ResultSet rs=null;
		List<Course> courseforclass=null;//用来保存课程的内容
		try{
			ps=conDB.prepareStatement("select * from CourseClass where classid=?");
			ps.setString(1, classid);
			rs=ps.executeQuery();
			courseforclass=new ArrayList<Course>();
			Course course=null;
			while(rs.next()){
				course=new Course();
				course.setCourseName(rs.getString("coursename"));
				//course.setIntroduction(rs.getString("introduction"));
				//course.setStartTime(rs.getString("starttime"));
				courseforclass.add(course);
			}
		}catch(SQLException e){
			e.printStackTrace();
		}finally{
			DatabaseTool.closeResultSet(rs);
			DatabaseTool.closeStatement(ps);
		}
		return courseforclass;
	}
}