安卓端连接数据库

 protected Boolean doInBackground(String... params) {
            String keyword = params[0];
            // 日志：打印输入的关键词
            Log.d("QueryTask", "【QueryTask】接收到的查询关键词：" + keyword);
            try {
                Class.forName("com.mysql.jdbc.Driver"); // 旧版驱动类名
                String url = "jdbc:mysql://192.168.243.67:3306/db1?allowPublicKeyRetrieval=true&useSSL=false";
                Connection connection = DriverManager.getConnection(url, "root", "1019");
                // 日志：数据库连接成功
                Log.d("QueryTask", "【QueryTask】成功建立数据库连接");

                Statement statement = connection.createStatement();
                String query = "SELECT name, text FROM policy WHERE name LIKE '%" + keyword + "%'";
                ResultSet resultSet = statement.executeQuery(query);

                while (resultSet.next()) {
                    names.add(resultSet.getString("name"));
                    texts.add(resultSet.getString("text"));
                }

                resultSet.close();
                statement.close();
                connection.close();
                return true;
            } catch (Exception e) {
                errorMessage = "数据库连接失败：" + e.getMessage();
                // 日志：打印异常信息
                Log.e("QueryTask", "【QueryTask】数据库操作出现异常", e);
                return false;
            }
        }