Steps:
1.
Create
a Program.java and type the codes
below:
class Program
{
public static void main(String[] args)
{
EmployeesModel
EmployeeModel = new
EmployeesModel(MSAccessDB.Connect());
EmployeesView
EmployeeView = new
EmployeesView(EmployeeModel);
EmployeesController EmployeeController = new
EmployeesController(EmployeeModel, EmployeeView);
}
}
2.
Create
PersonsModel.java and type the codes
below:
class PersonsModel
{
private String name;
private String address;
public String getName() { return
name; }
public void
setName(String name) { this.name = name; }
public String getAddress() { return
address; }
public void
setAddress(String address) { this.address =
address; }
public PersonsModel()
{
setName("Mario Silvano");
setAddress("Cebu City");
}
public String toString()
{
return "\nName:
" + getName() +
"\nAddress:" + getAddress();
}
}
3.
Create
EmployeesModel.java and type the
codes below:
import java.sql.*;
import java.io.*;
class EmployeesModel
extends PersonsModel{
private int id;
Connection db;
public int getId(){return id;}
public void setId(int
id){this.id=id;}
public EmployeesModel(){ }
public EmployeesModel(Connection db){
this.db=db;
}
public boolean delete(int
id){
String
sql="DELETE FROM Employees WHERE id="+id;
return MSAccessDB.Delete(sql,db);
}
public boolean isFound(int
id){
String
sql="SELECT * FROM Employees WHERE id="+id;
ResultSet
rs = MSAccessDB.Search(sql,db);
boolean found=false;
try{
while(rs.next()){found=true;}
}catch(Exception ex){ex.printStackTrace();}
return found;
}
public String toString(){
return "\nID="+getId()+super.toString();
}
}
4.
Create
EmployeesView.java and type the
codes below:
import java.util.*;
class EmployeesView{
EmployeesModel
EmployeeModel;
public EmployeesModel getEmployeeModel(){
return
EmployeeModel;
}
public void
setEmployeeModel(EmployeesModel EmployeeModel){
this.EmployeeModel=EmployeeModel;
}
public EmployeesView(){}
public EmployeesView(EmployeesModel EmployeeModel){
setEmployeeModel(EmployeeModel);
}
public void menu(){
Console.out.println("Menu-----");
Console.out.println("[4]Delete");
Console.out.println("[5]Quit");
Console.out.print("Select
Menu[1-5]: ");
}
public void
id(){Console.out.print("Input
ID:");}
public void
deletedSuccessfully(){Console.out.println("Deleted Successfully...");}
public void
errMsg(){Console.out.println("Error Encountered...");}
public void
notFoundMsg(){Console.out.println("Not Found...");}
}
5.
Create
EmployeesController.java and type
the codes below:
class EmployeesController
{
private EmployeesModel EmployeeModel;
private EmployeesView EmployeeView;
private int option;
public int
getOption() { return option; }
public EmployeesModel getEmployeeModel()
{
return EmployeeModel;
}
public void
setEmployeeModel(EmployeesModel EmployeeModel)
{
this.EmployeeModel = EmployeeModel;
}
public EmployeesView getEmployeeView()
{
return EmployeeView;
}
public void
setEmployeeView(EmployeesView EmployeeView)
{
this.EmployeeView = EmployeeView;
}
public void
setOption(int option) { this.option = option; }
public EmployeesController() { }
public EmployeesController(EmployeesModel
EmployeeModel, EmployeesView EmployeeView)
{
setEmployeeModel(EmployeeModel);
setEmployeeView(EmployeeView);
MenuUI();
}
private void
MenuUI(){
do{
EmployeeView.menu();
setOption(Console.in.readIntegerInput());
switch(getOption()){
case 4:
delete();
break;
}
}while(getOption()!=5);
}
private void
delete(){
EmployeeView.id();
int id = Console.in.readIntegerInput();
boolean
found=EmployeeModel.isFound(id);
if(found==true){
boolean
result=EmployeeModel.delete(id);
if(result)EmployeeView.deletedSuccessfully();
else EmployeeView.errMsg();
}
else{EmployeeView.notFoundMsg();}
}
}
6.
Create
MSAccessDB.java and type the codes
below:
import java.sql.*;
class MSAccessDB{
public static
Connection Connect(){
Connection conn=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String database
= "jdbc:odbc:Driver={Microsoft Access Driver
(*.mdb)};DBQ=EmployeesDB.mdb;";
conn =
DriverManager.getConnection(database, "",
"");
}catch(Exception ex){ex.printStackTrace();}
return conn;
}
public static boolean
Delete(String sql,Connection db){
return Execute(sql,db);
}
public static
ResultSet Search(String sql,Connection db){
return Query(sql,db);
}
private static
boolean Execute(String sql,Connection db){
try{
Statement
s = db.createStatement();
s.execute(sql);
s.close();
return true;
}catch(Exception ex){
ex.printStackTrace();
return false;
}
}
private static
ResultSet Query(String sql,Connection db){
ResultSet
rs=null;
try{
Statement
s = db.createStatement();
s.execute(sql);
rs
= s.getResultSet();
}catch(Exception ex){
ex.printStackTrace();
}
return rs;
}
}
7.
Create
a Console.java and type the codes
below:
import java.io.*;
class Console{
public static class out{
public static void print(String str){System.out.print(str);}
public static void println(String str){System.out.println(str);}
public static void println(Object obj){System.out.println(obj);}
}
public static class in{
static
int readIntegerInput(){
BufferedReader br=new BufferedReader(new
InputStreamReader(System.in));
int
input=0;
try{input=Integer.parseInt(br.readLine());}
catch(Exception ex){out.println("Error: "+ex.getMessage());System.exit(1);}
return input;
}
static String readStringInput(){
BufferedReader
br=new BufferedReader(new
InputStreamReader(System.in));
String
input="";
try{input=br.readLine();}
catch(Exception ex){out.println("Error: "+ex.getMessage());System.exit(1);}
return input;
}
}
}
8.
Put
your code to the test, nice jobJ
No comments:
Post a Comment