Steps:
1.
On
MSAccess 2003, create a database EmployeesDB.mdb
and on query tab write the SQL statement below:
CREATE
TABLE Employees
(
id
AUTOINCREMENT ,
EmpName
TEXT(50),
EmpAddress
TEXT(100)
)
2.
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);
}
}
3.
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();
}
}
4.
Create
EmployeesModel.java and type the
codes below:
import java.sql.*;
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 insert(EmployeesModel
Employee){
String
sql="INSERT INTO
Employees(EmpName,EmpAddress)"+
"VALUES('"+Employee.getName()+"','"+Employee.getAddress()+"')";
return MSAccessDB.Insert(sql,db);
}
public String toString(){
return "\nID="+getId()+super.toString();
}
}
5.
Create
EmployeesView.java and type the
codes below:
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("[1]Insert");
Console.out.println("[5]Quit");
Console.out.print("Select
Menu[1-5]: ");
}
public void
name(){Console.out.print("Input Name:");}
public void
address(){Console.out.print("Input Address:");}
public void
savedSuccessfully(){Console.out.println("Saved Successfully...");}
public void
errMsg(){Console.out.println("Error Encountered...");}
}
6.
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 1:
insert();
break;
}
}while(getOption()!=5);
}
private void insert()
{
boolean result
= EmployeeModel.insert(Employee());
if (result) EmployeeView.savedSuccessfully();
else EmployeeView.errMsg();
}
private EmployeesModel Employee(){
EmployeesModel
Employee=new EmployeesModel();
EmployeeView.name();
Employee.setName(Console.in.readStringInput());
EmployeeView.address();
Employee.setAddress(Console.in.readStringInput());
return Employee;
}
}
7.
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
Insert(String sql,Connection db){
return Execute(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;
}
}
}
8.
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;
}
}
}
9.
Put
your code to the test, nice jobJ
No comments:
Post a Comment