android 连接MySql数据库

public class searchActivity extends AppCompatActivity {

private static final String TAG="searchActivity";

private EditText mEditText;
private ImageView mImageView;

private static String driver = "com.mysql.jdbc.Driver";// MySql驱动

private static String url = "jdbc:mysql://192.168.0.101:3306/base_project";

private static String user = "username";// 用户名

private static String password = "password";// 密码


@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_search);

    mEditText = findViewById(R.id.et_chaXun);
    mImageView = findViewById(R.id.iv_search);

    mImageView.setOnClickListener(new View.OnClickListener() {


        @Override
        public void onClick(View v) {
            new Thread(new Runnable() {
                @Override
                public void run() {
                    Connection connection = null;

                    try {
                            Class.forName(driver);// 动态加载类
                        // 尝试建立到给定数据库URL的连接
                        connection = DriverManager.getConnection(url,
                                user, password);
                        String sql = "select * from check_info";
                        PreparedStatement st = connection.prepareStatement(sql);
                        ResultSet rs = st.executeQuery(sql);
                        while (rs.next()) {
                          String title=rs.getString("title");
                            Log.i("searchActivity",title);
                        }
                        connection.close();
                        st.close();
                        rs.close();
                        Log.i(TAG, "run: success to connect!");
                    } catch (ClassNotFoundException e) {
                        Log.i(TAG, "run: fail to connect!");
                    } catch (SQLException e) {
                        Log.i(TAG, "run: fail to connect!");
                    }
                }
            }).start();

        }
    });


}