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

AndroidManifest.xml

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

main_activity.xml

<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>

MainActivity.java

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();   
				  
		
		
		
	}


}

i am a beginner..
so can u help me for creating a server like yours
and 1 more thing what .jar files i have to add in my app and how to work this out?
thank you

Hi, I have concern with connection of my app to sql server, once the app launch its fast to connect but for the second time to connect its takes long time to connect again...what will be my option to avoid..Thanks in advance!

Hi , am having an exception "Can not connect to database" can u help me?

Thanks bro it helped me I wasted alot of time for this earlier.

Thanks for the code u save my day :)
I cant connect database with my own connection code

Is this code for a connection to Google's Sql Cloud?

From where to get this "10.0.2.2:3306"?

This looks like a bad idea.
Think about it you are exposing a MySQL/MariaDB username/password in a java application which can be decompiled if people know how to get the APK from thier phone on their computers.

Best way to do this is with a web based API and protocols like REST, SOAP or XML-RPC which does the MySQL/MariaDB connection.

Hallo. I also would like to know know where you get this ip "10.0.2.2"?

REST, SOAP or XML-RPC

Do you know any good (and simple) example to perform the same task using REST or SOAP?