-
-
Save cofearabi/5039135 to your computer and use it in GitHub Desktop.
<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(); | |
} | |
} |
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?
Hi , am having an exception "Can not connect to database" can u help me?