การใช้ SQLite หลายตาราง และรูปภาพ

build.gradle (Project: MyApplication)

// Top-level build file where you can add configuration options common to all sub-projects/modules.

buildscript {
    
    repositories {
        google()
        jcenter()
    }
    dependencies {
        classpath 'com.android.tools.build:gradle:3.1.4'
        

        // NOTE: Do not place your application dependencies here; they belong
        // in the individual module build.gradle files
    }
}

allprojects {
    repositories {
        google()
        jcenter()
        maven { url 'https://jitpack.io' }
    }
}

task clean(type: Delete) {
    delete rootProject.buildDir
}

// Top-level build file where you can add configuration options common to all sub-projects/modules.

buildscript {

repositories {

google()

jcenter()

}

dependencies {

classpath 'com.android.tools.build:gradle:3.1.4'

// NOTE: Do not place your application dependencies here; they belong

// in the individual module build.gradle files

}

allprojects {

repositories {

google()

jcenter()

maven { url 'https://jitpack.io' }

}

task clean(type: Delete) {

delete rootProject.buildDir

}

build.gradle (Module: app)

apply plugin: 'com.android.application'

android {
    compileSdkVersion 26
    defaultConfig {
        applicationId "com.phaisarn.myapplication"
        minSdkVersion 21
        targetSdkVersion 26
        versionCode 1
        versionName "1.0"
        testInstrumentationRunner "android.support.test.runner.AndroidJUnitRunner"
    }
    buildTypes {
        release {
            minifyEnabled false
            proguardFiles getDefaultProguardFile('proguard-android.txt'), 'proguard-rules.pro'
        }
    }
}

dependencies {
    implementation fileTree(dir: 'libs', include: ['*.jar'])
    implementation 'com.android.support:appcompat-v7:26.1.0'
    implementation 'com.android.support.constraint:constraint-layout:1.1.3'
    implementation 'com.android.support:design:26.1.0'
    testImplementation 'junit:junit:4.12'
    androidTestImplementation 'com.android.support.test:runner:1.0.2'
    androidTestImplementation 'com.android.support.test.espresso:espresso-core:3.0.2'

    implementation 'com.github.armcha:SimplePermissions:1.0.0'
    implementation 'com.github.vansikrishna:Multimager:1.0.6'
}

apply plugin: 'com.android.application'

android {

compileSdkVersion 26

defaultConfig {

applicationId "com.phaisarn.myapplication"

minSdkVersion 21

targetSdkVersion 26

versionCode 1

versionName "1.0"

testInstrumentationRunner "android.support.test.runner.AndroidJUnitRunner"

}

buildTypes {

release {

minifyEnabled false

proguardFiles getDefaultProguardFile('proguard-android.txt'), 'proguard-rules.pro'

}

dependencies {

implementation fileTree(dir: 'libs', include: ['*.jar'])

implementation 'com.android.support:appcompat-v7:26.1.0'

implementation 'com.android.support.constraint:constraint-layout:1.1.3'

implementation 'com.android.support:design:26.1.0'

testImplementation 'junit:junit:4.12'

androidTestImplementation 'com.android.support.test:runner:1.0.2'

androidTestImplementation 'com.android.support.test.espresso:espresso-core:3.0.2'

implementation 'com.github.armcha:SimplePermissions:1.0.0'

implementation 'com.github.vansikrishna:Multimager:1.0.6'

}

AndroidManifest.xml

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.phaisarn.myapplication">

    <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
    <uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" />

    <uses-permission-sdk-23 android:name="android.permission.READ_EXTERNAL_STORAGE" />

    <application
        android:allowBackup="true"
        android:icon="@mipmap/ic_launcher"
        android:label="@string/app_name"
        android:roundIcon="@mipmap/ic_launcher_round"
        android:supportsRtl="true"
        android:theme="@style/AppTheme">
        <activity
            android:name=".MainActivity"
            android:label="@string/app_name"
            android:theme="@style/AppTheme.NoActionBar">
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />

                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
        <activity
            android:name=".AddProductActivity"
            android:label="@string/title_activity_add_herb"
            android:theme="@style/AppTheme.NoActionBar"></activity>
        <activity
            android:name=".ProductDetailActivity"
            android:label="@string/title_activity_herb_detail"
            android:theme="@style/AppTheme.NoActionBar"></activity>
    </application>

</manifest>

<?xml version="1.0" encoding="utf-8"?>

<manifest xmlns:android="http://schemas.android.com/apk/res/android"

package="com.phaisarn.myapplication">

<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />

<uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" />

<uses-permission-sdk-23 android:name="android.permission.READ_EXTERNAL_STORAGE" />

<application

android:allowBackup="true"

android:icon="@mipmap/ic_launcher"

android:label="@string/app_name"

android:roundIcon="@mipmap/ic_launcher_round"

android:supportsRtl="true"

android:theme="@style/AppTheme">

<activity

android:name=".MainActivity"

android:label="@string/app_name"

android:theme="@style/AppTheme.NoActionBar">

<intent-filter>

</intent-filter>

</activity>

<activity

android:name=".AddProductActivity"

android:label="@string/title_activity_add_herb"

android:theme="@style/AppTheme.NoActionBar"></activity>

<activity

android:name=".ProductDetailActivity"

android:label="@string/title_activity_herb_detail"

android:theme="@style/AppTheme.NoActionBar"></activity>

</application>

</manifest>

values/styles.xml

<resources>

    <!-- Base application theme. -->
    <style name="AppTheme" parent="Theme.AppCompat.Light.DarkActionBar">
        <!-- Customize your theme here. -->
        <item name="colorPrimary">@color/colorPrimary</item>
        <item name="colorPrimaryDark">@color/colorPrimaryDark</item>
        <item name="colorAccent">@color/colorAccent</item>
    </style>

    <style name="AppTheme.NoActionBar">
        <item name="windowActionBar">false</item>
        <item name="windowNoTitle">true</item>
    </style>

    <style name="AppTheme.AppBarOverlay" parent="ThemeOverlay.AppCompat.Dark.ActionBar" />

    <style name="AppTheme.PopupOverlay" parent="ThemeOverlay.AppCompat.Light" />

    <style name="TextStyle">
        <item name="android:textSize">16sp</item>
        <item name="android:layout_marginLeft">5dp</item>
    </style>

    <style name="EditStyle">
        <item name="android:padding">3dp</item>
        <item name="android:textSize">16sp</item>
        <item name="android:layout_width">match_parent</item>
        <item name="android:layout_margin">5dp</item>
        <item name="android:background">@drawable/item_normal</item>
        <item name="android:lines">1</item>
        <item name="android:gravity">top</item>
    </style>

</resources>

<item name="colorPrimary">@color/colorPrimary</item>

<item name="colorPrimaryDark">@color/colorPrimaryDark</item>

<item name="colorAccent">@color/colorAccent</item>

</style>

<item name="windowActionBar">false</item>

</style>

</style>

<item name="android:layout_width">match_parent</item>

<item name="android:background">@drawable/item_normal</item>

</style>

</resources>

drawable/item_normal.xml

<?xml version="1.0" encoding="utf-8"?>
<shape xmlns:android="http://schemas.android.com/apk/res/android"
    android:shape="rectangle">
    <stroke
        android:width="1dp"
        android:color="#777" />
    <solid android:color="#fff" />
</shape>

<?xml version="1.0" encoding="utf-8"?>

<shape xmlns:android="http://schemas.android.com/apk/res/android"

android:shape="rectangle">

<stroke

android:width="1dp"

android:color="#777" />

</shape>

drawable/item_pressed.xml

<?xml version="1.0" encoding="utf-8"?>
<shape xmlns:android="http://schemas.android.com/apk/res/android"
    android:shape="rectangle">
    <stroke
        android:width="1dp"
        android:color="#777" />
    <solid android:color="#ccc" />
</shape>

<?xml version="1.0" encoding="utf-8"?>

<shape xmlns:android="http://schemas.android.com/apk/res/android"

android:shape="rectangle">

<stroke

android:width="1dp"

android:color="#777" />

</shape>

drawable/item_state.xml

<?xml version="1.0" encoding="utf-8"?>
<selector xmlns:android="http://schemas.android.com/apk/res/android" android:exitFadeDuration="100">
    <item android:drawable="@drawable/item_pressed" android:state_pressed="true" />
    <item android:drawable="@drawable/item_normal" />
</selector>

<?xml version="1.0" encoding="utf-8"?>

</selector>

layout/item_layout.xml

<?xml version="1.0" encoding="utf-8"?>
<GridLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:background="@drawable/item_state"
    android:columnCount="2">

    <ImageView
        android:id="@+id/image_view"
        android:layout_width="100dp"
        android:layout_height="50dp"
        android:layout_marginBottom="7dp"
        android:layout_marginLeft="7dp"
        android:layout_marginTop="7dp" />

    <TextView
        android:id="@+id/text_name"
        android:layout_columnWeight="1"
        android:layout_gravity="center_vertical"
        android:layout_marginLeft="20dp"
        android:textColor="#00a"
        android:textSize="18sp" />
</GridLayout>

<?xml version="1.0" encoding="utf-8"?>

<GridLayout xmlns:android="http://schemas.android.com/apk/res/android"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:background="@drawable/item_state"

android:columnCount="2">

<ImageView

android:id="@+id/image_view"

android:layout_width="100dp"

android:layout_height="50dp"

android:layout_marginBottom="7dp"

android:layout_marginLeft="7dp"

android:layout_marginTop="7dp" />

<TextView

android:id="@+id/text_name"

android:layout_columnWeight="1"

android:layout_gravity="center_vertical"

android:layout_marginLeft="20dp"

android:textColor="#00a"

android:textSize="18sp" />

</GridLayout>

activity_main.xml

<?xml version="1.0" encoding="utf-8"?>
<android.support.design.widget.CoordinatorLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    tools:context=".MainActivity">

    <android.support.design.widget.AppBarLayout
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:theme="@style/AppTheme.AppBarOverlay">

        <android.support.v7.widget.Toolbar
            android:id="@+id/toolbar"
            android:layout_width="match_parent"
            android:layout_height="?attr/actionBarSize"
            android:background="?attr/colorPrimary"
            app:popupTheme="@style/AppTheme.PopupOverlay" />

    </android.support.design.widget.AppBarLayout>

    <include layout="@layout/content_main" />

    <android.support.design.widget.FloatingActionButton
        android:id="@+id/fab"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_gravity="bottom|end"
        android:layout_margin="@dimen/fab_margin"
        app:srcCompat="@drawable/ic_add" />

</android.support.design.widget.CoordinatorLayout>

<?xml version="1.0" encoding="utf-8"?>

<android.support.design.widget.CoordinatorLayout xmlns:android="http://schemas.android.com/apk/res/android"

xmlns:app="http://schemas.android.com/apk/res-auto"

xmlns:tools="http://schemas.android.com/tools"

android:layout_width="match_parent"

android:layout_height="match_parent"

tools:context=".MainActivity">

<android.support.design.widget.AppBarLayout

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:theme="@style/AppTheme.AppBarOverlay">

<android.support.v7.widget.Toolbar

android:id="@+id/toolbar"

android:layout_width="match_parent"

android:layout_height="?attr/actionBarSize"

android:background="?attr/colorPrimary"

app:popupTheme="@style/AppTheme.PopupOverlay" />

</android.support.design.widget.AppBarLayout>

<android.support.design.widget.FloatingActionButton

android:id="@+id/fab"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_gravity="bottom|end"

android:layout_margin="@dimen/fab_margin"

app:srcCompat="@drawable/ic_add" />

</android.support.design.widget.CoordinatorLayout>

content_main.xml

<?xml version="1.0" encoding="utf-8"?>
<android.support.v4.widget.NestedScrollView xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:background="#def"
    app:layout_behavior="@string/appbar_scrolling_view_behavior"
    tools:context=".MainActivity"
    tools:showIn="@layout/activity_main">

    <LinearLayout
        android:id="@+id/main_layout"
        android:layout_width="match_parent"
        android:layout_height="match_parent"
        android:gravity="center_horizontal"
        android:orientation="vertical"
        android:padding="20dp" />

</android.support.v4.widget.NestedScrollView>

<?xml version="1.0" encoding="utf-8"?>

<android.support.v4.widget.NestedScrollView xmlns:android="http://schemas.android.com/apk/res/android"

xmlns:app="http://schemas.android.com/apk/res-auto"

xmlns:tools="http://schemas.android.com/tools"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:background="#def"

app:layout_behavior="@string/appbar_scrolling_view_behavior"

tools:context=".MainActivity"

tools:showIn="@layout/activity_main">

<LinearLayout

android:id="@+id/main_layout"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:gravity="center_horizontal"

android:orientation="vertical"

android:padding="20dp" />

</android.support.v4.widget.NestedScrollView>

activity_add_product.xml

<?xml version="1.0" encoding="utf-8"?>
<android.support.design.widget.CoordinatorLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    tools:context=".AddProductActivity">

    <android.support.design.widget.AppBarLayout
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:theme="@style/AppTheme.AppBarOverlay">

        <android.support.v7.widget.Toolbar
            android:id="@+id/toolbar"
            android:layout_width="match_parent"
            android:layout_height="?attr/actionBarSize"
            android:background="?attr/colorPrimary"
            app:popupTheme="@style/AppTheme.PopupOverlay" />

    </android.support.design.widget.AppBarLayout>

    <include layout="@layout/content_add_product" />

    <android.support.design.widget.FloatingActionButton
        android:id="@+id/fab"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_gravity="bottom|end"
        android:layout_margin="@dimen/fab_margin"
        app:srcCompat="@android:drawable/ic_dialog_email" />

</android.support.design.widget.CoordinatorLayout>

<?xml version="1.0" encoding="utf-8"?>

<android.support.design.widget.CoordinatorLayout xmlns:android="http://schemas.android.com/apk/res/android"

xmlns:app="http://schemas.android.com/apk/res-auto"

xmlns:tools="http://schemas.android.com/tools"

android:layout_width="match_parent"

android:layout_height="match_parent"

tools:context=".AddProductActivity">

<android.support.design.widget.AppBarLayout

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:theme="@style/AppTheme.AppBarOverlay">

<android.support.v7.widget.Toolbar

android:id="@+id/toolbar"

android:layout_width="match_parent"

android:layout_height="?attr/actionBarSize"

android:background="?attr/colorPrimary"

app:popupTheme="@style/AppTheme.PopupOverlay" />

</android.support.design.widget.AppBarLayout>

<android.support.design.widget.FloatingActionButton

android:id="@+id/fab"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_gravity="bottom|end"

android:layout_margin="@dimen/fab_margin"

app:srcCompat="@android:drawable/ic_dialog_email" />

</android.support.design.widget.CoordinatorLayout>

activity_product_detail.xml

<?xml version="1.0" encoding="utf-8"?>
<android.support.design.widget.CoordinatorLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    tools:context=".ProductDetailActivity">

    <android.support.design.widget.AppBarLayout
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:theme="@style/AppTheme.AppBarOverlay">

        <android.support.v7.widget.Toolbar
            android:id="@+id/toolbar"
            android:layout_width="match_parent"
            android:layout_height="?attr/actionBarSize"
            android:background="?attr/colorPrimary"
            app:popupTheme="@style/AppTheme.PopupOverlay" />

    </android.support.design.widget.AppBarLayout>

    <include layout="@layout/content_product_detail" />

    <android.support.design.widget.FloatingActionButton
        android:id="@+id/fab"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_gravity="bottom|end"
        android:layout_margin="@dimen/fab_margin"
        app:srcCompat="@android:drawable/ic_dialog_email" />

</android.support.design.widget.CoordinatorLayout>

<?xml version="1.0" encoding="utf-8"?>

<android.support.design.widget.CoordinatorLayout xmlns:android="http://schemas.android.com/apk/res/android"

xmlns:app="http://schemas.android.com/apk/res-auto"

xmlns:tools="http://schemas.android.com/tools"

android:layout_width="match_parent"

android:layout_height="match_parent"

tools:context=".ProductDetailActivity">

<android.support.design.widget.AppBarLayout

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:theme="@style/AppTheme.AppBarOverlay">

<android.support.v7.widget.Toolbar

android:id="@+id/toolbar"

android:layout_width="match_parent"

android:layout_height="?attr/actionBarSize"

android:background="?attr/colorPrimary"

app:popupTheme="@style/AppTheme.PopupOverlay" />

</android.support.design.widget.AppBarLayout>

<android.support.design.widget.FloatingActionButton

android:id="@+id/fab"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_gravity="bottom|end"

android:layout_margin="@dimen/fab_margin"

app:srcCompat="@android:drawable/ic_dialog_email" />

</android.support.design.widget.CoordinatorLayout>

content_add_product.xml

<?xml version="1.0" encoding="utf-8"?>
<android.support.v4.widget.NestedScrollView xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    app:layout_behavior="@string/appbar_scrolling_view_behavior"
    tools:context=".AddProductActivity"
    tools:showIn="@layout/activity_add_product">

    <GridLayout
        android:layout_width="match_parent"
        android:layout_height="match_parent"
        android:orientation="vertical"
        android:padding="16dp">

        <ImageView
            android:id="@+id/image_view"
            android:layout_width="400dp"
            android:layout_height="200dp"
            android:scaleType="centerCrop"
            android:visibility="gone" />

        <Button
            android:id="@+id/button_image"
            android:text="เลือกภาพ" />

        <TextView
            style="@style/TextStyle"
            android:text="ชื่อสินค้า" />

        <EditText
            android:id="@+id/edit_name"
            style="@style/EditStyle" />

        <TextView
            style="@style/TextStyle"
            android:text="ราคา" />

        <EditText
            android:id="@+id/edit_price"
            style="@style/EditStyle"
            android:inputType="number" />

        <TextView
            style="@style/TextStyle"
            android:text="ลักษณะสินค้า (แยกเป็นข้อๆ)" />

        <EditText
            android:id="@+id/edit_char1"
            style="@style/EditStyle" />

        <EditText
            android:id="@+id/edit_char2"
            style="@style/EditStyle" />

        <EditText
            android:id="@+id/edit_char3"
            style="@style/EditStyle" />

        <EditText
            android:id="@+id/edit_char4"
            style="@style/EditStyle" />

        <EditText
            android:id="@+id/edit_char5"
            style="@style/EditStyle" />

        <Button
            android:id="@+id/button_save"
            android:text="บันทึกข้อมูล" />
    </GridLayout>
</android.support.v4.widget.NestedScrollView>

<?xml version="1.0" encoding="utf-8"?>

<android.support.v4.widget.NestedScrollView xmlns:android="http://schemas.android.com/apk/res/android"

xmlns:app="http://schemas.android.com/apk/res-auto"

xmlns:tools="http://schemas.android.com/tools"

android:layout_width="match_parent"

android:layout_height="match_parent"

app:layout_behavior="@string/appbar_scrolling_view_behavior"

tools:context=".AddProductActivity"

tools:showIn="@layout/activity_add_product">

<GridLayout

android:layout_width="match_parent"

android:layout_height="match_parent"

android:orientation="vertical"

android:padding="16dp">

<ImageView

android:id="@+id/image_view"

android:layout_width="400dp"

android:layout_height="200dp"

android:scaleType="centerCrop"

android:visibility="gone" />

<Button

android:id="@+id/button_image"

android:text="เลือกภาพ" />

<TextView

style="@style/TextStyle"

android:text="ชื่อสินค้า" />

<EditText

android:id="@+id/edit_name"

style="@style/EditStyle" />

<TextView

style="@style/TextStyle"

android:text="ราคา" />

<EditText

android:id="@+id/edit_price"

style="@style/EditStyle"

android:inputType="number" />

<TextView

style="@style/TextStyle"

android:text="ลักษณะสินค้า (แยกเป็นข้อๆ)" />

<EditText

android:id="@+id/edit_char1"

style="@style/EditStyle" />

<EditText

android:id="@+id/edit_char2"

style="@style/EditStyle" />

<EditText

android:id="@+id/edit_char3"

style="@style/EditStyle" />

<EditText

android:id="@+id/edit_char4"

style="@style/EditStyle" />

<EditText

android:id="@+id/edit_char5"

style="@style/EditStyle" />

<Button

android:id="@+id/button_save"

android:text="บันทึกข้อมูล" />

</GridLayout>

</android.support.v4.widget.NestedScrollView>

content_product_detail.xml

<?xml version="1.0" encoding="utf-8"?>
<ScrollView xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:background="#fff"
    android:padding="16dp"
    app:layout_behavior="@string/appbar_scrolling_view_behavior"
    tools:context=".ProductDetailActivity"
    tools:showIn="@layout/activity_product_detail">

    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="match_parent"
        android:orientation="vertical">

        <ImageView
            android:id="@+id/image_view"
            android:layout_width="400dp"
            android:layout_height="200dp"
            android:layout_gravity="center_horizontal"
            android:scaleType="centerCrop" />

        <TextView
            android:id="@+id/text_name"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_marginBottom="10dp"
            android:layout_marginTop="10dp"
            android:paddingLeft="30dp"
            android:textColor="#00f"
            android:textSize="20sp"

            />

        <WebView
            android:id="@+id/web_view"
            android:layout_width="match_parent"
            android:layout_height="wrap_content" />

        <TextView
            android:id="@+id/text_price"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_marginTop="10dp"
            android:paddingLeft="30dp"
            android:textColor="#090"
            android:textSize="16sp"

            />
    </LinearLayout>
</ScrollView>

<?xml version="1.0" encoding="utf-8"?>

<ScrollView xmlns:android="http://schemas.android.com/apk/res/android"

xmlns:app="http://schemas.android.com/apk/res-auto"

xmlns:tools="http://schemas.android.com/tools"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:background="#fff"

android:padding="16dp"

app:layout_behavior="@string/appbar_scrolling_view_behavior"

tools:context=".ProductDetailActivity"

tools:showIn="@layout/activity_product_detail">

<LinearLayout

android:layout_width="match_parent"

android:layout_height="match_parent"

android:orientation="vertical">

<ImageView

android:id="@+id/image_view"

android:layout_width="400dp"

android:layout_height="200dp"

android:layout_gravity="center_horizontal"

android:scaleType="centerCrop" />

<TextView

android:id="@+id/text_name"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_marginBottom="10dp"

android:layout_marginTop="10dp"

android:paddingLeft="30dp"

android:textColor="#00f"

android:textSize="20sp"

<WebView

android:id="@+id/web_view"

android:layout_width="match_parent"

android:layout_height="wrap_content" />

<TextView

android:id="@+id/text_price"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_marginTop="10dp"

android:paddingLeft="30dp"

android:textColor="#090"

android:textSize="16sp"

</LinearLayout>

</ScrollView>

SQLiteHelper.java

package com.phaisarn.myapplication;

import android.database.sqlite.SQLiteOpenHelper;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;

public class SQLiteHelper extends SQLiteOpenHelper {
    private static SQLiteHelper sqLiteDB;
    private static final String DB_NAME = "db_product";
    private static final int DB_VERSION = 1;

    private SQLiteHelper(Context context) {
        super(context, DB_NAME, null, DB_VERSION);
    }

    public static synchronized SQLiteHelper getInstance(Context context) {
        if (sqLiteDB == null) {
            sqLiteDB = new SQLiteHelper(context.getApplicationContext());
        }
        return sqLiteDB;
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String sql =
                "CREATE TABLE IF NOT EXISTS product(" +
                        "_id INTEGER PRIMARY KEY AUTOINCREMENT, " +
                        "pro_name TEXT, " +
                        "price INTEGER)";
        db.execSQL(sql);

        sql =
                "CREATE TABLE IF NOT EXISTS characteristic(" +
                        "_id INTEGER PRIMARY KEY AUTOINCREMENT, " +
                        "pro_id INTEGER, " +
                        "pro_characteristic TEXT)";
        db.execSQL(sql);

        sql =
                "CREATE TABLE IF NOT EXISTS image(" +
                        "pro_id INTEGER, " +
                        "pro_image BLOB)";
        db.execSQL(sql);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldV, int newV) {

    }
}

package com.phaisarn.myapplication;

import android.database.sqlite.SQLiteOpenHelper;

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

public class SQLiteHelper extends SQLiteOpenHelper {

private static SQLiteHelper sqLiteDB;

private static final String DB_NAME = "db_product";

private static final int DB_VERSION = 1;

private SQLiteHelper(Context context) {

super(context, DB_NAME, null, DB_VERSION);

}

public static synchronized SQLiteHelper getInstance(Context context) {

if (sqLiteDB == null) {

sqLiteDB = new SQLiteHelper(context.getApplicationContext());

}

return sqLiteDB;

}

@Override

public void onCreate(SQLiteDatabase db) {

String sql =

"CREATE TABLE IF NOT EXISTS product(" +

"_id INTEGER PRIMARY KEY AUTOINCREMENT, " +

"pro_name TEXT, " +

"price INTEGER)";

db.execSQL(sql);

sql =

"CREATE TABLE IF NOT EXISTS characteristic(" +

"_id INTEGER PRIMARY KEY AUTOINCREMENT, " +

"pro_id INTEGER, " +

"pro_characteristic TEXT)";

db.execSQL(sql);

sql =

"CREATE TABLE IF NOT EXISTS image(" +

"pro_id INTEGER, " +

"pro_image BLOB)";

db.execSQL(sql);

}

@Override

public void onUpgrade(SQLiteDatabase db, int oldV, int newV) {

}

AddProductActivity.java

package com.phaisarn.myapplication;

import android.content.ContentValues;
import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.graphics.Bitmap;
import android.graphics.drawable.BitmapDrawable;
import android.net.Uri;
import android.os.Bundle;
import android.support.design.widget.FloatingActionButton;
import android.support.design.widget.Snackbar;
import android.support.v7.widget.Toolbar;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ImageView;
import android.widget.Toast;

import com.luseen.simplepermission.permissions.PermissionActivity;
import com.vlk.multimager.activities.GalleryActivity;
import com.vlk.multimager.utils.Constants;
import com.vlk.multimager.utils.Image;
import com.vlk.multimager.utils.Params;

import java.io.ByteArrayOutputStream;
import java.util.ArrayList;

public class AddProductActivity extends PermissionActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_add_product);
        Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
        setSupportActionBar(toolbar);

        FloatingActionButton fab = (FloatingActionButton) findViewById(R.id.fab);
        fab.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                Snackbar.make(view, "Replace with your own action", Snackbar.LENGTH_LONG)
                        .setAction("Action", null).show();
            }
        });
        fab.hide();

        Button btSelectImg = (Button) findViewById(R.id.button_image);
        btSelectImg.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                showGallery();
            }
        });

        Button buttonSave = (Button) findViewById(R.id.button_save);
        buttonSave.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                saveData();
            }
        });

    }

    private void showGallery() {
        //ส่งอินเทนต์เพื่อเลือกภาพ
        Intent intent = new Intent(this, GalleryActivity.class);
        Params params = new Params();
        params.setPickerLimit(1);    //จำนวนภาพที่เลือกได้
        intent.putExtra(Constants.KEY_PARAMS, params);
        startActivityForResult(intent, Constants.TYPE_MULTI_PICKER);
    }

    //หลังเลือกภาพเสร็จ ให้นำภาพนั้นไปแสดงใน ImageView ให้เห็นด้วย
    @Override
    public void onActivityResult(int rqCode, int rsCode, Intent intent) {
        if (rqCode != Constants.TYPE_MULTI_PICKER && rsCode != RESULT_OK) {
            return;
        }

        ArrayList<Image> images = intent.getParcelableArrayListExtra(
                Constants.KEY_BUNDLE_LIST);

        Uri uri = images.get(0).uri;
        ImageView imageView = (ImageView) findViewById(R.id.image_view);
        imageView.setImageURI(uri);
        imageView.setVisibility(View.VISIBLE);
    }

    //เมธอดนี้จะถูกเรียกเมื่อคลิกปุ่มบันทึกข้อมูล
    private void saveData() {
        ImageView imageView = (ImageView) findViewById(R.id.image_view);
        if (imageView.getDrawable() == null) {
            showToast("ต้องมีรูปภาพ");
            return;
        }

        EditText editName = (EditText) findViewById(R.id.edit_name);
        if (editName.getText().toString().trim().equals("")) {
            showToast("ต้องกำหนดชื่อ");
            return;
        }

        SQLiteHelper sqLiteHelper = SQLiteHelper.getInstance(this);
        SQLiteDatabase db = sqLiteHelper.getWritableDatabase();

        EditText editPrice = (EditText) findViewById(R.id.edit_price);
        String name = editName.getText().toString();
        String price = editPrice.getText().toString();

        ContentValues cv = new ContentValues();
        cv.put("pro_name", name);
        cv.put("price", price);
        long pro_id = db.insert("product", null, cv);

        int[] edits = {R.id.edit_char1, R.id.edit_char2, R.id.edit_char3, R.id.edit_char4, R.id.edit_char5};
        for (int i = 0; i < edits.length; i++) {
            String ch = ((EditText) findViewById(edits[i])).getText().toString();
            if (ch.trim().equals("")) {
                continue;
            }
            cv = new ContentValues();
            cv.put("pro_id", pro_id);
            cv.put("pro_characteristic", ch);
            db.insert("characteristic", null, cv);
        }

        BitmapDrawable bitmapDrawable = (BitmapDrawable) imageView.getDrawable();
        byte[] imgContent = getBytes(bitmapDrawable.getBitmap());

        cv = new ContentValues();
        cv.put("pro_id", pro_id);
        cv.put("pro_image", imgContent);
        db.insert("image", null, cv);

        showToast("บันทึกข้อมูลเสร็จแล้ว");
    }

    public byte[] getBytes(Bitmap bitmap) {
        ByteArrayOutputStream stream = new ByteArrayOutputStream();
        bitmap.compress(Bitmap.CompressFormat.PNG, 0, stream);
        return stream.toByteArray();
    }

    private void showToast(String msg) {
        Toast.makeText(getBaseContext(), msg, Toast.LENGTH_LONG).show();
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

package com.phaisarn.myapplication;

import android.content.ContentValues;

import android.content.Intent;

import android.database.sqlite.SQLiteDatabase;

import android.graphics.Bitmap;

import android.graphics.drawable.BitmapDrawable;

import android.net.Uri;

import android.os.Bundle;

import android.support.design.widget.FloatingActionButton;

import android.support.design.widget.Snackbar;

import android.support.v7.widget.Toolbar;

import android.view.View;

import android.widget.Button;

import android.widget.EditText;

import android.widget.ImageView;

import android.widget.Toast;

import com.luseen.simplepermission.permissions.PermissionActivity;

import com.vlk.multimager.activities.GalleryActivity;

import com.vlk.multimager.utils.Constants;

import com.vlk.multimager.utils.Image;

import com.vlk.multimager.utils.Params;

import java.io.ByteArrayOutputStream;

import java.util.ArrayList;

public class AddProductActivity extends PermissionActivity {

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_add_product);

Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);

