SqlLiteAndroidStudio: 2017

Hoy les mostrare un Código para hacer Altas, Bajas, Consultas Y Modificaciones

Crear Clases:

---------------------------------------------------------------------------------

Código de Mi Base De Datos SqLite

Código:

Recuerda Importar Todas Las Librerías Con las Teclas:

Alt + Enter

package com.example.eltit.pizzapuch;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;


public class AdminSQLiteOpenHelper  extends SQLiteOpenHelper {
    public AdminSQLiteOpenHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
    }

    @Override    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table usuarios (idusuario integer primary key, name text, user_name text, user_pass text)");
        db.execSQL("create table ventaext (idventaext integer primary key, fecha text, nombre text, ingrediente text,"+
        "cantidad int, calle text, colonia text, telefono text)");
    }

    @Override    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}

------------------------------------------------------------

Código de Insertar Datos

Código:






package com.example.eltit.pizzapuch;

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.text.TextUtils;
import android.view.View;
import android.widget.EditText;
import android.widget.Toast;

public class menu extends AppCompatActivity {

    EditText ET_FECHA, ET_NAME, ET_INGRE, ET_CANTIDAD, ET_CALLE, ET_COLONIA, ET_TELEFONO;
    String fecha, name, ingrediente, cantidad, calle, colonia, telefono;

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

