Android 通过jdbc 直连MySql 连不上

Android 通过jdbc 直连MySql 连不上

问题描述:

本人新手,找了好多资源,测试直连的问题,这些代码也是本网站找的,自己稍微改了一下,为何死活连不上去,conn返回都是空的,大神帮我看看。
public class MainActivity extends Activity {

private static final String URL = "jdbc:mysql://www.luhef.cn:3306/xh";
private static final String USER = "*******";
private static final String PASSWORD = "*****";

private Connection conn;
private Button onConn;
private Button onInsert;
private Button onDelete;
private Button onUpdate;
private Button onQuery;
private Handler handler = new Handler() {

    public void handleMessage(Message msg) {
        String str = (String) msg.obj;
        Toast.makeText(MainActivity.this, str, Toast.LENGTH_SHORT).show();
    };
};

@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    onConn = (Button) findViewById(R.id.onConn);
    onInsert = (Button) findViewById(R.id.onInsert);

}

@Override
protected void onDestroy() {
    super.onDestroy();
    if (conn != null) {
        try {
            conn.close();
        } catch (SQLException e) {
            conn = null;
        } finally {
            conn = null;
        }
    }
}

public void onConn(View view) {
    new Thread(new Runnable() {
        @Override
        public void run() {
            conn = Util.openConnection(URL, USER, PASSWORD);
            Message msg = new Message();
            msg.obj = conn;
            handler.sendMessage(msg);
        }
    }).start();
}

public void onInsert(View view) {
    new Thread(new Runnable() {
        @Override
        public void run() {
            String sql = "insert into users values(15, 'xiaoming')";
            Util.execSQL(conn, sql);
            Log.i("onInsert", "onInsert");
        }
    }).start();
}

}

package com.lyz.learning.mysqlandandroid;

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

public class Util {
final static String DRIVER_NAME = "com.mysql.jdbc.Driver";

public static Connection openConnection(String url, String user,
                                        String password) {
    Connection conn = null;
    try {
        Class.forName(DRIVER_NAME);
        conn = DriverManager.getConnection(url, user, password);
    } catch (ClassNotFoundException e) {
        conn = null;
    } catch (SQLException e) {
        conn = null;
    }
    System.out.println(conn);

    return conn;
}

public static void query(Connection conn, String sql) {
    if (conn == null) {
        return;
    }
    Statement statement = null;
    ResultSet result = null;
    try {
        statement = conn.createStatement();
        result = statement.executeQuery(sql);
        System.out.println(result);
        if (result != null && result.first()) {
            int idColumnIndex = result.findColumn("id");
            int nameColumnIndex = result.findColumn("name");
            System.out.println("id\t\t" + "name");
            while (!result.isAfterLast()) {
                System.out.print(result.getString(idColumnIndex) + "\t\t");
                System.out.println(result.getString(nameColumnIndex));
                result.next();
            }
        }
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        try {
            if (result != null) {
                result.close();
                result = null;
            }
            if (statement != null) {
                statement.close();
                statement = null;
            }} catch (SQLException sqle) {
            sqle.printStackTrace();
        }
    }
}

public static boolean execSQL(Connection conn, String sql) {
    boolean execResult = false;
    if (conn == null) {
        return execResult;
    }
    Statement statement = null;
    try {
        statement = conn.createStatement();
        if (statement != null) {
            execResult = statement.execute(sql);
        }
    } catch (SQLException e) {
        execResult = false;
    }
    return execResult;
}

}

是否在Manifest中配置了相关的网络权限和读写权限?

www.luhef.cn:3306

这个域名的数据库肯定没有开放让你直接访问。

你的数据库user 和 Password改没有?

异常提示呢?发来看看

异常信息来了,帮忙分析分析。图片

 query_cache_type:控制 Query Cache 功能的开关,可以设置为0(OFF),1(ON)和2(DEMAND)三种,意义分别如下:

0(OFF):关闭 Query Cache 功能,任何情况下都不会使用 Query Cache

1(ON):开启 Query Cache 功能,但是当 SELECT 语句中使用的 SQL_NO_CACHE 提示后,将不使用Query Cache

2(DEMAND):开启 Query Cache 功能,但是只有当 SELECT 语句中使用了 SQL_CACHE 提示后,才使用 Query Cache

数据库的问题。从这方面入手

1.你是使用的,mysql数据库的链接方式吗
2.mysql数据库的链接方式是这样的:
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicod
e=true&characterEncoding=8859_1"
//myDB为数据库名
Connection conn= DriverManager.getConnection(url);

结案,已解决问题,参照大神意见,换了jdbc驱动,mysql 版本5.1.73,jdbc驱动5.1.6.

我想问一下,怎么 mysql 8.0 下 用 mysql-connector-java-8.0.16.jar 死活上不了.