每日总结-政策查询
所花时间：2小时
代码量：如下：
博客量：本学期截至目前45篇
了解到的知识点：政策查询
上午没课，学了一会代码，然后下午上了王建民老师的课程，建民老师让我们实现科技查询政策的一些代码，按发布时间顺序，并且政策当鼠标点过去之后才能显示完整的内容，到了晚上继续搞了搞这个代码。
相关代码：
servlet：
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);
}
}
Dao：
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;
}
}
浙公网安备 33010602011771号