80,351
社区成员
发帖
与我相关
我的任务
分享
public class Fragment3 extends Fragment{
private final String TABLENAME="Money_TB";
private EditText ET_in,ET_out;
private Button BT_in,BT_out,BT_re;
private SQLiteDatabase db;
private TextView Money;
DBOpenHelper helper;
public Fragment3() {
}
@Override
public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {
// TODO Auto-generated method stub
return inflater.inflate(R.layout.tab03,container,false);
}
@Override
public void onActivityCreated(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onActivityCreated(savedInstanceState);
Money=(TextView)getActivity().findViewById(R.id.money2);
int num=Integer.parseInt(Money.getText().toString());
ET_in=(EditText)getActivity().findViewById(R.id.moneyin);
ET_out=(EditText)getActivity().findViewById(R.id.moneyout);
helper = new DBOpenHelper(getActivity());
BT_in=(Button)getActivity().findViewById(R.id.moneyinb);
BT_out=(Button)getActivity().findViewById(R.id.moneyoutb);
BT_re=(Button)getActivity().findViewById(R.id.referesh);
BT_re.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
db = helper.getWritableDatabase();
Refresh();
}
private void Refresh() {
// TODO Auto-generated method stub
ContentValues values=new ContentValues();
int money1=10000;
values.put("money", money1);
db.update(TABLENAME, values, null, null);
}
});
BT_in.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
ET_in.setText("123");
}
private void In() {
// TODO Auto-generated method stub
ContentValues values=new ContentValues();
String ETIN=ET_in.getText().toString();
int num=Integer.parseInt(ETIN);
values.put("money",num);
db.insert(TABLENAME, null, values);
Cursor cursor= db.query("diary",null,null,null,null,null,null);
Money.setText(num);
ET_in.setText(" ");
}
});
BT_out.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View arg0) {
// TODO Auto-generated method stub
db = helper.getWritableDatabase();
Out();
}
private void Out() {
// TODO Auto-generated method stub
}
});
}
}