        ET_FECHA = (EditText) findViewById(R.id.new_fecha);
        ET_NAME = (EditText) findViewById(R.id.new_client);
        ET_INGRE = (EditText) findViewById(R.id.new_ingredient);
        ET_CANTIDAD = (EditText) findViewById(R.id.new_cantidad);
        ET_CALLE = (EditText) findViewById(R.id.new_calle);
        ET_COLONIA = (EditText) findViewById(R.id.new_colonia);
        ET_TELEFONO = (EditText) findViewById(R.id.new_telefono);

    }

    public void altaPedido (View view){

        AdminSQLiteOpenHelper admin = new AdminSQLiteOpenHelper(this, "administracion", null, 1);
        SQLiteDatabase bd = admin.getWritableDatabase();

        fecha = ET_FECHA.getText().toString();
        name = ET_NAME.getText().toString();
        ingrediente = ET_INGRE.getText().toString();
        cantidad = ET_CANTIDAD.getText().toString();
        calle = ET_CALLE.getText().toString();
        colonia = ET_COLONIA.getText().toString();
        telefono = ET_TELEFONO.getText().toString();

        if (TextUtils.isEmpty(fecha)) {
            ET_FECHA.setError("Tiene que ingresar un nombre de usuario.");
            return;
        }else{
            if (TextUtils.isEmpty(name)) {
                ET_NAME.setError("Tiene que ingresar un nombre de usuario.");
                return;
            }else{
                if (TextUtils.isEmpty(ingrediente)) {
                    ET_INGRE.setError("Tiene que ingresar un nombre de usuario.");
                    return;
                }else{
                    if (TextUtils.isEmpty(cantidad)) {
                        ET_CANTIDAD.setError("Tiene que ingresar un nombre de usuario.");
                        return;
                    }else{
                        if (TextUtils.isEmpty(calle)) {
                            ET_CALLE.setError("Tiene que ingresar un nombre de usuario.");
                            return;
                        }else{
                            if (TextUtils.isEmpty(colonia)) {
                                ET_COLONIA.setError("Tiene que ingresar un nombre de usuario.");
                                return;
                            }else{
                                if (TextUtils.isEmpty(telefono)) {
                                    ET_TELEFONO.setError("Tiene que ingresar un nombre de usuario.");
                                    return;
                                }else{
                                    ContentValues registro = new ContentValues();
                                    registro.put("fecha", fecha);
                                    registro.put("nombre", name);
                                    registro.put("ingrediente", ingrediente);
                                    registro.put("cantidad", cantidad);
                                    registro.put("calle", calle);
                                    registro.put("colonia", colonia);
                                    registro.put("telefono", telefono);
                                    bd.insert("ventaext", null, registro);
                                    bd.close();
                                    ET_NAME.setText("");
                                    ET_FECHA.setText("");
                                    ET_NAME.setText("");
                                    ET_INGRE.setText("");
                                    ET_CANTIDAD.setText("");
                                    ET_CALLE.setText("");
                                    ET_COLONIA.setText("");
                                    ET_TELEFONO.setText("");
                                    Toast.makeText(this, "Pedido realizado.", Toast.LENGTH_SHORT).show();
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}

------------------------------------------------------------

Código de Consulta De Datos

Código:

package com.example.eltit.pizzapuch;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.text.TextUtils;
import android.view.View;
import android.widget.EditText;
import android.widget.Toast;

public class conpedidos extends AppCompatActivity {

    EditText ET_FECHA, ET_NAME, ET_INGRE, ET_CANTIDAD, ET_CALLE, ET_COLONIA, ET_TELEFONO, ET_ID;
    String name;
    @Override    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_conpedidos);

        ET_ID = (EditText) findViewById(R.id.new_id);
        ET_FECHA = (EditText) findViewById(R.id.new_fecha);
        ET_NAME = (EditText) findViewById(R.id.new_client);
        ET_INGRE = (EditText) findViewById(R.id.new_ingredient);
        ET_CANTIDAD = (EditText) findViewById(R.id.new_cantidad);
        ET_CALLE = (EditText) findViewById(R.id.new_calle);
        ET_COLONIA = (EditText) findViewById(R.id.new_colonia);
        ET_TELEFONO = (EditText) findViewById(R.id.new_telefono);
    }

    public void consulta(View view) {
        AdminSQLiteOpenHelper admin = new AdminSQLiteOpenHelper(this,
                "administracion", null, 1);
        SQLiteDatabase bd = admin.getWritableDatabase();
        name=ET_NAME.getText().toString();
        if (TextUtils.isEmpty(name)) {
            ET_NAME.setError("Tiene que ingresar una contraseña.");
            return;
        }else{
            Cursor fila = bd.rawQuery(
                    "select idventaext, fecha, ingrediente, cantidad, calle, colonia, telefono from"+
                            " ventaext where nombre='"+name+"'", null);
            if (fila.moveToFirst()) {
                ET_ID.setText(fila.getString(0));
                ET_FECHA.setText(fila.getString(1));
                ET_INGRE.setText(fila.getString(2));
                ET_CANTIDAD.setText(fila.getString(3));
                ET_CALLE.setText(fila.getString(4));
                ET_COLONIA.setText(fila.getString(5));
                ET_TELEFONO.setText(fila.getString(6));
            } else                Toast.makeText(this, "No existe el pedido.",
                        Toast.LENGTH_SHORT).show();
            bd.close();
        }
        }
}

------------------------------------------------------------

Código de Eliminar Datos 












Código:


package com.example.eltit.pizzapuch;

import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.text.TextUtils;
import android.view.View;
import android.widget.EditText;
import android.widget.Toast;

public class delpedido extends AppCompatActivity {

    EditText ET_ID;
    String id_data;
    @Override    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_delpedido);
        ET_ID = (EditText) findViewById(R.id.del_id);
    }
    public void eliminar(View view) {
        AdminSQLiteOpenHelper admin = new AdminSQLiteOpenHelper(this,
                "administracion", null, 1);
        SQLiteDatabase bd = admin.getWritableDatabase();
        id_data= ET_ID.getText().toString();
        if (TextUtils.isEmpty(id_data)) {
            ET_ID.setError("Tiene que ingresar una contraseña.");
            return;
        }else{
            int cant = bd.delete("ventaext", "idventaext=" + id_data, null);
            bd.close();
            ET_ID.setText("");
            if (cant == 1)
                Toast.makeText(this, "Se borró su pedido",
                        Toast.LENGTH_SHORT).show();
            else                Toast.makeText(this, "No existe el pedido",
                        Toast.LENGTH_SHORT).show();
        }
    }
}

----------------------------------------------


Código de Modificar Todos Los Datos












Código:





package com.example.eltit.pizzapuch;

import android.content.ContentValues;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.text.TextUtils;
import android.view.View;
import android.widget.EditText;
import android.widget.Toast;

public class modpedido extends AppCompatActivity {

    EditText ET_INGREDIENTE, ET_CANTIDAD, ET_ID;
    String ingrediente, cantidad, idventaext;

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

        ET_ID = (EditText) findViewById(R.id.id);
        ET_INGREDIENTE = (EditText) findViewById(R.id.new_ingredient);
        ET_CANTIDAD = (EditText) findViewById(R.id.new_cantidad);
    }

    public void modificacion(View v) {
        AdminSQLiteOpenHelper admin = new AdminSQLiteOpenHelper(this,
                "administracion", null, 1);
        SQLiteDatabase bd = admin.getWritableDatabase();
        idventaext = ET_ID.getText().toString();
        ingrediente = ET_INGREDIENTE.getText().toString();
        cantidad = ET_CANTIDAD.getText().toString();
        if (TextUtils.isEmpty(idventaext)) {
            ET_ID.setError("Tiene que ingresar un nombre de usuario.");
            return;
        } else{
            if (TextUtils.isEmpty(ingrediente)) {
                ET_INGREDIENTE.setError("Tiene que ingresar un nombre de usuario.");
                return;
            }else{
                if (TextUtils.isEmpty(cantidad)) {
                    ET_CANTIDAD.setError("Tiene que ingresar un nombre de usuario.");
                    return;
                }else                {
                    ContentValues registro = new ContentValues();
                    registro.put("ingrediente", ingrediente);
                    registro.put("cantidad", cantidad);
                    int cant = bd.update("ventaext", registro, "idventaext=" + idventaext, null);
                    bd.close();
                    if (cant == 1)
                        Toast.makeText(this, "Se modificaron los datos.", Toast.LENGTH_SHORT)
                                .show();
                    else                        Toast.makeText(this, "No existe el pedido que ingreso.",
                                Toast.LENGTH_SHORT).show();
                }
            }
        }
    }

}

------------------------------------------------------------


Crear Inicio de Sesión







Código:




package com.example.eltit.pizzapuch;

import android.content.ContentValues;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.EditText;
import android.widget.Toast;

public class MainActivity extends AppCompatActivity {

    EditText ET_NAME, ET_PASS;
    String login_name, login_pass;

    @Override    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
     ET_NAME = (EditText) findViewById(R.id.user_name);
     ET_PASS = (EditText) findViewById(R.id.user_pass);
    }

    public void iniciosesion(View v) {
        AdminSQLiteOpenHelper admin = new AdminSQLiteOpenHelper(this,
                "administracion", null, 1);
        SQLiteDatabase bd = admin.getWritableDatabase();
        login_name = ET_NAME.getText().toString();
        login_pass = ET_PASS.getText().toString();

        Cursor fila = bd.rawQuery(
                "select name, user_name, user_pass from usuarios where user_name='"+login_name+"' and user_pass='"+login_pass+"'", null);
        if (fila.moveToFirst()) {
            ET_NAME.setText("");
            ET_PASS.setText("");
            startActivity(new Intent(this, menu2.class));
        } else            Toast.makeText(this, "Usuario y/o Contraseña incorrectos.",
                    Toast.LENGTH_SHORT).show();
        bd.close();
    }

    public void userReg(View view){

        startActivity(new Intent(this, Register.class));
    }

}


Crear Registro Del Inicio de Sesión






Código:


package com.example.eltit.pizzapuch;

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.text.TextUtils;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.content.ContentValues;
import android.database.sqlite.SQLiteDatabase;
import android.widget.Toast;

public class Register extends AppCompatActivity {

    EditText ET_NAME, ET_USER_NAME, ET_USER_PASS;
    String name, user_name, user_pass;
    Button btnRegistrar;


    @Override    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_register);
        ET_NAME = (EditText) findViewById(R.id.name);
        ET_USER_NAME = (EditText) findViewById(R.id.new_user_name);
        ET_USER_PASS = (EditText) findViewById(R.id.new_user_pass);
        btnRegistrar = (Button) findViewById(R.id.btnRegistrar);
    }

    public void alta(View view) {

        AdminSQLiteOpenHelper admin = new AdminSQLiteOpenHelper(this, "administracion", null, 1);
        SQLiteDatabase bd = admin.getWritableDatabase();
        name = ET_NAME.getText().toString();
        user_name = ET_USER_NAME.getText().toString();
        user_pass = ET_USER_PASS.getText().toString();
        if (TextUtils.isEmpty(name)) {
            ET_NAME.setError("Tiene que ingresar su nombre.");
            return;
        } else {
            if (TextUtils.isEmpty(user_name)) {
                ET_USER_NAME.setError("Tiene que ingresar un nombre de usuario.");
                return;
            } else {
                if (TextUtils.isEmpty(user_pass)) {
                    ET_USER_PASS.setError("Tiene que ingresar una contraseña.");
                    return;
                } else {
                    ContentValues registro = new ContentValues();
                    registro.put("name", name);
                    registro.put("user_name", user_name);
                    registro.put("user_pass", user_pass);
                    bd.insert("usuarios", null, registro);
                    bd.close();
                    ET_NAME.setText("");
                    ET_USER_NAME.setText("");
                    ET_USER_PASS.setText("");
                    Toast.makeText(this, "Usuario registrado.", Toast.LENGTH_SHORT).show();
                }
            }

        }

    }
}

 Creación del Menú Principal














