my database has 1 line in Produtos table but my ListView is empty !
i put adapter String[] and works.... but when i set data from database is empty
i already give select, insert commands in cmd/sqlite and its ok.
i dont find the error ...
Thanks Very much !
//item.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://ift.tt/nIICcg"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
android:orientation="horizontal"
android:padding="5dp" >
<ImageButton
android:id="@+id/itemBuy"
android:layout_width="50dp"
android:layout_height="50dp"
android:layout_marginStart="5dp"
android:layout_marginEnd="5dp"
android:layout_marginTop="5dp"
android:src="@drawable/iconbuy1" />
<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="vertical"
android:padding="5dp" >
<TextView
android:id="@+id/itemName"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:layout_weight="0.71"
android:text="Produto"
android:textSize="25sp" />
<LinearLayout
android:orientation="horizontal"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:layout_weight="0.71" >
<TextView
android:id="@+id/itemQtde"
android:layout_width="wrap_content"
android:layout_height="20dp"
android:text="Quantidade: 4"
android:textSize="12sp" />
<View
android:layout_height="20dp"
android:layout_width="50dp"/>
<TextView
android:id="@+id/itemPreco"
android:layout_width="wrap_content"
android:layout_height="20dp"
android:text="Preco: R$4,00"
android:textSize="12sp" />
</LinearLayout>
</LinearLayout>
</LinearLayout>
novoproduto.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://ift.tt/nIICcg"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical" >
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="@string/product_name"
android:textAppearance="?android:attr/textAppearanceMedium" />
<EditText
android:id="@+id/editNome"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:ems="10" >
<requestFocus />
</EditText>
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="@string/product_preco"
android:textAppearance="?android:attr/textAppearanceMedium" />
<EditText
android:id="@+id/editPreco"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:inputType="numberDecimal"
android:ems="10" />
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="@string/product_desc"
android:textAppearance="?android:attr/textAppearanceMedium" />
<EditText
android:id="@+id/editDetalhes"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:ems="10"
android:inputType="textMultiLine" />
</LinearLayout>
//Main.java
package thiagoyb.controleestoque;
import android.app.ActionBar;
import android.app.Activity;
import android.app.Fragment;
import android.app.FragmentManager;
import android.content.Context;
import android.os.Bundle;
import android.support.v4.widget.DrawerLayout;
import android.view.LayoutInflater;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.view.ViewGroup;
import android.widget.ListView;
public class Main extends Activity implements NavigationDrawerFragment.NavigationDrawerCallbacks {
private NavigationDrawerFragment mNavigationDrawerFragment;
private CharSequence mTitle;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
mNavigationDrawerFragment = (NavigationDrawerFragment) getFragmentManager()
.findFragmentById(R.id.navigation_drawer); //lista
mTitle = getTitle();
// Set up the drawer.
mNavigationDrawerFragment.setUp(R.id.navigation_drawer,
(DrawerLayout) findViewById(R.id.drawer_layout));
BancoDeDados.criaBanco(this);
}
@Override
public void onNavigationDrawerItemSelected(int position) {
// update the main content by replacing fragments
FragmentManager fragmentManager = getFragmentManager();
fragmentManager
.beginTransaction()
.replace(R.id.container,
PlaceholderFragment.newInstance(this,position + 1)).commit();
}
public void onSectionAttached(int number) {
switch (number) {
case 1:
mTitle = getString(R.string.title_section1);
break;
case 2:
mTitle = getString(R.string.title_section2);
break;
case 3:
mTitle = getString(R.string.title_section3);
break;
}
}
public void restoreActionBar() {
ActionBar actionBar = getActionBar();
actionBar.setNavigationMode(ActionBar.NAVIGATION_MODE_STANDARD);
actionBar.setDisplayShowTitleEnabled(true);
actionBar.setTitle(mTitle);
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
if (!mNavigationDrawerFragment.isDrawerOpen()) {
getMenuInflater().inflate(R.menu.main, menu);
restoreActionBar();
return true;
}
return super.onCreateOptionsMenu(menu);
}
@Override
public boolean onOptionsItemSelected(MenuItem item) {
if (item.getItemId() == R.id.action_settings) {
return true;
}
return super.onOptionsItemSelected(item);
}
/**
* A placeholder fragment containing a simple view.
*/
public static class PlaceholderFragment extends Fragment {
private static final String ARG_SECTION_NUMBER = "section_number";
private static Context context = null;
public static PlaceholderFragment newInstance(Context c, int sectionNumber) {
context = c;
PlaceholderFragment fragment = new PlaceholderFragment();
Bundle args = new Bundle();
args.putInt(ARG_SECTION_NUMBER, sectionNumber);
fragment.setArguments(args);
return fragment;
}
public PlaceholderFragment() {
}
@Override
public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {
View rootView = inflater.inflate(R.layout.frag_main, container,false);
View emptyView = inflater.inflate(R.layout.vazio, null);
ListView loja = (ListView) rootView.findViewById(R.id.list_loja);
ListView estoque = (ListView) rootView.findViewById(R.id.list_estoque);
ListView loglist = (ListView) rootView.findViewById(R.id.list_log);
loja.setVisibility(View.GONE);
loja.setEmptyView(emptyView);
estoque.setVisibility(View.GONE);
estoque.setEmptyView(emptyView);
loglist.setVisibility(View.GONE);
loglist.setEmptyView(emptyView);
switch(getArguments().getInt(ARG_SECTION_NUMBER)){
case 1: {
loja.setVisibility(View.VISIBLE);
loja.setAdapter(new ItemAdapter(context, 1, BancoDeDados.ler(context)));
break;}
case 2: {
estoque.setVisibility(View.VISIBLE);
estoque.setAdapter(new ItemAdapter(context,2,BancoDeDados.ler(context)));
break;}
case 3: {
loglist.setVisibility(View.VISIBLE);
break;}
}
return rootView;
}
@Override
public void onAttach(Activity activity) {
super.onAttach(activity);
((Main) activity).onSectionAttached(getArguments().getInt(ARG_SECTION_NUMBER));
}
}
}
// BancoDeDados.java
package thiagoyb.controleestoque;
import java.util.ArrayList;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;
import android.widget.Toast;
public class BancoDeDados {
private static SQLiteDatabase database = null;
public static void criaBanco(Context context){
String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS Produtos"
+"(id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"
+" nome VARCHAR(20) NOT NULL,"
+" qtde INTEGER NOT NULL,"
+" preco VARCHAR(6) NOT NULL,"
+" desc VARCHAR(45) NULL"
+ ");";
try{
database = context.openOrCreateDatabase("estoque.db", Context.MODE_PRIVATE, null);
database.execSQL(CREATE_TABLE);
database.close();
Log.i("BD.java", "Banco Dados Criado/Aberto!");
//Toast.makeText(context, "Banco Dados Criado/Aberto!", Toast.LENGTH_SHORT).show();
}
catch(Exception e){
Log.i("BD.java", "Erro ao criar/abrir Banco de Dados.");
}
}
public static boolean table_exists(Context context, SQLiteDatabase database){
boolean tem = false;
try{
database = context.openOrCreateDatabase("estoque.db", Context.MODE_PRIVATE, null);
Cursor c = database.rawQuery("SELECT name FROM sqlite_master WHERE name = 'Produtos' and type = 'table';", null);
if(c!=null && c.moveToFirst()){
while(c.moveToNext()){
String tabela = c.getString(c.getColumnIndex("name"));
if(tabela.equals("Produtos")){
tem = true;
}
}
}
database.close();
Log.i("BD.java", "Verificou se tem a tabela.("+(tem?"True":"False")+")");
}
catch(Exception e){
Log.i("BD.java", "Erro ao ver se tabela existe.");}
return tem;
}
public static boolean db_exists(Context context, SQLiteDatabase database) {
try{
database = SQLiteDatabase.openDatabase("estoque.db", null, SQLiteDatabase.OPEN_READONLY);
database.close();
Log.i("BD.java", "o banco de dados existe.");
}
catch(Exception e){
Log.i("BD.java", "Erro ou o banco de dados nao existe.");}
return database != null;
}
public static ArrayList<Produto> ler(Context context){
ArrayList<Produto> produtos = new ArrayList<Produto>();
try{
String SELECT_TABLE = "SELECT * FROM Produtos;";
database = context.openOrCreateDatabase("estoque.db", Context.MODE_PRIVATE, null);
Cursor c = database.rawQuery(SELECT_TABLE, null);
if(c!=null && c.moveToFirst()){
while(c.moveToNext()){
Integer id = Integer.valueOf(c.getString(c.getColumnIndex("id")));
String nome = c.getString(c.getColumnIndex("nome"));
Integer qtde = Integer.valueOf(c.getString(c.getColumnIndex("qtde")));
String preco = c.getString(c.getColumnIndex("preco"));
String desc = c.getString(c.getColumnIndex("desc"));
produtos.add(new Produto(id, nome, qtde, preco, desc));
}
}
c.close();
database.close();
Log.i("BD.java", "Dados lidos do banco.");
Toast.makeText(context, "Produtos carregados.", Toast.LENGTH_SHORT).show();
}
catch(Exception e){Log.i("BD.java", "Erro ao ler os dados.");}
return produtos;
}
public static void apagar(Context context, Integer id){
try{
String DELETE = "DELETE FROM Produtos WHERE id = "+id;
database = context.openOrCreateDatabase("estoque.db", Context.MODE_PRIVATE, null);
database.execSQL(DELETE);
database.close();
Log.i("BD.java", "linha(s) apagada(s) no banco.");
Toast.makeText(context, "linha(s) apagada(s) no banco.", Toast.LENGTH_SHORT).show();
}
catch(Exception e){Log.i("BD.java", "Erro ao apagar dados.");}
}
public static void save(Context context, Produto p){
try{
String INSERT_TABLE = "INSERT INTO Produtos (id, nome, qtde, preco, desc) VALUES (null, \""+p.getNome().toString()+"\", "+p.getQuantidade()+",'"+p.getPreco()+"',\""+p.getDescricao().toString()+"\");";
database = context.openOrCreateDatabase("estoque.db", Context.MODE_PRIVATE, null);
ContentValues myvalues = new ContentValues();
myvalues.put("nome", p.getNome());
myvalues.put("qtde", 0);
myvalues.put("preco", p.getPreco());
myvalues.put("desc", p.getDescricao());
database.insert("Produtos", null, myvalues);
database.close();
Log.i("BD.java", "Dados inseridos no banco.");
Toast.makeText(context, "Produto Cadastrado.", Toast.LENGTH_SHORT).show();
}
catch(Exception e){Log.i("BD.java", "Erro ao inserir dados.");}
}
public static void gravar(Context context, Produto p){
try{
String INSERT_TABLE = "INSERT INTO Produtos (id, nome, qtde, preco, desc) VALUES (null, \""+p.getNome().toString()+"\", "+p.getQuantidade()+",'"+p.getPreco()+"',\""+p.getDescricao().toString()+"\");";
database = context.openOrCreateDatabase("estoque.db", Context.MODE_PRIVATE, null);
database.execSQL(INSERT_TABLE);
database.close();
Log.i("BD.java", "Dados inseridos no banco.");
Toast.makeText(context, "Produto Cadastrado.", Toast.LENGTH_SHORT).show();
}
catch(Exception e){Log.i("BD.java", "Erro ao inserir dados.");}
}
public static void apagaTabela(Context context){
try {
database = context.openOrCreateDatabase("estoque.db", Context.MODE_PRIVATE, null);
database.execSQL("DROP TABLE IF EXISTS Pessoas;");
database.close();
} catch (Exception e) {}
Toast.makeText(context, "Tabela apagada do banco.", Toast.LENGTH_SHORT).show();
}
}
//ItemAdapter.java
package thiagoyb.controleestoque;
import java.util.ArrayList;
import android.content.Context;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.View.OnClickListener;
import android.view.ViewGroup;
import android.widget.ArrayAdapter;
import android.widget.ImageView;
import android.widget.TextView;
import android.widget.Toast;
public class ItemAdapter extends ArrayAdapter<String> {
private final Context context;
private final ArrayList<Produto> produtos;
private int sectionid;
private static String[] v = new String[]{"Produto 1","Produto 2","Produto 3"};
public ItemAdapter(Context context, int sectionid, ArrayList<Produto> produtos) {
super(context, R.layout.item, getProductsNames(produtos));
this.context = context;
this.sectionid = sectionid;
this.produtos = produtos;
Log.i("SIZE", "Size: "+produtos.size());
}
@Override
public View getView(final int position, View convertView, ViewGroup parent) {
LayoutInflater inflater = (LayoutInflater) context
.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
View rowView = inflater.inflate(R.layout.item, parent, false);
TextView itemNome = (TextView) rowView.findViewById(R.id.itemName);
TextView itemQtde = (TextView) rowView.findViewById(R.id.itemQtde);
TextView itemPreco = (TextView) rowView.findViewById(R.id.itemPreco);
ImageView itemBuy = (ImageView) rowView.findViewById(R.id.itemBuy);
itemNome.setText(produtos.get(position).getNome().toString());
itemQtde.setText(produtos.get(position).getQuantidade());
itemPreco.setText(produtos.get(position).getPreco().toString());
/*
itemNome.setText(v[position]);
itemQtde.setText("Quantidade: 3");
itemPreco.setText("Preco: 1.25");
*/
itemBuy.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
Toast.makeText(context, "Item comprado !", Toast.LENGTH_SHORT).show();
}
});
return rowView;
}
public static String[] getProductsNames2(ArrayList<Produto> ps){
int i= ps.size();
String[] str = new String[i];
for(Produto p : ps){
str[i-1] = p.getNome();
i--;
}
return str;
}
public static String[] getProductsNames(ArrayList<Produto> ps){
ArrayList<String> strs = new ArrayList<String>();
for(Produto p : ps){
strs.add(p.getNome());
}
String[] str = new String[strs.size()];
str = strs.toArray(str);
return str;
}
}
//NavigationDrawerFragment.java
package thiagoyb.controleestoque;
import android.app.ActionBar;
import android.app.Activity;
import android.app.AlertDialog;
import android.app.Fragment;
import android.content.Context;
import android.content.DialogInterface;
import android.content.SharedPreferences;
import android.content.res.Configuration;
import android.os.Bundle;
import android.preference.PreferenceManager;
import android.support.v4.app.ActionBarDrawerToggle;
import android.support.v4.view.GravityCompat;
import android.support.v4.widget.DrawerLayout;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.Menu;
import android.view.MenuInflater;
import android.view.MenuItem;
import android.view.View;
import android.view.ViewGroup;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.TextView;
/**
* "http://ift.tt/1agbF6m"
*/
public class NavigationDrawerFragment extends Fragment {
private static final String STATE_SELECTED_POSITION = "selected_navigation_drawer_position";
private static final String PREF_USER_LEARNED_DRAWER = "navigation_drawer_learned";
private NavigationDrawerCallbacks mCallbacks;
private ActionBarDrawerToggle mDrawerToggle;
private DrawerLayout mDrawerLayout;
private ListView mDrawerListView;
private View mFragmentContainerView;
private int mCurrentSelectedPosition = 0;
private boolean mFromSavedInstanceState;
private boolean mUserLearnedDrawer;
public NavigationDrawerFragment() {
}
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
SharedPreferences sp = PreferenceManager.getDefaultSharedPreferences(getActivity());
mUserLearnedDrawer = sp.getBoolean(PREF_USER_LEARNED_DRAWER, false);
if (savedInstanceState != null) {
mCurrentSelectedPosition = savedInstanceState.getInt(STATE_SELECTED_POSITION);
mFromSavedInstanceState = true;
}
// Select either the default item (0) or the last selected item.
selectItem(mCurrentSelectedPosition);
}
@Override
public void onActivityCreated(Bundle savedInstanceState) {
super.onActivityCreated(savedInstanceState);
setHasOptionsMenu(true);
}
@Override
public View onCreateView(LayoutInflater inflater, ViewGroup container,Bundle savedInstanceState) {
mDrawerListView = (ListView) inflater.inflate(R.layout.frag_nav_drawer,container, false);
mDrawerListView
.setOnItemClickListener(new AdapterView.OnItemClickListener() {
@Override
public void onItemClick(AdapterView<?> parent, View view,int position, long id) {
selectItem(position);
}
});
mDrawerListView.setAdapter(new ArrayAdapter<String>(getActionBar()
.getThemedContext(),
android.R.layout.simple_list_item_activated_1,
android.R.id.text1, new String[] {
getString(R.string.title_section1),
getString(R.string.title_section2),
getString(R.string.title_section3), }));
mDrawerListView.setItemChecked(mCurrentSelectedPosition, true);
return mDrawerListView;
}
public boolean isDrawerOpen() {
return mDrawerLayout != null && mDrawerLayout.isDrawerOpen(mFragmentContainerView);
}
public void setUp(int fragmentId, DrawerLayout drawerLayout) {
mFragmentContainerView = getActivity().findViewById(fragmentId);
mDrawerLayout = drawerLayout;
mDrawerLayout.setDrawerShadow(R.drawable.drawer_shadow, GravityCompat.START);
ActionBar actionBar = getActionBar();
actionBar.setDisplayHomeAsUpEnabled(true);
actionBar.setHomeButtonEnabled(true);
// ActionBarDrawerToggle ties together the the proper interactions
// between the navigation drawer and the action bar app icon.
mDrawerToggle = new ActionBarDrawerToggle(getActivity(), /* host Activity */
mDrawerLayout, /* DrawerLayout object */
R.drawable.ic_drawer, /* nav drawer image to replace 'Up' caret */
R.string.navigation_drawer_open,
R.string.navigation_drawer_close){
@Override
public void onDrawerClosed(View drawerView) {
super.onDrawerClosed(drawerView);
if (!isAdded()) {
return;
}
getActivity().invalidateOptionsMenu(); // calls OnPrepareMenu
}
@Override
public void onDrawerOpened(View drawerView) {
super.onDrawerOpened(drawerView);
if (!isAdded()) {
return;
}
if (!mUserLearnedDrawer) {
mUserLearnedDrawer = true;
SharedPreferences sp = PreferenceManager.getDefaultSharedPreferences(getActivity());
sp.edit().putBoolean(PREF_USER_LEARNED_DRAWER, true).apply();
}
getActivity().invalidateOptionsMenu(); // calls
// onPrepareOptionsMenu()
}
};
if (!mUserLearnedDrawer && !mFromSavedInstanceState) {
mDrawerLayout.openDrawer(mFragmentContainerView);
}
// Defer code dependent on restoration of previous instance state.
mDrawerLayout.post(new Runnable() {
@Override
public void run() {
mDrawerToggle.syncState();
}
});
mDrawerLayout.setDrawerListener(mDrawerToggle);
}
private void selectItem(int position) {
mCurrentSelectedPosition = position;
if (mDrawerListView != null) {
mDrawerListView.setItemChecked(position, true);
}
if (mDrawerLayout != null) {
mDrawerLayout.closeDrawer(mFragmentContainerView);
}
if (mCallbacks != null) {
mCallbacks.onNavigationDrawerItemSelected(position);
}
}
@Override
public void onAttach(Activity activity) {
super.onAttach(activity);
try {
mCallbacks = (NavigationDrawerCallbacks) activity;
} catch (ClassCastException e) {
throw new ClassCastException(
"Activity must implement NavigationDrawerCallbacks.");
}
}
@Override
public void onDetach() {
super.onDetach();
mCallbacks = null;
}
@Override
public void onSaveInstanceState(Bundle outState) {
super.onSaveInstanceState(outState);
outState.putInt(STATE_SELECTED_POSITION, mCurrentSelectedPosition);
}
@Override
public void onConfigurationChanged(Configuration newConfig) {
super.onConfigurationChanged(newConfig);
// Forward the new configuration the drawer toggle component.
mDrawerToggle.onConfigurationChanged(newConfig);
}
@Override
public void onCreateOptionsMenu(Menu menu, MenuInflater inflater) {
if (mDrawerLayout != null && isDrawerOpen()) {
inflater.inflate(R.menu.global, menu);
showGlobalContextActionBar();
}
super.onCreateOptionsMenu(menu, inflater);
}
@Override
public boolean onOptionsItemSelected(MenuItem item) {
if (mDrawerToggle.onOptionsItemSelected(item)) {
return true;
}
if (item.getItemId() == R.id.novo_produto) {
CadastraNovoProduto();
return true;
}
return super.onOptionsItemSelected(item);
}
private void CadastraNovoProduto() {
LayoutInflater inflater = (LayoutInflater)getActivity().getSystemService(Context.LAYOUT_INFLATER_SERVICE);
final View rootView = inflater.inflate(R.layout.novoproduto, null);
new AlertDialog.Builder(getActivity())
.setTitle("Novo Produto")
.setIcon(R.drawable.newitem)
.setView(rootView)
.setNegativeButton("Cancelar", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
dialog.cancel();
}
})
.setPositiveButton("Cadastrar", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
TextView n = (TextView) rootView.findViewById(R.id.editNome);
TextView p = (TextView) rootView.findViewById(R.id.editPreco);
TextView d = (TextView) rootView.findViewById(R.id.editDetalhes);
String nome = n.getText().toString();
String preco = p.getText().toString();
String desc = d.getText().toString();
Log.i("VARS","Nome: "+nome+" Preco: "+preco+"");
BancoDeDados.save(getActivity(), new Produto(0, nome, 0, preco, desc));
}
})
.create().show();
}
private void showGlobalContextActionBar() {
ActionBar actionBar = getActionBar();
actionBar.setDisplayShowTitleEnabled(true);
actionBar.setNavigationMode(ActionBar.NAVIGATION_MODE_STANDARD);
actionBar.setTitle(R.string.app_name);
}
private ActionBar getActionBar() {
return getActivity().getActionBar();
}
public static interface NavigationDrawerCallbacks {
void onNavigationDrawerItemSelected(int position);
}
}
Aucun commentaire:
Enregistrer un commentaire