데이터 베이스 오류는 안나는데...

쌩초짜안드로맨

https://www.androidpub.com/android_dev_qna/1873066

2011.12.04 17:52:47

2220

앱개발 질문

오류는 안되는데 앱을 실행시키면 process 오류가 나네요ㅠㅠ

도대체 왜그런거죠?ㅠㅠ

StartActvity에서 데이터를 저장을 시키고\

GirokActivity에서 데이터를 불러오는 방식으로 구현하려고 합니다만..

소스 첨부합니다. 제발좀 도와주세요ㅠㅠ

StartActivity.java

package com.andro.ya9;

import android.app.Activity;
import android.app.AlertDialog;
import android.content.ContentValues;
import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.CheckBox;
import android.widget.RadioButton;
import android.widget.RadioGroup;
import android.widget.Spinner;

public class ReceiveStartActivity extends Activity implements OnClickListener{

private BaseballDBHelper m_dbHelper;

private int intasuk=1;
private int intasu=1;
private int inanta=1;
private int inhomerun=1;
private int inpianta=1;
private int inpihomerun=1;
private int inballnet=1;
private int insamjin=1;
private float intayul=0;

Spinner spinner1;
Spinner spinner2;
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.start);

        spinner1=(Spinner)findViewById(R.id.spinner_inning);
        ArrayAdapter<CharSequence>adapter1=
          ArrayAdapter.createFromResource(this,R.array.inning_array,android.R.layout.simple_spinner_item);

        adapter1.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
        spinner1.setAdapter(adapter1);

        spinner2=(Spinner)findViewById(R.id.spinner_name);
        ArrayAdapter<CharSequence>adapter2=
          ArrayAdapter.createFromResource(this,R.array.name_array,android.R.layout.simple_spinner_item);

        adapter2.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
        spinner2.setAdapter(adapter2);


        Button btn1=(Button)findViewById(R.id.start_prev);
        Button btn2=(Button)findViewById(R.id.start_save);

        btn1.setOnClickListener(this);
        btn2.setOnClickListener(this);


    }

    public void onClick(View v)
    {

    m_dbHelper=new BaseballDBHelper(this);

    SQLiteDatabase db = m_dbHelper.getWritableDatabase();

    ContentValues row = new ContentValues();


    String spn_inning = spinner1.getSelectedItem().toString();

  String spn_name = spinner2.getSelectedItem().toString();


  CheckBox chk_tusu = (CheckBox)findViewById(R.id.checkbox_tusu);
    String str_tusu="";
    if(chk_tusu.isChecked())
    {
      str_tusu=(String)chk_tusu.getText();
    }

    CheckBox chk_taja = (CheckBox)findViewById(R.id.checkbox_taja);
    String str_taja="";
    if(chk_taja.isChecked())
    {
      str_taja=(String)chk_taja.getText();
    }

    RadioGroup rg_result1=(RadioGroup)findViewById(R.id.radiogroup_result1);
    RadioButton rb_anta = (RadioButton)findViewById(R.id.radiobutton_anta);
    RadioButton rb_homerun = (RadioButton)findViewById(R.id.radiobutton_homerun);
    RadioButton rb_sasagu = (RadioButton)findViewById(R.id.radiobutton_sasagu);

    String str_result1 = "";

    if(rg_result1.getCheckedRadioButtonId()==R.id.radiobutton_anta)
    {
      str_result1=rb_anta.getText().toString();

    }
    if(rg_result1.getCheckedRadioButtonId()==R.id.radiobutton_homerun)
    {
      str_result1=rb_homerun.getText().toString();

    }
    if(rg_result1.getCheckedRadioButtonId()==R.id.radiobutton_sasagu)
    {
      str_result1=rb_sasagu.getText().toString();

    }

    RadioGroup rg_result2=(RadioGroup)findViewById(R.id.radiogroup_result2);
    RadioButton rb_ballnet = (RadioButton)findViewById(R.id.radiobutton_ballnet);
    RadioButton rb_out = (RadioButton)findViewById(R.id.radiobutton_out);
    RadioButton rb_samjin = (RadioButton)findViewById(R.id.radiobutton_samjin);

    String str_result2 = "";

    if(rg_result2.getCheckedRadioButtonId()==R.id.radiobutton_ballnet)
    {
      str_result2=rb_ballnet.getText().toString();

    }
    if(rg_result2.getCheckedRadioButtonId()==R.id.radiobutton_out)
    {
      str_result2=rb_out.getText().toString();

    }
    if(rg_result2.getCheckedRadioButtonId()==R.id.radiobutton_samjin)
    {
      str_result2=rb_samjin.getText().toString();

    }





    if(v.getId()==R.id.start_prev)
    {
        Intent it = new Intent(this, ReceiveBaseballActivity.class);
        startActivity(it);
        finish();
       }
    if(v.getId()==R.id.start_save)
    {
      row.put("name", "spn_name");

      db.insert("bunryu", null, row);

      if(rg_result1.getCheckedRadioButtonId()==R.id.radiobutton_anta)
        {
       if(chk_tusu.isChecked())
       {
        row.put("pianta", inpianta);
        db.insert("bunryu", null, row);
        inpianta=+1;
       }
       if(chk_taja.isChecked())
       {
       row.put("tasuk", intasuk);
       row.put("tasu", intasu);
       row.put("anta", inanta);
          db.insert("bunryu", null, row);

          intasuk=+1;
          intasu=+1;
          inanta=+1;
       }
        }
        if(rg_result1.getCheckedRadioButtonId()==R.id.radiobutton_homerun)
        {
          if(chk_tusu.isChecked())
       {
        row.put("pihomerun", inpihomerun);
        db.insert("bunryu", null, row);
        inpihomerun=+1;
       }
          if(chk_taja.isChecked())
          {
          row.put("tasuk", intasuk);
       row.put("tasu", intasu);
       row.put("anta", inanta);
       row.put("homerun", inhomerun);
          db.insert("bunryu", null, row);

          intasuk=+1;
          intasu=+1;
          inanta=+1;
          inhomerun=+1;
          }

        }
        if(rg_result1.getCheckedRadioButtonId()==R.id.radiobutton_sasagu)
        {
          if(chk_taja.isChecked())
          {
          row.put("tasuk", intasuk);
       db.insert("bunryu", null, row);

       intasuk=+1;
          }

        }

      if(rg_result2.getCheckedRadioButtonId()==R.id.radiobutton_ballnet)
        {
       if(chk_tusu.isChecked())
       {
        row.put("ballnet", inballnet);
        db.insert("bunryu", null, row);
        inballnet=+1;
       }
       if(chk_taja.isChecked())
          {
       row.put("tasuk", intasuk);
       db.insert("bunryu", null, row);

       intasuk=+1;
          }

        }
        if(rg_result2.getCheckedRadioButtonId()==R.id.radiobutton_out)
        {
          if(chk_tusu.isChecked())
       {
          row.put("tasuk", intasuk);
          row.put("tasu", intasu);
       db.insert("bunryu", null, row);

       intasuk=+1;
       intasu=+1;
       }
        }
        if(rg_result2.getCheckedRadioButtonId()==R.id.radiobutton_samjin)
        {
          if(chk_tusu.isChecked())
       {
        row.put("samjin", insamjin);
        db.insert("bunryu", null, row);
        insamjin=+1;
       }
          if(chk_taja.isChecked())
       {
          row.put("tasuk", intasuk);
          row.put("tasu", intasu);
       db.insert("bunryu", null, row);

       intasuk=+1;
       intasu=+1;
       }

        }

        intayul=(inanta)/(intasuk);

        row.put("tayul",intayul);
        db.insert("bunryu", null, row);



        m_dbHelper.close();

      AlertDialog.Builder alert = new AlertDialog.Builder(ReceiveStartActivity.this);
        alert.setTitle("기록저장");
        alert.setMessage("이닝: "+ spn_inning +"\n성명: "+ spn_name + "\n포지션: "+ str_tusu + str_taja +
           "\n결과: "+ str_result1 + str_result2);
        alert.setIcon(R.drawable.icon);
        alert.setPositiveButton("저장",null);
        alert.show();
       }

    }
}

