北京地铁查询系统4.0

1.bean层的Bean.java

package bean;

public class Bean {
    private int listid;//线路id
    private String listname;//线路名字
    private int id;//站的id
    private String zname;//站名

    public int getListid() {
        return listid;
    }

    public void setListid(int listid) {
        this.listid = listid;
    }

    public String getListname() {
        return listname;
    }

    public void setListname(String listname) {
        this.listname = listname;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getZname() {
        return zname;
    }

    public void setZname(String zname) {
        this.zname = zname;
    }
    public Bean() {};
    public Bean(int listid,String listname,int id,String zname)
    {
        this.listid=listid;
        this.listname=listname;
        this.id=id;
        this.zname=zname;
    }
}

　2.dao层的Dao.java

package dao;

import bean.*;
import DBUtil.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import org.apache.taglibs.standard.lang.jstl.NullLiteral;
import org.testng.annotations.Test;
public class Dao {//dao层
    private DBUtil dbutil = new DBUtil();

    public Dao() {
        // TODO Auto-generated constructor stub
    }

    @Test
    public List<Bean> list1() {//查询所有方法
        String sql = "select * from list1";
        Connection conn = DBUtil.getConnection();
        Statement st = null;
        List<Bean> list = new ArrayList<>();
        ResultSet rs = null;
        Bean bean = null;
        try {
            st = conn.createStatement();
            st.executeQuery(sql);
            rs = st.executeQuery(sql);
            while (rs.next()) {

                int listid = rs.getInt("listid");
                String listname = rs.getString("listname");
                int id = rs.getInt("id");
                String zname = rs.getString("zname");
                bean = new Bean(listid, listname, id, zname);
                list.add(bean);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, st, conn);
        }
        return list;
    }

    public List<Bean> list2() {//查询所有方法
        String sql = "select * from list2";
        Connection conn = DBUtil.getConnection();
        Statement st = null;
        List<Bean> list = new ArrayList<>();
        ResultSet rs = null;
        Bean bean = null;
        try {
            st = conn.createStatement();
            st.executeQuery(sql);
            rs = st.executeQuery(sql);
            while (rs.next()) {

                int listid = rs.getInt("listid");
                String listname = rs.getString("listname");
                int id = rs.getInt("id");
                String zname = rs.getString("zname");
                bean = new Bean(listid, listname, id, zname);
                list.add(bean);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, st, conn);
        }
        return list;
    }

    public List<Bean> list3() {//查询所有方法
        String sql = "select * from list3";
        Connection conn = DBUtil.getConnection();
        Statement st = null;
        List<Bean> list = new ArrayList<>();
        ResultSet rs = null;
        Bean bean = null;
        try {
            st = conn.createStatement();
            st.executeQuery(sql);
            rs = st.executeQuery(sql);
            while (rs.next()) {

                int listid = rs.getInt("listid");
                String listname = rs.getString("listname");
                int id = rs.getInt("id");
                String zname = rs.getString("zname");
                bean = new Bean(listid, listname, id, zname);
                list.add(bean);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, st, conn);
        }
        return list;
    }

    public List<Bean> list4() {//查询所有方法
        String sql = "select * from list4";
        Connection conn = DBUtil.getConnection();
        Statement st = null;
        List<Bean> list = new ArrayList<>();
        ResultSet rs = null;
        Bean bean = null;
        try {
            st = conn.createStatement();
            st.executeQuery(sql);
            rs = st.executeQuery(sql);
            while (rs.next()) {

                int listid = rs.getInt("listid");
                String listname = rs.getString("listname");
                int id = rs.getInt("id");
                String zname = rs.getString("zname");
                bean = new Bean(listid, listname, id, zname);
                list.add(bean);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, st, conn);
        }
        return list;
    }

    public List<Bean> list5() {//查询所有方法
        String sql = "select * from list5";
        Connection conn = DBUtil.getConnection();
        Statement st = null;
        List<Bean> list = new ArrayList<>();
        ResultSet rs = null;
        Bean bean = null;
        try {
            st = conn.createStatement();
            st.executeQuery(sql);
            rs = st.executeQuery(sql);
            while (rs.next()) {

                int listid = rs.getInt("listid");
                String listname = rs.getString("listname");
                int id = rs.getInt("id");
                String zname = rs.getString("zname");
                bean = new Bean(listid, listname, id, zname);
                list.add(bean);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, st, conn);
        }
        return list;
    }

    public List<Bean> list6() {
        String sql = "select * from list6";
        Connection conn = DBUtil.getConnection();
        Statement st = null;
        List<Bean> list = new ArrayList<>();
        ResultSet rs = null;
        Bean bean = null;
        try {
            st = conn.createStatement();
            st.executeQuery(sql);
            rs = st.executeQuery(sql);
            while (rs.next()) {

                int listid = rs.getInt("listid");
                String listname = rs.getString("listname");
                int id = rs.getInt("id");
                String zname = rs.getString("zname");
                bean = new Bean(listid, listname, id, zname);
                list.add(bean);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, st, conn);
        }
        return list;
    }