Código:




package com.example.eltit.pizzapuch;

import android.content.Intent;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;

public class menu2 extends AppCompatActivity {

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

    protected void pedido(View view)
    {
        startActivity(new Intent(this, menu.class));
    }

    protected void modpedido (View view)
    {
        startActivity(new Intent(this, modpedido.class ));
    }

    protected void delpedido (View view)
    {
        startActivity(new Intent(this, delpedido.class));
    }

    protected void conpedido (View view)
    {
        startActivity(new Intent(this, conpedidos.class));
    }
}


------------------------------------------------------------







Crear Pantallas:










<?xml version="1.0" encoding="utf-8"?><android.support.constraint.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"  
  xmlns:app="http://schemas.android.com/apk/res-auto"  
  xmlns:tools="http://schemas.android.com/tools" 
   android:layout_width="match_parent"  
  android:layout_height="match_parent"   
 tools:context="com.example.eltit.pizzapuch.MainActivity" 
   tools:layout_editor_absoluteY="81dp"   
 tools:layout_editor_absoluteX="0dp"    

android:background="@color/colorBackground">

    <TextView        android:id="@+id/textView"   

     android:layout_width="wrap_content"  
      android:layout_height="wrap_content" 
       android:layout_gravity="center_horizontal"   
     android:layout_marginBottom="8dp"  
      android:layout_marginTop="8dp"  
      android:text="@string/login"   
     android:textAppearance="?android:textAppearanceLarge"  
      android:textColor="@android:color/black"    
    android:textStyle="bold"      
  app:layout_constraintBottom_toTopOf="@+id/user_name"   
     app:layout_constraintLeft_toLeftOf="parent"  
      app:layout_constraintRight_toRightOf="parent"    

    app:layout_constraintTop_toBottomOf="@+id/imageView" />

    <EditText        android:id="@+id/user_name"     

   android:layout_width="250dp"  
      android:layout_height="wrap_content"  
      android:layout_gravity="center_horizontal"  
      android:layout_marginBottom="9dp"     
   android:hint="@string/user"      

  android:textColor="@android:color/black"   

     android:textColorHint="@android:color/black"     

   app:layout_constraintBottom_toTopOf="@+id/user_pass"   

     app:layout_constraintLeft_toLeftOf="parent"   

     app:layout_constraintRight_toRightOf="parent" />

    <EditText        android:id="@+id/user_pass"   

     android:layout_width="250dp"     

   android:layout_height="wrap_content"

        android:layout_gravity="center_horizontal"      

  android:layout_marginBottom="7dp"      

  android:hint="@string/Password"       

 android:inputType="textPassword"       

 android:textColor="@android:color/black"  

 android:textColorHint="@android:color/black"   

 app:layout_constraintBottom_toTopOf="@+id/button2" 

 app:layout_constraintLeft_toLeftOf="parent"  

