weixin_44307071 2019-06-11 16:12
浏览 555

用eclipse写安卓的记事本,如何实现在listview中显示我写的SQLite?新手求大神帮忙......

public class InputActivity extends Activity {
    MySQLiteHelper dbwjy;
     Button bt_save;
     EditText et_1;
     EditText et_2;
    @Override

    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_input);
        initListener();
    }
    public void initListener() {
        dbwjy=new MySQLiteHelper(this);
         SQLiteDatabase db = dbwjy.getReadableDatabase();
            et_1= (EditText)findViewById(R.id.et1);
            et_2 =(EditText) findViewById(R.id.et2);
            bt_save = (Button)findViewById(R.id.bt_save);
            bt_save.setOnClickListener(new View.OnClickListener(){
               public void onClick(View v) {
                    SQLiteDatabase db = dbwjy.getWritableDatabase();
                    ContentValues values = new ContentValues();
                    String title=et_1.getText().toString();
                    String content=et_2.getText().toString();
                    values.put(MySQLiteHelper.TITLE,title);
                    values.put(MySQLiteHelper.CONTENT,content);
                    db.insert(MySQLiteHelper.TABLE,null,values);
                    Toast.makeText(InputActivity.this,"保存成功",Toast.LENGTH_LONG).show();
                    Intent intent = new Intent(InputActivity.this,NotebookActivity.class);
                    startActivity(intent);
                    db.close();
               }
            });
}
}
public class main extends Activity {
    OnClickListener listener1=null;
    Button button1;
    public void initListener() {
        listener1=new OnClickListener() {

                public void onClick(View v) {
                    setTitle("记事本");
                    Intent intent1=new Intent(main.this,NotebookActivity.class);
                    startActivity(intent1);
                }
            };  
    }

    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        initListener();
        button1=(Button)findViewById(R.id.button1);
        button1.setOnClickListener(listener1);

    }
}


```public class MainActivity extends Activity {
    OnClickListener listener1 = null;
    OnClickListener listener2 =null;
    Button bt_ok;
    Button bt_cancel;
    EditText et1, et2;
    String username,password;
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        initListener();
        bt_ok = (Button) findViewById(R.id.bt_ok);
        bt_ok.setOnClickListener(listener1);
        bt_cancel=(Button)findViewById(R.id.bt_cancel);
        bt_cancel.setOnClickListener(listener2);

    }

    public void initListener() {
        listener1 = new OnClickListener() {
            public void onClick(View v) {
                setTitle("登录");
                et1= (EditText) findViewById(R.id.editText1);
                et2= (EditText) findViewById(R.id.editText2);
                username = et1.getText().toString();
                password = et2.getText().toString();
                if (username.equalsIgnoreCase("admin")&&password.equalsIgnoreCase("666")) {
                    Toast.makeText(MainActivity.this,"登陆成功", Toast.LENGTH_SHORT).show();
                    Intent intent1=new Intent(MainActivity.this,main.class);
                    startActivity(intent1);
                } else {
                    Toast.makeText(MainActivity.this,"密码错误请重试", Toast.LENGTH_SHORT).show();
                }
            }   
            };
            listener2=new OnClickListener(){
                public void onClick(View v) {
                    finish();

    }
};
    }
}

> ```

public class MySQLiteHelper extends SQLiteOpenHelper{
public static final String TABLE = "notes";
public static final String ID = "_id";
public static final String TITLE ="title";
public static final String CONTENT = "content";

public MySQLiteHelper(Context context) {
    super(context,"notepad.db",null,1);
}

@Override
public void onCreate(SQLiteDatabase db) {
    String sql = "CREATE TABLE "+TABLE+"( "+ID+
            " INTEGER PRIMARY KEY AUTOINCREMENT, "+
            TITLE +" VARCHAR(30) ,"+
            CONTENT + " TEXT , )";
    db.execSQL(sql);
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}

}```

public class NotebookActivity extends Activity {
private Cursor listItemCursor = null;
MySQLiteHelper dbwjy;
Button button_add;
OnClickListener listener1 = null;
private ListView listview;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_notebook);
initListener();
button_add=(Button)findViewById(R.id.button_add);
button_add.setOnClickListener(listener1);
listview=(ListView)findViewById(R.id.listview);

}
public void initListener() {    
        listener1=new OnClickListener() {

            public void onClick(View v) {
                setTitle("记事本");
                Intent intent1=new Intent(NotebookActivity.this,InputActivity.class);
                startActivity(intent1);
            }
        };


}

}

```public class Values {
private Integer id;
private String title;
private String content;
public Integer getId() {
return id;
}

public void setId(Integer id) {
    this.id = id;
}

public String getTitle() {
    return title;
}

public void setTitle(String title) {
    this.title = title;
}

public String getContent() {
    return content;
}

public void setContent(String content) {
    this.content = content;
}


@Override
public String toString() {
    return "Values{" +
            "id=" + id +
            ", title='" + title + '\'' +
            ", content='" + content + '\'' +  '}';
}

}

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 有关区间dp的问题求解
    • ¥15 多电路系统共用电源的串扰问题
    • ¥15 slam rangenet++配置
    • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
    • ¥15 对于相关问题的求解与代码
    • ¥15 ubuntu子系统密码忘记
    • ¥15 信号傅里叶变换在matlab上遇到的小问题请求帮助
    • ¥15 保护模式-系统加载-段寄存器
    • ¥15 电脑桌面设定一个区域禁止鼠标操作
    • ¥15 求NPF226060磁芯的详细资料