Last active
July 21, 2020 12:50
-
-
Save cofearabi/5039135 to your computer and use it in GitHub Desktop.
Android sample connect to the mysql server database and get the values of field of table , and display them.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<uses-permission android:name="android.permission.INTERNET"/> | |
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" /> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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(); | |
} | |
} |
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?
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
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.