public class Example2Activity extends Activity {
/** Called when the activity is first created. */
DatabaseHelper dbhelper = new DatabaseHelper(this);
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
Cursor cursor = dbhelper.getData();
ImageButton bt1 = (ImageButton)findViewById(R.id.bt1);
bt1.setBackgroundResource(R.drawable.tv_transformq_01);
ImageButton bt2 = (ImageButton)findViewById(R.id.bt2);
bt2.setBackgroundResource(R.drawable.tv_transformq_02);
ImageButton bt3 = (ImageButton)findViewById(R.id.bt3);
bt3.setBackgroundResource(R.drawable.tv_transformq_03);
ImageButton bt4 = (ImageButton) findViewById(R.id.bt4);
bt4.setBackgroundResource(R.drawable.power_selector);
int column = cursor.getColumnIndex("power");
byte[] b = cursor.getBlob(column);
setOperationButton(R.id.bt4,b);
bt4.setBackgroundResource(R.drawable.power_selector);
ImageButton bt5 = (ImageButton)findViewById(R.id.bt5);
bt5.setBackgroundResource(R.drawable.number_1_selector);
int column_5 = cursor.getColumnIndex("done");
byte[] b_5 = cursor.getBlob(column_5);
setOperationButton(R.id.bt5, b_5);
ImageButton bt6 =(ImageButton)findViewById(R.id.bt6);
bt6.setBackgroundResource(R.drawable.number_2_selector);
int column_6 = cursor.getColumnIndex("dtwo");
byte[] b_6 = cursor.getBlob(column_6);
setOperationButton(R.id.bt6, b_6);
ImageButton bt7 =(ImageButton)findViewById(R.id.bt7);
bt7.setBackgroundResource(R.drawable.number_3_selector);
int column_7= cursor.getColumnIndex("dthree");
byte[] b_7 = cursor.getBlob(column_7);
setOperationButton(R.id.bt7, b_7);
ImageButton bt8 =(ImageButton)findViewById(R.id.bt8);
bt8.setBackgroundResource(R.drawable.sound_selector);
int column_8 = cursor.getColumnIndex("mute");
byte[] b_8=cursor.getBlob(column_8);
setOperationButton(R.id.bt8, b_8);
ImageButton bt9 =(ImageButton)findViewById(R.id.bt9);
bt9.setBackgroundResource(R.drawable.number_4_selector);
int column_9= cursor.getColumnIndex("dfour");
byte[] b_9=cursor.getBlob(column_9);
setOperationButton(R.id.bt9, b_9);
ImageButton bt10 =(ImageButton)findViewById(R.id.bt10);
bt10.setBackgroundResource(R.drawable.number_5_selector);
int column_10= cursor.getColumnIndex("dfive");
byte[] b_10=cursor.getBlob(column_10);
setOperationButton(R.id.bt10, b_10);
ImageButton bt11 =(ImageButton)findViewById(R.id.bt11);
bt11.setBackgroundResource(R.drawable.number_6_selector);
int column_11= cursor.getColumnIndex("dsix");
byte[] b_11=cursor.getBlob(column_11);
setOperationButton(R.id.bt11, b_11);
ImageButton bt12 =(ImageButton)findViewById(R.id.bt12);
bt12.setBackgroundResource(R.drawable.p_p_selector);
int column_12= cursor.getColumnIndex("pandp");
byte[] b_12=cursor.getBlob(column_12);
setOperationButton(R.id.bt12, b_12);
ImageButton bt13 =(ImageButton)findViewById(R.id.bt13);
bt13.setBackgroundResource(R.drawable.number_7_selector);
int column_13= cursor.getColumnIndex("dseven");
byte[] b_13=cursor.getBlob(column_13);
setOperationButton(R.id.bt13, b_13);
ImageButton bt14 =(ImageButton)findViewById(R.id.bt14);
bt14.setBackgroundResource(R.drawable.number_8_selector);
int column_14= cursor.getColumnIndex("deight");
byte[] b_14=cursor.getBlob(column_14);
setOperationButton(R.id.bt14, b_14);
ImageButton bt15 =(ImageButton)findViewById(R.id.bt15);
bt15.setBackgroundResource(R.drawable.number_9_selector);
int column_15= cursor.getColumnIndex("dnine");
byte[] b_15=cursor.getBlob(column_15);
setOperationButton(R.id.bt15, b_15);
ImageButton bt16 =(ImageButton)findViewById(R.id.bt16);
bt16.setBackgroundResource(R.drawable.change_selector);
int column_16= cursor.getColumnIndex("arrow");
byte[] b_16=cursor.getBlob(column_16);
setOperationButton(R.id.bt16, b_16);
ImageButton bt17 =(ImageButton)findViewById(R.id.bt17);
bt17.setBackgroundResource(R.drawable.number_0_selector);
int column_17= cursor.getColumnIndex("dzero");
byte[] b_17=cursor.getBlob(column_17);
setOperationButton(R.id.bt17, b_17);
ImageButton bt18 =(ImageButton)findViewById(R.id.bt18);
bt18.setBackgroundResource(R.drawable.change_turn_selector);
int column_18= cursor.getColumnIndex("keyinput");
byte[] b_18=cursor.getBlob(column_18);
setOperationButton(R.id.bt18, b_18);
ImageButton bt19 = (ImageButton)findViewById(R.id.bt19);
bt19.setBackgroundResource(R.drawable.tv_transformq_19);
ImageButton bt20 =(ImageButton)findViewById(R.id.bt20);
bt20.setBackgroundResource(R.drawable.change_av_tv_selector);
int column_20= cursor.getColumnIndex("keyreverse");
byte[] b_20=cursor.getBlob(column_20);
setOperationButton(R.id.bt20, b_20);
ImageButton bt21 =(ImageButton)findViewById(R.id.bt21);
bt21.setBackgroundResource(R.drawable.change_ok_selector);
int column_21= cursor.getColumnIndex("keyok");
byte[] b_21=cursor.getBlob(column_21);
setOperationButton(R.id.bt21, b_21);
ImageButton bt22 =(ImageButton)findViewById(R.id.bt22);
bt22.setBackgroundResource(R.drawable.change_direction_selector);
int column_22= cursor.getColumnIndex("keydirection");
byte[] b_22=cursor.getBlob(column_22);
setOperationButton(R.id.bt22, b_22);
ImageButton bt23 =(ImageButton)findViewById(R.id.bt23);
bt23.setBackgroundResource(R.drawable.change_menu_selector);
int column_23= cursor.getColumnIndex("keymenu");
byte[] b_23=cursor.getBlob(column_23);
setOperationButton(R.id.bt23, b_23);
ImageButton bt24 =(ImageButton)findViewById(R.id.bt24);
bt24.setBackgroundResource(R.drawable.change_back_selector);
int column_24= cursor.getColumnIndex("keyback");
byte[] b_24=cursor.getBlob(column_24);
setOperationButton(R.id.bt24, b_24);
ImageButton bt25 =(ImageButton)findViewById(R.id.bt25);
bt25.setBackgroundResource(R.drawable.change_exit_selector);
int column_25= cursor.getColumnIndex("keyexit");
byte[] b_25=cursor.getBlob(column_25);
setOperationButton(R.id.bt25, b_25);
}
private void setOperationButton(int resId, byte[] action) {
ImageButton imb = (ImageButton)findViewById(resId);
imb.setOnClickListener(new OnclickAction(action));
}
@Override
protected void onDestroy() {
super.onDestroy();
if(dbhelper!=null){
dbhelper.close();
}
}
private class OnclickAction implements OnClickListener{
final byte[] action;
public OnclickAction(byte[] action) {
this.action = action;
}
public void onClick(View v) {
dealAction(action);
}
private void dealAction(byte[] action2) {
String s = new String(action,0,action2.length,Charset.forName("utf-8"));
byte[] array =s.getBytes(Charset.forName("utf-8"));
System.out.println(array[0]+" ");
Toast.makeText(Example2Activity.this, array[0]+"",Toast.LENGTH_LONG).show();
}
}
/** Called when the activity is first created. */
DatabaseHelper dbhelper = new DatabaseHelper(this);
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
Cursor cursor = dbhelper.getData();
ImageButton bt1 = (ImageButton)findViewById(R.id.bt1);
bt1.setBackgroundResource(R.drawable.tv_transformq_01);
ImageButton bt2 = (ImageButton)findViewById(R.id.bt2);
bt2.setBackgroundResource(R.drawable.tv_transformq_02);
ImageButton bt3 = (ImageButton)findViewById(R.id.bt3);
bt3.setBackgroundResource(R.drawable.tv_transformq_03);
ImageButton bt4 = (ImageButton) findViewById(R.id.bt4);
bt4.setBackgroundResource(R.drawable.power_selector);
int column = cursor.getColumnIndex("power");
byte[] b = cursor.getBlob(column);
setOperationButton(R.id.bt4,b);
bt4.setBackgroundResource(R.drawable.power_selector);
ImageButton bt5 = (ImageButton)findViewById(R.id.bt5);
bt5.setBackgroundResource(R.drawable.number_1_selector);
int column_5 = cursor.getColumnIndex("done");
byte[] b_5 = cursor.getBlob(column_5);
setOperationButton(R.id.bt5, b_5);
ImageButton bt6 =(ImageButton)findViewById(R.id.bt6);
bt6.setBackgroundResource(R.drawable.number_2_selector);
int column_6 = cursor.getColumnIndex("dtwo");
byte[] b_6 = cursor.getBlob(column_6);
setOperationButton(R.id.bt6, b_6);
ImageButton bt7 =(ImageButton)findViewById(R.id.bt7);
bt7.setBackgroundResource(R.drawable.number_3_selector);
int column_7= cursor.getColumnIndex("dthree");
byte[] b_7 = cursor.getBlob(column_7);
setOperationButton(R.id.bt7, b_7);
ImageButton bt8 =(ImageButton)findViewById(R.id.bt8);
bt8.setBackgroundResource(R.drawable.sound_selector);
int column_8 = cursor.getColumnIndex("mute");
byte[] b_8=cursor.getBlob(column_8);
setOperationButton(R.id.bt8, b_8);
ImageButton bt9 =(ImageButton)findViewById(R.id.bt9);
bt9.setBackgroundResource(R.drawable.number_4_selector);
int column_9= cursor.getColumnIndex("dfour");
byte[] b_9=cursor.getBlob(column_9);
setOperationButton(R.id.bt9, b_9);
ImageButton bt10 =(ImageButton)findViewById(R.id.bt10);
bt10.setBackgroundResource(R.drawable.number_5_selector);
int column_10= cursor.getColumnIndex("dfive");
byte[] b_10=cursor.getBlob(column_10);
setOperationButton(R.id.bt10, b_10);
ImageButton bt11 =(ImageButton)findViewById(R.id.bt11);
bt11.setBackgroundResource(R.drawable.number_6_selector);
int column_11= cursor.getColumnIndex("dsix");
byte[] b_11=cursor.getBlob(column_11);
setOperationButton(R.id.bt11, b_11);
ImageButton bt12 =(ImageButton)findViewById(R.id.bt12);
bt12.setBackgroundResource(R.drawable.p_p_selector);
int column_12= cursor.getColumnIndex("pandp");
byte[] b_12=cursor.getBlob(column_12);
setOperationButton(R.id.bt12, b_12);
ImageButton bt13 =(ImageButton)findViewById(R.id.bt13);
bt13.setBackgroundResource(R.drawable.number_7_selector);
int column_13= cursor.getColumnIndex("dseven");
byte[] b_13=cursor.getBlob(column_13);
setOperationButton(R.id.bt13, b_13);
ImageButton bt14 =(ImageButton)findViewById(R.id.bt14);
bt14.setBackgroundResource(R.drawable.number_8_selector);
int column_14= cursor.getColumnIndex("deight");
byte[] b_14=cursor.getBlob(column_14);
setOperationButton(R.id.bt14, b_14);
ImageButton bt15 =(ImageButton)findViewById(R.id.bt15);
bt15.setBackgroundResource(R.drawable.number_9_selector);
int column_15= cursor.getColumnIndex("dnine");
byte[] b_15=cursor.getBlob(column_15);
setOperationButton(R.id.bt15, b_15);
ImageButton bt16 =(ImageButton)findViewById(R.id.bt16);
bt16.setBackgroundResource(R.drawable.change_selector);
int column_16= cursor.getColumnIndex("arrow");
byte[] b_16=cursor.getBlob(column_16);
setOperationButton(R.id.bt16, b_16);
ImageButton bt17 =(ImageButton)findViewById(R.id.bt17);
bt17.setBackgroundResource(R.drawable.number_0_selector);
int column_17= cursor.getColumnIndex("dzero");
byte[] b_17=cursor.getBlob(column_17);
setOperationButton(R.id.bt17, b_17);
ImageButton bt18 =(ImageButton)findViewById(R.id.bt18);
bt18.setBackgroundResource(R.drawable.change_turn_selector);
int column_18= cursor.getColumnIndex("keyinput");
byte[] b_18=cursor.getBlob(column_18);
setOperationButton(R.id.bt18, b_18);
ImageButton bt19 = (ImageButton)findViewById(R.id.bt19);
bt19.setBackgroundResource(R.drawable.tv_transformq_19);
ImageButton bt20 =(ImageButton)findViewById(R.id.bt20);
bt20.setBackgroundResource(R.drawable.change_av_tv_selector);
int column_20= cursor.getColumnIndex("keyreverse");
byte[] b_20=cursor.getBlob(column_20);
setOperationButton(R.id.bt20, b_20);
ImageButton bt21 =(ImageButton)findViewById(R.id.bt21);
bt21.setBackgroundResource(R.drawable.change_ok_selector);
int column_21= cursor.getColumnIndex("keyok");
byte[] b_21=cursor.getBlob(column_21);
setOperationButton(R.id.bt21, b_21);
ImageButton bt22 =(ImageButton)findViewById(R.id.bt22);
bt22.setBackgroundResource(R.drawable.change_direction_selector);
int column_22= cursor.getColumnIndex("keydirection");
byte[] b_22=cursor.getBlob(column_22);
setOperationButton(R.id.bt22, b_22);
ImageButton bt23 =(ImageButton)findViewById(R.id.bt23);
bt23.setBackgroundResource(R.drawable.change_menu_selector);
int column_23= cursor.getColumnIndex("keymenu");
byte[] b_23=cursor.getBlob(column_23);
setOperationButton(R.id.bt23, b_23);
ImageButton bt24 =(ImageButton)findViewById(R.id.bt24);
bt24.setBackgroundResource(R.drawable.change_back_selector);
int column_24= cursor.getColumnIndex("keyback");
byte[] b_24=cursor.getBlob(column_24);
setOperationButton(R.id.bt24, b_24);
ImageButton bt25 =(ImageButton)findViewById(R.id.bt25);
bt25.setBackgroundResource(R.drawable.change_exit_selector);
int column_25= cursor.getColumnIndex("keyexit");
byte[] b_25=cursor.getBlob(column_25);
setOperationButton(R.id.bt25, b_25);
}
private void setOperationButton(int resId, byte[] action) {
ImageButton imb = (ImageButton)findViewById(resId);
imb.setOnClickListener(new OnclickAction(action));
}
@Override
protected void onDestroy() {
super.onDestroy();
if(dbhelper!=null){
dbhelper.close();
}
}
private class OnclickAction implements OnClickListener{
final byte[] action;
public OnclickAction(byte[] action) {
this.action = action;
}
public void onClick(View v) {
dealAction(action);
}
private void dealAction(byte[] action2) {
String s = new String(action,0,action2.length,Charset.forName("utf-8"));
byte[] array =s.getBytes(Charset.forName("utf-8"));
System.out.println(array[0]+" ");
Toast.makeText(Example2Activity.this, array[0]+"",Toast.LENGTH_LONG).show();
}
}