4.21

结对作业之北京地铁：

routedao:

package Dao;

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

import Data.route;
import DBUtil.DBUtil;

public class RouteDao {

    
     public void select(List<route> a,String name) throws ClassNotFoundException, SQLException{
             String sql="select * from route where name = ?";
            
             Connection connection = DBUtil.getConnection();
                 try {
                    PreparedStatement ps = connection.prepareStatement(sql);
                      ps.setString(1, name);
                     ResultSet rs =  ps.executeQuery();  
                    
                     
                 while(rs.next())
                 {
                     route route = new route();
                     route.setName(rs.getString(1));
                     route.setSite(rs.getString(2));
                     a.add(route);
                 }
                 
                 } catch (SQLException e) 
                 {
                        e.printStackTrace();
                    }
          
      }

}

routeservlet:

package Dao;

import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Data.route;

/**
 * Servlet implementation class RouteServlet
 */
@WebServlet("/RouteServlet")
public class RouteServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public RouteServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        request.setCharacterEncoding("utf-8");
        response.setContentType("text/html; charset=UTF-8");
        System.out.println("进入Servlet");
        
        String name = request.getParameter("name");
        String site = request.getParameter("site");
        String method= request.getParameter("method");
        

        ArrayList <route> a= new ArrayList<route>();
        
        RouteDao dao = new RouteDao();

        if(method.equals("select"))
        {
            if(name==null)
            {
                response.getWriter().append("输入内容为空");
            }else
            {
                try {
                    dao.select(a,name);
                    request.setAttribute("a", a);
                   
                    request.getRequestDispatcher("showRoute.jsp").forward(request, response);
                } catch (ClassNotFoundException e) {
                    e.printStackTrace();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
               
           }
        }
        
    }

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

}

sitedao:

package Dao;

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

import Data.site;
import DBUtil.DBUtil;

public class SiteDao {
    

    
     public void select(List<site> a,String name) throws ClassNotFoundException, SQLException{
             String sql="select * from site where name = ?";
            
             Connection connection = DBUtil.getConnection();
                 try {
                    PreparedStatement ps = connection.prepareStatement(sql);
                      ps.setString(1, name);
                     ResultSet rs =  ps.executeQuery();  
                    
                     
                 while(rs.next())
                 {
                     site site = new site();
                     site.setName(rs.getString(1));
                     site.setRoute(rs.getString(2));
                     a.add(site);
                 }
                 
                 } catch (SQLException e) 
                 {
                        e.printStackTrace();
                    }
          
      }

}

siteservlet:

package Dao;

import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Data.route;

/**
 * Servlet implementation class SiteServlet
 */
@WebServlet("/SiteServlet")
public class SiteServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public SiteServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        request.setCharacterEncoding("utf-8");
        response.setContentType("text/html; charset=UTF-8");
        
        String name = request.getParameter("name");
        String route = request.getParameter("route");
        String method = request.getParameter("method");

        ArrayList <route> a= new ArrayList<route>();
        
        RouteDao dao = new RouteDao();
        if(method.equals("select"))
        {
            if(name==null)
            {
                response.getWriter().append("输入内容为空");
            }else
            {
                try {
                    dao.select(a,name);
                    request.setAttribute("a", a);
                   
                    request.getRequestDispatcher("showSite.jsp").forward(request, response);
                } catch (ClassNotFoundException e) {
                    e.printStackTrace();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                request.setAttribute("test",a); 
           }
        }
    }

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

}