fork download

package com.example.mysql;
 
import org.json.JSONArray;
import org.json.JSONObject;
import com.example.mysql.R;
 
import android.app.Activity;
import android.os.Bundle;
import android.os.StrictMode;
import android.util.Log;
import android.view.Gravity;
import android.view.View;
import android.view.ViewGroup.LayoutParams;
import android.widget.Button;
import android.widget.TableLayout;
import android.widget.TableRow;
import android.widget.TextView;
 
 
public class MainActivity extends Activity {
 
 
	@Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
 
        findViews();
        setListeners();
 
        StrictMode.setThreadPolicy(new StrictMode.ThreadPolicy.Builder()  
        .detectDiskReads()  
        .detectDiskWrites()  
        .detectNetwork()  
        .penaltyLog()  
        .build());  
        StrictMode.setVmPolicy(new StrictMode.VmPolicy.Builder()  
        .detectLeakedSqlLiteObjects()   
        .penaltyLog()  
        .penaltyDeath()  
        .build());  
    }
 
    private Button button_get_record;
 
    private void findViews() {
        button_get_record = (Button)findViewById(R.id.get_record);
    }
 
    private void setListeners() {
        button_get_record.setOnClickListener(getDBRecord);
    }
 
    private Button.OnClickListener getDBRecord = new Button.OnClickListener() {
        public void onClick(View v) {
            // TODO Auto-generated method stub
            TableLayout user_list = (TableLayout)findViewById(R.id.user_list);
            user_list.setStretchAllColumns(true);
            TableLayout.LayoutParams row_layout = new TableLayout.LayoutParams(LayoutParams.WRAP_CONTENT, LayoutParams.WRAP_CONTENT);
            TableRow.LayoutParams view_layout = new TableRow.LayoutParams(LayoutParams.WRAP_CONTENT, LayoutParams.WRAP_CONTENT);
            try {
                String result = DBConnector.executeQuery("SELECT * FROM user");
 
                /*
                    SQL 結果有多筆資料時使用JSONArray
                    只有一筆資料時直接建立JSONObject物件
                    JSONObject jsonData = new JSONObject(result);
                */
                JSONArray jsonArray = new JSONArray(result);
                for(int i = 0; i < jsonArray.length(); i++) {
                    JSONObject jsonData = jsonArray.getJSONObject(i);
                    TableRow tr = new TableRow(MainActivity.this);
                    tr.setLayoutParams(row_layout);
                    tr.setGravity(Gravity.CENTER_HORIZONTAL);
 
                    TextView user_acc = new TextView(MainActivity.this);
                    user_acc.setText(jsonData.getString("latitude"));
                    user_acc.setLayoutParams(view_layout);
 
                    TextView user_pwd = new TextView(MainActivity.this);
                    user_pwd.setText(jsonData.getString("longitude"));
                    user_pwd.setLayoutParams(view_layout);
 
                    tr.addView(user_acc);
                    tr.addView(user_pwd);
                    user_list.addView(tr);
                }
            } catch(Exception e) {
                 Log.e("log_tag", e.toString());
            }
        }
    };
}

Main.java:20: error: class MainActivity is public, should be declared in a file named MainActivity.java
public class MainActivity extends Activity {
       ^
Main.java:3: error: package org.json does not exist
import org.json.JSONArray;
               ^
Main.java:4: error: package org.json does not exist
import org.json.JSONObject;
               ^
Main.java:5: error: cannot find symbol
import com.example.mysql.R;
                        ^
  symbol:   class R
  location: package com.example.mysql
Main.java:7: error: package android.app does not exist
import android.app.Activity;
                  ^
Main.java:8: error: package android.os does not exist
import android.os.Bundle;
                 ^
Main.java:9: error: package android.os does not exist
import android.os.StrictMode;
                 ^
Main.java:10: error: package android.util does not exist
import android.util.Log;
                   ^
Main.java:11: error: package android.view does not exist
import android.view.Gravity;
                   ^
Main.java:12: error: package android.view does not exist
import android.view.View;
                   ^
Main.java:13: error: package android.view.ViewGroup does not exist
import android.view.ViewGroup.LayoutParams;
                             ^
Main.java:14: error: package android.widget does not exist
import android.widget.Button;
                     ^
Main.java:15: error: package android.widget does not exist
import android.widget.TableLayout;
                     ^
Main.java:16: error: package android.widget does not exist
import android.widget.TableRow;
                     ^
Main.java:17: error: package android.widget does not exist
import android.widget.TextView;
                     ^
Main.java:20: error: cannot find symbol
public class MainActivity extends Activity {
                                  ^
  symbol: class Activity
Main.java:24: error: cannot find symbol
    public void onCreate(Bundle savedInstanceState) {
                         ^
  symbol:   class Bundle
  location: class MainActivity
Main.java:44: error: cannot find symbol
    private Button button_get_record;
            ^
  symbol:   class Button
  location: class MainActivity
Main.java:54: error: package Button does not exist
    private Button.OnClickListener getDBRecord = new Button.OnClickListener() {
                  ^
Main.java:25: error: cannot find symbol
        super.onCreate(savedInstanceState);
        ^
  symbol:   variable super
  location: class MainActivity
Main.java:26: error: package R does not exist
        setContentView(R.layout.main);
                        ^
Main.java:31: error: package StrictMode.ThreadPolicy does not exist
        StrictMode.setThreadPolicy(new StrictMode.ThreadPolicy.Builder()  
                                                              ^
Main.java:31: error: cannot find symbol
        StrictMode.setThreadPolicy(new StrictMode.ThreadPolicy.Builder()  
        ^
  symbol:   variable StrictMode
  location: class MainActivity
Main.java:37: error: package StrictMode.VmPolicy does not exist
        StrictMode.setVmPolicy(new StrictMode.VmPolicy.Builder()  
                                                      ^
Main.java:37: error: cannot find symbol
        StrictMode.setVmPolicy(new StrictMode.VmPolicy.Builder()  
        ^
  symbol:   variable StrictMode
  location: class MainActivity
Main.java:23: error: method does not override or implement a method from a supertype
	@Override
	^
Main.java:47: error: cannot find symbol
        button_get_record = (Button)findViewById(R.id.get_record);
                             ^
  symbol:   class Button
  location: class MainActivity
Main.java:47: error: package R does not exist
        button_get_record = (Button)findViewById(R.id.get_record);
                                                  ^
Main.java:54: error: package Button does not exist
    private Button.OnClickListener getDBRecord = new Button.OnClickListener() {
                                                           ^
29 errors

Standard output is empty