src/com/tjzhic/dao/impl/CourseDaoImpl.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.tjzhic.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import com.tjzhic.dao.CourseDao;
import com.tjzhic.db.ConnectionFactory;
import com.tjzhic.entity.Course;

public class CourseDaoImpl implements CourseDao{

//添加新的课程记录
  public int add(Course course) {
    int rows = 0;
    Connection con = ConnectionFactory.getConnection();
    PreparedStatement pre = null;
    try {
        String sql = "insert into course(ccode,cname,cmname,cstarttime,cendtime) values(?,?,?,?,?)";
        pre = con.prepareStatement(sql);
        pre.setString(1, course.getCcode());
        pre.setString(2, course.getCname());
        pre.setString(3, course.getCmname());
        pre.setString(4, course.getCstarttime());
        pre.setString(5, course.getCendtime());
        rows = pre.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        try{
            if (pre!=null)
                pre.close();
            if (con != null)
                con.close();
        }catch (SQLException e) {
            e.printStackTrace();
        }
    }
    return rows;

  }

  //按照课程代码删除专业记录
  public int deleteByCcode(String ccode) {
    int rows = 0;
    Connection con = ConnectionFactory.getConnection();
    PreparedStatement pre = null;
    try {
        String sql = "delete from course where ccode=?";
        pre = con.prepareStatement(sql);
        pre.setString(1, ccode);
        rows = pre.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        try{
            if (pre!=null)
                pre.close();