android获取mysql数据_android中使用Volley从mysql获取数据

根据这段视频

https://www.youtube.com/watch?v=XbDhQJe8d9o&list=PLshdtb5UWjSraOqG1iZW-8mDkJXe3LSL0&index=13

我试图从数据库中获取详细信息。但这不起作用。这是我的json格式的数据显示[{“Hour_code”:“8”,“timefr”:“15:50:00”,“timrto”:“14:40:00”}]。我根据视频所做的每一行都没有发生任何事情

日计划活动.java

TextView Factoryname,Hours,response,actqty;

private String facname,fccode;

private EditText addqty;

private ImageButton btnadd;

private Button viewbutton;

private String hourfr,hourto,hourcode,brcode,currenttime,lineno;

private Spinner linecode;

AlertDialog.Builder builder;

private String url="http://192.168.8.100/android/getdayplantime.php";

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_day_plan);

Hours = (TextView) findViewById(R.id.txthours);

Factoryname = (TextView) findViewById(R.id.txtfactoryname);

response=(TextView)findViewById(R.id.txtresponse);

actqty=(TextView)findViewById(R.id.txtactqty);

addqty=(EditText)findViewById(R.id.txtaddqty);

btnadd=(ImageButton)findViewById(R.id.btnadd);

viewbutton=(Button)findViewById(R.id.btnview);

linecode=(Spinner)findViewById(R.id.spinnerlno);

builder=new AlertDialog.Builder(DayPlanActivity.this);

facname=getIntent().getStringExtra("Factoryname");

String Code[]=facname.split(",");

Factoryname.setText(Code[1]);

fccode=Code[1];

viewbutton.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View view) {

brcode=fccode;

StringRequest stringRequest = new StringRequest(Request.Method.POST,url,

new Response.Listener() {

@Override

public void onResponse(String response) {

try {

JSONArray jsonArray=new JSONArray(response);

JSONObject jsonObject=jsonArray.getJSONObject(0);

String code=jsonObject.getString("Code");

if(code.equals("Error"))

{

builder.setTitle("Time Frame Error");

displayalert(jsonObject.getString("message"));

}

else

{

Intent intent=new Intent(DayPlanActivity.this,Add_ProductDetActivity.class);

Bundle bundle=new Bundle();

bundle.putString("fr",jsonObject.getString("timefr"));

bundle.putString("to",jsonObject.getString("timeto"));

intent.putExtras(bundle);

startActivity(intent);

}

} catch (JSONException e) {

e.printStackTrace();

}

}

}, new Response.ErrorListener() {

@Override

public void onErrorResponse(VolleyError error) {

Toast.makeText(DayPlanActivity.this,"Error",Toast.LENGTH_SHORT).show();

error.printStackTrace();

}

})

{

@Override

protected Map getParams() throws AuthFailureError {

Map params=new HashMap();

params.put("branch_code",brcode);

params.put("line_number","L01");

params.put("current_time","15:04:00");

return params;

}

};

MySingleton.getInstance(DayPlanActivity.this).addToRequestque(stringRequest);

}

});

}

public void displayalert(String message)

{

builder.setMessage(message);

builder.setPositiveButton("OK", new DialogInterface.OnClickListener() {

@Override

public void onClick(DialogInterface dialogInterface, int i) {

}

});

AlertDialog alertDialog=builder.create();

alertDialog.show();

}

MySingleton.java

private static MySingleton mInstance;

private RequestQueue requestQueue;

private static Context mctx;

private MySingleton(Context context)

{

mctx=context;

requestQueue = getRequestQueue();

}

public RequestQueue getRequestQueue()

{

if(requestQueue==null)

{

requestQueue = Volley.newRequestQueue(mctx.getApplicationContext());

}

return requestQueue;

}

public static synchronized MySingleton getInstance(Context context)

{

if(mInstance==null)

{

mInstance=new MySingleton(context);

}

return mInstance;

}

public void addToRequestque(Request request)

{

requestQueue.add(request);

}