Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
Android sample connect to the mysql server database and get the values of field of table , and display them.
<uses-permission android:name="android.permission.INTERNET"/>
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
<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();
}
}

Hi, thanks, it's the first code that I try right away and works out! May I see a screenshot of the table you uploaded on the server, please? I'd like to see if you took the whole column or the value of a particular row! Thanks in advance!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment