Listviewをカスタマイズしたい

前提・実現したいこと

Listviewのカスタマイズ

発生している問題・エラーメッセージ

E/AndroidRuntime: FATAL EXCEPTION: main
                  Process: com.example.innovation.f_featnote, PID: 3765
                  java.lang.NullPointerException: Attempt to invoke virtual method 'void android.widget.TextView.setText(java.lang.CharSequence)' on a null object reference
                      at com.example.innovation.f_featnote.ListAdapter.getView(SqlLoad.java:145)
                      at android.widget.AbsListView.obtainView(AbsListView.java:2344)
                      at android.widget.ListView.makeAndAddView(ListView.java:1864)
                      at android.widget.ListView.fillDown(ListView.java:698)
                      at android.widget.ListView.fillFromTop(ListView.java:759)
                      at android.widget.ListView.layoutChildren(ListView.java:1673)
                      at android.widget.AbsListView.onLayout(AbsListView.java:2148)
                      at android.view.View.layout(View.java:15596)
                      at android.view.ViewGroup.layout(ViewGroup.java:4966)
                      at android.widget.LinearLayout.setChildFrame(LinearLayout.java:1703)
                      at android.widget.LinearLayout.layoutVertical(LinearLayout.java:1557)
                      at android.widget.LinearLayout.onLayout(LinearLayout.java:1466)
                      at android.view.View.layout(View.java:15596)
                      at android.view.ViewGroup.layout(ViewGroup.java:4966)
                      at android.widget.FrameLayout.layoutChildren(FrameLayout.java:573)
                      at android.widget.FrameLayout.onLayout(FrameLayout.java:508)
                      at android.view.View.layout(View.java:15596)
                      at android.view.ViewGroup.layout(ViewGroup.java:4966)
                      at android.widget.LinearLayout.setChildFrame(LinearLayout.java:1703)
                      at android.widget.LinearLayout.layoutVertical(LinearLayout.java:1557)
                      at android.widget.LinearLayout.onLayout(LinearLayout.java:1466)
                      at android.view.View.layout(View.java:15596)
                      at android.view.ViewGroup.layout(ViewGroup.java:4966)
                      at android.widget.FrameLayout.layoutChildren(FrameLayout.java:573)
                      at android.widget.FrameLayout.onLayout(FrameLayout.java:508)
                      at android.view.View.layout(View.java:15596)
                      at android.view.ViewGroup.layout(ViewGroup.java:4966)
                      at android.view.ViewRootImpl.performLayout(ViewRootImpl.java:2072)
                      at android.view.ViewRootImpl.performTraversals(ViewRootImpl.java:1829)
                      at android.view.ViewRootImpl.doTraversal(ViewRootImpl.java:1054)
                      at android.view.ViewRootImpl$TraversalRunnable.run(ViewRootImpl.java:5779)
                      at android.view.Choreographer$CallbackRecord.run(Choreographer.java:767)
                      at android.view.Choreographer.doCallbacks(Choreographer.java:580)
                      at android.view.Choreographer.doFrame(Choreographer.java:550)
                      at android.view.Choreographer$FrameDisplayEventReceiver.run(Choreographer.java:753)
                      at android.os.Handler.handleCallback(Handler.java:739)
                      at android.os.Handler.dispatchMessage(Handler.java:95)
                      at android.os.Looper.loop(Looper.java:135)
                      at android.app.ActivityThread.main(ActivityThread.java:5221)
                      at java.lang.reflect.Method.invoke(Native Method)
                      at java.lang.reflect.Method.invoke(Method.java:372)
                      at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:899)
                      at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:694)

SqlLoad.java

package com.example.innovation.f_featnote;

import 省略

