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