setSupportActionBar(toolbar);

FloatingActionButton fab = (FloatingActionButton) findViewById(R.id.fab);

fab.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View view) {

Snackbar.make(view, "Replace with your own action", Snackbar.LENGTH_LONG)

.setAction("Action", null).show();

}

});

fab.hide();

Button btSelectImg = (Button) findViewById(R.id.button_image);

btSelectImg.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View v) {

showGallery();

}

});

Button buttonSave = (Button) findViewById(R.id.button_save);

buttonSave.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View v) {

saveData();

}

});

}

private void showGallery() {

//ส่งอินเทนต์เพื่อเลือกภาพ

Intent intent = new Intent(this, GalleryActivity.class);

Params params = new Params();

params.setPickerLimit(1); //จำนวนภาพที่เลือกได้

intent.putExtra(Constants.KEY_PARAMS, params);

startActivityForResult(intent, Constants.TYPE_MULTI_PICKER);

}

//หลังเลือกภาพเสร็จ ให้นำภาพนั้นไปแสดงใน ImageView ให้เห็นด้วย

@Override

public void onActivityResult(int rqCode, int rsCode, Intent intent) {

if (rqCode != Constants.TYPE_MULTI_PICKER && rsCode != RESULT_OK) {

return;

}

ArrayList<Image> images = intent.getParcelableArrayListExtra(

Constants.KEY_BUNDLE_LIST);

Uri uri = images.get(0).uri;

ImageView imageView = (ImageView) findViewById(R.id.image_view);

imageView.setImageURI(uri);

imageView.setVisibility(View.VISIBLE);

}

