상세 컨텐츠

본문 제목

안드로이드스튜디오, 명함관리 수정 및 삭제 기능 구현하기

DEVELOPMENT/모바일앱개발

by 포근함 간지뽕빨 리턴씨 2020. 6. 20. 17:45

본문

 모바일앱개발,안드로이드스튜디오,수정,삭제,업데이트,insert,update확인,패치,삭제,delete 

안드로이드 스튜디오, 명함관리 최종 마무리? 수정 및 삭제 기능 구현하기 !

과제일시 : 06 - 20

저장과 검색 기능 까지는 구현이 되었고, 이제 수정과 삭제의 기능을 구현 할 차례가 되었습니다. 이번에는 생각보다 쉽게 구현이 되었습니다. 많이 부족한만큼 열심히 하겠습니다.

 

[ 실행화면 ]

 

[ 소스 코드 ]

* MainActivity.java
package com.example.sqltest;

import androidx.appcompat.app.AppCompatActivity;

import android.annotation.SuppressLint;
import android.os.AsyncTask;
import android.os.Bundle;
import android.os.Handler;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.io.OutputStreamWriter;
import java.net.HttpURLConnection;
import java.net.URL;



public class MainActivity extends AppCompatActivity {
    Handler handler = new Handler();
    EditText etName, etTelNo, email, etLoad;
    Button btnSave,btnsrch, btndelete, btnupdate;
    String[] result;
    private static String IP_ADDRESS = "10.0.2.2";
    //private static String IP_ADDRESS = "123";
    private static String serverIP = "http://" + IP_ADDRESS + "/andtest.php";
    private static String TAG = "phptest";
    @SuppressLint("WrongViewCast")
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        etName = (EditText)findViewById(R.id.editText);
        etTelNo = (EditText)findViewById(R.id.editText2);
        email = (EditText)findViewById(R.id.editText3);
        btnSave = (Button)findViewById(R.id.button);
        etLoad = (EditText)findViewById(R.id.editText4);
        btnSave.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                String name = etName.getText().toString();
                String telNo = etTelNo.getText().toString();
                String email = MainActivity.this.email.getText().toString();

