Guest User

Untitled

a guest
Apr 23rd, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.65 KB | None | 0 0
  1. SQLiteDatabse mydatabase = openOrCreateDatabase("your database name",MODE_PRIVATE,null);
  2.  
  3. openDatabase(String path, SQLiteDatabase.CursorFactory factory, int flags, DatabaseErrorHandler errorHandler)
  4.  
  5. openDatabase(String path, SQLiteDatabase.CursorFactory factory, int flags)
  6.  
  7. openOrCreateDatabase(String path, SQLiteDatabase.CursorFactory factory)
  8.  
  9. openOrCreateDatabase(File file, SQLiteDatabase.CursorFactory factory)
  10.  
  11. mydatabase.execSQL("CREATE TABLE IF NOT EXISTS TutorialsPoint(Username VARCHAR,Password VARCHAR);");
  12. mydatabase.execSQL("INSERT INTO TutorialsPoint VALUES('admin','admin');");
  13.  
  14. Cursor resultSet = mydatbase.rawQuery("Select * from TutorialsPoint",null);
  15. resultSet.moveToFirst();
  16. String username = resultSet.getString(1);
  17. String password = resultSet.getString(2);
  18.  
  19. public class DBHelper extends SQLiteOpenHelper {
  20. public DBHelper(){
  21. super(context,DATABASE_NAME,null,1);
  22. }
  23. public void onCreate(SQLiteDatabase db) {}
  24. public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {}
  25. }
  26.  
  27. public class MainActivity extends AppCompatActivity {
  28. Button b1,b2,b3,b4;
  29. SQLiteDatabase db;
  30. EditText n,i;
  31. @Override
  32. protected void onCreate(Bundle savedInstanceState) {
  33. super.onCreate(savedInstanceState);
  34. setContentView(R.layout.activity_main);
  35. b1=(Button)findViewById(R.id.button);
  36. b2=(Button)findViewById(R.id.button3);
  37. b3=(Button)findViewById(R.id.button4);
  38. b4=(Button)findViewById(R.id.button5);
  39. n=(EditText)findViewById(R.id.editText);
  40. i=(EditText)findViewById(R.id.editText4);
  41. db = openOrCreateDatabase("emp", Context.MODE_PRIVATE, null);
  42. db.execSQL("CREATE TABLE IF NOT EXISTS student1(name VARCHAR, rollno number)");
  43. b1.setOnClickListener(new View.OnClickListener() {
  44. @Override
  45. public void onClick(View view) {
  46. db.execSQL("INSERT INTO student1 VALUES('" + n.getText() + "'," + i.getText() + ");");
  47.  
  48. }
  49. });
  50.  
  51. b2.setOnClickListener(new View.OnClickListener() {
  52. @Override
  53. public void onClick(View view) {
  54. //Toast.makeText(MainActivity.this, "hey", Toast.LENGTH_SHORT).show();
  55. db=openOrCreateDatabase("emp",Context.MODE_PRIVATE,null);
  56. Cursor c=db.rawQuery("SELECT * FROM student1",null);
  57. if(c.getCount()==0)
  58. {
  59. Toast.makeText(MainActivity.this, "Error no records found", Toast.LENGTH_SHORT).show();
  60. }
  61. StringBuffer buffer=new StringBuffer();
  62. while(c.moveToNext())
  63. {
  64. buffer.append("Name : "+c.getString(0)+"n");
  65. buffer.append("RollNo:"+c.getString(1)+"n");
  66. }
  67.  
  68. Toast.makeText(MainActivity.this, buffer, Toast.LENGTH_SHORT).show();
  69.  
  70. }
  71. });
  72.  
  73. b3.setOnClickListener(new View.OnClickListener() {
  74. @Override
  75. public void onClick(View view) {
  76. try {
  77. db.execSQL("DELETE FROM student1 WHERE name='" + n.getText().toString() +"';");
  78. }
  79. catch(Exception e){
  80. Toast.makeText(getApplicationContext(),"Crash",Toast.LENGTH_SHORT).show();
  81. e.printStackTrace();
  82. }
  83. }
  84. });
  85.  
  86. b4.setOnClickListener(new View.OnClickListener() {
  87. @Override
  88. public void onClick(View view) {
  89. db.execSQL("UPDATE student1 SET name='"+n.getText().toString()+"' where name='heyeee'");
  90. }
  91. });
  92.  
  93.  
  94.  
  95. }
  96.  
  97.  
  98. }
Add Comment
Please, Sign In to add comment