//เมธอดนี้จะถูกเรียกเมื่อคลิกปุ่มบันทึกข้อมูล

private void saveData() {

ImageView imageView = (ImageView) findViewById(R.id.image_view);

if (imageView.getDrawable() == null) {

showToast("ต้องมีรูปภาพ");

return;

}

EditText editName = (EditText) findViewById(R.id.edit_name);

if (editName.getText().toString().trim().equals("")) {

showToast("ต้องกำหนดชื่อ");

return;

}

SQLiteHelper sqLiteHelper = SQLiteHelper.getInstance(this);

SQLiteDatabase db = sqLiteHelper.getWritableDatabase();

EditText editPrice = (EditText) findViewById(R.id.edit_price);

String name = editName.getText().toString();

String price = editPrice.getText().toString();

ContentValues cv = new ContentValues();

cv.put("pro_name", name);

cv.put("price", price);

long pro_id = db.insert("product", null, cv);

int[] edits = {R.id.edit_char1, R.id.edit_char2, R.id.edit_char3, R.id.edit_char4, R.id.edit_char5};

for (int i = 0; i < edits.length; i++) {

String ch = ((EditText) findViewById(edits[i])).getText().toString();

if (ch.trim().equals("")) {

continue;

}

cv = new ContentValues();

cv.put("pro_id", pro_id);

cv.put("pro_characteristic", ch);

db.insert("characteristic", null, cv);

}

BitmapDrawable bitmapDrawable = (BitmapDrawable) imageView.getDrawable();

byte[] imgContent = getBytes(bitmapDrawable.getBitmap());

cv = new ContentValues();

cv.put("pro_id", pro_id);

cv.put("pro_image", imgContent);

db.insert("image", null, cv);

showToast("บันทึกข้อมูลเสร็จแล้ว");

}