GirokActivity.java

 package com.andro.ya9;

import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.CheckBox;
import android.widget.Spinner;
import android.widget.TextView;

public class ReceiveGirokActivity extends Activity implements OnClickListener{
 
 
 private BaseballDBHelper m_dbHelper; 
 
 TextView tasuk;
 TextView tasu;
 TextView anta;
 TextView homerun;
 TextView tayul;
 TextView pianta;
 TextView pihomerun;
 TextView ballnet;
 TextView samjin;
 
 TextView db_tasuk;
 TextView db_tasu;
 TextView db_anta;
 TextView db_homerun;
 TextView db_tayul;
 TextView db_pianta;
 TextView db_pihomerun;
 TextView db_ballnet;
 TextView db_samjin;
 
 
 
 String a= new String("투수");
 String b= new String("타자");
 
 String p1 = new String("윤 석 민");
 String p2 = new String("서 재 응");
 String p3 = new String("손 영 민");
 String p4 = new String("심 동 섭");
 String c1 = new String("차 일 목");
 String c2 = new String("김 상 훈");
 String in1 = new String("최 희 섭");
 String in2 = new String("안 치 홍");
 String in3 = new String("이 범 호");
 String in4 = new String("김 선 빈");
 String out1 = new String("김 상 현");
 String out2 = new String("이 용 규");
 String out3 = new String("이 종 범");
 String out4 = new String("나 지 완");
 
