A simple database application that I wrote using a Text file in Java programming language that I called employee's record system demonstrates the concepts of CRUD (Create, Read, Update, and Delete) in the database management system.

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me at the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.

My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.

My mobile number here in the Philippines is 09173084360.

Please subscribe to my channel  https://www.youtube.com/channel/UCOs-lpOoIeJoh6gpJthPoGg

=================================================



Want to support my channel?

GCash Account

Jake Pomperada

09173084360



Paypal

https://paypal.me/jakerpomperada



Patreon

https://www.patreon.com/jakerpomperada



Thank you very much for your support.

Program Listing



Main.java


/* Main.java
   Author : Jake Rodriguez Pomperada, MAED-IT, MIT
   Date   : June 12, 2022  Sunday  11:32 AM
   Tool   : Java SDK, Employee's Record System in Java
   Website: www.jakerpomperada.com and www.jakerpomperada.blogspot.com
   Email : jakerpomperada@gmail.com
   Bacolod City, Negros Occidental Philippines
 */

package com.company;

import java.io.*;
import java.util.ArrayList;
import java.util.Scanner;


public class Main {

    public  static  String filename="database.txt";


    // main method
    public static void main(String[] args) {


      createNewFileWithHeaders();
        displayServices();


    }

    // methods

    public static void createNewFileWithHeaders(){
        File database=new File(filename);

        try {

            if( database.createNewFile()==true){

                try {
                    FileWriter writer=new FileWriter(filename,true);
                    writer.append("User ID"+","+"User Name"+","+","+"Job"+","+"Address");
                    writer.append("\n");
                    writer.close();
                    System.out.println("file created succefully!");
                } catch (IOException e) {
                    System.out.println(e);
                }

            }
            else {

            }

        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    public static void createAddNewPerson( Scanner input){
        System.out.println("Enter Employee's ID :  ");
        String id=input.next();
        System.out.println("Enter your name :");
        String name=input.next();
        System.out.println("Enter your job : ");
        String job=input.next();
        System.out.println("Enter your address");
        String address=input.next();
        Person person=new Person(id,name,job,address);

        try {
            FileWriter writer=new FileWriter(filename,true);
            writer.append(person.getUserData());
            writer.append("\n");
            writer.close();
            System.out.println("person added succefully!");
        } catch (IOException e) {
            System.out.println(e);
        }

    }

    public static void  deleteRecordById(ArrayList<String> arrayList,Scanner input){
        System.out.println("enter any id or word to delete a record");
        String searchKey=input.next();
        String line;
        try {

            BufferedReader reader=new BufferedReader(new FileReader(filename));
            while ((line=reader.readLine())!=null){
                if(line.contains(searchKey)){
                    System.out.println(line);
                    continue;
                }else {
                    arrayList.add(line);
                }



            }

        }catch (Exception e){

        }
        try {
            FileWriter writer=new FileWriter(filename);
            for (int i=0;i<arrayList.size();i++){
                writer.append( arrayList.get(i));
                writer.append("\n");


            }
            writer.close();

        }catch (Exception e){
            System.out.println(e);
        }finally {
            System.out.println("done!");
        }}

    public static void updateRecord(ArrayList<String>arrayList,Scanner input){
        try {
            BufferedReader reader=new BufferedReader(new FileReader(filename));
            System.out.println("please enter any key to update the record");
            String searchKey=input.next();
            String line;
            while ((line=reader.readLine())!=null){
                if(   line.contains(searchKey)){
                    System.out.println("enter the text you want to change");
                    String oldValue=input.next();
                    System.out.println("enter the new text you want to change");
                    String newValue=input.next();
                    arrayList.add(line.replace(oldValue,newValue));


                }else {
                    arrayList.add(line);
                }

            }


        }catch (Exception e){
            System.out.println(e);
        }

        try {
            FileWriter writer=new FileWriter(filename);
            for(int i=0;i<arrayList.size();i++){
                writer.append(arrayList.get(i));
                writer.append("\n");
            }
            writer.close();
        }catch (Exception e){
            System.out.println(e);
        }

    }
    public static void getUserById(Scanner input){
        try {
            BufferedReader reader=new BufferedReader(new FileReader(filename));
            System.out.println("please enter any key to get the record");
            String searchKey=input.next();
            String line;
            while ((line=reader.readLine())!=null){
                if(   line.contains(searchKey)){
                    System.out.println(line);

                }

            }


        }catch (Exception e){
            System.out.println(e);
        }


    }
    public static void getAllPersons(){

        try {
            BufferedReader reader=new BufferedReader(new FileReader(filename));


            String line;
            while ((line=reader.readLine())!=null){

                System.out.println(line);

            }

        }catch (Exception e){
            System.out.println(e);
        }





    }



    public static void  displayServices(){
        Scanner input = new Scanner(System.in).useDelimiter("\n");

        while(true){
            ArrayList<String> arrayList=new ArrayList<String>();

            System.out.println("====================================================");
            System.out.println("Employee's Record System in Java Using Text File" +
                    "");
            System.out.println("====================================================");
            System.out.println("[1] Add New Employees Record");
            System.out.println("[2] Delete Employees Record");
            System.out.println("[3] Update Employees Record");
            System.out.println("[4] View Employees Record");
            System.out.println("[5] Quit Program");
            System.out.println("====================================================");
            System.out.print("Select a Number : ");
            int x=  input.nextInt();
            if(x==5) {
                System.out.println();
                System.out.print("Thank you for using this program.");
                System.out.println();
                break;
            }
            else if(x==1){
                createAddNewPerson(input);
            }
            else  if(x==2){

                deleteRecordById(arrayList,input);
            }
            else  if(x==3){
                updateRecord(arrayList,input);
            }
            else if(x==4){
                getUserById(input);

            }
             else {
                System.out.println("please enter a vaild number");
            }




        }
    }





}

Person.java
/* Main.java
   Author : Jake Rodriguez Pomperada, MAED-IT, MIT
   Date   : June 12, 2022  Sunday  11:32 AM
   Tool   : Java SDK, Employee's Record System in Java
   Website: www.jakerpomperada.com and www.jakerpomperada.blogspot.com
   Email : jakerpomperada@gmail.com
   Bacolod City, Negros Occidental Philippines
 */

package com.company;

public class Person {
    // attributes
    public String id;
    public String name;
    public  String job;
    public   String address;

    Person(String id , String name,String job, String address){
        this.id=id;
        this.name=name;
        this.job=job;
        this.address=address;

    }

    public  String getUserData(){

return   id+"," + name +","  + ","+job+"," +address;
    }


    // methods



}

database.txt
567,Jacob Samuel F. Pomperada,,Data Scientist,Eroreco, Bacolod City, Negros Occidental
8912,Lydia R. Pomperada,,Social Science Teacher,Alijis, Bacolod City, Negros Occidental
345,Virgilio V. Pomperada,,Agriculture Teacher,Alijis, Bacolod City, Negros Occidental
983,Leslie Vinky P. Pepito,,Electronics Engineer,Alijis, Bacolod City, Negros Occidental




Leave a Reply

Your email address will not be published.