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中配置了相关的网络权限和读写权限?
你的数据库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 死活上不了.