每日总结4.14

package Dao;

import Bean.Menu;

import Bean.bean;

 

import DBUtil.dbutil;

 

import java.io.Reader;

import java.sql.*;

import java.util.ArrayList;

import java.util.List;

 

public class dao {

 

    public List<bean> searchAll( ){

        List<bean> list = new ArrayList<bean>();

        try {

            Connection conn = dbutil.getConn();

            Statement state = null;

            String sql="select * from policy";

            PreparedStatement  pstmt = conn.prepareStatement(sql);

            ResultSet rs = pstmt.executeQuery();

            System.out.println("搜索全部政策");

            while(rs.next()){

                bean lu = new bean();

 

                lu.setId(rs.getString("id"));

                lu.setType(rs.getString("type"));

                lu.setOrgan(rs.getString("organ"));

                lu.setPubdata(rs.getString("pubdata"));

                lu.setName(rs.getString("name"));

                list.add(lu);

 

            }

            rs.close();

            pstmt.close();

            conn.close();

        }catch(SQLException e) {

 

            System.out.println("发生错误");

            e.printStackTrace();

 

 

        }

 

 

        return list;

 

    }

 

 

    public List<bean> search(String name,String document,String organ){

        List<bean> list = new ArrayList<bean>();

        try {

            Connection conn = dbutil.getConn();

            Statement state = null;

 

 

 

            String sql = "select * from policy where name REGEXP '"+name+"' and document REGEXP '"+document+"' and organ REGEXP '"+organ+"'";

 

            PreparedStatement  pstmt = conn.prepareStatement(sql);

 

            ResultSet rs = pstmt.executeQuery();

            System.out.println("多项条件搜索运行中");

            while(rs.next()){

 

                bean lu = new bean();

 

                lu.setId(rs.getString("id"));

                lu.setType(rs.getString("type"));

                lu.setOrgan(rs.getString("organ"));

                lu.setPubdata(rs.getString("pubdata"));

                lu.setName(rs.getString("name"));

                list.add(lu);

 

 

            }

            rs.close();

            pstmt.close();

            conn.close();

        }catch(SQLException e) {

 

            System.out.println("发生错误");

            e.printStackTrace();

 

 

        }

 

 

        return list;

 

    }

 

    public static bean getOne(String id){

        bean lu = new bean();

        try {

            Connection conn = dbutil.getConn();

            Statement state = null;

            String sql="select * from policy where id=?";

            PreparedStatement  pstmt = conn.prepareStatement(sql);

            pstmt.setString(1,id);

            ResultSet rs = pstmt.executeQuery();

            while(rs.next()){

 

                lu.setId(rs.getString("id"));

                lu.setType(rs.getString("type"));

                lu.setCategory(rs.getString("category"));

                lu.setOrgan(rs.getString("organ"));

                lu.setPubdata(rs.getString("pubdata"));

                lu.setName(rs.getString("name"));

                lu.setDocument(rs.getString("document"));

                lu.setRange(rs.getString("range"));

                lu.setPerdata(rs.getString("perdata"));

                lu.setViadata(rs.getString("viadata"));

                lu.setText(rs.getString("text"));

 

            }

            rs.close();

            pstmt.close();

            conn.close();

        }

        catch(SQLException e) {

 

            e.printStackTrace();

        }

        return lu;

 

    }

 

   

}