 Spinner spinner;
 
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.girok);
        
                            
        tasuk=(TextView)findViewById(R.id.girok_taja1);
        tasu=(TextView)findViewById(R.id.girok_taja2);
        anta=(TextView)findViewById(R.id.girok_taja3);
        homerun=(TextView)findViewById(R.id.girok_taja4);
        tayul=(TextView)findViewById(R.id.girok_taja5);
        
        pianta=(TextView)findViewById(R.id.girok_tusu1);
        pihomerun=(TextView)findViewById(R.id.girok_tusu2);
        ballnet=(TextView)findViewById(R.id.girok_tusu3);
        samjin=(TextView)findViewById(R.id.girok_tusu4);
        
        
        db_tasuk=(TextView)findViewById(R.id.db_taja1);
        db_tasu=(TextView)findViewById(R.id.db_taja2);
        db_anta=(TextView)findViewById(R.id.db_taja3);
        db_homerun=(TextView)findViewById(R.id.db_taja4);
        db_tayul=(TextView)findViewById(R.id.db_taja5);
        
        db_pianta=(TextView)findViewById(R.id.db_tusu1);
        db_pihomerun=(TextView)findViewById(R.id.db_tusu2);
        db_ballnet=(TextView)findViewById(R.id.db_tusu3);
        db_samjin=(TextView)findViewById(R.id.db_tusu4);
        
        
        
        
        spinner=(Spinner)findViewById(R.id.spinner_name);
        ArrayAdapter<CharSequence>adapter=
          ArrayAdapter.createFromResource(this,R.array.name_array,android.R.layout.simple_spinner_item);
        
        adapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
        spinner.setAdapter(adapter);
        
        
        
      
        
        Button btn1=(Button)findViewById(R.id.girok_prev);
        Button btn2=(Button)findViewById(R.id.girok_search);
        
        btn1.setOnClickListener(this);
        btn2.setOnClickListener(this);
        
        
    }
    
    public void onClick(View v)
    {
     m_dbHelper=new BaseballDBHelper(this);
     
     SQLiteDatabase db = m_dbHelper.getReadableDatabase();
     //String sql="select * from bunryu where name=?;";
     String [] columns1={"name"};
     String [] args={"100"};
     
     Cursor cursor;
     
     cursor = db.query("bunryu",columns1,"name=?",args,null,null,null);
          
     while(cursor.moveToNext())
     {
      String name = cursor.getString(0);
      Log.e("[db]", "[com] bunryu name = " + name);
     }
     
     
     
     tasuk.setVisibility(View.INVISIBLE);
     tasu.setVisibility(View.INVISIBLE);
     anta.setVisibility(View.INVISIBLE);
     homerun.setVisibility(View.INVISIBLE);
     tayul.setVisibility(View.INVISIBLE);
     pianta.setVisibility(View.INVISIBLE);
     pihomerun.setVisibility(View.INVISIBLE);
     ballnet.setVisibility(View.INVISIBLE);
     samjin.setVisibility(View.INVISIBLE);
     
     db_tasuk.setVisibility(View.INVISIBLE);
     db_tasu.setVisibility(View.INVISIBLE);
     db_anta.setVisibility(View.INVISIBLE);
     db_homerun.setVisibility(View.INVISIBLE);
     db_tayul.setVisibility(View.INVISIBLE);
     db_pianta.setVisibility(View.INVISIBLE);
     db_pihomerun.setVisibility(View.INVISIBLE);
     db_ballnet.setVisibility(View.INVISIBLE);
     db_samjin.setVisibility(View.INVISIBLE);
     
     CheckBox chk_giroktusu = (CheckBox)findViewById(R.id.checkbox_giroktusu);
        String str_giroktusu = "";
        if(chk_giroktusu.isChecked())
        {
         str_giroktusu=(String)chk_giroktusu.getText();
        }
        CheckBox chk_giroktaja = (CheckBox)findViewById(R.id.checkbox_giroktaja);
        String str_giroktaja = "";
        if(chk_giroktaja.isChecked())
        {
         str_giroktaja=(String)chk_giroktaja.getText();
        }
        
        
        String str_girokname = spinner.getSelectedItem().toString();
        
        
     
        if(v.getId()==R.id.girok_prev)
     {
         Intent it = new Intent(this, ReceiveBaseballActivity.class);
         startActivity(it);
         finish();
        }
     if(v.getId()==R.id.girok_search)
     {
      
      //String[] args={"100"};
      //String[] columns={"tasuk","tasu","anta","homerun","tayul"};
       //String sql1="select * from bunryu where tasuk=?;";
               
      boolean result = str_giroktusu.equals(a);
      boolean bigyo1 = str_girokname.equals(p1);
   boolean bigyo2 = str_girokname.equals(p2);
   boolean bigyo3 = str_girokname.equals(p3);
   boolean bigyo4 = str_girokname.equals(p4);
   
      if(result==true)
      {
              
       if(bigyo1==true)
       {
        String [] columns2={"pianta","pihomerun","ballnet","samjin"};
              
                 cursor = db.query("bunryu",columns2,"name=윤 석 민",null,null,null,null);
                       
           String str="";
           String str1="";
           String str2="";
           String str3="";
                 
           while(cursor.moveToNext())
        {
         int pianta=cursor.getInt(0);
         int pihomerun=cursor.getInt(1);
         int ballnet=cursor.getInt(2);
         int samjin=cursor.getInt(3);
             
         str +=(pianta);
         str1 +=(pihomerun);
         str2 +=(ballnet);
         str3 +=(samjin);
         
        }
        db_pianta.setText(str);
        db_pihomerun.setText(str1);
        db_ballnet.setText(str2);
        db_samjin.setText(str3);
        
        
        pianta.setVisibility(View.VISIBLE);
        pihomerun.setVisibility(View.VISIBLE);
        ballnet.setVisibility(View.VISIBLE);
        samjin.setVisibility(View.VISIBLE);
        db_pianta.setVisibility(View.VISIBLE);
           db_pihomerun.setVisibility(View.VISIBLE);
           db_ballnet.setVisibility(View.VISIBLE);
           db_samjin.setVisibility(View.VISIBLE);
           
           db.close();
       }
       else if(bigyo2==true)
       {
        String [] columns2={"pianta","pihomerun","ballnet","samjin"};
              
                 cursor = db.query("bunryu",columns2,"name=서 재 응",null,null,null,null);
                       
           String str="";
           String str1="";
           String str2="";
           String str3="";
                 
           while(cursor.moveToNext())
        {
         int pianta=cursor.getInt(0);
         int pihomerun=cursor.getInt(1);
         int ballnet=cursor.getInt(2);
         int samjin=cursor.getInt(3);
             
         str +=(pianta);
         str1 +=(pihomerun);
         str2 +=(ballnet);
         str3 +=(samjin);
         
        }
        db_pianta.setText(str);
        db_pihomerun.setText(str1);
        db_ballnet.setText(str2);
        db_samjin.setText(str3);
        
        
        pianta.setVisibility(View.VISIBLE);
        pihomerun.setVisibility(View.VISIBLE);
        ballnet.setVisibility(View.VISIBLE);
        samjin.setVisibility(View.VISIBLE);
        db_pianta.setVisibility(View.VISIBLE);
           db_pihomerun.setVisibility(View.VISIBLE);
           db_ballnet.setVisibility(View.VISIBLE);
           db_samjin.setVisibility(View.VISIBLE);
           
           db.close();
       }
       else if(bigyo3==true)
       {
        String [] columns2={"pianta","pihomerun","ballnet","samjin"};
              
                 cursor = db.query("bunryu",columns2,"name=손 영 민",null,null,null,null);
                       
           String str="";
           String str1="";
           String str2="";
           String str3="";
                 
           while(cursor.moveToNext())
        {
         int pianta=cursor.getInt(0);
         int pihomerun=cursor.getInt(1);
         int ballnet=cursor.getInt(2);
         int samjin=cursor.getInt(3);
             
         str +=(pianta);
         str1 +=(pihomerun);
         str2 +=(ballnet);
         str3 +=(samjin);
         
        }
        db_pianta.setText(str);
        db_pihomerun.setText(str1);
        db_ballnet.setText(str2);
        db_samjin.setText(str3);
        
        
        pianta.setVisibility(View.VISIBLE);
        pihomerun.setVisibility(View.VISIBLE);
        ballnet.setVisibility(View.VISIBLE);
        samjin.setVisibility(View.VISIBLE);
        db_pianta.setVisibility(View.VISIBLE);
           db_pihomerun.setVisibility(View.VISIBLE);
           db_ballnet.setVisibility(View.VISIBLE);
           db_samjin.setVisibility(View.VISIBLE);
           
           db.close();
       }
       else if(bigyo4==true)
       {
        String [] columns2={"pianta","pihomerun","ballnet","samjin"};
              
                 cursor = db.query("bunryu",columns2,"name=심 동 섭",null,null,null,null);
                       
           String str="";
           String str1="";
           String str2="";
           String str3="";
                 
           while(cursor.moveToNext())
        {
         int pianta=cursor.getInt(0);
         int pihomerun=cursor.getInt(1);
         int ballnet=cursor.getInt(2);
         int samjin=cursor.getInt(3);
             
         str +=(pianta);
         str1 +=(pihomerun);
         str2 +=(ballnet);
         str3 +=(samjin);
         
        }
        db_pianta.setText(str);
        db_pihomerun.setText(str1);
        db_ballnet.setText(str2);
        db_samjin.setText(str3);
        
        
        pianta.setVisibility(View.VISIBLE);
        pihomerun.setVisibility(View.VISIBLE);
        ballnet.setVisibility(View.VISIBLE);
        samjin.setVisibility(View.VISIBLE);
        db_pianta.setVisibility(View.VISIBLE);
           db_pihomerun.setVisibility(View.VISIBLE);
           db_ballnet.setVisibility(View.VISIBLE);
           db_samjin.setVisibility(View.VISIBLE);
           
           db.close();
       }
        
       
          
       
       
      }
      
         
      
      boolean result1 = str_giroktaja.equals(b);
      boolean bigyo5 = str_girokname.equals(c1);
   boolean bigyo6 = str_girokname.equals(c2);
   boolean bigyo7 = str_girokname.equals(in1);
   boolean bigyo8 = str_girokname.equals(in2);
   boolean bigyo9 = str_girokname.equals(in3);
   boolean bigyo10 = str_girokname.equals(in4);
   boolean bigyo11 = str_girokname.equals(out1);
   boolean bigyo12 = str_girokname.equals(out2);
   boolean bigyo13 = str_girokname.equals(out3);
   boolean bigyo14 = str_girokname.equals(out4);
      if(result1==true)
      {
              
       if(bigyo5==true)
       {
        String [] columns2={"tasuk","tasu","anta","homerun","tayul"};
              
                 cursor = db.query("bunryu",columns2,"name=차 일 목",null,null,null,null);
                       
           String str="";
           String str1="";
           String str2="";
           String str3="";
           //String str4="";
                 
           while(cursor.moveToNext())
        {
         int tasuk=cursor.getInt(0);
         int tasu=cursor.getInt(1);
         int anta=cursor.getInt(2);
         int homerun=cursor.getInt(3);
         //float tayul=cursor.getFloat(4);
         
         str +=(tasuk);
         str1 +=(tasu);
         str2 +=(anta);
         str3 +=(homerun);
         //str4 +=(tayul);
         
        }
        db_tasuk.setText(str);
        db_tasu.setText(str1);
        db_anta.setText(str2);
        db_homerun.setText(str3);
        //db_tayul.setText(str4);
        
        
        tasuk.setVisibility(View.VISIBLE);
           tasu.setVisibility(View.VISIBLE);
           anta.setVisibility(View.VISIBLE);
           homerun.setVisibility(View.VISIBLE);
           tayul.setVisibility(View.VISIBLE);
           db_tasuk.setVisibility(View.VISIBLE);
              db_tasu.setVisibility(View.VISIBLE);
              db_anta.setVisibility(View.VISIBLE);
              db_homerun.setVisibility(View.VISIBLE);
              db_tayul.setVisibility(View.VISIBLE);
              
              db.close();
       }
       else if(bigyo6==true)
       {
        String [] columns2={"tasuk","tasu","anta","homerun","tayul"};
              
                 cursor = db.query("bunryu",columns2,"name=김 상 훈",null,null,null,null);
                       
           String str="";
           String str1="";
           String str2="";
           String str3="";
           //String str4="";
                 
           while(cursor.moveToNext())
        {
         int tasuk=cursor.getInt(0);
         int tasu=cursor.getInt(1);
         int anta=cursor.getInt(2);
         int homerun=cursor.getInt(3);
         //float tayul=cursor.getFloat(4);
         
         str +=(tasuk);
         str1 +=(tasu);
         str2 +=(anta);
         str3 +=(homerun);
         //str4 +=(tayul);
         
        }
        db_tasuk.setText(str);
        db_tasu.setText(str1);
        db_anta.setText(str2);
        db_homerun.setText(str3);
        //db_tayul.setText(str4);
        
        tasuk.setVisibility(View.VISIBLE);
           tasu.setVisibility(View.VISIBLE);
           anta.setVisibility(View.VISIBLE);
           homerun.setVisibility(View.VISIBLE);
           tayul.setVisibility(View.VISIBLE);
           db_tasuk.setVisibility(View.VISIBLE);
              db_tasu.setVisibility(View.VISIBLE);
              db_anta.setVisibility(View.VISIBLE);
              db_homerun.setVisibility(View.VISIBLE);
              db_tayul.setVisibility(View.VISIBLE);
              
              db.close();
       }
       else if(bigyo7==true)
       {
        String [] columns2={"tasuk","tasu","anta","homerun","tayul"};
              
                 cursor = db.query("bunryu",columns2,"name=최 희 섭",null,null,null,null);
                       
           String str="";
           String str1="";
           String str2="";
           String str3="";
           //String str4="";
                 
           while(cursor.moveToNext())
        {
         int tasuk=cursor.getInt(0);
         int tasu=cursor.getInt(1);
         int anta=cursor.getInt(2);
         int homerun=cursor.getInt(3);
         //float tayul=cursor.getFloat(4);
         
         str +=(tasuk);
         str1 +=(tasu);
         str2 +=(anta);
         str3 +=(homerun);
         //str4 +=(tayul);
         
        }
        db_tasuk.setText(str);
        db_tasu.setText(str1);
        db_anta.setText(str2);
        db_homerun.setText(str3);
        //db_tayul.setText(str4);
        
        tasuk.setVisibility(View.VISIBLE);
           tasu.setVisibility(View.VISIBLE);
           anta.setVisibility(View.VISIBLE);
           homerun.setVisibility(View.VISIBLE);
           tayul.setVisibility(View.VISIBLE);
           db_tasuk.setVisibility(View.VISIBLE);
              db_tasu.setVisibility(View.VISIBLE);
              db_anta.setVisibility(View.VISIBLE);
              db_homerun.setVisibility(View.VISIBLE);
              db_tayul.setVisibility(View.VISIBLE);
              
              db.close();
       }
       else if(bigyo8==true)
       {
        String [] columns2={"tasuk","tasu","anta","homerun","tayul"};
              
                 cursor = db.query("bunryu",columns2,"name=안 치 홍",null,null,null,null);
                       
           String str="";
           String str1="";
           String str2="";
           String str3="";
           //String str4="";
                 
           while(cursor.moveToNext())
        {
         int tasuk=cursor.getInt(0);
         int tasu=cursor.getInt(1);
         int anta=cursor.getInt(2);
         int homerun=cursor.getInt(3);
         //float tayul=cursor.getFloat(4);
         
         str +=(tasuk);
         str1 +=(tasu);
         str2 +=(anta);
         str3 +=(homerun);
         //str4 +=(tayul);
         
        }
        db_tasuk.setText(str);
        db_tasu.setText(str1);
        db_anta.setText(str2);
        db_homerun.setText(str3);
        //db_tayul.setText(str4);
        
        tasuk.setVisibility(View.VISIBLE);
           tasu.setVisibility(View.VISIBLE);
           anta.setVisibility(View.VISIBLE);
           homerun.setVisibility(View.VISIBLE);
           tayul.setVisibility(View.VISIBLE);
           db_tasuk.setVisibility(View.VISIBLE);
              db_tasu.setVisibility(View.VISIBLE);
              db_anta.setVisibility(View.VISIBLE);
              db_homerun.setVisibility(View.VISIBLE);
              db_tayul.setVisibility(View.VISIBLE);
              
              db.close();
       }
       else if(bigyo9==true)
       {
        String [] columns2={"tasuk","tasu","anta","homerun","tayul"};
              
                 cursor = db.query("bunryu",columns2,"name=이 범 호",null,null,null,null);
                       
           String str="";
           String str1="";
           String str2="";
           String str3="";
           //String str4="";
                 
           while(cursor.moveToNext())
        {
         int tasuk=cursor.getInt(0);
         int tasu=cursor.getInt(1);
         int anta=cursor.getInt(2);
         int homerun=cursor.getInt(3);
         //float tayul=cursor.getFloat(4);
         
         str +=(tasuk);
         str1 +=(tasu);
         str2 +=(anta);
         str3 +=(homerun);
         //str4 +=(tayul);
         
        }
        db_tasuk.setText(str);
        db_tasu.setText(str1);
        db_anta.setText(str2);
        db_homerun.setText(str3);
        //db_tayul.setText(str4);
        
        tasuk.setVisibility(View.VISIBLE);
           tasu.setVisibility(View.VISIBLE);
           anta.setVisibility(View.VISIBLE);
           homerun.setVisibility(View.VISIBLE);
           tayul.setVisibility(View.VISIBLE);
           db_tasuk.setVisibility(View.VISIBLE);
              db_tasu.setVisibility(View.VISIBLE);
              db_anta.setVisibility(View.VISIBLE);
              db_homerun.setVisibility(View.VISIBLE);
              db_tayul.setVisibility(View.VISIBLE);
              
              db.close();
       }
       else if(bigyo10==true)
       {
        
        String [] columns2={"tasuk","tasu","anta","homerun","tayul"};
              
                 cursor = db.query("bunryu",columns2,"name=김 선 빈",null,null,null,null);
                       
           String str="";
           String str1="";
           String str2="";
           String str3="";
           //String str4="";
                 
           while(cursor.moveToNext())
        {
         int tasuk=cursor.getInt(0);
         int tasu=cursor.getInt(1);
         int anta=cursor.getInt(2);
         int homerun=cursor.getInt(3);
         //float tayul=cursor.getFloat(4);
         
         str +=(tasuk);
         str1 +=(tasu);
         str2 +=(anta);
         str3 +=(homerun);
         //str4 +=(tayul);
         
        }
        db_tasuk.setText(str);
        db_tasu.setText(str1);
        db_anta.setText(str2);
        db_homerun.setText(str3);
        //db_tayul.setText(str4);
        
        tasuk.setVisibility(View.VISIBLE);
           tasu.setVisibility(View.VISIBLE);
           anta.setVisibility(View.VISIBLE);
           homerun.setVisibility(View.VISIBLE);
           tayul.setVisibility(View.VISIBLE);
           db_tasuk.setVisibility(View.VISIBLE);
              db_tasu.setVisibility(View.VISIBLE);
              db_anta.setVisibility(View.VISIBLE);
              db_homerun.setVisibility(View.VISIBLE);
              db_tayul.setVisibility(View.VISIBLE);
              
              db.close();
       }
       else if(bigyo11==true)
       {
        String [] columns2={"tasuk","tasu","anta","homerun","tayul"};
              
                 cursor = db.query("bunryu",columns2,"name=김 상 현",null,null,null,null);
                       
           String str="";
           String str1="";
           String str2="";
           String str3="";
           //String str4="";
                 
           while(cursor.moveToNext())
        {
         int tasuk=cursor.getInt(0);
         int tasu=cursor.getInt(1);
         int anta=cursor.getInt(2);
         int homerun=cursor.getInt(3);
         //float tayul=cursor.getFloat(4);
         
         str +=(tasuk);
         str1 +=(tasu);
         str2 +=(anta);
         str3 +=(homerun);
         //str4 +=(tayul);
         
        }
        db_tasuk.setText(str);
        db_tasu.setText(str1);
        db_anta.setText(str2);
        db_homerun.setText(str3);
        //db_tayul.setText(str4);
        
        tasuk.setVisibility(View.VISIBLE);
           tasu.setVisibility(View.VISIBLE);
           anta.setVisibility(View.VISIBLE);
           homerun.setVisibility(View.VISIBLE);
           tayul.setVisibility(View.VISIBLE);
           db_tasuk.setVisibility(View.VISIBLE);
              db_tasu.setVisibility(View.VISIBLE);
              db_anta.setVisibility(View.VISIBLE);
              db_homerun.setVisibility(View.VISIBLE);
              db_tayul.setVisibility(View.VISIBLE);
              
              db.close();
       }
       else if(bigyo12==true)
       {
        String [] columns2={"tasuk","tasu","anta","homerun","tayul"};
              
                 cursor = db.query("bunryu",columns2,"name=이 용 규",null,null,null,null);
                       
           String str="";
           String str1="";
           String str2="";
           String str3="";
           //String str4="";
                 
           while(cursor.moveToNext())
        {
         int tasuk=cursor.getInt(0);
         int tasu=cursor.getInt(1);
         int anta=cursor.getInt(2);
         int homerun=cursor.getInt(3);
         //float tayul=cursor.getFloat(4);
         
         str +=(tasuk);
         str1 +=(tasu);
         str2 +=(anta);
         str3 +=(homerun);
         //str4 +=(tayul);
         
        }
        db_tasuk.setText(str);
        db_tasu.setText(str1);
        db_anta.setText(str2);
        db_homerun.setText(str3);
        //db_tayul.setText(str4);
        
        tasuk.setVisibility(View.VISIBLE);
           tasu.setVisibility(View.VISIBLE);
           anta.setVisibility(View.VISIBLE);
           homerun.setVisibility(View.VISIBLE);
           tayul.setVisibility(View.VISIBLE);
           db_tasuk.setVisibility(View.VISIBLE);
              db_tasu.setVisibility(View.VISIBLE);
              db_anta.setVisibility(View.VISIBLE);
              db_homerun.setVisibility(View.VISIBLE);
              db_tayul.setVisibility(View.VISIBLE);
              
              db.close();
       }
       else if(bigyo13==true)
       {
        
        String [] columns2={"tasuk","tasu","anta","homerun","tayul"};
              
                 cursor = db.query("bunryu",columns2,"name=이 종 범",null,null,null,null);
                       
           String str="";
           String str1="";
           String str2="";
           String str3="";
           //String str4="";
                 
           while(cursor.moveToNext())
        {
         int tasuk=cursor.getInt(0);
         int tasu=cursor.getInt(1);
         int anta=cursor.getInt(2);
         int homerun=cursor.getInt(3);
         //float tayul=cursor.getFloat(4);
         
         str +=(tasuk);
         str1 +=(tasu);
         str2 +=(anta);
         str3 +=(homerun);
         //str4 +=(tayul);
         
        }
        db_tasuk.setText(str);
        db_tasu.setText(str1);
        db_anta.setText(str2);
        db_homerun.setText(str3);
        //db_tayul.setText(str4);
        
        tasuk.setVisibility(View.VISIBLE);
           tasu.setVisibility(View.VISIBLE);
           anta.setVisibility(View.VISIBLE);
           homerun.setVisibility(View.VISIBLE);
           tayul.setVisibility(View.VISIBLE);
           db_tasuk.setVisibility(View.VISIBLE);
              db_tasu.setVisibility(View.VISIBLE);
              db_anta.setVisibility(View.VISIBLE);
              db_homerun.setVisibility(View.VISIBLE);
              db_tayul.setVisibility(View.VISIBLE);
              
              db.close();
       }
       else if(bigyo14==true)
       {
        String [] columns2={"tasuk","tasu","anta","homerun","tayul"};
              
                 cursor = db.query("bunryu",columns2,"name=나 지 완",null,null,null,null);
                       
           String str="";
           String str1="";
           String str2="";
           String str3="";
           //String str4="";
                 
           while(cursor.moveToNext())
        {
         int tasuk=cursor.getInt(0);
         int tasu=cursor.getInt(1);
         int anta=cursor.getInt(2);
         int homerun=cursor.getInt(3);
         //float tayul=cursor.getFloat(4);
         
         str +=(tasuk);
         str1 +=(tasu);
         str2 +=(anta);
         str3 +=(homerun);
         //str4 +=(tayul);
         
        }
        db_tasuk.setText(str);
        db_tasu.setText(str1);
        db_anta.setText(str2);
        db_homerun.setText(str3);
        //db_tayul.setText(str4);
        
        tasuk.setVisibility(View.VISIBLE);
           tasu.setVisibility(View.VISIBLE);
           anta.setVisibility(View.VISIBLE);
           homerun.setVisibility(View.VISIBLE);
           tayul.setVisibility(View.VISIBLE);
           db_tasuk.setVisibility(View.VISIBLE);
              db_tasu.setVisibility(View.VISIBLE);
              db_anta.setVisibility(View.VISIBLE);
              db_homerun.setVisibility(View.VISIBLE);
              db_tayul.setVisibility(View.VISIBLE);
              
              db.close();
       }
       
       
      
      }
       
        } 
          
    }
}

