android又腐案mysql数据库;连接不上的问题
package com.example.mysqldemo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import android.os.Bundle;
import android.R.string;
import android.app.Activity;
import android.util.Log;
import android.view.Menu;
import android.view.View;
import android.widget.Button;
public class MainActivity extends Activity {
protected static final String TAG = null;
Button button1,button2;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
button1 = (Button) this.findViewById(R.id.button1);
button2 = (Button) this.findViewById(R.id.button2);
button1 .setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View arg0) {
// TODO Auto-generated method stub
try {
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/clientlist?useUnicode=true&characterEncodeing=utf-8", "root",
"11231205");
if(!connection.isClosed()){
System.out.println("连接成功");
}
Statement usest = connection.createStatement();
String strm = new String(
("select* from clientdata;").getBytes("gbk"),
"iso-8859-1");
ResultSet users = usest.executeQuery(strm);
if (users.next()) {
String loginid = new String(users.getString("loginID").getBytes("gbk"),
"iso-8859-1");
String loginpw = new String(users.getString("password").getBytes("gbk"),
"iso-8859-1");
Log.i(TAG, loginid+" "+loginpw);
}
} catch (Exception e) {
e.printStackTrace();
}
}
});
button2.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View arg0) {
// TODO Auto-generated method stub
System.exit(0);
}
});
}
}
哪位大神能帮我看下代码,为什么连接不上mysql数据库吗,我在java平台上运行都可以的(用写数据库的思路),本来以为搬过来就可以了,结果完全没反应,在网络上搜了很多方法,都大同小异,没能解决,我mysql的驱动是加载了的,通过build path,是不是有什么地方需要注意的?