腾讯个人4.25

help功能的前后端界面

<?xml version="1.0" encoding="utf-8"?>

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

    xmlns:tools="http://schemas.android.com/tools"

    android:layout_width="match_parent"

    android:layout_height="match_parent"

    tools:context=".gridview">

    <GridView

        android:id="@+id/gridview"

        android:layout_width="match_parent"

        android:layout_height="match_parent"

        android:numColumns="auto_fit"

        android:columnWidth="100dp"

        android:verticalSpacing="10dp"

        android:horizontalSpacing="10dp"

        android:stretchMode="columnWidth"

        android:gravity="center"/>

</RelativeLayout>

package com.example.helppeople;

import android.os.AsyncTask;

import android.os.Bundle;

import android.widget.GridView;

import androidx.appcompat.app.AppCompatActivity;

import com.example.helppeople.adapter.HelpAdapter;

import com.example.helppeople.utils.JDBCUtils; // 导入JDBCUtils类

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

public class gridview extends AppCompatActivity {

    private GridView gridView;

    private HelpAdapter adapter;

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_gridview);

        gridView = findViewById(R.id.gridview);

        RetrieveDataTask retrieveDataTask = new RetrieveDataTask();

        retrieveDataTask.execute();

    }

    private class RetrieveDataTask extends AsyncTask<Void, Void, ArrayList<String>> {

        @Override

        protected ArrayList<String> doInBackground(Void... voids) {

            Connection connection = JDBCUtils.getConn();

            ArrayList<String> dataList = new ArrayList<>();

            if (connection != null) {

                try {

                    Statement stmt = connection.createStatement();

                    ResultSet rs = stmt.executeQuery("SELECT * FROM help");

                    while (rs.next()) {

                        String data = rs.getString("money");

                        dataList.add(data);

                    }

                    rs.close();

                    stmt.close();

                    connection.close();

                } catch (SQLException e) {

                    e.printStackTrace();

                }

            }

            return dataList;

        }

        @Override

        protected void onPostExecute(ArrayList<String> dataList) {

            super.onPostExecute(dataList);

            adapter = new HelpAdapter(gridview.this, dataList);

            gridView.setAdapter(adapter);

        }

    }

}