安卓手机app开发之kotin入门教程--调用网络接口写入mysql数据

   花了点时间写了一个入门级数据读写操作，是kotlin版本。教程没有涉及json的第三方解析，没有MVVM模式操作数据库，所以代码很适合了解手机开发的app是如何操作数据库的入门者阅读。
   教程是采用android studio最新版下编写的，项目是用底部导航栏的系统默认模板搭建的，很容易阅读和理解。写入是通过远程php的接口写入到数据库的没有用kotlin实现，因为用php实现后端数据库操作是非常有优势的，编写代码快捷省事。完整源码打包到  专业开发网   http://www.zhuanyekaifa.com/datarwite.rar 去下载吧

看几个效果图：

1. 项目结构图：红框部分是着重改写的部分
   
   2 , 布局文件

<?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=".ui.dashboard.DashboardFragment">

<EditText
    android:id="@+id/personname"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_marginStart="24dp"
    android:layout_marginTop="130dp"
    android:layout_marginEnd="24dp"
    android:ems="10"
    android:inputType="textPersonName"
    android:text="输入姓名"
    app:layout_constraintEnd_toEndOf="parent"
    app:layout_constraintStart_toStartOf="parent"
    app:layout_constraintTop_toTopOf="parent" />

<EditText
    android:id="@+id/personage"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_marginTop="16dp"
    android:ems="10"
    android:inputType="number"
    android:text="输入年龄"
    app:layout_constraintEnd_toEndOf="parent"
    app:layout_constraintStart_toStartOf="parent"
    app:layout_constraintTop_toBottomOf="@+id/personname" />

<EditText
    android:id="@+id/personadd"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_marginTop="16dp"
    android:ems="10"
    android:inputType="textPersonName"
    android:text="输入住址"
    app:layout_constraintEnd_toEndOf="parent"
    app:layout_constraintStart_toStartOf="parent"
    app:layout_constraintTop_toBottomOf="@+id/personage" />

<ImageButton
    android:id="@+id/imageButton"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_marginTop="16dp"
    android:src="@android:drawable/ic_input_add"
    app:layout_constraintEnd_toEndOf="parent"
    app:layout_constraintStart_toStartOf="parent"
    app:layout_constraintTop_toBottomOf="@+id/personadd" />

 ![在这里插入图片描述](https://img-blog.csdnimg.cn/11d4a95abcf54c919ee99ff5c73ec8b5.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE4NDQ3NjQ5,size_16,color_FFFFFF,t_70#pic_center)

3.数据请求，主要是看是如何请求远程数据的部分

package com.mykotlin.five_adddata.ui.dashboard

import android.os.Bundle
import android.os.Looper
import android.text.Editable
import android.view.LayoutInflater
import android.view.View
import android.view.ViewGroup
import android.widget.Toast
import androidx.fragment.app.Fragment
import androidx.lifecycle.ViewModelProvider
import com.mykotlin.five_adddata.databinding.FragmentDashboardBinding
import okhttp3.*
import org.json.JSONObject
import java.io.IOException
class DashboardFragment : Fragment() {

private var dashboardViewModel: DashboardViewModel? = null
private var _binding: FragmentDashboardBinding? = null



// This property is only valid between onCreateView and
// onDestroyView.
private val binding get() = _binding!!



override fun onCreateView(
    inflater: LayoutInflater,
    container: ViewGroup?,
    savedInstanceState: Bundle?
    ): View? {
    dashboardViewModel =
        ViewModelProvider(this).get(DashboardViewModel::class.java)

    _binding = FragmentDashboardBinding.inflate(inflater, container, false)


    val root: View = binding.root
    val pname = binding.personname.text
    val page = binding.personage.text
    val padd=binding.personadd.text


    binding.imageButton.setOnClickListener {
        getAdd(pname,page,padd)
    }

    return root
}


private fun getAdd(name: Editable, age: Editable, add: Editable){

    **val client = OkHttpClient()
    var url = "http://www.kuaidian777.com/mydata.php"
    val urlAPI: String = url**

    val builder = FormBody.Builder()
    builder.add("hname", name.toString())
    builder.add("hage", age.toString())
    builder.add("hadd", add.toString())
    val formBody = builder.build()

    val request = Request.Builder()
        .method("POST", formBody)
        .url(urlAPI).build()

    client.newCall(request).enqueue(object : Callback {

            override fun onResponse(call: Call, response: Response) {
                val result = response.body?.string()
                var jstr=""
                var myjson= JSONObject(result)
                //println("result：" + myjson)

                if(myjson.getString("msg")=="ok") {
                    Looper.prepare();
                    Toast.makeText(context, "输入写入成功", Toast.LENGTH_SHORT).show()
                    Looper.loop();
                }else {
                    Looper.prepare();
                    Toast.makeText(context, "唉，失败了", Toast.LENGTH_SHORT).show()
                    Looper.loop();
                    //println(myjson.getString("msg"))
                }

            }

            override fun onFailure(call: Call, e: IOException) {
                println("Failed request api :( " + e.message)
            }

    })



}


override fun onDestroyView() {
    super.onDestroyView()
    _binding = null
}

}

4.点击 +按钮后 把数据写入数据库，通过调用远程http://www.kuaidian777.com/mydata.php写入的

接口内容

<? header('Content-Type:application/json; charset=utf-8'); $mysql_server_name = 'localhost'; //改成自己的mysql数据库服务器 $mysql_username = '。。。。。'; //改成自己的mysql数据库用户名 $mysql_password = '。。。。。'; //改成自己的mysql数据库密码 $mysql_database = '。。。。。'; //改成自己的mysql数据库名 $conn=mysqli_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database); //连接数据库 //连接数据库错误提示 if (mysqli_connect_errno($conn)) { die("连接 MySQL 失败: " . mysqli_connect_error()); } mysqli_query($conn,"set names utf8"); //数据库编码格式 $hname=$_POST["hname"]; $hage=$_POST["hage"];; $hadd=$_POST["hadd"];; $sql="INSERT INTO `testme`(`hname`, `hage`, `hadd`) VALUES ('".$hname."',".$hage.",'".$hadd."')"; mysqli_query($conn,$sql); $arr = array('msg'=>"ok",'ret'=>2); echo json_encode($arr); // mysqli_set_charset($conn,"utf8");//设置默认客户端字符集。 // mysqli_select_db($conn,$mysql_database); //更改连接的默认数据库 //查询代码 //$sql = “select * from db_table”; //$query = mysqli_query($conn,$sql); //while($row = mysqli_fetch_array($query)){ // echo $row['title']; //} //查询代码 // 释放结果集+关闭MySQL数据库连接 //mysqli_free_result($result); //mysqli_close($conn); ?>

技术探讨 : qq 2047879076