利用servlet获取数据库数据

数据库的数据传到前台

数据库建表：（图片的话存放到第一个里面，自己选图片地址添加数据库）

CREATE TABLE COURSE(
	COURSE_imgurl VARCHAR(150),
	COURSE_title VARCHAR(150),
	COURSE_num INT(255),
	COURSE_price INT(255) 	
 );
 SELECT * FROM COURSE;
 INSERT INTO COURSE VALUE('','在线美女','54567218','2000');
 INSERT INTO COURSE VALUE('','在线美女','54567218','2000');

controller层：

@WebServlet("/CourseServlet")
public class CourseServlet extends HttpServlet {
   

	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
   
		// 处理请求
		// 传递请求到service层
		CourseService serice = new CourseServiceImpl();
		List<Course> courseList = serice.findAllCourse();
		// 处理响应
		// 转发给jsp进行数据的展示
		request.setAttribute("courseList", courseList);
		request.getRequestDispatcher("/course_List.jsp").forward(request, response);
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
   
		// TODO Auto-generated method stub
		doGet(request, response);
	}
}

service层：

public interface CourseService {
   
	// 传递请求到dao层
	public List<Course> findAllCourse();
}

serviceImpl层：

public class CourseServiceImpl implements CourseService {
   

	@Override
	public List<Course> findAllCourse<