可能安卓就是连不上mysql吧

来源：互联网发布：程序员相亲被骗编辑：程序博客网时间：2024/05/02 01:38
等到日后再解决吧
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();        }    }}
0 0