app:layout_constraintRight_toRightOf="parent" />


    <Button        android:id="@+id/button2"  

      android:layout_width="100dp" 

       android:layout_height="wrap_content"    

    android:layout_gravity="center_horizontal"  

      android:layout_marginBottom="10dp"    

    android:onClick="iniciosesion"      

  android:text="@string/inicio"    

    app:layout_constraintBottom_toTopOf="@+id/button"    

    app:layout_constraintLeft_toLeftOf="parent" 

       app:layout_constraintRight_toRightOf="parent" />

    <Button        android:layout_width="wrap_content"  

      android:layout_height="wrap_content"      

  android:text="@string/register"      

  android:layout_gravity="center_horizontal"  

      android:onClick="userReg"      

  android:id="@+id/button"      

  app:layout_constraintLeft_toLeftOf="parent"

        app:layout_constraintRight_toRightOf="parent"     

   app:layout_constraintHorizontal_bias="0.501"

        app:layout_constraintBottom_toBottomOf="parent"   

     android:layout_marginBottom="34dp" />

    <android.support.constraint.Guideline   

     android:layout_width="wrap_content"   

     android:layout_height="wrap_content"  

      android:id="@+id/guideline"  

      app:layout_constraintGuide_begin="20dp"       

 android:orientation="vertical"       

 tools:layout_editor_absoluteY="0dp"  

      tools:layout_editor_absoluteX="20dp" />

    <ImageView        android:id="@+id/imageView"  

      android:layout_width="149dp"   

     android:layout_height="127dp"       

 android:layout_marginTop="39dp"      

  android:contentDescription="@string/login"  

      app:layout_constraintHorizontal_bias="0.502"  

      app:layout_constraintLeft_toLeftOf="parent"   

     app:layout_constraintRight_toRightOf="parent" 

       app:layout_constraintTop_toTopOf="parent"   

     app:srcCompat="@drawable/logo" />

