안드로이드 DB 오류요

Question

package com.andro;

import java.util.ArrayList;

import android.content.Context;
 import android.database.Cursor;
 import android.database.sqlite.SQLiteDatabase;
 import android.database.sqlite.SQLiteDatabase.CursorFactory;
 import android.database.sqlite.SQLiteOpenHelper;
 import android.widget.Toast;




public class DBManager {
  
     // DB관련 상수 선언
    private static final String dbName = "APinfo.db";
     private static final String tableName = "APinfo";
     public static final int dbVersion = 1;
  
     // DB관련 객체 선언
    private OpenHelper opener; // DB opener
     private SQLiteDatabase db; // DB controller
  
     // 부가적인 객체들
    private Context context;
  
     // 생성자
    public DBManager(Context context) {
         this.context = context;
         this.opener = new OpenHelper(context, dbName, null, dbVersion);
         db = opener.getWritableDatabase();
     }
  
     // Opener of DB and Table
     private class OpenHelper extends SQLiteOpenHelper {
  
         public OpenHelper(Context context, String name, CursorFactory factory,
                 int version) {
             super(context, name, null, version);
             // TODO Auto-generated constructor stub
         }
  
         // 생성된 DB가 없을 경우에 한번만 호출됨
        @Override
         public void onCreate(SQLiteDatabase arg0) {
             // String dropSql = "drop table if exists " + tableName;
             // db.execSQL(dropSql);
  
             String createSql = "create table " + tableName + " ("
                     + "id integer primary key autoincrement, " + "SSID text, "
                     + "capabilities integer, " + "passwd text)";
             arg0.execSQL(createSql);
             Toast.makeText(context, "DB is opened", 0).show();
         }
  
         @Override
         public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
             // TODO Auto-generated method stub
         }
     }
  
     // 데이터 추가
    public void insertData(APinfo info) {
         String sql = "insert into " + tableName + " values(NULL, '"
                 + info.getSSID() + "', " + info.getCapabilities() + ", '"
                 + info.getPasswd() + "');";
         db.execSQL(sql);
     }
  
     // 데이터 갱신
    public void updateData(APinfo info, int index) {
         String sql = "update " + tableName + " set SSID = '" + info.getSSID()
                 + "', capabilities = " + info.getCapabilities()
                 + ", passwd = '" + info.getPasswd() + "' where id = " + index
                 + ";";
         db.execSQL(sql);
     }
  
    
     // 데이터 삭제
    public void removeData(int index) {
         String sql = "delete from " + tableName + " where id = " + index + ";";
         db.execSQL(sql);
     }
  
     // 데이터 검색
    public APinfo selectData(int index) {
         String sql = "select * from " + tableName + " where id = " + index
                 + ";";
         Cursor result = db.rawQuery(sql, null);
  
         // result(Cursor 객체)가 비어 있으면 false 리턴
        if (result.moveToFirst()) {
             APinfo info = new APinfo(result.getInt(0), result.getString(1),
                     result.getInt(2), result.getString(3));
             result.close();
             return info;
         }
         result.close();
         return null;
     }
  
     // 데이터 전체 검색
    public ArrayList<apinfo> selectAll() {
         String sql = "select * from " + tableName + ";";
         Cursor results = db.rawQuery(sql, null);
  
         results.moveToFirst();
         ArrayList<apinfo> infos = new ArrayList<apinfo>();
  
         while (!results.isAfterLast()) {
             APinfo info = new APinfo(results.getInt(0), results.getString(1),
                     results.getInt(2), results.getString(3));
             infos.add(info);
             results.moveToNext();
         }
         results.close();
         return infos;
     }
 }







여기서 APinfo의 모든 부분에 빨간 밑줄이 가거든요..?

ArrayList<apinfo> infos = new ArrayList<apinfo>();




객체생성부터가 안되요.. 이거 지정된 객체이름이 없어서 그런거같은데..

sqlite에서 사용하는 객체가 따로있나요?

 

Answer 1

아뇨 그런거 없어요 import를 해야 빨간줄이 없어지죠

자바 가장 기초공부도 한번 하셔야 할 듯 싶네요