fork download
  1. package com.example.orisa.mytask3;
  2.  
  3. import android.app.DatePickerDialog;
  4. import android.content.ContentValues;
  5. import android.content.DialogInterface;
  6. import android.content.Intent;
  7. import android.database.Cursor;
  8. import android.database.sqlite.SQLiteDatabase;
  9. import java.util.Calendar;
  10. import android.support.design.widget.FloatingActionButton;
  11. import android.support.v7.app.AlertDialog;
  12. import android.support.v7.app.AppCompatActivity;
  13. import android.os.Bundle;
  14. import android.view.Gravity;
  15. import android.view.Menu;
  16. import android.view.MenuInflater;
  17. import android.view.MenuItem;
  18. import android.view.View;
  19. import android.view.ViewGroup;
  20. import android.widget.Button;
  21. import android.widget.CheckBox;
  22. import android.widget.CompoundButton;
  23. import android.widget.DatePicker;
  24. import android.widget.ImageButton;
  25. import android.widget.LinearLayout;
  26. import android.widget.TextView;
  27. import android.widget.Toast;
  28.  
  29. import org.w3c.dom.Text;
  30.  
  31. public class MainActivity extends AppCompatActivity {
  32.  
  33. //部品の変数
  34. TextView showDate;
  35. ImageButton prevBtn, nextBtn;
  36. LinearLayout amLayout, pmLayout;
  37. FloatingActionButton fab;
  38.  
  39. //日付を格納する変数
  40. String today_str;
  41. Calendar today_cal;
  42.  
  43. @Override
  44. protected void onCreate(Bundle savedInstanceState) {
  45. super.onCreate(savedInstanceState);
  46. setContentView(R.layout.activity_main);
  47.  
  48. //部品の取得
  49. showDate = (TextView)findViewById(R.id.showDate);
  50. prevBtn = (ImageButton) findViewById(R.id.prevBtn);
  51. nextBtn = (ImageButton) findViewById(R.id.nextBtn);
  52. amLayout = (LinearLayout)findViewById(R.id.amLayout);
  53. pmLayout = (LinearLayout)findViewById(R.id.pmLayout);
  54. fab = (FloatingActionButton)findViewById(R.id.fab);
  55.  
  56. //日付表示欄にリスナーを登録
  57. showDate.setOnClickListener(new View.OnClickListener() {
  58. @Override
  59. public void onClick(View v) {
  60. //Calendarインスタンスの取得
  61. Calendar cal = Calendar.getInstance();
  62. //DatePickerDialogインスタンスの生成
  63. DatePickerDialog dialog = new DatePickerDialog(MainActivity.this,
  64. new DatePickerDialog.OnDateSetListener() {
  65. @Override
  66. public void onDateSet(DatePicker view, int year, int month, int dayOfMonth) {
  67. //日付を取得
  68. today_str = String.format("%d/%02d/%02d", year, month+1, dayOfMonth);
  69. today_cal.set(year, month, dayOfMonth);
  70. //日付を表示
  71. showDate.setText(today_str);
  72. //データベースを表示
  73. showDB();
  74. }
  75. }, cal.get(Calendar.YEAR), cal.get(Calendar.MONTH), cal.get(Calendar.DAY_OF_MONTH));
  76. //DatePickerDialogの表示
  77. dialog.show();
  78. }
  79. });
  80.  
  81. //矢印ボタンにリスナーを設定
  82. prevBtn.setOnClickListener(new View.OnClickListener() {
  83. @Override
  84. public void onClick(View v) {
  85. //Calendar変数を前日に設定する
  86. today_cal.add(Calendar.DAY_OF_MONTH, -1);
  87. today_str = calToStr(today_cal);
  88. //日付を表示
  89. showDate.setText(today_str);
  90. //データベースを表示
  91. showDB();
  92. }
  93. });
  94.  
  95. nextBtn.setOnClickListener(new View.OnClickListener() {
  96. @Override
  97. public void onClick(View v) {
  98. //Calendar変数を翌日に設定する
  99. today_cal.add(Calendar.DAY_OF_MONTH, 1);
  100. today_str = calToStr(today_cal);
  101. //日付を表示
  102. showDate.setText(today_str);
  103. //データベースを表示
  104. showDB();
  105. }
  106. });
  107.  
  108. //FloatingActionButtonにリスナーを登録
  109. fab.setOnClickListener(new View.OnClickListener() {
  110. @Override
  111. public void onClick(View v) {
  112. //Intentインスタンスの生成
  113. Intent intent = new Intent(getApplication(), AddActivity.class);
  114. //activityの開始
  115. startActivity(intent);
  116. }
  117. });
  118. }
  119.  
  120. @Override
  121. protected void onResume() {
  122. super.onResume();
  123.  
  124. //今日の日付を取得
  125. today_cal = Calendar.getInstance();
  126. today_str = calToStr(today_cal);
  127. //日付を表示
  128. showDate.setText(today_str);
  129.  
  130. //データベースを表示
  131. showDB();
  132. }
  133.  
  134.  
  135. //Action Bar関連
  136. @Override
  137. public boolean onCreateOptionsMenu(Menu menu) {
  138. MenuInflater inflater = getMenuInflater();
  139. inflater.inflate(R.menu.main_activity_actions, menu);
  140. return super.onCreateOptionsMenu(menu);
  141. }
  142.  
  143. @Override
  144. public boolean onOptionsItemSelected(MenuItem item) {
  145. AlertDialog.Builder builder = new AlertDialog.Builder(this);
  146.  
  147. //dialogの設定
  148. builder.setMessage("Delete all tasks?");
  149.  
  150. //OKボタンの設定
  151. builder.setPositiveButton("OK", new DialogInterface.OnClickListener() {
  152. @Override
  153. public void onClick(DialogInterface dialog, int which) {
  154. //データベースの全削除
  155. deleteAllDB();
  156. //データベースの表示
  157. showDB();
  158. //Toastの表示
  159. Toast.makeText(MainActivity.this, "deleted all tasks", Toast.LENGTH_SHORT).show();
  160. }
  161. });
  162.  
  163. //CANCELボタンの設定
  164. builder.setNegativeButton("CANCEL", new DialogInterface.OnClickListener() {
  165. @Override
  166. public void onClick(DialogInterface dialog, int which) {
  167. }
  168. });
  169.  
  170. switch (item.getItemId()){
  171. case R.id.deleteAll:
  172. //dialogの描画
  173. builder.create();
  174. builder.show();
  175. break;
  176. default:
  177. break;
  178. }
  179. return super.onOptionsItemSelected(item);
  180. }
  181.  
  182. //CalendarからStringに変換するメソッド
  183. protected String calToStr(Calendar cal){
  184. String str = String.format("%d/%02d/%02d", cal.get(Calendar.YEAR),
  185. cal.get(Calendar.MONTH)+1, cal.get(Calendar.DAY_OF_MONTH));
  186. return str;
  187. }
  188.  
  189. //データベースを表示するメソッド
  190. protected void showDB(){
  191. //データベースの取得
  192. MyDBHelper helper = new MyDBHelper(MainActivity.this);
  193. final SQLiteDatabase db = helper.getWritableDatabase();
  194.  
  195. //表示のクリア
  196. amLayout.removeAllViews();
  197. pmLayout.removeAllViews();
  198.  
  199. //検索して表示
  200. final Cursor c_am = db.query("default_tb", new String[]{"task_col", "checked_col"},
  201. "date_col =? AND time_col =?", new String[] {today_str, "AM"},
  202. null, null, null);
  203. boolean bool = c_am.moveToFirst();
  204. while(bool){
  205. //CheckBoxの設定
  206. final CheckBox cb = new CheckBox(MainActivity.this);
  207. // TODO: CheckBoxのテキストサイズを設定
  208. cb.setText(c_am.getString(0));
  209. cb.setTextAppearance(R.style.TextAppearance_AppCompat_Medium);
  210.  
  211. //CheckBoxにリスナーをつける
  212. cb.setOnCheckedChangeListener(new CompoundButton.OnCheckedChangeListener() {
  213. @Override
  214. public void onCheckedChanged(CompoundButton buttonView, boolean isChecked) {
  215. //DBのアップデート処理
  216. ContentValues val = new ContentValues();
  217. val.put("checked_col", 1);
  218. db.update("default_tb", val, "task_col =?", new String[]{cb.getText().toString()});
  219. }
  220. });
  221. //checkedが1(=TRUE)なら、checkedにする
  222. if(c_am.getInt(1) == 1){
  223. cb.setChecked(true);
  224. }
  225.  
  226. //全体のlayoutに追加
  227. amLayout.addView(setRow(cb));
  228. bool = c_am.moveToNext();
  229. }
  230. c_am.close();
  231.  
  232. final Cursor c_pm = db.query("default_tb", new String[]{"task_col", "checked_col"},
  233. "date_col =? AND time_col =?", new String[] {today_str, "PM"},
  234. null, null, null);
  235. bool = c_pm.moveToFirst();
  236. while(bool){
  237. //CheckBoxの設定
  238. final CheckBox cb = new CheckBox(MainActivity.this);
  239. cb.setText(c_pm.getString(0));
  240. cb.setTextAppearance(R.style.TextAppearance_AppCompat_Medium);
  241. //CheckBoxにリスナーをつける
  242. cb.setOnCheckedChangeListener(new CompoundButton.OnCheckedChangeListener() {
  243. @Override
  244. public void onCheckedChanged(CompoundButton buttonView, boolean isChecked) {
  245. //DBのアップデート処理
  246. ContentValues val = new ContentValues();
  247. val.put("checked_col", 1);
  248. db.update("default_tb", val, "task_col =?", new String[]{cb.getText().toString()});
  249. }
  250. });
  251. //checkedが1(=TRUE)なら、checkedにする
  252. if(c_pm.getInt(1) == 1){
  253. cb.setChecked(true);
  254. }
  255.  
  256. //全体のlayoutに追加
  257. pmLayout.addView(setRow(cb));
  258. bool = c_pm.moveToNext();
  259. }
  260. c_pm.close();
  261. }
  262.  
  263. //showDBの中で、部品を配置するメソッド
  264. protected LinearLayout setRow(CheckBox cb_param){
  265. //CheckBox変数
  266. final CheckBox cb = cb_param;
  267.  
  268. //アイコンの設定
  269. ImageButton edit_btn = new ImageButton(MainActivity.this);
  270. edit_btn.setImageResource(R.drawable.ic_edit);
  271. edit_btn.setBackground(null);
  272.  
  273. ImageButton delete_btn = new ImageButton(MainActivity.this);
  274. delete_btn.setImageResource(R.drawable.ic_delete);
  275. delete_btn.setBackground(null);
  276.  
  277. //リスナーの登録
  278. edit_btn.setOnClickListener(new View.OnClickListener() {
  279. @Override
  280. public void onClick(View v) {
  281. //UPDATE画面に遷移
  282. Intent intent = new Intent(getApplication(), UpdateActivity.class);
  283. //intentにデータを渡す
  284. intent.putExtra("task_data", cb.getText().toString());
  285. startActivity(intent);
  286. }
  287. });
  288. delete_btn.setOnClickListener(new View.OnClickListener() {
  289. @Override
  290. public void onClick(View v) {
  291. //データベースを削除
  292. deleteDb(cb.getText().toString());
  293.  
  294. //CheckBoxが入っているLayoutを取得
  295. LinearLayout ll = (LinearLayout)cb.getParent();
  296. //Layoutが入ってるLayoutを取得
  297. LinearLayout ll_p = (LinearLayout)ll.getParent();
  298. //CheckBoxの入っているLayoutのindexを取得
  299. int ll_index = ((ViewGroup)ll_p).indexOfChild(ll);
  300. //CheckBoxの入っているLayoutを削除
  301. ll_p.removeViewAt(ll_index);
  302. }
  303. });
  304.  
  305. //LinearLayoutの設定
  306. LinearLayout layout = new LinearLayout(MainActivity.this);//インスタンスの生成
  307. layout.setGravity(Gravity.CENTER_VERTICAL);//Gravityの設定
  308.  
  309. //CheckBoxとImageButtonの間をうめるやつ
  310. View view = new View(MainActivity.this);
  311. LinearLayout.LayoutParams v_lp = new LinearLayout.LayoutParams(
  312. ViewGroup.LayoutParams.WRAP_CONTENT, 1, 1f);
  313. view.setLayoutParams(v_lp);
  314.  
  315. //LinearLayoutに部品を追加
  316. layout.addView(cb);
  317. layout.addView(view);
  318. layout.addView(edit_btn);
  319. layout.addView(delete_btn);
  320.  
  321. return layout;
  322. }
  323.  
  324. //データベースを削除
  325. protected void deleteDb(String task_str){
  326. //データベースの取得
  327. MyDBHelper helper = new MyDBHelper(MainActivity.this);
  328. SQLiteDatabase db = helper.getWritableDatabase();
  329.  
  330. //データベースの削除
  331. db.delete("default_tb", "task_col =?", new String[]{task_str});
  332. }
  333.  
  334. //データベースの全削除をするメソッド
  335. protected void deleteAllDB(){
  336. //データベースの取得
  337. MyDBHelper helper = new MyDBHelper(MainActivity.this);
  338. SQLiteDatabase db = helper.getWritableDatabase();
  339.  
  340. //データベース削除
  341. db.delete("default_tb", null, null);
  342. }
  343. }
  344.  