이 게시물을

2011.12.05 14:14:00

정품인증

로그,도 없고..주석도 없고...........누가 답변을 한단 말인가!!!!!!!

번호	분류	제목	글쓴이	날짜	추천	조회
공지	앱개발 질문	게시글 작성시 소스코드를 보기 쉽게 처리하기 33	멍멍대왕	01-21	5	739391
공지	앱개발 질문	[필독] Q&A 게시판 글작성 안내, 질문전 검색 필수! 176	회색	01-29	7	1224239
30272	앱개발 질문	동영상플레이어를 만들려구합니다	달보고	12-04		2210
30271	앱개발 질문	로그캣 분석 부탁드립니다...ㅜ_ㅜ 4	시로코	12-04		2551
30270	기타 질문	마켓의 APK 업로드가 단순모드에 활성화 안되네요? 2	볼레로	12-04		4608
30269	앱개발 질문	버튼을 눌렀을때 제 페이스북으로 연결하려면? 1	바야바	12-04		2131
30268	앱개발 질문	로그캣에 나온 에러 입니다... 도와주세요 7	시로코	12-04		3686
30267	앱개발 질문	TabActivity에 Activity를 추가시 화면 찌그러지는 문제.. 1	강호유랑객	12-04		2435
30266	앱개발 질문	스피너 포지션 값 저장하는 방법..질문입니다 3	seinrose	12-04		2514
30265	앱개발 질문	sdcard에 그림 저장, 불러오기 질문드립니다. 1	짬충	12-04		2278
30264	앱개발 질문	ProgressBar에 글자를 보이게 하고 싶은데요 3	산기생	12-04		7618
	앱개발 질문	데이터 베이스 오류는 안나는데... 1	쌩초짜안드로맨	12-04		2220
