等到日后再解决吧
import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.view.View;
import android.webkit.WebSettings;
import android.webkit.WebView;
import android.webkit.WebViewClient;
import android.widget.Button;
import android.widget.Toast;
import com.mysql.jdbc.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class MainActivity extends AppCompatActivity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Button button = (Button) findViewById(R.id.btn);
button.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
connectSQL();
}
});
}
private Connection getCon(){
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (ClassNotFoundException e) {
Toast.makeText(MainActivity.this,"驱动获取失败1",Toast.LENGTH_SHORT).show();
e.printStackTrace();
} catch (InstantiationException e) {
Toast.makeText(MainActivity.this,"驱动获取失败2",Toast.LENGTH_SHORT).show();
e.printStackTrace();
} catch (IllegalAccessException e) {
Toast.makeText(MainActivity.this,"驱动获取失败3",Toast.LENGTH_SHORT).show();
e.printStackTrace();
}
Connection con = null;
try {
con = (Connection) DriverManager.getConnection("jdbc:mysql://***.***.***.***:3306/*****?user=*****&password=******&useUnicode=true&characterEncoding=UTF8");
} catch (SQLException e) {
Toast.makeText(MainActivity.this,"远程数据库请求失败",Toast.LENGTH_SHORT).show();
e.printStackTrace();
}
return con;
}
private void connectSQL(){
Toast.makeText(MainActivity.this,"下面开始连接",Toast.LENGTH_SHORT).show();
Connection conn = getCon();
if(conn != null){
Toast.makeText(MainActivity.this,"连接成功",Toast.LENGTH_SHORT).show();
try {
conn.close();
} catch (SQLException e) {
Toast.makeText(MainActivity.this,"数据关闭失败",Toast.LENGTH_SHORT).show();
e.printStackTrace();
}
}
else{
Toast.makeText(MainActivity.this,"数据库连接失败",Toast.LENGTH_SHORT).show();
}
}
}