    /*public  List<Bean> searchlistname(String name){
        String sql="select * from allstation where zname= ?";
        Connection conn=DBUtil.getConnection();
       Statement st=null;
       List<Bean> list=new ArrayList<>();
       ResultSet rs=null;
       Bean bean=null;
        pa.setString(1,name );
        try {
        st=conn.createStatement();
        st.executeQuery(sql);
        rs=st.executeQuery(sql);
        while(rs.next()) {
            int listid=rs.getInt("listid");
            String listname = rs.getString("listname");
            int id=rs.getInt("id");
            String zname = rs.getString("zname");
            bean=new Bean(listid,listname,id,zname);
            list.add(bean);
        }
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
        finally {
        DBUtil.close(rs, st, conn);
    }
        return list;
}

   /* public String searchlistname(String name) throws ClassNotFoundException, SQLException {

        Connection conn = DBUtil.getConnection();
        Statement state = null;
        ResultSet rs = null;
        String listname = null;
        try {
            String sql1 = "select listname from allstation where zname ='" + name + "' ";
            state = conn.createStatement();
            rs = state.executeQuery(sql1);
            while (rs.next()) {
                listname = rs.getString("listname");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, state, conn);
        }
        return listname;

    }*/
    public List<Bean> searchlistname(String s1) {
        List<Bean> list=new ArrayList<Bean>();
        Connection con;
        try {
            String sql="select * from allstation where zname = ?";
            con = DBUtil.getConnection();
            PreparedStatement pa=con.prepareStatement(sql);
            pa.setString(1,s1);
            ResultSet rs=pa.executeQuery();
            while(rs.next()) {
                Bean L = new Bean();
                int listid = rs.getInt("listid");
                String listname = rs.getString("listname");
                int id = rs.getInt("id");
                String zname = rs.getString("zname");
                L=new Bean(listid,listname,id,zname);
                list.add(L);

            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return list;
    }
}

　　3.DBUtil层的DBUtil.java

package DBUtil;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class DBUtil {
    private static String url = "jdbc:mysql://localhost:3306/subway?useUnicode=true&characterEncoding=utf8";
    private static String user = "root";
    private static String password = "lyf123456";
    private static String jdbcName="com.mysql.jdbc.Driver";
    private Connection con=null;
    public static  Connection getConnection() {
        Connection con=null;
        try {
            Class.forName(jdbcName);
            con=DriverManager.getConnection(url, user, password);
            //System.out.println("数据库连接成功");
        } catch (Exception e) {
            // TODO Auto-generated catch block
            //System.out.println("数据库连接失败");
            e.printStackTrace();
        }
        return con;

    }
    public static void close(Connection con) {
        if(con!=null)
            try {
                con.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }

    }
    public static void close(Statement state, Connection conn) {
        if(state!=null) {
            try {
                state.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if(conn!=null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    public static void close(ResultSet rs, Statement state, Connection conn) {
        if(rs!=null) {
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if(state!=null) {
            try {
                state.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if(conn!=null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

}

　　4.servlet层的servlet.java

package servlet;
import bean.*;
import dao.*;
import DBUtil.DBUtil;
import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.sql.SQLException;
import java.util.List;
import java.util.*;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class servlet
 */
@WebServlet("/servlet")
public class servlet extends HttpServlet {
    Dao dao=new Dao();

    private static final long serialVersionUID = 1L;
    /**
     * @see HttpServlet#HttpServlet()
     */
    public servlet() {
        super();
        // TODO Auto-generated constructor stub
    }
    private void list1(HttpServletRequest request, HttpServletResponse response) throws Exception {
        // TODO Auto-generated method stub
        request.setCharacterEncoding("utf-8");
        List<Bean> list = dao.list1();
        request.setAttribute("list", list);
        request.getRequestDispatcher("list.jsp").forward(request,response);
    }
    private void list2(HttpServletRequest request, HttpServletResponse response) throws Exception {
        // TODO Auto-generated method stub
        request.setCharacterEncoding("utf-8");
        List<Bean> list = dao.list2();
        request.setAttribute("list", list);
        request.getRequestDispatcher("list.jsp").forward(request,response);
    }
    private void list3(HttpServletRequest request, HttpServletResponse response) throws Exception {
        // TODO Auto-generated method stub
        request.setCharacterEncoding("utf-8");
        List<Bean> list = dao.list3();
        request.setAttribute("list", list);
        request.getRequestDispatcher("list.jsp").forward(request,response);
    }
    private void list4(HttpServletRequest request, HttpServletResponse response) throws Exception {
        // TODO Auto-generated method stub
        request.setCharacterEncoding("utf-8");
        List<Bean> list = dao.list4();
        request.setAttribute("list", list);
        request.getRequestDispatcher("list.jsp").forward(request,response);
    }
    private void list5(HttpServletRequest request, HttpServletResponse response) throws Exception {
        // TODO Auto-generated method stub
        request.setCharacterEncoding("utf-8");
        List<Bean> list = dao.list5();
        request.setAttribute("list", list);
        request.getRequestDispatcher("list.jsp").forward(request,response);
    }
    private void list6(HttpServletRequest request, HttpServletResponse response) throws Exception {
        // TODO Auto-generated method stub
        request.setCharacterEncoding("utf-8");
        List<Bean> list = dao.list6();
        request.setAttribute("list", list);
        request.getRequestDispatcher("list.jsp").forward(request,response);
    }
    private void show1(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String zname=request.getParameter("zname");
        List<Bean> list=dao.searchlistname(request.getParameter("s1"));
        request.setAttribute("list",list);
        request.getRequestDispatcher("list.jsp").forward(request, response);
    }




    /**
     * @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");
        String method=request.getParameter("method");


        if("list1".equals(method)) {
            try {
                list1(request,response);
            } catch (Exception e) {
                e.printStackTrace();
            }

        }
        else if("list2".equals(method)) {
            try {
                list2(request,response);
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }

        }
        else if("list3".equals(method)) {
            try {
                list3(request,response);
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        else if("list4".equals(method)) {
            try {
                list4(request,response);
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        else if("list5".equals(method)) {
            try {
                list5(request,response);
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        else if("list6".equals(method)) {
            try {
                list6(request,response);
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        else if("show1".equals(method)) {
            try {
                show1(request,response);
            } catch (Exception e) {
                // TODO Auto-generated catch block
                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);
    }

}

　　前端代码在我队友的博客园：https://www.cnblogs.com/diandianzai/