30262	앱개발 질문	카메라영상이 들어올떄 어두운지 확인하는법좀 갈켜주세요 1	콩알이	12-04		2258
30261	앱개발 질문	설치되있는 어플 패키지말고 어플명 가져오는방법은없나요 ㅠㅠ 1	PSLAB	12-04		2369
30260	앱개발 질문	버튼 클릭 시 저장된 이미지를 화면에 하나씩 출력하고 싶습니다..ㅠ	개발자지망생	12-04		2668
30259	앱개발 질문	webview 컨텐츠 크기만큼 동적으로 페이지 리사이징 하고 싶습니다.	동진2	12-04		3124
30258	앱개발 질문	super.oncreate() 내용이...	Tarrit	12-04		2847
30257	앱개발 질문	광고 삽입 문제입니다. 1	카르니틴	12-04		2277
30256	앱개발 질문	만보기 개발중 .. 2	핑퐁꽁숑	12-04		2592
30255	앱개발 질문	MediaRecorder 녹화 완료시, 완료 되었다는것을 어떻게 알수 있나요??	너무잘생겼노	12-04		3056
30254	앱개발 질문	ActivityGroup를 만들었을때 뒤로가기 버튼에 대해.. 1	강호유랑객	12-04		3100
30253	앱개발 질문	어플에서 입력한값을 함수에서 사용하는법 어떻게하나요 2	주종족은proyo	12-04		2317

쓰기

첫 페이지 735 736 737 738 739 740 741 742 743 744 끝 페이지

최근 인기글

개발자 질문/답변 게시판이 새로운 공간으로 이전되었습니다.