2q7d5j93

1package com.example.ricardohdez.testing;
2import android.os.AsyncTask;
3import android.os.Bundle;
4import android.support.v4.app.Fragment;
5import android.util.Log;
6import android.view.LayoutInflater;
7import android.view.View;
8import android.view.ViewGroup;
9import android.widget.Button;
10import android.widget.EditText;
11
12import java.sql.Connection;
13import java.sql.DriverManager;
14import com.mysql.jdbc.PreparedStatement;
15
16public class SesionFragment extends Fragment {
17
18    EditText txtUser0, txtPwd0;
19    Button btn0;
20
21    @Override
22    public View onCreateView(LayoutInflater inflater, ViewGroup container,
23                             Bundle savedInstanceState) {
24        View vista=inflater.inflate(R.layout.fragment_sesion, container,false);
25        txtUser0 = (EditText) vista.findViewById(R.id.txtUser);
26        txtPwd0 = (EditText) vista.findViewById(R.id.txtPwd);
27        btn0 = (Button) vista.findViewById(R.id.btn1);
28
29
30        btn0.setOnClickListener(new View.OnClickListener(){
31            @Override
32            public void onClick(View v) {
33                new Conexion().execute();
34
35            }
36        });
37        return vista;
38    }
39
40
41    private class Conexion extends AsyncTask<Void, Void, Void>{
42
43        @Override
44        protected Void doInBackground(Void... voids) {
45            try {
46                Log.d("test","===============BACKGROUND METHOD============");
47                Class.forName("com.mysql.jdbc.Driver");
48
49                String url = "jdbc:mysql://sql3.freesqldatabase.com/sql3233468";
50                String user = "sql3233468";
51                String pass = "P5sm4Cylhr";
52
53                Connection connect = DriverManager.getConnection(url,user,pass);
54
55                String crearUsers = "CREATE TABLE if not exists registros ( id INT AUTO_INCREMENT PRIMARY KEY, usuario VARCHAR(20),"
56                        + " contra VARCHAR(20));";
57
58                PreparedStatement ps1 = (PreparedStatement) connect.prepareStatement(crearUsers);
59                ps1.execute();
60                ps1.close();
61
62                String agrega = "INSERT ignore INTO registros (usuario, contra) VALUE('"+txtUser0.getText()+"','"+txtPwd0.getText()+"');";
63
64                PreparedStatement ps2 = (PreparedStatement) connect.prepareStatement(agrega);
65                ps2.executeUpdate();
66                connect.close();
67
68
69
70            } catch (Exception e) {
71                Log.d("ERROR",e+"");
72            }
73
74
75
76            return null;
77        }
78
79        @Override
80        protected void onPostExecute(Void aVoid) {
81            super.onPostExecute(aVoid);
82        }
83    }
84
85}