public byte[] getBytes(Bitmap bitmap) {

ByteArrayOutputStream stream = new ByteArrayOutputStream();

bitmap.compress(Bitmap.CompressFormat.PNG, 0, stream);

return stream.toByteArray();

}

private void showToast(String msg) {

Toast.makeText(getBaseContext(), msg, Toast.LENGTH_LONG).show();

}

ProductDetailActivity.java

package com.phaisarn.myapplication;

import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.graphics.Bitmap;
import android.graphics.BitmapFactory;

import java.text.NumberFormat;

import android.os.Bundle;
import android.support.design.widget.FloatingActionButton;
import android.support.design.widget.Snackbar;
import android.support.v7.app.AppCompatActivity;
import android.support.v7.widget.Toolbar;
import android.view.View;
import android.webkit.WebView;
import android.widget.ImageView;
import android.widget.TextView;

public class ProductDetailActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_product_detail);
        Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
        setSupportActionBar(toolbar);

        FloatingActionButton fab = (FloatingActionButton) findViewById(R.id.fab);
        fab.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                Snackbar.make(view, "Replace with your own action", Snackbar.LENGTH_LONG)
                        .setAction("Action", null).show();
            }
        });
        fab.hide();
    }

    @Override
    public void onStart() {
        super.onStart();
        Intent intent = getIntent();
        String _id = intent.getStringExtra("_id");

        SQLiteHelper sqLiteHelper = SQLiteHelper.getInstance(getBaseContext());
        SQLiteDatabase db = sqLiteHelper.getReadableDatabase();

        String sql =
                "SELECT product.*, image.pro_image FROM product " +
                        "LEFT JOIN image " +
                        "ON product._id = image.pro_id " +
                        "WHERE product._id = " + _id;

        Cursor cursor = db.rawQuery(sql, null);

        ImageView imageView = (ImageView) findViewById(R.id.image_view);
        TextView textName = (TextView) findViewById(R.id.text_name);
        TextView textPrice = (TextView) findViewById(R.id.text_price);
        WebView webView = (WebView) findViewById(R.id.web_view);

        if (cursor.moveToNext()) {
            imageView.setImageBitmap(getImage(cursor.getBlob(3)));
            textName.setText(cursor.getString(1));
            NumberFormat numFormat = NumberFormat.getInstance();   //่java.text.NumberFormat
            int price = cursor.getInt(2);
            textPrice.setText("ราคา: " + numFormat.format(price) + " บาท");
        }
        cursor.close();

        sql = "SELECT pro_characteristic FROM characteristic WHERE pro_id = " + _id;
        cursor = db.rawQuery(sql, null);

        String html = "<ul>";
        while (cursor.moveToNext()) {
            html += "<li>" + cursor.getString(0) + "</li>";
        }
        html += "</ul>";
        webView.loadDataWithBaseURL(null, html, "text/html", "utf-8", null);

        cursor.close();
    }

    public Bitmap getImage(byte[] image) {
        return BitmapFactory.decodeByteArray(image, 0, image.length);
    }
}

