엄청 간단하게 했는데 회원가입 버튼을 누르면 오류가 생기네요
package com.example.dbdbd;
import java.io.File;
public class MainActivity extends Activity implements OnClickListener {
public SQLiteDatabase db;
public Cursor cursor;
public SimpleCursorAdapter Adapter=null;
public SimpleCursorAdapter AdapterStomach=null;
public SimpleCursorAdapter AdapterColon=null;
public SimpleCursorAdapter AdapterLiver=null;
public SimpleCursorAdapter AdapterBreast=null;
public SimpleCursorAdapter AdapterCervix=null;
public static final String ROOT_DIR = "/data/data/com.example.dbdbd/databases/";
EditText edit_id, edit_pass ;
ProductDBHelper mHelper;
public void setDB() {
File folder = new File(ROOT_DIR);
if(folder.exists()) {
}
else {
folder.mkdirs();
//Toast.makeText(this, "폴더생성", Toast.LENGTH_LONG).show();
}
AssetManager assetManager = getResources().getAssets();
File outfile = new File(ROOT_DIR+"DBDBD.db"); //--폰에 위치할 경로
InputStream is = null;
FileOutputStream fo = null;
long filesize = 0;
try {
// --asset 폴더 및 복사할 DB 지정
is = assetManager.open("DBDBD.db", AssetManager.ACCESS_BUFFER);
filesize = is.available(); //--사이즈 검증
// 파일이 없거나 패키지 폴더에 설치된 DB파일이 포함된 DB파일 보다 크기가 같지않을 경우 DB파일을 덮어 쓴다.
if (outfile.length() <= 0) {
byte[] tempdata = new byte[(int) filesize];
is.read(tempdata);
is.close();
outfile.createNewFile();
fo = new FileOutputStream(outfile);
fo.write(tempdata);
fo.close();
}
else
{
//Toast.makeText(this, "db있음", Toast.LENGTH_LONG).show();
}
} catch (IOException e) {
Toast.makeText(this, "db이동실패", Toast.LENGTH_LONG).show();
}
}
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Button btn = (Button)findViewById(R.id.button_send);
btn.setOnClickListener(this);
Button btn2 = (Button)findViewById(R.id.button_cancel);
btn2.setOnClickListener(this);
edit_id = (EditText) findViewById(R.id.edit_id);
edit_pass = (EditText) findViewById(R.id.edit_id);
}
public void onClick(View v) {
if (v.getId() == R.id.button_send){
if ((edit_id.getText().toString().equals("")) ||
(edit_pass.getText().toString().equals(""))) {
Toast.makeText(getApplicationContext(), "자료 입력 바람",
Toast.LENGTH_SHORT).show(); }
else {
mHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("id", edit_id.getText().toString() );
values.put("pass", edit_pass.getText().toString() );
db.insert("member", null, values);
db.close();
}
}
}
}
이게 전체코드구요
이건 sqlite에 미리 만들어 놓은 테이블이구
05-29 13:42:10.200: E/AndroidRuntime(14482): FATAL EXCEPTION: main
05-29 13:42:10.200: E/AndroidRuntime(14482): java.lang.NullPointerException
05-29 13:42:10.200: E/AndroidRuntime(14482): at com.example.dbdbd.MainActivity.onClick(MainActivity.java:100)
05-29 13:42:10.200: E/AndroidRuntime(14482): at android.view.View.performClick(View.java:4084)
05-29 13:42:10.200: E/AndroidRuntime(14482): at android.view.View$PerformClick.run(View.java:16966)
05-29 13:42:10.200: E/AndroidRuntime(14482): at android.os.Handler.handleCallback(Handler.java:615)
05-29 13:42:10.200: E/AndroidRuntime(14482): at android.os.Handler.dispatchMessage(Handler.java:92)
05-29 13:42:10.200: E/AndroidRuntime(14482): at android.os.Looper.loop(Looper.java:137)
05-29 13:42:10.200: E/AndroidRuntime(14482): at android.app.ActivityThread.main(ActivityThread.java:4745)
05-29 13:42:10.200: E/AndroidRuntime(14482): at java.lang.reflect.Method.invokeNative(Native Method)
05-29 13:42:10.200: E/AndroidRuntime(14482): at java.lang.reflect.Method.invoke(Method.java:511)
05-29 13:42:10.200: E/AndroidRuntime(14482): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:786)
05-29 13:42:10.200: E/AndroidRuntime(14482): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:553)
05-29 13:42:10.200: E/AndroidRuntime(14482): at dalvik.system.NativeStart.main(Native Method)
이건 오류 메세집니다
요건 xml 화면..
이렇게 간단한 코드도 못짜고 있네요 답답합니다ㅜㅜ 도와주세요~!!
