Android compose 直接操作 MySQL Kotlin代码示例

0.添加用户权限

    <uses-permission android:name="android.permission.INTERNET" />
    <uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />

1.添加库

    implementation 'mysql:mysql-connector-java:5.1.47'

2.编写MySqlHelpter.java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;


public class DBHelper {
    private static String driver = "com.mysql.jdbc.Driver";
    private static String url = "jdbc:mysql://XX.xxx.xxx.xxx(ip):3306/kucun";
    private static String user = "username";
    private static String password = "password";

    public static Connection getConn() {
        Connection conn = null;
        try {
            Class.forName(driver);
            conn = (Connection) DriverManager.getConnection(url, user, password);
            //System.out.println("conn:" + conn);
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }

        return conn;
    }

    public static ArrayList<ArrayList<String>> ExecuteQuerySQL(String strSQL) {
        Connection conn = null;
        ArrayList<ArrayList<String>> resultSetList = new ArrayList<ArrayList<String>>();
        conn = (Connection) DBHelper.getConn();
        if (conn == null) {
            //System.out.println("输出为null");
            return null;
        }

        Statement st;
        try {
            st = (Statement) conn.createStatement();
            ResultSet rsForResult = st.executeQuery(strSQL);
            while(rsForResult.next())
            {
                ArrayList<String> rsRecord = new ArrayList<String>();
                int icount = rsForResult.getMetaData().getColumnCount();
                for(int i=1; i<=icount; i++)
                    rsRecord.add(rsForResult.getString(i));

                resultSetList.add(rsRecord);
            }
            st.close();
            conn.close();
            return resultSetList;
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return null;
    }

    public static boolean ExecuteNoQuerySQL(String strSQL) {
        Connection conn = null;
        conn = (Connection) DBHelper.getConn();
        if (conn == null) {
            //System.out.println("输出为null");
            return false;
        }

        Statement st;
        try {
            st = (Statement) conn.createStatement();
            st.executeQuery(strSQL);
            st.close();
            conn.close();
            return true;
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return false;

    }

}

代码中的url,user,password，3306，请对应修改。

3.应用

 Connection conn  = null;
 conn = (Connection)DBHelper.getConn();

 if(conn == null)
 {
    Log.i("scoreInfo","输出为NULL");
 }

 String sql = "select userName from userT where id = "+(icount+6);

 try {
    ArrayList<ArrayList<String>> rsList =  DBHelper.ExecuteQuerySQL(sql);
    
    for (ArrayList<String> rs : rsList){
       Log.i("scoreInfo",rs.get(0));
    }
 } catch (Exception e) {
    e.printStackTrace();
 }