php - 试图从数据库中获取信息-6ren

php - 试图从数据库中获取信息

转载作者：行者123 更新时间：2023-11-29 06:09:34

我试图从数据库中获取信息并将其写入 TextView 以在输入订单名称后显示数据库中的信息

package com.example.mauricio.pairlines;

import android.content.Intent;
import android.support.v7.app.AlertDialog;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;

import com.android.volley.RequestQueue;
import com.android.volley.Response;
import com.android.volley.toolbox.Volley;

import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;

public class Seeorder extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_seeorder);
        final EditText etOrdernum = (EditText) findViewById(R.id.etOrdernum);
        final TextView tvPilotname = (TextView) findViewById(R.id.tvPilotname);
        final TextView tvPilotcash = (TextView) findViewById(R.id.tvPilotcash);
        final TextView tvDate = (TextView) findViewById(R.id.tvDate);
        final TextView tvPlanemodel = (TextView) findViewById(R.id.tvPlanemodel);
        final TextView tvHoobsstart = (TextView) findViewById(R.id.tvHoobsstart);
        final TextView tvHoobsend = (TextView) findViewById(R.id.tvHoobsend);
        final TextView tvWatchtime = (TextView) findViewById(R.id.tvWatchtime);
        final TextView tvHoobstime = (TextView) findViewById(R.id.tvHoobstime);
        final TextView tvGas = (TextView) findViewById(R.id.tvGas);
        final TextView tvLiter = (TextView) findViewById(R.id.etLiter);
        final TextView tvRepairname = (TextView) findViewById(R.id.tvRepairname);
        final TextView tvRepaircost = (TextView) findViewById(R.id.tvRepaircost);
        final TextView tvTravelexpense = (TextView) findViewById(R.id.tvTravelexpense);
        final TextView tvOthername1 = (TextView) findViewById(R.id.tvOthername1);
        final TextView tvOthercost1 = (TextView) findViewById(R.id.tvOthercost1);
        final Button bTickets = (Button) findViewById(R.id.bTickets);
        final Button bBack = (Button) findViewById(R.id.bBack);
        final Button btSerach = (Button) findViewById(R.id.bSerach);

        btSerach.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {

                final String ordernum = etOrdernum.getText().toString();


                Response.Listener<String> responseListener = new Response.Listener<String>() {
                    @Override
                    public void onResponse(String response) {
                        try {
                            JSONObject jsonResponse = new JSONObject(response);
                            int succees = jsonResponse.getInt("success");

                            if(succees==1){
                                JSONArray array = jsonResponse.getJSONArray("myorder");
                                JSONObject jsonName1 = array.getJSONObject(0);
                                String ordernum= jsonName1.getString("ordernum")+" Numero de orden";
                                JSONObject jsonName2 = array.getJSONObject(1);
                                String pilotname= jsonName2.getString("pilotname")+" Nombre del piloto";
                                JSONObject jsonName3 = array.getJSONObject(2);
                                String pilotcash= jsonName3.getString("pilotcash")+"$ Sueldo del piloto";
                                JSONObject jsonName4 = array.getJSONObject(3);
                                String date= jsonName4.getString("date")+" Fecha ";
                                JSONObject jsonName5 = array.getJSONObject(4);
                                String planemodel= jsonName5.getString("planemodel")+" Modelo del avion";
                                JSONObject jsonName6 = array.getJSONObject(5);
                                String hoobsstart= jsonName6.getString("hoobsstart")+" Hoobs inicio";
                                JSONObject jsonName7 = array.getJSONObject(6);
                                String hoobsend= jsonName7.getString("hoobsend")+"Hoobs final";
                                JSONObject jsonName8 = array.getJSONObject(7);
                                String watchtime= jsonName8.getString("watchtime")+" Watch time";
                                JSONObject jsonName9 = array.getJSONObject(8);
                                String hoobstime= jsonName9.getString("hoobstime")+" Hoobstime";
                                JSONObject jsonName10 = array.getJSONObject(9);
                                String gas= jsonName10.getString("gas")+" Combustible";
                                JSONObject jsonName11 = array.getJSONObject(10);
                                String liter= jsonName11.getString("liter")+" litros de combustible";
                                JSONObject jsonName12 = array.getJSONObject(11);
                                String repairname= jsonName12.getString("repairname")+" Nombre de refaccion";
                                JSONObject jsonName13 = array.getJSONObject(12);
                                String repaircost= jsonName13.getString("repaircost")+"$ Costo de refaccion";
                                JSONObject jsonName14 = array.getJSONObject(13);
                                String travelexpense= jsonName14.getString("travelexpense")+"$ Costo viaticos";
                                JSONObject jsonName15 = array.getJSONObject(13);
                                String othername1= jsonName15.getString("othername1")+"$ Otros Concepto";
                                JSONObject jsonName16 = array.getJSONObject(13);
                                String othercost1= jsonName16.getString("othercost1")+"$ Otros precio";





                                tvPilotname.setText(pilotname);
                                tvPilotcash.setText(pilotcash);
                                tvDate.setText(date);
                                tvPlanemodel.setText(planemodel);
                                tvHoobsstart.setText(hoobsstart);
                                tvHoobsend.setText(hoobsend);
                                tvWatchtime.setText(watchtime);
                                tvHoobstime.setText(hoobstime);
                                tvGas.setText(gas);
                                tvLiter.setText(liter);
                                tvRepairname.setText(repairname);
                                tvRepaircost.setText(repaircost);
                                tvTravelexpense.setText(travelexpense);
                                tvOthername1.setText(othername1);
                                tvOthercost1.setText(othercost1);





                            }else{
                                AlertDialog.Builder builder = new AlertDialog.Builder(Seeorder.this);
                                builder.setMessage("La orden no existe")
                                        .setNegativeButton("Retry",null)
                                        .create()
                                        .show();
                            }

                        } catch (JSONException e) {
                            e.printStackTrace();
                        }


                    }
                };

                SeeorderRequest seeorderRequest = new SeeorderRequest(ordernum, responseListener);
                RequestQueue queue = Volley.newRequestQueue(Seeorder.this);
                queue.add(seeorderRequest);
                bBack.setOnClickListener(new View.OnClickListener() {
                    @Override
                    public void onClick(View view) {
                        Intent registerIntent =new Intent(Seeorder.this, UserArea.class);
                        Seeorder.this.startActivity(registerIntent);
                    }
                });

            }
        });
    }
}

