4.10课堂小测（政策查询web）

package bean;

public class policy {
    private int id;
    private String name,type,category,range,document,form,organ,viadata,pubdata,perdata,text;

    public int getId() {
        return id;
    }

    public String getText() {
        return text;
    }

    public void setText(String text) {
        this.text = text;
    }

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

    public policy() {
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getType() {
        return type;
    }

    public void setType(String type) {
        this.type = type;
    }

    public String getCategory() {
        return category;
    }

    public void setCategory(String category) {
        this.category = category;
    }

    public String getRange() {
        return range;
    }

    public void setRange(String range) {
        this.range = range;
    }

    public String getDocument() {
        return document;
    }

    public void setDocument(String document) {
        this.document = document;
    }

    public String getForm() {
        return form;
    }

    public void setForm(String form) {
        this.form = form;
    }

    public String getOrgan() {
        return organ;
    }

    public void setOrgan(String organ) {
        this.organ = organ;
    }

    public String getViadata() {
        return viadata;
    }

    public void setViadata(String viadata) {
        this.viadata = viadata;
    }

    public String getPubdata() {
        return pubdata;
    }

    public void setPubdata(String pubdata) {
        this.pubdata = pubdata;
    }

    public String getPerdata() {
        return perdata;
    }

    public void setPerdata(String perdata) {
        this.perdata = perdata;
    }

    @Override
    public String toString() {
        return "policy{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", type='" + type + '\'' +
                ", category='" + category + '\'' +
                ", range='" + range + '\'' +
                ", document='" + document + '\'' +
                ", form='" + form + '\'' +
                ", organ='" + organ + '\'' +
                ", viadata='" + viadata + '\'' +
                ", pubdata='" + pubdata + '\'' +
                ", perdata='" + perdata + '\'' +
                '}';
    }
}

package dao;

import bean.policy;
import com.mysql.cj.jdbc.result.UpdatableResultSet;
import util.DButil;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.util.Set;

public class Dao {
    public ArrayList<policy> getall(){
        ArrayList<policy> policies=new ArrayList<>();
        try{
            Connection connection= DButil.getConn();
            String sql="select * from policy";
            Statement statement=connection.createStatement();
            ResultSet resultSet=statement.executeQuery(sql);
            while(resultSet.next()){
                policy p=new policy();
                p.setId(resultSet.getInt("id"));
                p.setName(resultSet.getString("name"));
                p.setType(resultSet.getString("type"));
                p.setCategory(resultSet.getString("category"));
                p.setRange(resultSet.getString("range"));
                p.setDocument(resultSet.getString("document"));
                p.setForm(resultSet.getString("form"));
                p.setOrgan(resultSet.getString("organ"));
                p.setViadata(resultSet.getString("viadata"));
                p.setPubdata(resultSet.getString("pubdata"));
                p.setPerdata(resultSet.getString("perdata"));
                policies.add(p);
            }
        }catch (Exception e){
            e.printStackTrace();
        }
        return policies;
    }
    public ArrayList<policy> chaxuntext(int cpage, int count){
        String sql="select * from policy  order by pubdata limit "+((cpage-1)*count)+","+count;
        ArrayList<policy> texts=new ArrayList<>();
        try {
            Connection connection = DButil.getConn();
            Statement statement = connection.createStatement();
            ResultSet resultSet=statement.executeQuery(sql);
            while(resultSet.next()){
                policy p=new policy();
                p.setId(resultSet.getInt("id"));
                p.setName(resultSet.getString("name"));
                p.setType(resultSet.getString("type"));
                p.setCategory(resultSet.getString("category"));
                p.setRange(resultSet.getString("range"));
                p.setDocument(resultSet.getString("document"));
                p.setForm(resultSet.getString("form"));
                p.setOrgan(resultSet.getString("organ"));
                p.setViadata(resultSet.getString("viadata"));
                p.setPubdata(resultSet.getString("pubdata"));
                p.setPerdata(resultSet.getString("perdata"));
                p.setText(resultSet.getString("text"));
                texts.add(p);
            }
        } catch (SQLException | ClassNotFoundException e) {
            throw new RuntimeException(e);
        }
        return texts;
    }
    public ArrayList<policy> chaxunname(int cpage, int count,String name){
        String sql="select * from policy where name like ?  order by pubdata limit "+((cpage-1)*count)+","+count;
        ArrayList<policy> texts=new ArrayList<>();
        try {
            Connection connection = DButil.getConn();
            PreparedStatement preparedStatement=connection.prepareStatement(sql);
            preparedStatement.setString(1,"%"+name+"%");
            ResultSet resultSet=preparedStatement.executeQuery();
            while(resultSet.next()){
                policy p=new policy();
                p.setId(resultSet.getInt("id"));
                p.setName(resultSet.getString("name"));
                p.setType(resultSet.getString("type"));
                p.setCategory(resultSet.getString("category"));
                p.setRange(resultSet.getString("range"));
                p.setDocument(resultSet.getString("document"));
                p.setForm(resultSet.getString("form"));
                p.setOrgan(resultSet.getString("organ"));
                p.setViadata(resultSet.getString("viadata"));
                p.setPubdata(resultSet.getString("pubdata"));
                p.setPerdata(resultSet.getString("perdata"));
                p.setText(resultSet.getString("text"));
                texts.add(p);
            }
        } catch (SQLException | ClassNotFoundException e) {
            throw new RuntimeException(e);
        }
        return texts;
    }
    public ArrayList<policy> chaxundocument(int cpage, int count,String name){
        String sql="select * from policy where document like ?  order by pubdata limit "+((cpage-1)*count)+","+count;
        ArrayList<policy> texts=new ArrayList<>();
        try {
            Connection connection = DButil.getConn();
            PreparedStatement preparedStatement=connection.prepareStatement(sql);
            preparedStatement.setString(1,"%"+name+"%");
            ResultSet resultSet=preparedStatement.executeQuery();
            while(resultSet.next()){
                policy p=new policy();
                p.setId(resultSet.getInt("id"));
                p.setName(resultSet.getString("name"));
                p.setType(resultSet.getString("type"));
                p.setCategory(resultSet.getString("category"));
                p.setRange(resultSet.getString("range"));
                p.setDocument(resultSet.getString("document"));
                p.setForm(resultSet.getString("form"));
                p.setOrgan(resultSet.getString("organ"));
                p.setViadata(resultSet.getString("viadata"));
                p.setPubdata(resultSet.getString("pubdata"));
                p.setPerdata(resultSet.getString("perdata"));
                p.setText(resultSet.getString("text"));
                texts.add(p);
            }
        } catch (SQLException | ClassNotFoundException e) {
            throw new RuntimeException(e);
        }
        return texts;
    }
    public ArrayList<policy> chaxunorgan(int cpage, int count,String name){
        String sql="select * from policy where organ like ?  order by pubdata limit "+((cpage-1)*count)+","+count;
        ArrayList<policy> texts=new ArrayList<>();
        try {
            Connection connection = DButil.getConn();
            PreparedStatement preparedStatement=connection.prepareStatement(sql);
            preparedStatement.setString(1,"%"+name+"%");
            ResultSet resultSet=preparedStatement.executeQuery();
            while(resultSet.next()){
                policy p=new policy();
                p.setId(resultSet.getInt("id"));
                p.setName(resultSet.getString("name"));
                p.setType(resultSet.getString("type"));
                p.setCategory(resultSet.getString("category"));
                p.setRange(resultSet.getString("range"));
                p.setDocument(resultSet.getString("document"));
                p.setForm(resultSet.getString("form"));
                p.setOrgan(resultSet.getString("organ"));
                p.setViadata(resultSet.getString("viadata"));
                p.setPubdata(resultSet.getString("pubdata"));
                p.setPerdata(resultSet.getString("perdata"));
                p.setText(resultSet.getString("text"));
                texts.add(p);
            }
        } catch (SQLException | ClassNotFoundException e) {
            throw new RuntimeException(e);
        }
        return texts;
    }
    public ArrayList<policy> chaxun3(int cpage, int count,String name,String document,String organ){
        String sql="select * from policy where organ like ? and name like ? and document like ? order by pubdata limit "+((cpage-1)*count)+","+count;
        ArrayList<policy> texts=new ArrayList<>();
        try {
            Connection connection = DButil.getConn();
            PreparedStatement preparedStatement=connection.prepareStatement(sql);
            preparedStatement.setString(1,"%"+organ+"%");
            preparedStatement.setString(2,"%"+name+"%");
            preparedStatement.setString(3,"%"+document+"%");
            ResultSet resultSet=preparedStatement.executeQuery();
            while(resultSet.next()){
                policy p=new policy();
                p.setId(resultSet.getInt("id"));
                p.setName(resultSet.getString("name"));
                p.setType(resultSet.getString("type"));
                p.setCategory(resultSet.getString("category"));
                p.setRange(resultSet.getString("range"));
                p.setDocument(resultSet.getString("document"));
                p.setForm(resultSet.getString("form"));
                p.setOrgan(resultSet.getString("organ"));
                p.setViadata(resultSet.getString("viadata"));
                p.setPubdata(resultSet.getString("pubdata"));
                p.setPerdata(resultSet.getString("perdata"));
                p.setText(resultSet.getString("text"));
                texts.add(p);
            }
        } catch (SQLException | ClassNotFoundException e) {
            throw new RuntimeException(e);
        }
        return texts;
    }
    public ArrayList<policy> chaxunnameanddocument(int cpage, int count,String name,String document){
        String sql="select * from policy where  name like ? and document  like ? order by pubdata limit "+((cpage-1)*count)+","+count;
        ArrayList<policy> texts=new ArrayList<>();
        try {
            Connection connection = DButil.getConn();
            PreparedStatement preparedStatement=connection.prepareStatement(sql);
            preparedStatement.setString(1,"%"+name+"%");
            preparedStatement.setString(2,"%"+document+"%");
            ResultSet resultSet=preparedStatement.executeQuery();
            while(resultSet.next()){
                policy p=new policy();
                p.setId(resultSet.getInt("id"));
                p.setName(resultSet.getString("name"));
                p.setType(resultSet.getString("type"));
                p.setCategory(resultSet.getString("category"));
                p.setRange(resultSet.getString("range"));
                p.setDocument(resultSet.getString("document"));
                p.setForm(resultSet.getString("form"));
                p.setOrgan(resultSet.getString("organ"));
                p.setViadata(resultSet.getString("viadata"));
                p.setPubdata(resultSet.getString("pubdata"));
                p.setPerdata(resultSet.getString("perdata"));
                p.setText(resultSet.getString("text"));
                texts.add(p);
            }
        } catch (SQLException | ClassNotFoundException e) {
            e.printStackTrace();
        }
        return texts;
    }
    public ArrayList<policy> chaxunnameandorgan(int cpage, int count,String name,String organ){
        String sql="select * from policy where  name like ? and organ like ? order by pubdata limit "+((cpage-1)*count)+","+count;
        ArrayList<policy> texts=new ArrayList<>();
        try {
            Connection connection = DButil.getConn();
            PreparedStatement preparedStatement=connection.prepareStatement(sql);
            preparedStatement.setString(1,"%"+name+"%");
            preparedStatement.setString(2,"%"+organ+"%");
            ResultSet resultSet=preparedStatement.executeQuery();
            while(resultSet.next()){
                policy p=new policy();
                p.setId(resultSet.getInt("id"));
                p.setName(resultSet.getString("name"));
                p.setType(resultSet.getString("type"));
                p.setCategory(resultSet.getString("category"));
                p.setRange(resultSet.getString("range"));
                p.setDocument(resultSet.getString("document"));
                p.setForm(resultSet.getString("form"));
                p.setOrgan(resultSet.getString("organ"));
                p.setViadata(resultSet.getString("viadata"));
                p.setPubdata(resultSet.getString("pubdata"));
                p.setPerdata(resultSet.getString("perdata"));
                p.setText(resultSet.getString("text"));
                texts.add(p);
            }
        } catch (SQLException | ClassNotFoundException e) {
            throw new RuntimeException(e);
        }
        return texts;
    }
    public ArrayList<policy> chaxundocumentandorgan(int cpage, int count,String organ,String document){
        String sql="select * from policy  where   organ like ? and document like ? order by pubdata limit "+((cpage-1)*count)+","+count;
        ArrayList<policy> texts=new ArrayList<>();
        try {
            Connection connection = DButil.getConn();
            PreparedStatement preparedStatement=connection.prepareStatement(sql);
            preparedStatement.setString(1,"%"+organ+"%");
            preparedStatement.setString(2,"%"+document+"%");
            ResultSet resultSet=preparedStatement.executeQuery();
            while(resultSet.next()){
                policy p=new policy();
                p.setId(resultSet.getInt("id"));
                p.setName(resultSet.getString("name"));
                p.setType(resultSet.getString("type"));
                p.setCategory(resultSet.getString("category"));
                p.setRange(resultSet.getString("range"));
                p.setDocument(resultSet.getString("document"));
                p.setForm(resultSet.getString("form"));
                p.setOrgan(resultSet.getString("organ"));
                p.setViadata(resultSet.getString("viadata"));
                p.setPubdata(resultSet.getString("pubdata"));
                p.setPerdata(resultSet.getString("perdata"));
                p.setText(resultSet.getString("text"));
                texts.add(p);
            }
        } catch (SQLException | ClassNotFoundException e) {
            throw new RuntimeException(e);
        }
        return texts;
    }