package com.phaisarn.myapplication;

import android.content.Intent;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.graphics.Bitmap;

import android.graphics.BitmapFactory;

import java.text.NumberFormat;

import android.os.Bundle;

import android.support.design.widget.FloatingActionButton;

import android.support.design.widget.Snackbar;

import android.support.v7.app.AppCompatActivity;

import android.support.v7.widget.Toolbar;

import android.view.View;

import android.webkit.WebView;

import android.widget.ImageView;

import android.widget.TextView;

public class ProductDetailActivity extends AppCompatActivity {

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_product_detail);

Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);

setSupportActionBar(toolbar);

FloatingActionButton fab = (FloatingActionButton) findViewById(R.id.fab);

fab.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View view) {

Snackbar.make(view, "Replace with your own action", Snackbar.LENGTH_LONG)

.setAction("Action", null).show();

}

});

fab.hide();

}

@Override

public void onStart() {

super.onStart();

Intent intent = getIntent();

String _id = intent.getStringExtra("_id");

SQLiteHelper sqLiteHelper = SQLiteHelper.getInstance(getBaseContext());

SQLiteDatabase db = sqLiteHelper.getReadableDatabase();

String sql =

"SELECT product.*, image.pro_image FROM product " +

"LEFT JOIN image " +

"ON product._id = image.pro_id " +

"WHERE product._id = " + _id;

Cursor cursor = db.rawQuery(sql, null);

ImageView imageView = (ImageView) findViewById(R.id.image_view);

TextView textName = (TextView) findViewById(R.id.text_name);

TextView textPrice = (TextView) findViewById(R.id.text_price);

WebView webView = (WebView) findViewById(R.id.web_view);

if (cursor.moveToNext()) {

imageView.setImageBitmap(getImage(cursor.getBlob(3)));

textName.setText(cursor.getString(1));

NumberFormat numFormat = NumberFormat.getInstance(); //่java.text.NumberFormat

int price = cursor.getInt(2);

textPrice.setText("ราคา: " + numFormat.format(price) + " บาท");

}

cursor.close();

sql = "SELECT pro_characteristic FROM characteristic WHERE pro_id = " + _id;

cursor = db.rawQuery(sql, null);

String html = "<ul>";

while (cursor.moveToNext()) {

html += "<li>" + cursor.getString(0) + "</li>";

}

html += "</ul>";

webView.loadDataWithBaseURL(null, html, "text/html", "utf-8", null);

cursor.close();

}

