package com.cookandroid.Joljag.mainp;
import android.annotation.SuppressLint;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.v4.app.Fragment;
import android.view.LayoutInflater;
import android.view.View;
import android.view.View.OnClickListener;
import android.view.ViewGroup;
import android.widget.Button;
import android.widget.ListView;
import android.widget.TextView;
@SuppressLint("ValidFragment")
public class Tab1 extends Fragment {
Context mContext;
DBHelper dbHelp;
Cursor cursor;
SQLiteDatabase sqlDB;
TextView txt1;
TextView txt2;
public Tab1(Context context) {
mContext = context;
}
@Override
public View onCreateView(LayoutInflater inflater,
ViewGroup container, Bundle savedInstanceState) {
View view = inflater.inflate(R.layout.activity_tab1, null);
Button button1 = (Button) view.findViewById(com.tistory.whdghks913.exampletabs.R.id.btntest);
txt1 = (TextView) view.findViewById(com.tistory.whdghks913.exampletabs.R.id.listvDb);
txt2 = (TextView) view.findViewById(com.tistory.whdghks913.exampletabs.R.id.listvDb1);
button1.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
sqlDB = dbHelp.getReadableDatabase();
cursor = sqlDB.rawQuery("SELECT * FROM mGameNews;", null);
String strTitel = "게임 명" + "\r\n" + "------" + "\r\n";
String strMemo = "게임 소식" + "\r\n" + "------" + "\r\n";
while (cursor.moveToNext()){
strTitel +=cursor.getString(0) + "\r\n";
strMemo +=cursor.getString(1) + "\r\n";
}
txt1.setText(strTitel);
txt2.setText(strMemo);
txt1.setText(strTitel);
cursor.close();
sqlDB.close();
}
});
return view;
}
}
------------------------------------
Activity가 아닌 fragment 여서 onClick부분에서 클릭하면 앱이 꺼집니다.
조언좀 구해요~