    public int[] alltext(int count){
        String sql="select count(*) from policy";
        int[] s=new int[2];
        try{
            Connection connection=DButil.getConn();
            Statement statement=connection.createStatement();
            ResultSet resultSet=statement.executeQuery(sql);
            while(resultSet.next()){
                s[0]=resultSet.getInt(1);
            }
            if(s[0]%count==0)
                s[1]=s[0]/count;
            else s[1]=s[0]/count+1;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return s;
    }
    public int[] allchaxunname(int count,String name){
        String sql="select count(*) from policy where name like ?";
        int[] s=new int[2];
        try{
            Connection connection=DButil.getConn();
            PreparedStatement statement=connection.prepareStatement(sql);
            statement.setString(1,"%"+name+"%");
            ResultSet resultSet= statement.executeQuery();
            while(resultSet.next()){
                s[0]=resultSet.getInt(1);
            }
            if(s[0]%count==0)
                s[1]=s[0]/count;
            else s[1]=s[0]/count+1;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return s;
    }
    public int[] allchaxundo(int count,String name){
        String sql="select count(*) from policy where document like ?";
        int[] s=new int[2];
        try{
            Connection connection=DButil.getConn();
            PreparedStatement statement=connection.prepareStatement(sql);
            statement.setString(1,"%"+name+"%");
            ResultSet resultSet= statement.executeQuery();
            while(resultSet.next()){
                s[0]=resultSet.getInt(1);
            }
            if(s[0]%count==0)
                s[1]=s[0]/count;
            else s[1]=s[0]/count+1;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return s;
    }
    public int[] allchaxunorgan(int count,String name){
        String sql="select count(*) from policy where organ like ?";
        int[] s=new int[2];
        try{
            Connection connection=DButil.getConn();
            PreparedStatement statement=connection.prepareStatement(sql);
            statement.setString(1,"%"+name+"%");
            ResultSet resultSet= statement.executeQuery();
            while(resultSet.next()){
                s[0]=resultSet.getInt(1);
            }
            if(s[0]%count==0)
                s[1]=s[0]/count;
            else s[1]=s[0]/count+1;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return s;
    }
    public policy getdetail(int id){
        policy p=new policy();
        try{
            Connection connection= DButil.getConn();
            String sql="select * from policy where id=?";
            PreparedStatement preparedStatement=connection.prepareStatement(sql);
            preparedStatement.setInt(1,id);
            ResultSet resultSet=preparedStatement.executeQuery();
            while(resultSet.next()){
                p.setId(resultSet.getInt("id"));
                p.setName(resultSet.getString("name"));
                p.setType(resultSet.getString("type"));
                p.setCategory(resultSet.getString("category"));
                p.setRange(resultSet.getString("range"));
                p.setDocument(resultSet.getString("document"));
                p.setForm(resultSet.getString("form"));
                p.setOrgan(resultSet.getString("organ"));
                p.setViadata(resultSet.getString("viadata"));
                p.setPubdata(resultSet.getString("pubdata"));
                p.setPerdata(resultSet.getString("perdata"));
                p.setText(resultSet.getString("text"));
            }
        }catch (Exception e){
            e.printStackTrace();
        }
        return p;
    }
}

package service;

import bean.policy;
import dao.Dao;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

public class Servlet extends HttpServlet {
    Dao dao=new Dao();

    public void service(HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException {
        request.setCharacterEncoding("UTF-8");
        String message=request.getParameter("method");
        if(message.equals("all")){
            all(request,response);
        }
        else if(message.equals("chakan")){
            chakan(request,response);
        }
        else if(message.equals("suoyou")){
            suoyou(request,response);
        }
        else if(message.equals("chadata")){
            chadata(request,response);
        }
    }
    public void suoyou(HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException{
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        int cpage=1; //当前页数
        int count=10; //每页显示数
        String cp=request.getParameter("cp");
        if(cp!=null){
            cpage=Integer.parseInt(cp);
        }
        int arr[]=dao.alltext(count);
        ArrayList<policy> policies=new ArrayList<>();
        policies=dao.chaxuntext(cpage,count);
        request.setAttribute("policies",policies);
        request.setAttribute("cpage",cpage);
        request.setAttribute("sum",arr[0]);
        request.setAttribute("tpage",arr[1]);
        request.setAttribute("dd","d");
        request.getRequestDispatcher("index.jsp").forward(request,response);
    }
    public void chadata(HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException{
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        int cpage=1; //当前页数
        int count=10; //每页显示数
        String cp=request.getParameter("cp");
        if(cp!=null){
            cpage=Integer.parseInt(cp);
        }
        int[]s = new int[2];
        int zero=0;
        ArrayList<policy> policies=new ArrayList<>();
        String name=request.getParameter("name");
        String document=request.getParameter("document");
        String organ=request.getParameter("organ");
        if(name!=null&&!name.equals("")&&document!=null&&!document.equals("")&&organ!=null&&!organ.equals("")){
            policies=dao.chaxun3(cpage,count,name,document,organ);
        }
        else if(name!=null&&!name.equals("")&&document!=null&&!document.equals("")){
            policies=dao.chaxunnameanddocument(cpage,count,name,document);
        }
        else if(name!=null&&!name.equals("")&&organ!=null&&!organ.equals("")){
            policies=dao.chaxunnameandorgan(cpage,count,name,organ);
        }
        else if(document!=null&&!document.equals("")&&organ!=null&&!organ.equals("")){
            policies=dao.chaxundocumentandorgan(cpage,count,organ,document);
        }
        else if(name!=null&&!name.equals("")){
            policies=dao.chaxunname(cpage,count,name);
            s=dao.allchaxunname(count,name);
        }
        else if(document!=null&&!document.equals("")){
            policies=dao.chaxundocument(cpage,count,document);
            s=dao.allchaxundo(count,document);
        }
        else if(organ!=null&&!organ.equals("")){
            policies=dao.chaxunorgan(cpage,count,organ);
            s=dao.allchaxunorgan(count,organ);
        }
        else{
            request.setAttribute("message","未查询到相关信息");
            request.setAttribute("policies",null);
            request.setAttribute("cpage",zero);
            request.setAttribute("sum",zero);
            request.setAttribute("tpage",zero);

            request.getRequestDispatcher("index.jsp").forward(request,response);
            return;
        }
        if(policies.size()>0)
        request.setAttribute("policies",policies);
        else {
            request.setAttribute("message","未查询到相关信息");
            request.setAttribute("policies",null);
            request.setAttribute("cpage",0);
            request.setAttribute("sum",policies.size());
            request.setAttribute("tpage",policies.size()%10==0?policies.size()/10:policies.size()/10+1);
            request.getRequestDispatcher("index.jsp").forward(request,response);
            return;
        }
        request.setAttribute("cpage",cpage);
        request.setAttribute("sum",s[0]);
        request.setAttribute("name",name);
        request.setAttribute("organ",organ);
        request.setAttribute("document",document);
        request.setAttribute("tpage",s[1]);
        request.setAttribute("dd","dd");
        request.getRequestDispatcher("index.jsp").forward(request,response);
    }
    public void all(HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException {
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        ArrayList<policy> policies=dao.getall();
        request.setAttribute("policies",policies);
        request.getRequestDispatcher("index.jsp").forward(request,response);
    }
    public void chakan(HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException {
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        String id0=request.getParameter("id");
        int id=Integer.parseInt(id0);
        policy p=dao.getdetail(id);
        request.setAttribute("policy",p);
        request.getRequestDispatcher("detail.jsp").forward(request,response);
    }
}

package util;

import java.sql.*;

public class DButil {
    public static Connection getConn() throws ClassNotFoundException {

        Connection connection=null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/st", "root", "byc666");
        }catch(Exception e){
            e.printStackTrace();
        }
        return connection;
    }
    public static void closeall(Connection connection, PreparedStatement preparedStatement, ResultSet resultSet){
        try{
            if(resultSet!=null)
                resultSet.close();
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
        try{
            if(preparedStatement!=null)
                preparedStatement.close();
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
        try{
            if(connection!=null)
                connection.close();
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }

    }
}

<%--
  Created by IntelliJ IDEA.
  User: Lenovo
  Date: 2023/4/10
  Time: 15:43
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
    <link href="table.css" rel="stylesheet">
</head>
<body>
<center>
    <table class="tb" border="0">
        <th>正文</th>
        <tr>
            <td>${policy.text}</td>
        </tr>
    </table>
</center>
</body>
</html>

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="bean.policy" %><%--
  Created by IntelliJ IDEA.
  User: Lenovo
  Date: 2023/4/10
  Time: 15:19
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <link href="table.css" rel="stylesheet">
    <title>Title</title>
</head>
<body>
<center>
<img src="LOGO.png">
</center>
<%
    request.setCharacterEncoding("UTF-8");
    response.setCharacterEncoding("UTF-8");
    Object message=request.getAttribute("message");
    if(message!=null)
    {
        %>
    <script language="JavaScript">alert("<%=message%>")</script>
<%
    }
    ArrayList<policy> policies= (ArrayList<policy>) request.getAttribute("policies");
    if(policies==null){
%>
<form action="Servlet?method=suoyou" method="post">
    <input type="submit" value="查询">
</form>
<%
    }
    else if(policies!=null){
%>
<center>
    <form action="Servlet?method=chadata" method="post">
        政策名称:<input type="text" name="name" placeholder="请输入政策名称" style="border: none">
        发文字号:<input type="text" name="document" placeholder="请输入发文字号" style="border: none">
        发文机构:<input type="text" name="organ" placeholder="请输入发文机构" style="border: none">
        全文检索:<input type="text" name="data" style="border: none">
        <input type="submit" value="搜索">
    </form>
    <br>
    <br>
<table border="0" cellspacing="0">
    <th width="10%">id</th><th width="20%">政策名称</th><th width="20%">发文机构</th><th width="20%">颁布日期</th><th width="20%">政策分类</th><th width="10%">操作</th>
    <c:forEach items="${policies}" var="item">
        <tr>
            <td>${item.id}</td>
            <td>${item.name}</td>
            <td>${item.organ}</td>
            <td>${item.pubdata}</td>
            <td>${item.type}</td>
            <td><a href="Servlet?method=chakan&id=${item.id}" style="text-decoration: none">查看</a> </td>
        </tr>
    </c:forEach>
</table>
    <br>
共${sum}条记录，当前第${cpage}/${tpage}页
    <%
        String dd= request.getAttribute("dd").toString();
        if(Integer.parseInt(request.getAttribute("sum").toString())<10){
        } else if(dd.equals("d")){%>
    <a href="Servlet?method=suoyou&cp=1">首页</a>
    <a href="Servlet?method=suoyou&cp=${cpage-1<=0?1:cpage-1}">上一页</a>
    <a href="Servlet?method=suoyou&cp=${cpage+1>=tpage?tpage:cpage+1}">下一页</a>
    <a href="Servlet?method=suoyou&cp=${tpage}">尾页</a>
    <%
        }
        else if(dd.equals("dd")){%>
    <a href="Servlet?method=chadata&cp=1&name=<%=request.getAttribute("name")%>&document=<%=request.getAttribute("document")%>&organ=<%=request.getAttribute("organ")%>">首页</a>
    <a href="Servlet?method=chadata&cp=${cpage-1<=0?1:cpage-1}&name=<%=request.getAttribute("name")%>&document=<%=request.getAttribute("document")%>&organ=<%=request.getAttribute("organ")%>">上一页</a>
    <a href="Servlet?method=chadata&cp=${cpage+1>=tpage?tpage:cpage+1}&name=<%=request.getAttribute("name")%>&document=<%=request.getAttribute("document")%>&organ=<%=request.getAttribute("organ")%>">下一页</a>
    <a href="Servlet?method=chadata&cp=${tpage}&name=<%=request.getAttribute("name")%>&document=<%=request.getAttribute("document")%>&organ=<%=request.getAttribute("organ")%>">尾页</a>
    <%
        }
    %>
</center>
<%
    }
%>
</body>
</html>

* {
    padding: 0;
    margin: 0;
    font-family: 'Open Sans Light';
    letter-spacing: .05em;
    margin: 0 auto;
    text-align: center;
}
html {
    height: 100%;
}
body {

    height: 100%;
    font: normal 20px auto “Trebuchet MS”, Verdana, Arial, Helvetica, sans-serif;

    color: #4f6b72;

    background: #E6EAE9;

}

a {


    color: #c75f3e;

}

table {
    width: 100%;

    padding: 0;

    margin: 0;

}

caption {


    padding: 0 0 5px 0;

    width: max-content;

    font: italic 30px “Trebuchet MS”, Verdana, Arial, Helvetica, sans-serif;

    text-align: right;

}

th {


    font: bold 30px “Trebuchet MS”, Verdana, Arial, Helvetica, sans-serif;

    color: #4f6b72;

    border: 0;

    letter-spacing: 2px;

    text-transform: uppercase;

    text-align: center;
    height: 40px;

    padding: 6px 6px 6px 12px;

    background: #CAE8EA no-repeat;

    background-size: cover;

}

th.nobg {


    border-top: 0;

    border-left: 0;

    border: 0;

    background: none;

}

td {

    height: 30px;

    border: 0;

    background: #fff;

    font-size:30px;

    color: #4f6b72;

}


th.spec {


    border-left: 1px solid #C1DAD7;

    border-top: 0;

    background: #fff no-repeat;

    font: bold 10px “Trebuchet MS”, Verdana, Arial, Helvetica, sans-serif;

}

th.specalt {


    border-left: 1px solid #C1DAD7;

    border-top: 0;

    background: #f5fafa no-repeat;

    font: bold 10px “Trebuchet MS”, Verdana, Arial, Helvetica, sans-serif;

    color: #797268;

}

td.alt {


    background: #F5FAFA;

    color: #797268;


}

/*———for IE 5.x bug*/

html>body td{ font-size:20px;}

body,td,th {


    font-family: 宋体, Arial;

    font-size: 15px;

}