Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
swdev:android:database_mysql [2018/05/02 15:48]
smayr [MainActivity] 		swdev:android:database_mysql [2018/05/02 17:22] (current)
smayr
Line 1: Line 1:
 = Database: MySQL = = Database: MySQL =
 +== Using RESTful API ==
 +
 +== Using Java Connector (no API) ==
 ==== DB Connector ==== ==== DB Connector ====
 Download the appropriate Java database connector: Download the appropriate Java database connector:
Line 48: Line 51:
 public class DbStrings public class DbStrings
 { {
-  static final String DATABASE_URL  = "192.168.0.1:3306"; +    static final String DATABASE_URL  = "192.168.0.1:3306"; 
-  static final String DATABASE_NAME = "mydatabase"; +    static final String DATABASE_NAME = "mydatabase"; 
-  static final String USERNAME      = "dbuser"; +    static final String USERNAME      = "dbuser"; 
-  static final String PASSWORD      = "dbsecret";+    static final String PASSWORD      = "dbsecret";
 } }
 </code> </code>
Line 84: Line 87:
         map = m;         map = m;
         products = new ArrayList<String>(map.keySet());         products = new ArrayList<String>(map.keySet());
-        prices   = new ArrayList<Double>(map.keySet());+        prices   = new ArrayList<Double>(map.values());
                  
         mInflater = (LayoutInflater) cx.getSystemService(Context.LAYOUT_INFLATER_SERVICE);         mInflater = (LayoutInflater) cx.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
Line 142: Line 145:
     ListView lstProducts;     ListView lstProducts;
     TextView lblProgress;     TextView lblProgress;
-    Map<String, Double> mapProducts = new LinkedHashMap<String, Double>();+    Map<String,Double> mapProducts = new LinkedHashMap<String,Double>();
    
     @Override     @Override
Line 176: Line 179:
              
       // Example: 192.168.0.2:3306       // Example: 192.168.0.2:3306
-      static final String DB_URL = "jdbc:mysql://"++      static final String DB_URL = "jdbc:mysql://" +
           DbStrings.DATABASE_URL + "/" +           DbStrings.DATABASE_URL + "/" +
           DbStrings.DATABASE_NAME;           DbStrings.DATABASE_NAME;
Line 195: Line 198:
                Class.forName(JDBC_DRIVER);                Class.forName(JDBC_DRIVER);
                conn = DriverManager.getConnection(DB_URL, DbStrings.USERNAME, DbStrings.PASSWORD);                conn = DriverManager.getConnection(DB_URL, DbStrings.USERNAME, DbStrings.PASSWORD);
-               stmt = conn.createStatement(); +                
-               String sql = "SELECT * FROM products";+               stmt         = conn.createStatement(); 
 +               String sql   = "SELECT * FROM products";
                ResultSet rs = stmt.executeQuery(sql);                ResultSet rs = stmt.executeQuery(sql);
 +               
                while(rs.next()) {                while(rs.next()) {
-                   String name = rs.getString("name");+                   String name  = rs.getString("name");
                    double price = rs.getDouble("price");                    double price = rs.getDouble("price");
                                        
Line 212: Line 217:
                                
            } catch (SQLException connError) {            } catch (SQLException connError) {
-              msg = "Exception was thrown for JDBC."; +               msg = "Exception was thrown for JDBC."; 
-              connError.printStackTrace();+               connError.printStackTrace();
            } catch (ClassNotFoundException ex) {            } catch (ClassNotFoundException ex) {
-              msg = "A 'Class not Found' exception was thrown."; +               msg = "A 'Class not Found' exception was thrown."; 
-              ex.printStackTrace();+               ex.printStackTrace();
            } finally {            } finally {
                try {                try {
                    if (stmt != null) { stmt.close(); }                    if (stmt != null) { stmt.close(); }
                } catch (SQLException ex) {                } catch (SQLException ex) {
-                   stmt.close();+                   ex.printStackTrace();
                }                }
                try {                try {
                    if (conn != null) { conn.close(); }                    if (conn != null) { conn.close(); }
                } catch (SQLException ex) {                } catch (SQLException ex) {
-                   conn.close();+                   ex.printStackTrace();
                }                }
            }            }
Line 234: Line 239:
        @Override        @Override
        protected void onPostExecute(String msg) {        protected void onPostExecute(String msg) {
 +
            lblProgress.setText(this.msg);            lblProgress.setText(this.msg);
 +           
            if (mapProducts.size() > 0) {            if (mapProducts.size() > 0) {
                itemAdapter = new ItemAdapter(thisContext, mapProducts);                itemAdapter = new ItemAdapter(thisContext, mapProducts);
-               lstProducts.setAdapter(itemAdapter());+               lstProducts.setAdapter(itemAdapter);
            }            }
        }        }
Line 245: Line 252:
  
 === Example Quick Connection === === Example Quick Connection ===
 +''activity_main.xml'':
 +<code 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>
 +</code>
 +
 +''MainActivity.java'':
 <code java> <code java>
 package com.example.andmysql; package com.example.andmysql;
Line 326: Line 353:
 } }
 </code> </code>
 +
 +See: [[https://gist.github.com/cofearabi/5039135]]
 +
 +
 == References == == References ==
 See also: See also:
-  * [[swdev:java:Connecting to MYSQL Database]] +  * [[swdev:java:Connecting to MySQL Database]] 
-  * [[https://developer.android.com/training/data-storage/sqlite|Data Storage: SQLite]] +  * [[https://www.youtube.com/watch?v=bu5Y3uZ6LLM|Butterfield: Studio For Beginners Part 4: Connecting to MySQL]]
-  * [[https://developer.android.com/training/data-storage/room|Data Storage: Room]]+
   * [[https://www.simplifiedcoding.net/android-mysql-tutorial-to-perform-basic-crud-operation|Android MySQL Tutorial to Perform Basic CRUD Using API]]   * [[https://www.simplifiedcoding.net/android-mysql-tutorial-to-perform-basic-crud-operation|Android MySQL Tutorial to Perform Basic CRUD Using API]]
   * [[http://www.helloandroid.com/tutorials/connecting-mysql-database|Connecting MySQL Database with API]]   * [[http://www.helloandroid.com/tutorials/connecting-mysql-database|Connecting MySQL Database with API]]
   * [[http://androidbash.com/connecting-android-app-to-a-database-using-php-and-mysql|Connecting Android App to MySQL Database]]   * [[http://androidbash.com/connecting-android-app-to-a-database-using-php-and-mysql|Connecting Android App to MySQL Database]]
swdev/android/database_mysql.1525290517.txt.gz · Last modified: 2018/05/02 15:48 by smayr
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International


  • Show page
  • Old revisions
  • Backlinks
  • Recent Changes
  • Media Manager
  • Sitemap