Demo_01 JavaWeb查询数据显示到网页上（Druid，JdbcTemplate，Servlet，MVC）

1. 目录结构

2. 浏览器上输入网址：http://localhost:8080/TrainSys/show

<servlet>
    <servlet-name>FindAllServlet</servlet-name>
    <servlet-class>com.zcw.controller.FindAllServlet</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>FindAllServlet</servlet-name>
    <url-pattern>/show</url-pattern>
  </servlet-mapping>

3. 根据web.xml的配置好的映射关系，执行FindAllServlet里面的doGet()方法。

private TrainService trainService=new TrainServiceImpl() ;   
 //http://localhost:8080/TrainSys/show  当浏览器输入网址时，调到这个方法。
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
     
  List<Train> list=trainService.find();  
  request.setAttribute("list", list);
  request.getRequestDispatcher("show.jsp").forward(request, response);    
 }

4. 调用Service层

public List<Train> find() {
   
  // TODO Auto-generated method stub
  return trainDao.find();
 }

5. 调用Dao层

private JdbcTemplate template = new JdbcTemplate(JdbcUtils.getDataSource());
public List<Train