</android.support.constraint.ConstraintLayout>


------------------------------------------------------------















<?xml version="1.0" encoding="utf-8"?><android.support.constraint.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"    xmlns:app="http://schemas.android.com/apk/res-auto"    xmlns:tools="http://schemas.android.com/tools"    android:layout_width="match_parent"    android:layout_height="match_parent"    tools:context="com.example.eltit.pizzapuch.Register"    tools:layout_editor_absoluteY="81dp"    tools:layout_editor_absoluteX="0dp">
    <TextView        android:layout_width="wrap_content"        android:layout_height="wrap_content"        android:text="@string/register"        android:textAppearance="?android:textAppearanceLarge"        android:textStyle="bold"        android:layout_gravity="center_horizontal"        android:id="@+id/textView2"        app:layout_constraintTop_toTopOf="parent"        android:layout_marginTop="69dp"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintHorizontal_bias="0.501" />

    <EditText        android:id="@+id/name"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_gravity="center_horizontal"        android:layout_marginTop="17dp"        android:hint="@string/nombre"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/textView2" />

    <EditText        android:id="@+id/new_user_name"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_gravity="center_horizontal"        android:layout_marginTop="0dp"        android:hint="@string/nomusu"        android:textColor="@android:color/black"        android:textColorLink="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/name" />
    <EditText        android:layout_width="250dp"        android:layout_height="wrap_content"        android:hint="@string/Password"        android:id="@+id/new_user_pass"        android:layout_gravity="center_horizontal"        android:inputType="textPassword"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        android:layout_marginTop="-4dp"        app:layout_constraintTop_toBottomOf="@+id/new_user_name" />
    <Button        android:layout_width="130dp"        android:layout_height="wrap_content"        android:text="@string/regis"        android:layout_gravity="center_horizontal"        android:onClick="alta"        android:id="@+id/btnRegistrar"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintBottom_toBottomOf="parent"        android:layout_marginBottom="8dp"        android:layout_marginTop="8dp"        app:layout_constraintTop_toBottomOf="@+id/new_user_pass"        app:layout_constraintVertical_bias="0.091" />
</android.support.constraint.ConstraintLayout>


------------------------------------------------------------