public Bitmap getImage(byte[] image) {

return BitmapFactory.decodeByteArray(image, 0, image.length);

}

MainActivity.java

package com.phaisarn.myapplication;

import android.os.Bundle;
import android.support.design.widget.FloatingActionButton;
import android.support.v7.app.AppCompatActivity;
import android.support.v7.widget.Toolbar;
import android.view.View;
import android.view.Menu;
import android.view.MenuItem;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.graphics.Bitmap;
import android.graphics.BitmapFactory;
import android.view.LayoutInflater;
import android.widget.ImageView;
import android.widget.LinearLayout;
import android.widget.TextView;

public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
        setSupportActionBar(toolbar);

        FloatingActionButton fab = (FloatingActionButton) findViewById(R.id.fab);
        fab.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                startActivity(new Intent(MainActivity.this, AddProductActivity.class));
            }
        });

    }

    @Override
    public void onStart() {
        super.onStart();

        LayoutInflater inflater = getLayoutInflater();
        LinearLayout root = (LinearLayout) findViewById(R.id.main_layout);
        root.removeAllViewsInLayout();

        SQLiteHelper sqlite = SQLiteHelper.getInstance(this);
        SQLiteDatabase db = sqlite.getReadableDatabase();

        String sql =
                "SELECT product.*, image.pro_image FROM product " +
                        "LEFT JOIN image " +
                        "ON product._id = image.pro_id";

        Cursor cursor = db.rawQuery(sql, null);

        LinearLayout.LayoutParams param = new LinearLayout.LayoutParams(
                LinearLayout.LayoutParams.MATCH_PARENT,
                LinearLayout.LayoutParams.WRAP_CONTENT);

        param.bottomMargin = 50;

        int i = 0;
        while(cursor.moveToNext()) {
            final View item = inflater.inflate(R.layout.item_layout, null);
            item.setLayoutParams(param);

            ImageView imageView = (ImageView)item.findViewById(R.id.image_view);
            imageView.setImageBitmap(getImage(cursor.getBlob(3)));

            TextView textName = (TextView)item.findViewById(R.id.text_name);
            textName.setText(cursor.getString(1));
            item.setTag(cursor.getString(0));
            item.setOnClickListener(new View.OnClickListener() {
                @Override
                public void onClick(View v) {
                    Intent intent  = new Intent(MainActivity.this, ProductDetailActivity.class);
                    intent.putExtra("_id", item.getTag().toString());
                    startActivity(intent);
                }
            });

            root.addView(item, i);
            i++;
        }

        cursor.close();
    }

    public Bitmap getImage(byte[] image) {
        return BitmapFactory.decodeByteArray(image, 0, image.length);
    }

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        // Inflate the menu; this adds items to the action bar if it is present.
        getMenuInflater().inflate(R.menu.menu_main, menu);
        return true;
    }

    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        // Handle action bar item clicks here. The action bar will
        // automatically handle clicks on the Home/Up button, so long
        // as you specify a parent activity in AndroidManifest.xml.
        int id = item.getItemId();

        //noinspection SimplifiableIfStatement
        if(id == R.id.action_settings) {
            return true;
        }

        return super.onOptionsItemSelected(item);
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

