main.xml

<?xml version="1.0" encoding="UTF-8"?>
<LinearLayout
 android:layout_height="wrap_content"
 android:layout_width="fill_parent"
 android:orientation="vertical"
 xmlns:android="http://schemas.android.com/apk/res/android"
 android:id="@+id/overview_layout">
 <LinearLayout
  android:layout_height="wrap_content"
  android:layout_width="fill_parent"
  android:orientation="horizontal"
  android:id="@+id/DailyTextView_layout">
  <TextView
  android:layout_height="wrap_content"
  android:layout_width="wrap_content"
  android:id="@+id/testView"
  android:layout_gravity="center_horizontal"/>
  
 </LinearLayout>
 
</LinearLayout>


DbAdapter.java

package com.dbTest;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

 

public class DbAdapter
{
 public static final String KEY_ROWID = "_id";
 public static final String KEY_test1="test1";
 public static final String KEY_test2="test2";
 
 
  
      private SQLiteDatabase mDb;
      private DatabaseHelper mDbHelper;
      private final Context mCtx;
     
 
      private static final String TAG = "DbAdapter";
      //"artid","aname","BirthP","BirthM","BirthTime","manse","BirthCode","BirthCode2","aSex","LeapMonth","userCode"
   
      private static final String DATABASE_NAME = "test_db";
      private static final String DATABASE_TABLE = "suntolun";
      private static final int DATABASE_VERSION = 2;
 
      private static class DatabaseHelper extends SQLiteOpenHelper
      {
            DatabaseHelper(Context context) {
                  super(context, DATABASE_NAME, null, DATABASE_VERSION);
            }
 
            @Override
            public void onCreate(SQLiteDatabase db) {
                  // TODO Auto-generated method stub
                  //db.execSQL(DATABASE_CREATE);
            }

 

            @Override
            public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
                  // TODO Auto-generated method stub
                  Log.w(TAG, "Upgrading database from version " + oldVersion + " to "
                        + newVersion + ", which will destroy all old data");
                  //db.execSQL("DROP TABLE IF EXISTS aMember");
                  //onCreate(db);
            }
      }
 
      public DbAdapter(Context ctx)
      {
            this.mCtx = ctx;
      }
 
   

 

 

 public DbAdapter(test1 test) {
  // TODO Auto-generated constructor stub
   this.mCtx = null;
 }

 

 

 

 public DbAdapter Open() throws SQLException
      {
            mDbHelper = new DatabaseHelper(mCtx);
            mDb = mDbHelper.getWritableDatabase();
            return this;
      }
 
      public void Close()
      {
            mDbHelper.close();
      }
 
    
      private void startManagingCursor(Cursor curCode) {
  // TODO Auto-generated method stub
  
 }


 public boolean DeleteList(long rowid)
      {
            return mDb.delete(DATABASE_TABLE, KEY_ROWID + "=" + rowid, null) > 0;
      }
     
   
       public Cursor suntolun_sql(String where1,String where2) throws SQLiteException{
       String selectArgs[];
       String col[];
       Cursor sun_Cur=null;
       col=new String[]{KEY_ROWID,KEY_test1,KEY_test2};
       if (Integer.parseInt(where1)==0){
        selectArgs=new String[]{where2};
        sun_Cur=mDb.query(true,DATABASE_TABLE, col, KEY_test2+"=? ", selectArgs, null, null, null,null);
       }else{
        selectArgs=new String[]{where1};
        sun_Cur=mDb.query(true,DATABASE_TABLE, col, KEY_ROWID+"=? ", selectArgs, null, null, null,null);
       }
      
       if(sun_Cur != null)
        sun_Cur.moveToFirst();
      
       return sun_Cur;
      }
    
}

test1.java

package com.dbTest;

import android.database.Cursor;

public class test1 {
 private static final String MODE_PRIVATE = null;
 private DbAdapter mDbAdapter;
 
 // DB 생성 or Open
 
 public void db_open() {
  mDbAdapter = new DbAdapter(this);
  mDbAdapter.Open(); // 우리가 사용할 db를 열어야겠죠
 }

 public String gf_test(String gf_Year,String gf_Month,String gf_Day,boolean GF_YUN){
  
  String gf_test_return="";
      
  gf_test_return=suntolun_sqlCall("10","");
     return gf_test_return ;
        
 }
 
 public String suntolun_sqlCall(String args1,String args2){
  String rtn_sun="";
  
  db_open();
  
  Cursor cur_sun = mDbAdapter.suntolun_sql("10","");
  
  if (cur_sun != null){
   rtn_sun=cur_sun.getString(cur_sun.getColumnIndex(DbAdapter.KEY_test1));
  }else{
   rtn_sun="dddd";
  }
  
  return rtn_sun;
 
 
 }

}

 제가 안드로이드 개발초자인데요
자바도 잘 모른상태에서 공부할려니 너무 힘드네요.
굵은 글자 부분이 에러인데요
해결 방법이 없을까요?
db는 Activity에서는 불러올 수 있는건가요?
답변 부탁드립니다.

이 게시물을