                new Task().execute(serverIP, name, telNo, email);

//                etName.setText("");
//                etTelNo.setText("");

            }
        });
        btnsrch = (Button)findViewById(R.id.button2);
        btnsrch.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                dataSelect();
            }
        });
        btndelete = (Button) findViewById(R.id.button3);
        btnupdate = (Button) findViewById(R.id.button4);
        btndelete.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                dataDelete();
            }
        });

        btnupdate.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                dataUpdate();
            }
        });


    }

    public void dataSelect() {

        new Thread() {

            public void run() {

                try {
                    String key = etLoad.getText().toString();
                    URL url = new URL("Http://10.0.2.2/selectSerach.php");
                    HttpURLConnection http = (HttpURLConnection) url.openConnection();
                    http.setDefaultUseCaches(false);
                    http.setDoInput(true);
                    http.setRequestMethod("POST");
                    http.setRequestProperty("content-type", "application/x-www-form-urlencoded");
                    StringBuffer buffer = new StringBuffer();
                    buffer.append("key").append("=").append(key);
                    OutputStreamWriter osw = new OutputStreamWriter(http.getOutputStream(), "utf-8");
                    osw.write(buffer.toString());
                    osw.flush();

                    InputStreamReader tmp = new InputStreamReader(http.getInputStream(), "utf-8");
                    BufferedReader reader = new BufferedReader(tmp);
                    StringBuilder builder = new StringBuilder();
                    String str;

                    while ((str = reader.readLine()) != null) {
                        builder.append(str + "\n");
                    }

                    String resultData = builder.toString();
                    final String[] sResult = resultData.split("/");
                    handler.post(new Runnable() {
                        @Override
                        public void run() {

                            etName.setText(sResult[0]);
                            etTelNo.setText(sResult[1]);
                            email.setText(sResult[2]);

                        }
                    });

                    etName.setText(str);

                } catch (Exception e) {
                    Log.e("", "Error", e);
                }
            }
        }.start();
    }
    public void dataDelete(){
        new Thread(){
            public void run(){
                try
                {
                    final String key = etName.getText().toString();
                    URL url = new URL("Http://10.0.2.2/delete.php/");
                    HttpURLConnection http = (HttpURLConnection)url.openConnection();
                    http.setDefaultUseCaches(false);
                    http.setDoInput(true);
                    http.setRequestMethod("POST");
                    http.setRequestProperty("content-type", "application/x-www-form-urlencoded");
                    StringBuffer buffer = new StringBuffer();
                    buffer.append("name").append("=").append(key);

                    OutputStreamWriter osw = new OutputStreamWriter(http.getOutputStream(),"euc-kr");
                    osw.write(buffer.toString());
                    osw.flush();

                    InputStreamReader tmp = new InputStreamReader(http.getInputStream(), "euc-kr");
                    BufferedReader reader = new BufferedReader(tmp);
                    StringBuilder builder = new StringBuilder();
                    String resultData = builder.toString();
                    String[] Result = resultData.split("/");
                    handler.post(new Runnable() {
                        @Override
                        public void run() {
                            Toast.makeText(MainActivity.this,key+"정보 삭제",Toast.LENGTH_SHORT).show();
                        }
                    });

                } catch (Exception e){
                    Log.e("","Error",e);
                }

            }
        }.start();
    }
    public void dataUpdate(){
        new Thread(){
            public void run(){
                try
                {
                    String sname = etName.getText().toString();
                    String scall = etTelNo.getText().toString();
                    String smail = email.getText().toString();

                    URL url = new URL("Http://10.0.2.2/update.php/");
                    HttpURLConnection http = (HttpURLConnection)url.openConnection();
                    http.setDefaultUseCaches(false);
                    http.setDoInput(true);
                    http.setRequestMethod("POST");
                    http.setRequestProperty("content-type", "application/x-www-form-urlencoded");

                    StringBuffer buffer = new StringBuffer();
                    buffer.append("ins").append("=").append(sname).append("/").append(scall).append("/").append(smail);

                    OutputStreamWriter osw = new OutputStreamWriter(http.getOutputStream(),"euc-kr");
                    osw.write(buffer.toString());
                    osw.flush();

                    InputStreamReader tmp = new InputStreamReader(http.getInputStream(), "euc-kr");
                    BufferedReader reader = new BufferedReader(tmp);
                    StringBuilder builder = new StringBuilder();
                    String str;
                    while ((str=reader.readLine())!=null){
                        builder.append(str);
                        builder.append("\n");
                    }
                    String resultData = builder.toString();
                    final String sResult[] = resultData.split("/");
                    handler.post(new Runnable() {
                        @Override
                        public void run() {
                            Toast.makeText(MainActivity.this,"수정완료",Toast.LENGTH_SHORT).show();
                        }
                    });


                } catch (Exception e){
                    Log.e("","Error",e);
                }

            }
        }.start();
    }

    class Task extends AsyncTask<String,Void,String> {
        String sendMsg,receiveMsg;

        protected void onPreExcute(){
            super.onPreExecute();
        }
        @Override
        protected String doInBackground(String... strings) {
            try{

                String str;
                String serverIp = (String)strings[0];
                String name = (String)strings[1];
                String telNo = (String)strings[2];
                String email = (String)strings[3];

                Log.d("doinBackground", name);

                URL url=new URL(serverIp);
                HttpURLConnection conn=(HttpURLConnection)url.openConnection();
                Log.d("network", serverIp);
                //conn.setRequestProperty("Content-type","application/x-www-form-rlencoded");
                conn.setRequestMethod("POST");
                conn.connect();

                OutputStreamWriter osw=new OutputStreamWriter(conn.getOutputStream());
                sendMsg= "name=" + name + "&telNo=" + telNo + "&email=" + email;
                osw.write(sendMsg);
                Log.d("check OutputStream", sendMsg);
                osw.flush();   osw.close();

                if(conn.getResponseCode()==conn.HTTP_OK){
                    InputStreamReader tmp=new InputStreamReader(conn.getInputStream(),"UTF-8");
                    BufferedReader reader=new BufferedReader(tmp);
                    StringBuffer buffer=new StringBuffer();
                    while((str=reader.readLine()) != null){
                        buffer.append(str);
                    }
                    receiveMsg=buffer.toString();
                    Log.d("check InputStream", receiveMsg);
                }
                else {
                    Log.d(TAG, "Insert Error");
                }
            }catch (Exception e){
                Log.d("Error", "DoInBackground");
            }
            return  receiveMsg;
        }
        @Override
        protected void onPostExecute(String result) {
            super.onPostExecute(result);

            Toast.makeText(MainActivity.this, result, Toast.LENGTH_SHORT).show();
        }
    }
}

* activity_main.xml
<?xml version="1.0" encoding="utf-8"?>
<androidx.constraintlayout.widget.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    tools:context=".MainActivity">

    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="match_parent"
        android:orientation="vertical">

        <EditText
            android:id="@+id/editText"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:ems="10"
            android:hint="이름을 입력하세요."
            android:inputType="textPersonName" />

        <EditText
            android:id="@+id/editText2"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:ems="10"
            android:hint="전화번호를 입력하세요."
            android:inputType="textPersonName" />

        <EditText
            android:id="@+id/editText3"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:ems="10"
            android:hint="이메일을 입력하세요."
            android:inputType="textPersonName" />

        <Button
            android:id="@+id/button"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:text="저장" />

        <Button
            android:id="@+id/button3"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:text="삭제" />

        <Button
            android:id="@+id/button4"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:text="수정" />

        <TextView
            android:id="@+id/textView"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:text="검색창" />

        <EditText
            android:id="@+id/editText4"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:ems="10"
            android:hint="이름으로 검색하세요"
            android:inputType="textPersonName" />

        <Button
            android:id="@+id/button2"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:text="검색" />

    </LinearLayout>
</androidx.constraintlayout.widget.ConstraintLayout>

* update.php
<?
 $ins = $_POST["ins"];
 
 $connect = mysqli_connect("localhost","root","apmsetup","company");
 mysqli_select_db($connect, "company");

 $arrUp = explode("/", $ins);
 $updateSQL = "update customer set telno = '$arrUp[1]', email = '$arrUp[2]' where name = '$arrUp[0]'";
 
 mysqli_query( $connect,$updateSQL);
?>

* delete.php
<?
$key = $_POST["name"];

$connect = mysqli_connect("localhost","root","apmsetup","company");
mysqli_select_db($connect, "company");

$sqlDelete = "delete  from customer where name = '$key'";

mysqli_query($connect, $sqlDelete);

?>


감사합니다

Thank you !

관련글 더보기

댓글 영역