Skip to content

This Android app, built with SQLite, facilitates student data management, allowing users to insert, display, and delete student records in a local database. Features a user-friendly interface and basic CRUD operations.

Notifications You must be signed in to change notification settings

Rudy9025/Database-Connectivity-SQLite-Android-App

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 

Repository files navigation

Database Connectivity SQLite-Android-App

This Project is a foundation for managing student information within a mobile application. Users can add new student records, view existing records, and delete records as needed. This app utilizes SQLite as the embedded database to store and manage student information.

Design

Design

Project Components

  1. Database Helper Class (MyDB.java):

    • Manages database creation and upgrades.
    • Provides methods for inserting, displaying, and deleting student data.
  2. Main Activity Class (MainActivity.java):

    • Handles user interactions and communicates with the database helper class.
    • Includes buttons for inserting, displaying, and deleting data, and EditText fields for student ID and name.
  3. XML Layout File (activity_main.xml):

    • Defines the layout of the main activity.
    • Includes UI components such as TextView, EditText, and Button.

Features Used

  • SQLite Database: Embedded database for efficient data storage.
  • Android UI Components: Utilizes EditText, TextView, and Button for a user-friendly interface.
  • Android Toast: Provides feedback to users through toast messages.
  • ConstraintLayout: Responsive and flexible UI layout.
  • Database CRUD Operations: Allows users to manage student records.

Usage

  1. Insert Data:

    • Enter student ID and name.
    • Click the "Insert to DB" button.
  2. Display Data:

    • Click the "Display DB" button to view existing records.
  3. Delete Data:

    • Enter the student ID to be deleted.
    • Click the "Delete from DB" button.

How to Run

  • Open the project in Android Studio.
  • Run the app on an Android emulator or device.

Contributing

Contributions are welcome! Feel free to open issues or submit pull requests.

License

This project is licensed under the MIT License.

About

This Android app, built with SQLite, facilitates student data management, allowing users to insert, display, and delete student records in a local database. Features a user-friendly interface and basic CRUD operations.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages