kk匡的日記&學習筆記

mvc.controller
mvc.model
mvc.object
mvc.objectDAO
MyDBHelper

ControllerActivity

public class ControllerActivity extends AppCompatActivity {

    private MemberDAO memberDAO;
    private MemberObject memberObject;
    private MemberModel memberModel;
    
    private ArrayList<MemberObject> p_arrMemberObject = new ArrayList<MemberObject>();
    
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_member_panel);
        
        memberDAO = new MemberDAO(this);
        memberObject = new MemberObject();
        memberModel = new MemberModel();
        
        initView();
        readInfo();
    }
    
    public void initView() {
        p_edstrUserName = (EditText) findViewById(R.id.edstrUserName);
        p_btnUserInfoSubmit = (Button) findViewById(R.id.btnUserInfoSubmit);
    }
    
    public void readInfo() {
        p_arrMemberObject = memberDAO.p_arrMemberObject;

        int p_mListSize;
        while (p_arrMemberObject.size() > p_mListSize) {
            show(p_arrMemberObject.getP_strUserName());
            p_mListSize++;
        }
    }
}

MemberObject

public class MemberObject {
    private static String p_strUserName;

    public void  MemberObject() {
        // Null
    }

    public void setP_strUserName(String p_strUserName) {
        this.p_strUserName = p_strUserName;
    }

    public String getP_strUserName() {
        return p_strUserName;
    }
}

MemberDAO

public class MemberDAO {

    private MyDBHelper myDBHelper;
    private SQLiteDatabase db;
    private MemberObject memberObject;
    private static ArrayList<MemberObject> p_arrMemberObject = new ArrayList<MemberObject>();

    public MemberDAO(Context context) {
        myDBHelper =  new MyDBHelper(context);
    }

    public void insert() {
        db = myDBHelper.getWritableDatabase();
        String sql = "INSERT OR REPLACE INTO memberTable (userName) VALUES(?)";
        SQLiteStatement st =db.compileStatement(sql);
        st.bindString(1, memberObject.getP_strUserName());
        st.executeInsert();
    }

    public void readInfo() {
        db = myDBHelper.getWritableDatabase();
        String sql = "SELECT userName FROM memberTable ORDER BY _id DESC LIMIT 1;";
        Cursor c = db.rawQuery(sql, null);
        while (c.moveToNext()) {
        memberObject = new MemberObject();
        memberObject.setP_strUserName(c.getString(c.getColumnIndex("userName")));
        p_arrMemberObject.add(memberObject);
        }
    }
}

MemberModel

public class MemberModel {

    public void MemberModel() {
    
    }
    
    public void doSometing() {
    
    }
}