coursedao.java

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

package Sys.dao;

import javax.swing.*;

import java.util.*;
import java.sql.*;

import Sys.db.*;
import Sys.vo.*;
public class CourseDao {
	private Connection conDB=null;
	public CourseDao(){
		conDB=DatabaseTool.conDB();
	}
	
	public void addCourse(Course course){
		PreparedStatement ps=null;
		try{
			ps=conDB.prepareStatement("Insert into Course(coursename" +
					",introduction,starttime) values(?,?,?)");
			ps.setString(1, course.getCourseName());
			ps.setString(2, course.getIntroduction());
			ps.setString(3, course.getStartTime());
			ps.executeUpdate();
		}catch(SQLException e){
			e.printStackTrace();
			JOptionPane.showMessageDialog(null, "添加课程失败");
		}finally{
			DatabaseTool.closeStatement(ps);
		}
	}
	
	public void delCourse(String coursename){
		PreparedStatement ps=null;
		try{
			ps=conDB.prepareStatement("delete from Course where coursename=?");
			ps.setString(1, coursename);
			ps.executeUpdate();
		}catch(SQLException e){
			e.printStackTrace();
			JOptionPane.showMessageDialog(null, "删除课程失败");
		}finally{
			DatabaseTool.closeStatement(ps);
		}
	}
	
	public Course getCourse(String coursename){
		PreparedStatement ps=null;
		ResultSet rs=null;
		Course course=null;
		try{
			ps=conDB.prepareStatement("select * from Course where coursename=?");
			ps.setString(1, coursename);
			rs=ps.executeQuery();
			if(rs.next()){
				course=new Course();
				course.setCourseName(rs.getString("coursename"));
				course.setIntroduction(rs.getString("introduction"));
				course.setStartTime(rs.getString("starttime"));
			}
		}catch(SQLException e){
			e.printStackTrace();
			JOptionPane.showMessageDialog(null, "获得班级资料失败");
		}finally{
			DatabaseTool.closeResultSet(rs);
			DatabaseTool.closeStatement(ps);
		}
		return course;
	}
	
	public List<Course> getAllCourse(){
		PreparedStatement ps=null;
		ResultSet rs=null;
		List<Course> courselist=null;
		try{
			ps=conDB.prepareStatement("select * from Course");
			rs=ps.executeQuery();
			courselist=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"));
				courselist.add(course);
			}
		}catch(SQLException e){
			e.printStackTrace();
			JOptionPane.showMessageDialog(null,"获得课程表失败");
		}finally{
			DatabaseTool.closeResultSet(rs);
			DatabaseTool.closeStatement(ps);
		}
		return courselist;
	}
}