public class SqlLoad extends Activity {
    ListView lv;
    static String[][] list;
    static String[] Did = new String[2];
    static long id_;
    static String[] Data;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.sql_load);
       // final boolean[] flg = new boolean[1];




        Main();
    }

    public void Main(){

        Data = SQLDataGet();
       // lv = new ListView(this);
    //    ArrayList<String> Data = new ArrayList<>(Arrays.asList(SQLDataGet()));
        lv = (ListView)findViewById(R.id.sql_load_main);
        List Dlist = new ArrayList<DataList>();
        for (int i = 0; i< list.length;i++){
            DataList dataList = new DataList();
            dataList.setTitle(list[i][0]);
            dataList.setContent(list[i][1]);
            dataList.setDate(list[i][2]);
            Dlist.add(dataList);
        }
       // ArrayAdapter<String> adapter = new ArrayAdapter<>(this, android.R.layout.simple_list_item_1, data);
        ListAdapter adapter = new ListAdapter(getApplicationContext(),Dlist);
        lv.setAdapter(adapter);//リスト表示
     //   setContentView(lv,new ViewGroup.LayoutParams(WC,WC));

        lv.setOnItemClickListener(new AdapterView.OnItemClickListener(){
            @Override
            public void onItemClick(AdapterView<?> parent,View view,int position,long id){
                //  ListView listView = (ListView) parent;
                //   String item = (String)listView.getItemAtPosition(position);
                Log.d("id",""+id);
                id_ = id;
                SQLDContentGet();
                SQLDataSet();
                finish();
                // Toast.makeText(getApplicationContext(),item + "clicked",Toast.LENGTH_LONG).show();
            }
        });
    }





    public String[] SQLDataGet(){
        MainActivity main = new MainActivity();
        Context con = this;
        SQLiteDatabase sdb = main.SQLopen(con.getApplicationContext());//MainActivity参照
        final String[] columns = new String[]{"title","content","date"};//列名
       // String where = null;//条件
      //  String[] Args = new String[]{""};//？の置き換え
        @SuppressLint("Recycle") Cursor c = sdb.query("MemoContents", columns, null, null, null, null, null);
        int startPostion = c.getPosition();
        c.moveToFirst();
       // Log.d("DBG",""+c.getCount());
        list = new String[c.getCount()][columns.length];
        String[] Dlist = new String[c.getCount()];
        for (int i = 0; i< list.length; i++){
            for (int j = 0; j < list[1].length; j++){
                list[i][j] = c.getString(j);
                Log.d(i+"-"+j,list[i][j]);//デバッグ
                Dlist[i] = list[i][0];
            }
            c.moveToNext();
        }
        c.moveToPosition(startPostion);

      //  finish();
        return Dlist;
    }

    public void SQLDContentGet(){
        Did[0] = list[(int)id_][0];
        Did[1] = list[(int)id_][1];
    }

    public void SQLDataSet(){
        Intent data = new Intent();
        Bundle bundle = new Bundle();
        data.putExtra("key.data",Did);
        data.putExtras(bundle);
        setResult(RESULT_OK,data);
        finish();
    }

    @Override
    public void finish() {
        super.finish();
    }
}

class ListAdapter extends ArrayAdapter<DataList>{
    private LayoutInflater inflater;
    private TextView title;
    private TextView content;
    private TextView date;

    public ListAdapter(Context context, List<DataList> objects){
        super(context,0,objects);
        inflater = (LayoutInflater)context.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
    }

    public View getView(final int position, View convertView, ViewGroup parent){
        if (convertView == null){
            convertView = inflater.inflate(R.layout.sql_load,null);
        }
        final DataList list = this.getItem(position);
        if (list != null){
            title = (TextView)convertView.findViewById(R.id.textView1);
            title.setText(list.getTitle());
            content = (TextView)convertView.findViewById(R.id.textView2);
            content.setText(list.getContent());
            date = (TextView)convertView.findViewById(R.id.textView3);
            date.setText(list.getDate());
        }
        return convertView;
    }
}

DataList.java

package com.example.innovation.f_featnote;

public class DataList{
    private  String title = "";
    private String content = "";
    private String date = "";

    public void setTitle(String title){
        this.title = title;
    }
    public String getTitle(){
        return title;
    }
    public void setContent(String content){
        this.content = content;
    }
    public String getContent(){
        return content;
    }
    public void setDate(String date){
        this.date = date;
    }
    public String getDate(){
        return date;
    }
}