nargesjooon
چهارشنبه 09 دی 1394, 11:58 صبح
سلام دوستان
کلا حالا ک موضوع دیتابیس را متوجه شدم البتهبا 1 جدول
حالا 4 تا جدول دارم میخام با کلیک روی باتن های 1 تا 4 فیلدهای جدول 1 تا 4 ب نمایش دربیایند
اما
به این صورت نمایش داده میشن
اینم تصاویر و کدهای نوشته شده
ممنون میشم کمکم کنید
http://8pic.ir/images/qzx7530suoj2jjmtrml3.jpg
http://8pic.ir/images/fshb9ipngep5w3pm80bx.jpg
کد دیتابیس و کوئری های مربوطه
public String namayesh_field(String table , int row){
Cursor Cursor = mydb.rawQuery("SELECT * FROM "+table+" group by season", null);
Cursor.moveToPosition(row);
String s = Cursor.getString(4);
return s;
}
public Integer shomaresh_field1(String table , String field){
Cursor Cursor=mydb.rawQuery("SELECT * FROM "+table+" group by "+field, null);
int i=Cursor.getCount();
return i ;
}
public String namayesh_field1(String table , int row){
Cursor Cursor = mydb.rawQuery("SELECT * FROM "+table+" group by season", null);
Cursor.moveToPosition(row);
String s = Cursor.getString(4);
return s;
}
public Integer shomaresh_dastan(String table , String seasone){
Cursor Cursor = mydb.rawQuery("SELECT * FROM "+table+" where season='"+seasone+"' group by name", null);
int s = Cursor.getCount();
return s;
}
public Integer shomaresh_dastan1(String table , String seasone){
Cursor Cursor = mydb.rawQuery("SELECT * FROM "+table+" where season='"+seasone+"' group by name", null);
int s = Cursor.getCount();
return s;
}
public String namayesh_dastan (String table , int row , String season ){
Cursor Cursor = mydb.rawQuery("select * from " +table,null);
Cursor.moveToPosition(row);
String save = Cursor.getString(1);
return save;
}
public Integer shomaresh_safhe_dastan (String table , String season , String story){
Cursor Cursor = mydb.rawQuery("select * from "+table+" where season='"+season+"' and name='"+story+"'",null);
int save = Cursor.getCount();
return save;
}
}
کد مربوط ب نمایش فصل ها
public class Season extends ListActivity {
private MyDatabase db;
private String [] Name;
private String [] Teadad;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.season);
db = new MyDatabase(this);
refresher();
setListAdapter(new AA());
}
@Override
protected void onListItemClick(ListView l, View v, int position, long id) {
Intent intent = new Intent(Season.this, Story.class);
intent.putExtra("season", Name[position]);
startActivity(intent);
}
class AA extends ArrayAdapter<String>{
public AA(){
super (Season.this , R.layout.raw_season , Name);
}
@Override
public View getView(int position, View convertView, ViewGroup parent) {
LayoutInflater in = getLayoutInflater();
View row = in.inflate(R.layout.raw_season, parent,false);
TextView name = (TextView) row.findViewById(R.id.txt_season);
TextView teadad = (TextView) row.findViewById(R.id.txt_number_season);
name.setText(Name [position]);
teadad.setText(Teadad [position]);
return (row);
}
}
private void refresher (){
db.open();
int save = db .shomaresh_field("tb1", "season");
Name = new String[save];
Teadad = new String[save];
for (int i = 0; i < save; i++) {
Name[i] = db.namayesh_field("tb1", i);
Teadad[i]=db.shomaresh_dastan("tb1", Name[i].toString())+"";
}
int save1 = db .shomaresh_field1("tb2", "season");
Name = new String[save1];
Teadad = new String[save1];
for (int i = 0; i < save1; i++) {
Name[i] = db.namayesh_field1("tb2", i);
Teadad[i]=db.shomaresh_dastan1("tb2", Name[i].toString())+"";
}
db.close();
}
}
کلا حالا ک موضوع دیتابیس را متوجه شدم البتهبا 1 جدول
حالا 4 تا جدول دارم میخام با کلیک روی باتن های 1 تا 4 فیلدهای جدول 1 تا 4 ب نمایش دربیایند
اما
به این صورت نمایش داده میشن
اینم تصاویر و کدهای نوشته شده
ممنون میشم کمکم کنید
http://8pic.ir/images/qzx7530suoj2jjmtrml3.jpg
http://8pic.ir/images/fshb9ipngep5w3pm80bx.jpg
کد دیتابیس و کوئری های مربوطه
public String namayesh_field(String table , int row){
Cursor Cursor = mydb.rawQuery("SELECT * FROM "+table+" group by season", null);
Cursor.moveToPosition(row);
String s = Cursor.getString(4);
return s;
}
public Integer shomaresh_field1(String table , String field){
Cursor Cursor=mydb.rawQuery("SELECT * FROM "+table+" group by "+field, null);
int i=Cursor.getCount();
return i ;
}
public String namayesh_field1(String table , int row){
Cursor Cursor = mydb.rawQuery("SELECT * FROM "+table+" group by season", null);
Cursor.moveToPosition(row);
String s = Cursor.getString(4);
return s;
}
public Integer shomaresh_dastan(String table , String seasone){
Cursor Cursor = mydb.rawQuery("SELECT * FROM "+table+" where season='"+seasone+"' group by name", null);
int s = Cursor.getCount();
return s;
}
public Integer shomaresh_dastan1(String table , String seasone){
Cursor Cursor = mydb.rawQuery("SELECT * FROM "+table+" where season='"+seasone+"' group by name", null);
int s = Cursor.getCount();
return s;
}
public String namayesh_dastan (String table , int row , String season ){
Cursor Cursor = mydb.rawQuery("select * from " +table,null);
Cursor.moveToPosition(row);
String save = Cursor.getString(1);
return save;
}
public Integer shomaresh_safhe_dastan (String table , String season , String story){
Cursor Cursor = mydb.rawQuery("select * from "+table+" where season='"+season+"' and name='"+story+"'",null);
int save = Cursor.getCount();
return save;
}
}
کد مربوط ب نمایش فصل ها
public class Season extends ListActivity {
private MyDatabase db;
private String [] Name;
private String [] Teadad;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.season);
db = new MyDatabase(this);
refresher();
setListAdapter(new AA());
}
@Override
protected void onListItemClick(ListView l, View v, int position, long id) {
Intent intent = new Intent(Season.this, Story.class);
intent.putExtra("season", Name[position]);
startActivity(intent);
}
class AA extends ArrayAdapter<String>{
public AA(){
super (Season.this , R.layout.raw_season , Name);
}
@Override
public View getView(int position, View convertView, ViewGroup parent) {
LayoutInflater in = getLayoutInflater();
View row = in.inflate(R.layout.raw_season, parent,false);
TextView name = (TextView) row.findViewById(R.id.txt_season);
TextView teadad = (TextView) row.findViewById(R.id.txt_number_season);
name.setText(Name [position]);
teadad.setText(Teadad [position]);
return (row);
}
}
private void refresher (){
db.open();
int save = db .shomaresh_field("tb1", "season");
Name = new String[save];
Teadad = new String[save];
for (int i = 0; i < save; i++) {
Name[i] = db.namayesh_field("tb1", i);
Teadad[i]=db.shomaresh_dastan("tb1", Name[i].toString())+"";
}
int save1 = db .shomaresh_field1("tb2", "season");
Name = new String[save1];
Teadad = new String[save1];
for (int i = 0; i < save1; i++) {
Name[i] = db.namayesh_field1("tb2", i);
Teadad[i]=db.shomaresh_dastan1("tb2", Name[i].toString())+"";
}
db.close();
}
}