Dao接口及实现类编写
接口:
package com.lagou.dao;
import com.lagou.pojo.Course;
import java.util.List;
/**
* 课程模块 DAO层接口
* */
public interface CourseDao {
//查询课程列表信息
public List<Course> findCourseList();
}
实现类:
package com.lagou.dao.impl;
import com.lagou.dao.CourseDao;
import com.lagou.pojo.Course;
import com.lagou.utils.DruidUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
/**
* 课程模块的 DAO层的实现类
* */
public class CourseDaoImpl implements CourseDao {
@Override
public List<Course> findCourseList() {
try {
//1.创建QueryRunner
QueryRunner qr = new QueryRunner(DruidUtils.getDataSource());