android通过JDBC连接本地Mysql总是出错
ip地址我换了好几个,因为连接WIFI用ipconfig查地址。此时试了的Ip地址为百度查询的,但都错了
并且我也build mysql-connect.jar包,最后log总打印连接出错,就是走了catch,没有走try
在mysql中也创建了ming数据库,也加入mark用户,密码。
代码如下:
package com.example.mysql_connect;
import android.support.v7.app.ActionBarActivity;
import android.app.Activity;
import java.sql.Connection;
import java.sql.SQLException;
import android.app.Activity;
import android.os.Bundle;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class MainActivity extends Activity {
private static final String REMOTE_IP = "113.57.27.87:3306";或者192.168.155.5:3306
private static final String URL = "jdbc:mysql://" + REMOTE_IP + "/ming";
private static final String USER = "mark";
private static final String PASSWORD = "123456";
private Connection conn;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
new Thread() {
public void run() {
try {
conn = null;
final String DRIVER_NAME = "com.mysql.jdbc.Driver";
Class.forName(DRIVER_NAME);
conn = DriverManager.getConnection(URL, USER, PASSWORD);
conn.close();
} catch (ClassNotFoundException e) {
System.out.println("连接出错!");
} catch (SQLException e) {
conn = null;
}
}
}.start();
}
}