<?xml version="1.0" encoding="utf-8"?><android.support.constraint.ConstraintLayout    xmlns:android="http://schemas.android.com/apk/res/android"    xmlns:app="http://schemas.android.com/apk/res-auto"    xmlns:tools="http://schemas.android.com/tools"    android:layout_width="match_parent"    android:layout_height="match_parent"    tools:context="com.example.eltit.pizzapuch.menu2"    tools:layout_editor_absoluteY="81dp"    tools:layout_editor_absoluteX="0dp"    android:background="@color/colorBackground">

    <TextView        android:id="@+id/textView2"        android:layout_width="wrap_content"        android:layout_height="wrap_content"        android:layout_gravity="center_horizontal"        android:layout_marginTop="37dp"        android:text="@string/menu"        android:textAppearance="?android:textAppearanceLarge"        android:textColor="@android:color/black"        android:textStyle="bold"        app:layout_constraintHorizontal_bias="0.502"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toTopOf="parent" />

    <Button        android:id="@+id/button5"        android:layout_width="239dp"        android:layout_height="53dp"        android:onClick="pedido"        android:text="@string/new_pedido"        android:layout_marginTop="63dp"        app:layout_constraintTop_toBottomOf="@+id/textView2"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintHorizontal_bias="0.503" />

    <Button        android:id="@+id/button6"        android:layout_width="239dp"        android:layout_height="53dp"        android:layout_marginTop="16dp"        android:onClick="modpedido"        android:text="@string/mod_pedido"        android:textAlignment="center"        app:layout_constraintHorizontal_bias="0.503"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/button5" />

    <Button        android:id="@+id/button7"        android:layout_width="239dp"        android:layout_height="53dp"        android:onClick="delpedido"        android:text="@string/del_pedido"        android:layout_marginTop="3dp"        app:layout_constraintTop_toBottomOf="@+id/button6"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintHorizontal_bias="0.503" />

    <Button        android:id="@+id/button3"        android:layout_width="239dp"        android:layout_height="53dp"        android:onClick="conpedido"        android:text="@string/con_pedidos"        android:layout_marginTop="12dp"        app:layout_constraintTop_toBottomOf="@+id/button7"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintHorizontal_bias="0.503"        app:layout_constraintBottom_toBottomOf="parent"        android:layout_marginBottom="8dp"        app:layout_constraintVertical_bias="0.0" />

</android.support.constraint.ConstraintLayout>



------------------------------------------------------------















<?xml version="1.0" encoding="utf-8"?><android.support.constraint.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"    xmlns:app="http://schemas.android.com/apk/res-auto"    xmlns:tools="http://schemas.android.com/tools"    android:layout_width="match_parent"    android:layout_height="match_parent"    tools:context="com.example.eltit.pizzapuch.menu"    android:background="@color/colorBackground"    tools:layout_editor_absoluteY="81dp"    tools:layout_editor_absoluteX="0dp">

    <EditText        android:id="@+id/new_fecha"        android:layout_width="247dp"        android:layout_height="43dp"        android:layout_marginTop="30dp"        android:ems="10"        android:hint="@string/fecha"        android:inputType="date"        android:maxLength="8"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintHorizontal_bias="0.503"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toTopOf="parent" />

    <EditText        android:id="@+id/new_client"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_gravity="center_horizontal"        android:layout_marginTop="6dp"        android:hint="@string/cliente"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/new_fecha" />

    <EditText        android:id="@+id/new_ingredient"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_gravity="center_horizontal"        android:layout_marginTop="0dp"        android:hint="@string/ingrediente"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/new_client" />

    <EditText        android:id="@+id/new_calle"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_gravity="center_horizontal"        android:layout_marginTop="3dp"        android:hint="@string/calle"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/new_cantidad" />

    <EditText        android:id="@+id/new_colonia"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_gravity="center_horizontal"        android:layout_marginTop="-5dp"        android:hint="@string/colonia"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/new_calle" />

    <Button        android:id="@+id/button4"        android:layout_width="216dp"        android:layout_height="48dp"        android:onClick="altaPedido"        android:text="@string/pedido"        android:layout_marginTop="8dp"        app:layout_constraintTop_toBottomOf="@+id/new_telefono"        app:layout_constraintBottom_toBottomOf="parent"        android:layout_marginBottom="8dp"        app:layout_constraintVertical_bias="0.592"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent" />

    <EditText        android:id="@+id/new_cantidad"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_marginTop="4dp"        android:ems="10"        android:hint="@string/cantidad"        android:inputType="number"        android:maxLength="1"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/new_ingredient" />

    <EditText        android:id="@+id/new_telefono"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_marginTop="-14dp"        android:ems="10"        android:hint="@string/telefono"        android:inputType="number"        android:maxLength="12"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/new_colonia" />

