import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import android.app.Activity;
import android.os.Bundle;
import android.widget.Toast;
public class sampleActivity extend Activity {
@Override
public void onCreate(Bundle savedInstanceState){
super.onCreate(savedInstanceSate);
setContentView(R.layout.main);
try {
Connection con = MySqlConnect.getConnection();
Statement stmt = (Statement) con.createStatement();
String mySql = "select date from table;";
ResultSet rs = stmt.executeQuery(mySql);
while(rs.next()){
Toast.makeText(getApplicationContext(), rs.getString("date"), Toast.LENGTH_LONG).show();
}
rs.close();
stmt.close();
con.close();
} catch(Exception e){
}
}
}
import java.sql.*;
class MySqlConnect{
static Connection getConnection() throws Exception {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://xxx.xxx.xxx/db_name";
String user = "user_name";
String pass = "password";
Connection con = DriverManager.getConnection(url, user,pass);
return con;
}
}