请各位大佬帮忙看看这段代码哪里出了问题,无法连接数据库,权限和架包都已经弄好了,但是就是不行
package com.example.mysql_1;import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.support.v7.app.AppCompatActivity;
import android.util.Log;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class MainActivity extends AppCompatActivity { @Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Log.i("123123", "000功");
new Thread(runnable).start();
}
Handler myHandler = new Handler(){
public void handleMessage(Message msg){
super.handleMessage(msg);
Bundle data = new Bundle();
data=msg.getData();
System.out.println("username" + data.get("username").toString());
System.out.println("userpass" + data.get("userpass").toString());
}
};
Runnable runnable = new Runnable() {
private Connection connection = null; @Override
public void run() {
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://192.168.191.88/aaa", "root", "123456");
Log.i("123123", "连接成功");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e1) {
e1.printStackTrace();
}
try {
test(connection); //测试数据库连接
} catch (java.sql.SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} public void test(Connection con1) throws java.sql.SQLException {
try {
String sql = "select * from user"; //查询表名为“user”的所有内容
Statement stmt = con1.createStatement(); //创建Statement
ResultSet rs = stmt.executeQuery(sql); //ResultSet类似Cursor //<code>ResultSet</code>最初指向第一行
Bundle bundle = new Bundle();
while (rs.next()) {
bundle.clear();
bundle.putString("username", rs.getString("username"));
bundle.putString("userpass", rs.getString("userpass"));
Message msg = new Message();
msg.setData(bundle);
myHandler.sendMessage(msg);
} rs.close();
stmt.close();
} catch (SQLException e) { } finally {
if (con1 != null)
try {
con1.close();
} catch (SQLException e) {
}
}
}
};
}
希望大佬们能够解答!!!
package com.example.mysql_1;import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.support.v7.app.AppCompatActivity;
import android.util.Log;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class MainActivity extends AppCompatActivity { @Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Log.i("123123", "000功");
new Thread(runnable).start();
}
Handler myHandler = new Handler(){
public void handleMessage(Message msg){
super.handleMessage(msg);
Bundle data = new Bundle();
data=msg.getData();
System.out.println("username" + data.get("username").toString());
System.out.println("userpass" + data.get("userpass").toString());
}
};
Runnable runnable = new Runnable() {
private Connection connection = null; @Override
public void run() {
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://192.168.191.88/aaa", "root", "123456");
Log.i("123123", "连接成功");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e1) {
e1.printStackTrace();
}
try {
test(connection); //测试数据库连接
} catch (java.sql.SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} public void test(Connection con1) throws java.sql.SQLException {
try {
String sql = "select * from user"; //查询表名为“user”的所有内容
Statement stmt = con1.createStatement(); //创建Statement
ResultSet rs = stmt.executeQuery(sql); //ResultSet类似Cursor //<code>ResultSet</code>最初指向第一行
Bundle bundle = new Bundle();
while (rs.next()) {
bundle.clear();
bundle.putString("username", rs.getString("username"));
bundle.putString("userpass", rs.getString("userpass"));
Message msg = new Message();
msg.setData(bundle);
myHandler.sendMessage(msg);
} rs.close();
stmt.close();
} catch (SQLException e) { } finally {
if (con1 != null)
try {
con1.close();
} catch (SQLException e) {
}
}
}
};
}
希望大佬们能够解答!!!
是不是端口问题,设置成mysql访问端口试试。