这是日志

08-25 14:36:55.833 4782-4782/com.example.mauricio.pairlines W/System.err: org.json.JSONException: Index 1 out of range [0..1)
08-25 14:36:55.833 4782-4782/com.example.mauricio.pairlines W/System.err:     at org.json.JSONArray.get(JSONArray.java:293)
08-25 14:36:55.833 4782-4782/com.example.mauricio.pairlines W/System.err:     at org.json.JSONArray.getJSONObject(JSONArray.java:521)
08-25 14:36:55.833 4782-4782/com.example.mauricio.pairlines W/System.err:     at com.example.mauricio.pairlines.Seeorder$1$1.onResponse(Seeorder.java:70)
08-25 14:36:55.833 4782-4782/com.example.mauricio.pairlines W/System.err:     at com.example.mauricio.pairlines.Seeorder$1$1.onResponse(Seeorder.java:59)
08-25 14:36:55.833 4782-4782/com.example.mauricio.pairlines W/System.err:     at com.android.volley.toolbox.StringRequest.deliverResponse(StringRequest.java:60)
08-25 14:36:55.833 4782-4782/com.example.mauricio.pairlines W/System.err:     at com.android.volley.toolbox.StringRequest.deliverResponse(StringRequest.java:30)
08-25 14:36:55.833 4782-4782/com.example.mauricio.pairlines W/System.err:     at com.android.volley.ExecutorDelivery$ResponseDeliveryRunnable.run(ExecutorDelivery.java:99)
08-25 14:36:55.833 4782-4782/com.example.mauricio.pairlines W/System.err:     at android.os.Handler.handleCallback(Handler.java:739)
08-25 14:36:55.833 4782-4782/com.example.mauricio.pairlines W/System.err:     at android.os.Handler.dispatchMessage(Handler.java:95)
08-25 14:36:55.833 4782-4782/com.example.mauricio.pairlines W/System.err:     at android.os.Looper.loop(Looper.java:135)
08-25 14:36:55.833 4782-4782/com.example.mauricio.pairlines W/System.err:     at android.app.ActivityThread.main(ActivityThread.java:5254)
08-25 14:36:55.833 4782-4782/com.example.mauricio.pairlines W/System.err:     at java.lang.reflect.Method.invoke(Native Method)
08-25 14:36:55.834 4782-4782/com.example.mauricio.pairlines W/System.err:     at java.lang.reflect.Method.invoke(Method.java:372)
08-25 14:36:55.834 4782-4782/com.example.mauricio.pairlines W/System.err:     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:902)
08-25 14:36:55.834 4782-4782/com.example.mauricio.pairlines W/System.err:     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:697)
08-25 14:37:04.248 4782-4782/com.example.mauricio.pairlines I/ViewRootImpl: CPU Rendering VSync enable = false
08-25 14:37:07.594 4782-4782/com.example.mauricio.pairlines I/Timeline: Timeline: Activity_idle id: android.os.BinderProxy@2c32922a time:3689475
08-25 14:37:09.092 4782-4782/com.example.mauricio.pairlines I/Timeline: Timeline: Activity_launch_request id:com.example.mauricio.pairlines time:3690974
08-25 14:37:09.203 4782-4782/com.example.mauricio.pairlines I/ViewRootImpl: CPU Rendering VSync enable = false
08-25 14:37:09.392 4782-4821/com.example.mauricio.pairlines D/OpenGLRenderer: endAllStagingAnimators on 0xb75eb718 (RippleDrawable) with handle 0xb765d220
08-25 14:37:09.398 4782-4782/com.example.mauricio.pairlines I/Timeline: Timeline: Activity_idle id: android.os.BinderProxy@2e649e84 time:3691280
08-25 14:37:10.182 4782-4782/com.example.mauricio.pairlines I/ViewRootImpl: CPU Rendering VSync enable = false
08-25 14:37:10.452 4782-4782/com.example.mauricio.pairlines I/ViewRootImpl: CPU Rendering VSync enable = false
08-25 14:37:19.005 4782-4782/com.example.mauricio.pairlines W/System.err: org.json.JSONException: Index 1 out of range [0..1)
08-25 14:37:19.005 4782-4782/com.example.mauricio.pairlines W/System.err:     at org.json.JSONArray.get(JSONArray.java:293)
08-25 14:37:19.005 4782-4782/com.example.mauricio.pairlines W/System.err:     at org.json.JSONArray.getJSONObject(JSONArray.java:521)
08-25 14:37:19.005 4782-4782/com.example.mauricio.pairlines W/System.err:     at com.example.mauricio.pairlines.Seeorder$1$1.onResponse(Seeorder.java:70)
08-25 14:37:19.005 4782-4782/com.example.mauricio.pairlines W/System.err:     at com.example.mauricio.pairlines.Seeorder$1$1.onResponse(Seeorder.java:59)
08-25 14:37:19.005 4782-4782/com.example.mauricio.pairlines W/System.err:     at com.android.volley.toolbox.StringRequest.deliverResponse(StringRequest.java:60)
08-25 14:37:19.005 4782-4782/com.example.mauricio.pairlines W/System.err:     at com.android.volley.toolbox.StringRequest.deliverResponse(StringRequest.java:30)
08-25 14:37:19.006 4782-4782/com.example.mauricio.pairlines W/System.err:     at com.android.volley.ExecutorDelivery$ResponseDeliveryRunnable.run(ExecutorDelivery.java:99)
08-25 14:37:19.006 4782-4782/com.example.mauricio.pairlines W/System.err:     at android.os.Handler.handleCallback(Handler.java:739)
08-25 14:37:19.006 4782-4782/com.example.mauricio.pairlines W/System.err:     at android.os.Handler.dispatchMessage(Handler.java:95)
08-25 14:37:19.006 4782-4782/com.example.mauricio.pairlines W/System.err:     at android.os.Looper.loop(Looper.java:135)
08-25 14:37:19.006 4782-4782/com.example.mauricio.pairlines W/System.err:     at android.app.ActivityThread.main(ActivityThread.java:5254)
08-25 14:37:19.006 4782-4782/com.example.mauricio.pairlines W/System.err:     at java.lang.reflect.Method.invoke(Native Method)
08-25 14:37:19.006 4782-4782/com.example.mauricio.pairlines W/System.err:     at java.lang.reflect.Method.invoke(Method.java:372)
08-25 14:37:19.006 4782-4782/com.example.mauricio.pairlines W/System.err:     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:902)
08-25 14:37:19.006 4782-4782/com.example.mauricio.pairlines W/System.err:     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:697)