</android.support.constraint.ConstraintLayout>

------------------------------------------------------------
















<?xml version="1.0" encoding="utf-8"?><android.support.constraint.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"    xmlns:app="http://schemas.android.com/apk/res-auto"    xmlns:tools="http://schemas.android.com/tools"    android:layout_width="match_parent"    android:layout_height="match_parent"    tools:context="com.example.eltit.pizzapuch.delpedido"    android:background="@color/colorBackground"    tools:layout_editor_absoluteY="81dp"    tools:layout_editor_absoluteX="0dp">

    <EditText        android:id="@+id/del_id"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_marginTop="69dp"        android:ems="10"        android:hint="@string/idET"        android:inputType="number"        android:maxLength="1"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/write_id" />

    <TextView        android:id="@+id/write_id"        android:layout_width="wrap_content"        android:layout_height="wrap_content"        android:layout_marginTop="80dp"        android:text="@string/eliminar"        android:textColor="@android:color/black"        android:textSize="24sp"        android:textStyle="bold"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toTopOf="parent" />

    <TextView        android:id="@+id/del_msg"        android:layout_width="345dp"        android:layout_height="53dp"        android:layout_gravity="center_horizontal"        android:layout_marginBottom="8dp"        android:layout_marginLeft="18dp"        android:layout_marginRight="8dp"        android:layout_marginTop="8dp"        android:text="@string/message"        android:textAppearance="?android:textAppearanceLarge"        android:textColor="@android:color/black"        android:textSize="14sp"        android:textStyle="bold"        app:layout_constraintBottom_toTopOf="@+id/button8"        app:layout_constraintHorizontal_bias="0.153"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/del_id"        app:layout_constraintVertical_bias="0.466" />

    <Button        android:id="@+id/button8"        android:layout_width="wrap_content"        android:layout_height="wrap_content"        android:onClick="eliminar"        android:text="@string/btneliminar"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintBottom_toBottomOf="parent"        android:layout_marginBottom="68dp" />

</android.support.constraint.ConstraintLayout>

------------------------------------------------------------






















<?xml version="1.0" encoding="utf-8"?><android.support.constraint.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"    xmlns:app="http://schemas.android.com/apk/res-auto"    xmlns:tools="http://schemas.android.com/tools"    android:layout_width="match_parent"    android:layout_height="match_parent"    tools:context="com.example.eltit.pizzapuch.conpedidos"    android:background="@color/colorBackground"    tools:layout_editor_absoluteY="81dp"    tools:layout_editor_absoluteX="0dp">

    <EditText        android:id="@+id/new_fecha"        android:layout_width="250dp"        android:layout_height="43dp"        android:layout_marginTop="6dp"        android:ems="10"        android:hint="@string/fecha"        android:inputType="text"        android:maxLength="8"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/new_id" />

    <EditText        android:id="@+id/new_id"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_marginTop="10dp"        android:ems="10"        android:hint="@string/idET"        android:inputType="text"        android:maxLength="12"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/new_client" />

    <TextView        android:id="@+id/mod_textview2"        android:layout_width="wrap_content"        android:layout_height="wrap_content"        android:layout_gravity="center_horizontal"        android:layout_marginTop="4dp"        android:text="@string/con_pedidos"        android:textAppearance="?android:textAppearanceLarge"        android:textColor="@android:color/black"        android:textSize="24sp"        android:textStyle="bold"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toTopOf="parent" />

    <EditText        android:id="@+id/new_client"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_gravity="center_horizontal"        android:layout_marginTop="8dp"        android:hint="@string/cliente"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/mod_textview2" />

    <EditText        android:id="@+id/new_ingredient"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_gravity="center_horizontal"        android:layout_marginTop="10dp"        android:hint="@string/ingrediente"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/new_fecha" />

    <EditText        android:id="@+id/new_calle"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_gravity="center_horizontal"        android:layout_marginTop="5dp"        android:hint="@string/calle"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/new_cantidad" />

    <EditText        android:id="@+id/new_colonia"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_gravity="center_horizontal"        android:layout_marginTop="13dp"        android:hint="@string/colonia"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/new_calle" />

    <Button        android:id="@+id/button4"        android:layout_width="216dp"        android:layout_height="48dp"        android:onClick="consulta"        android:text="@string/buscar"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        android:layout_marginTop="8dp"        app:layout_constraintTop_toBottomOf="@+id/new_telefono"        app:layout_constraintBottom_toBottomOf="parent"        android:layout_marginBottom="8dp"        app:layout_constraintVertical_bias="0.0" />

    <EditText        android:id="@+id/new_cantidad"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_marginTop="21dp"        android:ems="10"        android:hint="@string/cantidad"        android:inputType="text"        android:maxLength="1"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/new_ingredient" />

    <EditText        android:id="@+id/new_telefono"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_marginTop="3dp"        android:ems="10"        android:hint="@string/telefono"        android:inputType="text"        android:maxLength="12"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/new_colonia" />

