manniru
1/6/2017 - 6:05 PM

Android sample connect to the mysql server database and get the values of field of table , and display them.

Android sample connect to the mysql server database and get the values of field of table , and display them.

<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=".MainActivity" >

    <TextView
        android:id="@+id/textView0"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_centerHorizontal="true"
        android:layout_centerVertical="true"
        android:text="@string/hello_world" />

</RelativeLayout>
package com.example.andmysql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.app.Activity;
import android.widget.TextView;

public class MainActivity extends Activity implements Runnable{

	private String hiduke="";
	private int price=0;
	private String errmsg="";
	
	public void run() {
		  System.out.println("Select Records Example by using the Prepared Statement!");
		  Connection con = null;
		  int count = 0;
		  try{
		  Class.forName("com.mysql.jdbc.Driver");
		  con = DriverManager.getConnection
		("jdbc:mysql://10.0.2.2:3306/stock","root","root");
		  try{
			  String sql;
		//	  sql
		//	  = "SELECT title,year_made FROM movies WHERE year_made >= ? AND year_made <= ?";
			  sql 
			  = "SELECT hiduke,jikan,code,price FROM table_stock";
		  PreparedStatement prest = con.prepareStatement(sql);
		  //prest.setInt(1,1980);
		  //prest.setInt(2,2004);
		  ResultSet rs = prest.executeQuery();
		  while (rs.next()){
		   hiduke = rs.getString(1);
		   price = rs.getInt(4);
		  count++;
		  System.out.println(hiduke + "\t" + "- " + price);
		  }
		  System.out.println("Number of records: " + count);
		  prest.close();
		  con.close();
		  }
		  catch (SQLException s){
		  System.out.println("SQL statement is not executed!");
		  errmsg=errmsg+s.getMessage();

		  }
		  }
		  catch (Exception e){
		  e.printStackTrace();
		  errmsg=errmsg+e.getMessage();
		  }

		  handler.sendEmptyMessage(0);
		
	}
	private Handler handler = new Handler() {
	      public void handleMessage(Message msg) {
	    	  
	          TextView textView = (TextView) findViewById(R.id.textView0);  
	          textView.setText("hiduke="+hiduke+" price="+price+" "+errmsg);  
	      }
	   };

	
	
	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
		
		
		Thread thread = new Thread(this);
	    thread.start();   
				  
		
		
		
	}


}
<uses-permission android:name="android.permission.INTERNET"/>
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />