4bbDtpB7

1public class DatabaseHelper extends SQLiteOpenHelper {
2public static final String TAG = DatabaseHelper.class.getSimpleName();
3public static final String DATABASE_NAME = "maharshi.db";
4private static final int DATABASE_VERSION = 1;
5public static  String Patient_Table = "patients";
6public final static String Patient_Table_ID = "_id";
7public final static String Patient_Table_Name = "Name";
8public final static String Patient_Table_Image = "Image";
9 private Context myContext;
10
11public DatabaseHelper(Context context) {
12    super(context, DATABASE_NAME, null, DATABASE_VERSION);
13    this.myContext = context;
14}
15
16
17@Override
18public void onCreate(SQLiteDatabase db) {
19    db.execSQL(
20            "CREATE TABLE IF NOT EXISTS " + Patient_Table +
21                    "( "+Patient_Table_ID+" integer primary key AUTOINCREMENT, "+Patient_Table_Name+" text, Gender text, Age varchar, Father text, Mother text, Oc text, Adress varchar, Phone varchar, Mail varchar, Blood varchar, Health text, Height varchar, Weight2 varchar, "+Patient_Table_Image+" BLOB)"
22    );
23
24}
25
26@Override
27public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
28    db.execSQL("DROP TABLE IF EXISTS " + Patient_Table); 
29}
30    public void insertData( String Name, String Gender, String Age, String 
31    Father, String Mother, String Oc, String Adress, String Phone, String 
32    Mail, String Blood, String Health, String Height, String Weight2, byte[] 
33    image){
34    SQLiteDatabase db1 = this.getWritableDatabase();
35    ContentValues contentValues = new ContentValues();
36    contentValues.put(Patient_Table_Name,Name );
37    contentValues.put("Gender",Gender );
38    contentValues.put("Age",Age );
39    contentValues.put("Father",Father );
40    contentValues.put("Mother",Mother );
41    contentValues.put("Oc",Oc );
42    contentValues.put("Adress",Adress );
43    contentValues.put("Phone",Phone );
44    contentValues.put("Mail",Mail );
45    contentValues.put("Blood",Blood );
46    contentValues.put("Health",Health );
47    contentValues.put("Height",Height );
48    contentValues.put("Weight2",Weight2);
49    contentValues.put(Patient_Table_Image,image);
50    db1.insert(Patient_Table, null, contentValues);
51}
52	
53public class MainActivity extends AppCompatActivity {
54Button backup,restore;
55 @Override
56protected void onCreate(Bundle savedInstanceState) {
57super.onCreate(savedInstanceState);
58setContentView(R.layout.activity_main);
59 backup= findViewById(R.id.backup);
60 restore = findViewById(R.id.restore);
61backup.setOnClickListener(new View.OnClickListener() {
62@Override
63public void onClick(View v) {
64}
65});
66restore.setOnClickListener(new View.OnClickListener() {
67@Override
68public void onClick(View v) {
69}
70});
71}