</android.support.constraint.ConstraintLayout>

------------------------------------------------------------















<?xml version="1.0" encoding="utf-8"?><android.support.constraint.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"    xmlns:app="http://schemas.android.com/apk/res-auto"    xmlns:tools="http://schemas.android.com/tools"    android:layout_width="match_parent"    android:layout_height="match_parent"    tools:context="com.example.eltit.pizzapuch.modpedido"    android:background="@color/colorBackground"    tools:layout_editor_absoluteY="81dp"    tools:layout_editor_absoluteX="0dp">

    <TextView    android:id="@+id/mod_textview"    android:layout_width="wrap_content"    android:layout_height="wrap_content"    android:layout_gravity="center_horizontal"    android:text="@string/mod_tw"    android:textAppearance="?android:textAppearanceLarge"    android:textColor="@color/colorLetters"    android:textSize="14sp"    android:textStyle="bold"        android:layout_marginTop="8dp"        app:layout_constraintTop_toBottomOf="@+id/button4"        app:layout_constraintBottom_toBottomOf="parent"        android:layout_marginBottom="8dp"        app:layout_constraintVertical_bias="0.816"        android:layout_marginLeft="8dp"        app:layout_constraintLeft_toLeftOf="parent"        android:layout_marginRight="8dp"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintHorizontal_bias="1.0" />

    <TextView        android:id="@+id/mod_textview2"        android:layout_width="wrap_content"        android:layout_height="wrap_content"        android:layout_gravity="center_horizontal"        android:layout_marginTop="36dp"        android:text="@string/mod_btn"        android:textAppearance="?android:textAppearanceLarge"        android:textColor="@android:color/black"        android:textSize="24sp"        android:textStyle="bold"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toTopOf="parent" />

    <EditText        android:id="@+id/id"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_marginTop="22dp"        android:ems="10"        android:hint="@string/idET"        android:inputType="number"        android:maxLength="1"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/mod_textview2" />

    <EditText        android:id="@+id/new_ingredient"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_gravity="center_horizontal"        android:layout_marginTop="36dp"        android:hint="@string/ingrediente"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/id" />

    <Button        android:id="@+id/button4"        android:layout_width="216dp"        android:layout_height="48dp"        android:layout_marginTop="51dp"        android:onClick="modificacion"        android:text="@string/mod_btn"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/new_cantidad" />

    <EditText        android:id="@+id/new_cantidad"        android:layout_width="250dp"        android:layout_height="wrap_content"        android:layout_marginTop="25dp"        android:ems="10"        android:hint="@string/cantidad"        android:inputType="number"        android:maxLength="1"        android:textColor="@color/colorLetters"        android:textColorHint="@android:color/black"        app:layout_constraintLeft_toLeftOf="parent"        app:layout_constraintRight_toRightOf="parent"        app:layout_constraintTop_toBottomOf="@+id/new_ingredient" />

</android.support.constraint.ConstraintLayout>

SqlLiteAndroidStudio

lunes, 10 de abril de 2017

Sqlite ¿Cómo Se Usa?

Hoy les mostrare un Código para hacer Altas, Bajas, Consultas Y Modificaciones

Archivo del blog