Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private static final String url = "jdbc:mysql://172.0.0.1:3306/intalum";
- private static final String user = "pepe";
- private static final String pass = "123456";
- private Button buttonLoad;
- private TextView firstName;
- @Override
- protected void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- setContentView(R.layout.activity_main);
- firstName = (TextView) findViewById(R.id.firstName);
- buttonLoad = (Button) findViewById(R.id.buttonLoad);
- buttonLoad.setOnClickListener(new View.OnClickListener() {
- @Override
- public void onClick(View v) {
- new MyTask().execute();
- }
- });
- }
- private class MyTask extends AsyncTask<Void, Void, Void> {
- private String fName = "";
- @Override
- protected Void doInBackground(Void... params) {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- Connection con = DriverManager.getConnection(url, user, pass);
- Statement st = con.createStatement();
- String sql = "select * from cursos";
- final ResultSet rs = st.executeQuery(sql);
- rs.next();
- fName = rs.getString(2);
- } catch (Exception e) {
- e.printStackTrace();
- }
- return null;
- }
- @Override
- protected void onPostExecute(Void result) {
- firstName.setText(fName);
- super.onPostExecute(result);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement