5.24

政务查询系统安卓
• 所花时间：3
• 代码行数：271
• 博客容量：1
• 代码如下：

package entity;

import android.content.Context;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.BaseAdapter;
import android.widget.TextView;

import com.example.androidpolicy.R;

import java.util.List;

public class PolicyAdapter extends BaseAdapter {
    private Context context;
    private List<Policy> policies;

    public PolicyAdapter(Context context, List<Policy> policies) {
        this.context = context;
        this.policies = policies;
    }

    @Override
    public int getCount() {
        return policies.size();
    }

    @Override
    public Object getItem(int position) {
        return policies.get(position);
    }

    @Override
    public long getItemId(int position) {
        return position;
    }

    @Override
    public View getView(int position, View convertView, ViewGroup parent) {
        if (convertView == null) {
            convertView = LayoutInflater.from(context).inflate(R.layout.item_policy, parent, false);
        }

        Policy policy = policies.get(position);

        TextView titleTextView = convertView.findViewById(R.id.policyTitle);
        titleTextView.setText(policy.getName());

        return convertView;
    }
}

package entity;

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

public class PolicyDAO {
    private final String driver = "com.mysql.jdbc.Driver";
    private static String url = "jdbc:mysql://172.18.33.232:3306/party?useUnicode=true&characterEncoding=UTF-8";
    private static String user = "root";
    private static String password = "1234";

    //查询所有Policy
    public List<Policy> queryAll() {
        List<Policy> policies = new ArrayList<>();
        try {
            Class.forName(driver);
            Connection conn = DriverManager.getConnection(url, user, password);
            String sql = "SELECT * FROM policy";
            PreparedStatement ps = conn.prepareStatement(sql);
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                Policy policy = new Policy();
                populatePolicyFromResultSet(policy, rs);
                policies.add(policy);
            }
            rs.close();
            ps.close();
            conn.close();
        } catch (ClassNotFoundException | SQLException e) {
            throw new RuntimeException(e);
        }
        return policies;
    }

    //查询range河北省Policy
    public List<Policy> queryByRange(String range) {
        List<Policy> policies = new ArrayList<>();
        try {
            Class.forName(driver);
            Connection conn = DriverManager.getConnection(url, user, password);
            String sql = "SELECT * FROM policy WHERE `range` = ?";
            PreparedStatement ps = conn.prepareStatement(sql);
            ps.setString(1, range);
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                Policy policy = new Policy();
                populatePolicyFromResultSet(policy, rs);
                policies.add(policy);
            }
            rs.close();
            ps.close();
            conn.close();
        } catch (ClassNotFoundException | SQLException e) {
            throw new RuntimeException(e);
        }
        return policies;
    }

    //查询所有type名称Policy
    public List<String> queryAllTypes() {
        List<String> types = new ArrayList<>();
        try {
            Class.forName(driver);
            Connection conn = DriverManager.getConnection(url, user, password);
            String sql = "SELECT DISTINCT type FROM policy";
            PreparedStatement ps = conn.prepareStatement(sql);
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                types.add(rs.getString("type"));
            }
            rs.close();
            ps.close();
            conn.close();
        } catch (ClassNotFoundException | SQLException e) {
            throw new RuntimeException(e);
        }
        return types;
    }

    //查询指定type类型的Policy
    public List<Policy> queryByType(String type) {
        List<Policy> policies = new ArrayList<>();
        try {
            Class.forName(driver);
            Connection conn = DriverManager.getConnection(url, user, password);
            String sql = "SELECT * FROM policy WHERE type = ?";
            PreparedStatement ps = conn.prepareStatement(sql);
            ps.setString(1, type);
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                Policy policy = new Policy();
                populatePolicyFromResultSet(policy, rs);
                policies.add(policy);
            }
            rs.close();
            ps.close();
            conn.close();
        } catch (ClassNotFoundException | SQLException e) {
            throw new RuntimeException(e);
        }
        return policies;
    }

    // Helper method to populate Policy object from ResultSet
    private void populatePolicyFromResultSet(Policy policy, ResultSet rs) throws SQLException {
        policy.setId(rs.getLong("id"));
        policy.setName(rs.getString("name"));
        policy.setType(rs.getString("type"));
        policy.setCategory(rs.getString("category"));
        policy.setRange(rs.getString("range"));
        policy.setDocument(rs.getString("document"));
        policy.setForm(rs.getString("form"));
        policy.setOrgan(rs.getString("organ"));
        policy.setViadata(rs.getDate("viadata"));
        policy.setPubdata(rs.getDate("pubdata"));
        policy.setPerdata(rs.getDate("perdata"));
        policy.setField(rs.getString("field"));
        policy.setTheme(rs.getString("theme"));
        policy.setKeyword(rs.getString("keyword"));
        policy.setSuperior(rs.getString("superior"));
        policy.setPrecursor(rs.getString("precursor"));
        policy.setSucceed(rs.getString("succeed"));
        policy.setState(rs.getString("state"));
        policy.setText(rs.getString("text"));
        policy.setPdf(rs.getString("pdf"));
        policy.setRedundancy(rs.getString("redundancy"));
        policy.setRank(rs.getString("rank"));
        policy.setPolicykey(rs.getString("policykey"));
        policy.setNewrank(rs.getString("newrank"));
        policy.setYear(rs.getString("year"));
        policy.setNewkey(rs.getString("newkey"));
        policy.setSecondtheme(rs.getString("secondtheme"));
        policy.setAllsum(rs.getInt("allsum"));
    }
}