如果我使用 postman 发送 ordernum，这是我从数据库得到的响应

{"success":1,"myorder":[{"ordernum":"1","pilotname":"1","pilotcash":"2","date":"3","planemodel":"4","hoobsstart":"5","hoobsend":"6","watchtime":"7","hoobstime":"8","gas":"9","liter":null,"repairname":"11","repaircost":"12","travelexpense":null,"othername1":"14","othercost1":"15"}]}

问题是我什至无法在 logcat 上找到问题它似乎是这个JSONException:索引 1 超出范围 [0..1)，我认为这意味着插槽 1 中的 myorder 数组上没有任何内容，但它应该是一个“pilotname”:“1”

最佳答案

您只需要对 if 语句进行一点重构，因为数组只有一个项目:

if(succees==1){
   JSONArray array = jsonResponse.getJSONArray("myorder");
   JSONObject orderObj = array.getJSONObject(0);

   String ordernum= orderObj.getString("ordernum")+" Numero de orden";
   String pilotname= orderObj.getString("pilotname")+" Nombre del piloto";
   String pilotcash= orderObj.getString("pilotcash")+"$ Sueldo del piloto";
   String date= orderObj.getString("date")+" Fecha ";
   String planemodel= orderObj.getString("planemodel")+" Modelo del avion";
   String hoobsstart= orderObj.getString("hoobsstart")+" Hoobs inicio";
   String hoobsend= orderObj.getString("hoobsend")+"Hoobs final";
   String watchtime= orderObj.getString("watchtime")+" Watch time";
   String hoobstime= orderObj.getString("hoobstime")+" Hoobstime";
   String gas= orderObj.getString("gas")+" Combustible";
   String liter= orderObj.getString("liter")+" litros de combustible";
   String repairname= orderObj.getString("repairname")+" Nombre de refaccion";
   String repaircost= orderObj.getString("repaircost")+"$ Costo de refaccion";
   String travelexpense= orderObj.getString("travelexpense")+"$ Costo viaticos";
   String othername1= orderObj.getString("othername1")+"$ Otros Concepto";
   String othercost1= orderObj.getString("othercost1")+"$ Otros precio";

Take a look at this article too: http://www.technotalkative.com/android-json-parsing/

关于php - 试图从数据库中获取信息，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/39153824/

c++ - 试图 Cout 函数的返回
我是 C++ 的新手，我在使用这段代码时遇到了问题: string output_date(int day, int month, int year){ string date; if
linux - 试图 tar 一个目录而不是列出目录
所以我这样做了 tar cvzf test.zip FP 为了创建目录 FP 的 zip 但是，它会列出 zip 中的目录 FP/ FP/php/ FP/php/pdf/ FP/php/docs/ F
swift - 试图 swift 概括
我正在尝试在 Swift、Xcode 7.3(所以是 Swift 2.2)中创建一个通用类，但我似乎无法让它通过编译器: protocol Struct1Protocol { } struct Str
PHPUnit - 试图@cover 不存在的方法
我的测试用例是这样的: class FooTest extends PHPUnit_Framework_TestCase { /** @covers MyClass::bar */ f
homebrew - SHA256不匹配，试图 brew Wine
我正在尝试将brew install wine作为使electron-builder工作的一步。但是我所能得到的只是以下响应: ==> Installing dependencies for wine
c# - 试图 int.parse 多数组字符串
我这样做: string[,] string1 = {{"one", "0"},{"Two", "5"},{"Three","1"}}; int b = 0; for(int i = 0; i <=
c++ - 试图 Hook Notepad.exe
我正在尝试使用 SetWindowsHookEx 键盘 Hook Notepad.exe。如您所见，工作线程正在将其 ASCII 代码(即 wParam)发送到指定的服务器。 UINT WINAPI
java - android listview null 试图 setAdapter()
我正在尝试将 ListView 实现到我的 Fragment 中，但无论我尝试什么，我都会得到一个 NullPointerException。我检查对象是否为 null 并记录是否为 null，看起来
html - 试图 float 两个 div 但有问题
我尝试在一行中对齐两个 div。使用 float left 属性，一切顺利。但是当我在 div 中使用图像时，它开始产生问题。所以这是我的示例代码:- Some headi
python-3.x - 试图 reshape 我的 numpy 数组以获得额外的维度
我目前正在使用此代码来获取图像的灰度图像表示并以 (512, 370, 1) 的格式表示它大批。 img_instance = cv2.imread(df.iloc[i][x_col]) / 255.
c++ - 试图 Hook 一个窗口的窗口过程。 SetWindowsHookEx 失败返回 NULL HHOOK 并且 GetLastError 返回错误代码 126
总结我正在创建一个简单的应用程序，它允许用户选择一个包含顶级窗口的进程。用户首先键入 native DLL(而非托管 DLL)的路径。然后用户键入将在 Hook 过程中调用的方法的名称。该方法不得返

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

php - 试图从数据库中获取信息