package com.phaisarn.myapplication;

import android.os.Bundle;

import android.support.design.widget.FloatingActionButton;

import android.support.v7.app.AppCompatActivity;

import android.support.v7.widget.Toolbar;

import android.view.View;

import android.view.Menu;

import android.view.MenuItem;

import android.content.Intent;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.graphics.Bitmap;

import android.graphics.BitmapFactory;

import android.view.LayoutInflater;

import android.widget.ImageView;

import android.widget.LinearLayout;

import android.widget.TextView;

public class MainActivity extends AppCompatActivity {

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);

setSupportActionBar(toolbar);

FloatingActionButton fab = (FloatingActionButton) findViewById(R.id.fab);

fab.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View view) {

startActivity(new Intent(MainActivity.this, AddProductActivity.class));

}

});

}

@Override

public void onStart() {

super.onStart();

LayoutInflater inflater = getLayoutInflater();

LinearLayout root = (LinearLayout) findViewById(R.id.main_layout);

root.removeAllViewsInLayout();

SQLiteHelper sqlite = SQLiteHelper.getInstance(this);

SQLiteDatabase db = sqlite.getReadableDatabase();

String sql =

"SELECT product.*, image.pro_image FROM product " +

"LEFT JOIN image " +

"ON product._id = image.pro_id";

Cursor cursor = db.rawQuery(sql, null);

LinearLayout.LayoutParams param = new LinearLayout.LayoutParams(

LinearLayout.LayoutParams.MATCH_PARENT,

LinearLayout.LayoutParams.WRAP_CONTENT);

param.bottomMargin = 50;

int i = 0;

while(cursor.moveToNext()) {

final View item = inflater.inflate(R.layout.item_layout, null);

item.setLayoutParams(param);

ImageView imageView = (ImageView)item.findViewById(R.id.image_view);

imageView.setImageBitmap(getImage(cursor.getBlob(3)));

TextView textName = (TextView)item.findViewById(R.id.text_name);

textName.setText(cursor.getString(1));

item.setTag(cursor.getString(0));

item.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View v) {

Intent intent = new Intent(MainActivity.this, ProductDetailActivity.class);

intent.putExtra("_id", item.getTag().toString());

startActivity(intent);

}

});

root.addView(item, i);

i++;

}

cursor.close();

}

public Bitmap getImage(byte[] image) {

return BitmapFactory.decodeByteArray(image, 0, image.length);

}

@Override

public boolean onCreateOptionsMenu(Menu menu) {

// Inflate the menu; this adds items to the action bar if it is present.

getMenuInflater().inflate(R.menu.menu_main, menu);

return true;

}

@Override

public boolean onOptionsItemSelected(MenuItem item) {

// Handle action bar item clicks here. The action bar will

// automatically handle clicks on the Home/Up button, so long

// as you specify a parent activity in AndroidManifest.xml.

int id = item.getItemId();

//noinspection SimplifiableIfStatement

if(id == R.id.action_settings) {

return true;

}

return super.onOptionsItemSelected(item);

}

รูปที่ใช้

Phaisarn Sutheebanjard

blog.phaisarn.com

การใช้ SQLite หลายตาราง และรูปภาพ