Compilation error #stdin compilation error #stdout 0s 0KB
stdin
Standard input is empty
compilation info
Main.java:31: error: class MainActivity is public, should be declared in a file named MainActivity.java
public class MainActivity extends AppCompatActivity {
       ^
Main.java:3: error: package android.app does not exist
import android.app.DatePickerDialog;
                  ^
Main.java:4: error: package android.content does not exist
import android.content.ContentValues;
                      ^
Main.java:5: error: package android.content does not exist
import android.content.DialogInterface;
                      ^
Main.java:6: error: package android.content does not exist
import android.content.Intent;
                      ^
Main.java:7: error: package android.database does not exist
import android.database.Cursor;
                       ^
Main.java:8: error: package android.database.sqlite does not exist
import android.database.sqlite.SQLiteDatabase;
                              ^
Main.java:10: error: package android.support.design.widget does not exist
import android.support.design.widget.FloatingActionButton;
                                    ^
Main.java:11: error: package android.support.v7.app does not exist
import android.support.v7.app.AlertDialog;
                             ^
Main.java:12: error: package android.support.v7.app does not exist
import android.support.v7.app.AppCompatActivity;
                             ^
Main.java:13: error: package android.os does not exist
import android.os.Bundle;
                 ^
Main.java:14: error: package android.view does not exist
import android.view.Gravity;
                   ^
Main.java:15: error: package android.view does not exist
import android.view.Menu;
                   ^
Main.java:16: error: package android.view does not exist
import android.view.MenuInflater;
                   ^
Main.java:17: error: package android.view does not exist
import android.view.MenuItem;
                   ^
Main.java:18: error: package android.view does not exist
import android.view.View;
                   ^
Main.java:19: error: package android.view does not exist
import android.view.ViewGroup;
                   ^
Main.java:20: error: package android.widget does not exist
import android.widget.Button;
                     ^
Main.java:21: error: package android.widget does not exist
import android.widget.CheckBox;
                     ^
Main.java:22: error: package android.widget does not exist
import android.widget.CompoundButton;
                     ^
Main.java:23: error: package android.widget does not exist
import android.widget.DatePicker;
                     ^
Main.java:24: error: package android.widget does not exist
import android.widget.ImageButton;
                     ^
Main.java:25: error: package android.widget does not exist
import android.widget.LinearLayout;
                     ^
Main.java:26: error: package android.widget does not exist
import android.widget.TextView;
                     ^
Main.java:27: error: package android.widget does not exist
import android.widget.Toast;
                     ^
Main.java:31: error: cannot find symbol
public class MainActivity extends AppCompatActivity {
                                  ^
  symbol: class AppCompatActivity
Main.java:34: error: cannot find symbol
    TextView showDate;
    ^
  symbol:   class TextView
  location: class MainActivity
Main.java:35: error: cannot find symbol
    ImageButton prevBtn, nextBtn;
    ^
  symbol:   class ImageButton
  location: class MainActivity
Main.java:36: error: cannot find symbol
    LinearLayout amLayout, pmLayout;
    ^
  symbol:   class LinearLayout
  location: class MainActivity
Main.java:37: error: cannot find symbol
    FloatingActionButton fab;
    ^
  symbol:   class FloatingActionButton
  location: class MainActivity
Main.java:44: error: cannot find symbol
    protected void onCreate(Bundle savedInstanceState) {
                            ^
  symbol:   class Bundle
  location: class MainActivity
Main.java:137: error: cannot find symbol
    public boolean onCreateOptionsMenu(Menu menu) {
                                       ^
  symbol:   class Menu
  location: class MainActivity
Main.java:144: error: cannot find symbol
    public boolean onOptionsItemSelected(MenuItem item) {
                                         ^
  symbol:   class MenuItem
  location: class MainActivity
Main.java:264: error: cannot find symbol
    protected LinearLayout setRow(CheckBox cb_param){
                                  ^
  symbol:   class CheckBox
  location: class MainActivity
Main.java:264: error: cannot find symbol
    protected LinearLayout setRow(CheckBox cb_param){
              ^
  symbol:   class LinearLayout
  location: class MainActivity
Main.java:43: error: method does not override or implement a method from a supertype
    @Override
    ^
Main.java:45: error: cannot find symbol
        super.onCreate(savedInstanceState);
        ^
  symbol:   variable super
  location: class MainActivity
Main.java:46: error: package R does not exist
        setContentView(R.layout.activity_main);
                        ^
Main.java:49: error: cannot find symbol
        showDate = (TextView)findViewById(R.id.showDate);
                    ^
  symbol:   class TextView
  location: class MainActivity
Main.java:49: error: package R does not exist
        showDate = (TextView)findViewById(R.id.showDate);
                                           ^
Main.java:50: error: cannot find symbol
        prevBtn = (ImageButton) findViewById(R.id.prevBtn);
                   ^
  symbol:   class ImageButton
  location: class MainActivity
Main.java:50: error: package R does not exist
        prevBtn = (ImageButton) findViewById(R.id.prevBtn);
                                              ^
Main.java:51: error: cannot find symbol
        nextBtn = (ImageButton) findViewById(R.id.nextBtn);
                   ^
  symbol:   class ImageButton
  location: class MainActivity
Main.java:51: error: package R does not exist
        nextBtn = (ImageButton) findViewById(R.id.nextBtn);
                                              ^
Main.java:52: error: cannot find symbol
        amLayout = (LinearLayout)findViewById(R.id.amLayout);
                    ^
  symbol:   class LinearLayout
  location: class MainActivity
Main.java:52: error: package R does not exist
        amLayout = (LinearLayout)findViewById(R.id.amLayout);
                                               ^
Main.java:53: error: cannot find symbol
        pmLayout = (LinearLayout)findViewById(R.id.pmLayout);
                    ^
  symbol:   class LinearLayout
  location: class MainActivity
Main.java:53: error: package R does not exist
        pmLayout = (LinearLayout)findViewById(R.id.pmLayout);
                                               ^
Main.java:54: error: cannot find symbol
        fab = (FloatingActionButton)findViewById(R.id.fab);
               ^
  symbol:   class FloatingActionButton
  location: class MainActivity
Main.java:54: error: package R does not exist
        fab = (FloatingActionButton)findViewById(R.id.fab);
                                                  ^
Main.java:57: error: package View does not exist
        showDate.setOnClickListener(new View.OnClickListener() {
                                            ^
Main.java:82: error: package View does not exist
        prevBtn.setOnClickListener(new View.OnClickListener() {
                                           ^
Main.java:95: error: package View does not exist
        nextBtn.setOnClickListener(new View.OnClickListener() {
                                           ^
Main.java:109: error: package View does not exist
        fab.setOnClickListener(new View.OnClickListener() {
                                       ^
Main.java:120: error: method does not override or implement a method from a supertype
    @Override
    ^
Main.java:122: error: cannot find symbol
        super.onResume();
        ^
  symbol:   variable super
  location: class MainActivity
Main.java:136: error: method does not override or implement a method from a supertype
    @Override
    ^
Main.java:138: error: cannot find symbol
        MenuInflater inflater = getMenuInflater();
        ^
  symbol:   class MenuInflater
  location: class MainActivity
Main.java:138: error: cannot find symbol
        MenuInflater inflater = getMenuInflater();
                                ^
  symbol:   method getMenuInflater()
  location: class MainActivity
Main.java:139: error: package R does not exist
        inflater.inflate(R.menu.main_activity_actions, menu);
                          ^
Main.java:140: error: cannot find symbol
        return super.onCreateOptionsMenu(menu);
               ^
  symbol:   variable super
  location: class MainActivity
Main.java:143: error: method does not override or implement a method from a supertype
    @Override
    ^
Main.java:145: error: package AlertDialog does not exist
        AlertDialog.Builder builder = new AlertDialog.Builder(this);
                   ^
Main.java:145: error: package AlertDialog does not exist
        AlertDialog.Builder builder = new AlertDialog.Builder(this);
                                                     ^
Main.java:151: error: package DialogInterface does not exist
        builder.setPositiveButton("OK", new DialogInterface.OnClickListener() {
                                                           ^
Main.java:164: error: package DialogInterface does not exist
        builder.setNegativeButton("CANCEL", new DialogInterface.OnClickListener() {
                                                               ^
Main.java:171: error: package R does not exist
            case R.id.deleteAll:
                  ^
Main.java:179: error: cannot find symbol
        return super.onOptionsItemSelected(item);
               ^
  symbol:   variable super
  location: class MainActivity
Main.java:192: error: cannot find symbol
        MyDBHelper helper = new MyDBHelper(MainActivity.this);
        ^
  symbol:   class MyDBHelper
  location: class MainActivity
Main.java:192: error: cannot find symbol
        MyDBHelper helper = new MyDBHelper(MainActivity.this);
                                ^
  symbol:   class MyDBHelper
  location: class MainActivity
Main.java:193: error: cannot find symbol
        final SQLiteDatabase db = helper.getWritableDatabase();
              ^
  symbol:   class SQLiteDatabase
  location: class MainActivity
Main.java:200: error: cannot find symbol
        final Cursor c_am = db.query("default_tb", new String[]{"task_col", "checked_col"},
              ^
  symbol:   class Cursor
  location: class MainActivity
Main.java:206: error: cannot find symbol
            final CheckBox cb = new CheckBox(MainActivity.this);
                  ^
  symbol:   class CheckBox
  location: class MainActivity
Main.java:206: error: cannot find symbol
            final CheckBox cb = new CheckBox(MainActivity.this);
                                    ^
  symbol:   class CheckBox
  location: class MainActivity
Main.java:209: error: package R does not exist
            cb.setTextAppearance(R.style.TextAppearance_AppCompat_Medium);
                                  ^
Main.java:212: error: package CompoundButton does not exist
            cb.setOnCheckedChangeListener(new CompoundButton.OnCheckedChangeListener() {
                                                            ^
Main.java:232: error: cannot find symbol
        final Cursor c_pm = db.query("default_tb", new String[]{"task_col", "checked_col"},
              ^
  symbol:   class Cursor
  location: class MainActivity
Main.java:238: error: cannot find symbol
            final CheckBox cb = new CheckBox(MainActivity.this);
                  ^
  symbol:   class CheckBox
  location: class MainActivity
Main.java:238: error: cannot find symbol
            final CheckBox cb = new CheckBox(MainActivity.this);
                                    ^
  symbol:   class CheckBox
  location: class MainActivity
Main.java:240: error: package R does not exist
            cb.setTextAppearance(R.style.TextAppearance_AppCompat_Medium);
                                  ^
Main.java:242: error: package CompoundButton does not exist
            cb.setOnCheckedChangeListener(new CompoundButton.OnCheckedChangeListener() {
                                                            ^
Main.java:266: error: cannot find symbol
        final CheckBox cb = cb_param;
              ^
  symbol:   class CheckBox
  location: class MainActivity
Main.java:269: error: cannot find symbol
        ImageButton edit_btn = new ImageButton(MainActivity.this);
        ^
  symbol:   class ImageButton
  location: class MainActivity
Main.java:269: error: cannot find symbol
        ImageButton edit_btn = new ImageButton(MainActivity.this);
                                   ^
  symbol:   class ImageButton
  location: class MainActivity
Main.java:270: error: package R does not exist
        edit_btn.setImageResource(R.drawable.ic_edit);
                                   ^
Main.java:273: error: cannot find symbol
        ImageButton delete_btn = new ImageButton(MainActivity.this);
        ^
  symbol:   class ImageButton
  location: class MainActivity
Main.java:273: error: cannot find symbol
        ImageButton delete_btn = new ImageButton(MainActivity.this);
                                     ^
  symbol:   class ImageButton
  location: class MainActivity
Main.java:274: error: package R does not exist
        delete_btn.setImageResource(R.drawable.ic_delete);
                                     ^
Main.java:278: error: package View does not exist
        edit_btn.setOnClickListener(new View.OnClickListener() {
                                            ^
Main.java:288: error: package View does not exist
        delete_btn.setOnClickListener(new View.OnClickListener() {
                                              ^
Main.java:306: error: cannot find symbol
        LinearLayout layout = new LinearLayout(MainActivity.this);//?????????
        ^
  symbol:   class LinearLayout
  location: class MainActivity
Main.java:306: error: cannot find symbol
        LinearLayout layout = new LinearLayout(MainActivity.this);//?????????
                                  ^
  symbol:   class LinearLayout
  location: class MainActivity
Main.java:307: error: cannot find symbol
        layout.setGravity(Gravity.CENTER_VERTICAL);//Gravity???
                          ^
  symbol:   variable Gravity
  location: class MainActivity
Main.java:310: error: cannot find symbol
        View view = new View(MainActivity.this);
        ^
  symbol:   class View
  location: class MainActivity
Main.java:310: error: cannot find symbol
        View view = new View(MainActivity.this);
                        ^
  symbol:   class View
  location: class MainActivity
Main.java:311: error: package LinearLayout does not exist
        LinearLayout.LayoutParams v_lp = new LinearLayout.LayoutParams(
                    ^
Main.java:311: error: package LinearLayout does not exist
        LinearLayout.LayoutParams v_lp = new LinearLayout.LayoutParams(
                                                         ^
Main.java:312: error: package ViewGroup does not exist
                ViewGroup.LayoutParams.WRAP_CONTENT, 1, 1f);
                         ^
Main.java:327: error: cannot find symbol
        MyDBHelper helper = new MyDBHelper(MainActivity.this);
        ^
  symbol:   class MyDBHelper
  location: class MainActivity
Main.java:327: error: cannot find symbol
        MyDBHelper helper = new MyDBHelper(MainActivity.this);
                                ^
  symbol:   class MyDBHelper
  location: class MainActivity
100 errors
stdout
Standard output is empty