CMJD – Diploma in Comprehensive Master Java Developer

Object Reference Casting

01.

class A{
int a;
public void mA(){
[Link]("mA of A");
}
}
class B extends A{
int b;
public void mB(){
[Link]("mB of B");
}
}
class Demo{
public static void main(String args[]){
A a1=new B();
a1.a=100;
[Link]();
a1.b=200; //Illegal
[Link](); //Illegal
}
}

02.
Exercise

class A{
int a;
public void mA(){
[Link]("mA of A");
}
}
class B extends A{
int b;
public void mB(){
[Link]("mB of B");
}
}

Page 1 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

class Demo{
public static void main(String args[]){
A a1=new B();
a1.a=100;
[Link]();

//---------------------------
//call mB()of B
}
}

03 From 02.

class A{
int a;
public void mA(){
[Link]("mA of A");
}
}
class B extends A{
int b;
public void mB(){
[Link]("mB of B");
}
}
class Demo{
public static void main(String args[]){
A a1=new B();
a1.a=100;
[Link]();

//---------------------------
//call mB()of B
B b1=a1; //Illegal
b1.b=200;
[Link]();
}
}

Page 2 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

04.

class A{
int a;
public void mA(){
[Link]("mA of A");
}
}
class B extends A{
int b;
public void mB(){
[Link]("mB of B");
}
}
class Demo{
public static void main(String args[]){
A a1=new B();
a1.a=100;
[Link]();

//---------------------------
//call mB()of B
//B b1=a1; //Illegal
B b1=(B)a1; //Object Reference Casting
b1.b=200;
[Link]();
}
}

05. Case I

class A{
int a;
public void mA(){
[Link]("mA of A");
}
}
class B extends A{
int b;
public void mB(){
[Link]("mB of B");

Page 3 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

}
}
class Demo{
public static void main(String args[]){
A a1=new A();
a1.a=100;
[Link]();

B b1=(B)a1; //Legal, Runtime Error

b1.b=200;
[Link]();
}
}

06. Case II

class A{
int a;
public void mA(){
[Link]("mA of A");
}
}
class B extends A{
int b;
public void mB(){
[Link]("mB of B");
}
}
class Demo{
public static void main(String args[]){
A a1=new A();
a1.a=100;
[Link]();

if( a1 instanceof B){

B b1=(B)a1;
b1.b=200;
[Link]();
}
[Link]("a1 instanceof B :"+(a1 instanceof B));
}
}

Page 4 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

07. Exercise

class A{}
class B extends A{}
class C extends B{}
class Demo{
public static void main(String args[]){
A a1=new A();
A a2=new B();
A a3=new C();
B b1=new B();
B b2=new C();
C c1=new C();

[Link]("a1 instanceof A :"+(a1 instanceof A));

[Link]("a1 instanceof B :"+(a1 instanceof B));
[Link]("a1 instanceof C :"+(a1 instanceof C));

[Link]("a2 instanceof A :"+(a2 instanceof A));

[Link]("a2 instanceof B :"+(a2 instanceof B));
[Link]("a2 instanceof C :"+(a2 instanceof C));

[Link]("a3 instanceof A :"+(a3 instanceof A));

[Link]("a3 instanceof B :"+(a3 instanceof B));
[Link]("a3 instanceof C :"+(a3 instanceof C));

[Link]("b1 instanceof A :"+(b1 instanceof A));

[Link]("b1 instanceof B :"+(b1 instanceof B));
[Link]("b1 instanceof C :"+(b1 instanceof C));

[Link]("c1 instanceof A :"+(c1 instanceof A));

[Link]("c1 instanceof B :"+(c1 instanceof B));
[Link]("c1 instanceof C :"+(c1 instanceof C));
}
}

Page 5 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

08. Case III

class A{}
class B{}
class Demo{
public static void main(String args[]){
A a1=new A();
B b1=new B();
a1=(A)b1; //Illegal
b1=(B)a1; //Illegal
}
}

09. Exercise

class A{}
class B{}
class Demo{
public static void main(String args[]){
A a1=new A();
B b1=new B();
[Link](a1 instanceof A);
[Link](a1 instanceof B); //Compile Error
[Link](b1 instanceof A); //Compile Error
[Link](b1 instanceof B);
}
}

10. Case IV

class A{}
interface P{}
class Demo{
public static void main(String args[]){
A a1=null;
P p1=null;

a1=(A)p1; //Legal
p1=(P)a1; //Legal
}
}

Page 6 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

11. Case V

final class A{}

interface P{}
class Demo{
public static void main(String args[]){
A a1=null;
P p1=null;

a1=(A)p1; //Illegal
p1=(P)a1; //Illegal
}
}

Enumerations
12.

/*class Color{
public final static String RED="RED";
public final static String BLACK="BLACK";
public final static String BLUE="BLUE";
public final static String GREEN="GREEN";
}*/
enum Color{
RED,BLACK,BLUE,GREEN; //enum Objects
}
class Demo{
public static void main(String args[]){
Color c1; //Create an enum reference type "Color"
c1=[Link];
[Link](c1); //[Link]()-->BLACK
}
}

Page 7 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

13. Case I

enum Color{
RED,BLACK,BLUE,GREEN; //enum Objects
}
class Demo{
public static void main(String args[]){
Color c1=new Color(); //Error
}
}

14. Case II

enum Color{
RED,BLACK,BLUE,GREEN; //enum Objects
}
class Demo{
public static void main(String args[]){
Color[] colors=[Link]();
for(Color c1:colors){
[Link](c1);
}
}
}

15. Case III

enum Color{
RED,BLACK,BLUE,GREEN; //enum Objects
}
class Demo{
public static void main(String args[]){
Color color=[Link];

switch(color){ //Legal
case RED : //
case BLUE:
case BLACK:
}
}
}

Page 8 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

16. Case IV

enum Color{
RED,BLACK,BLUE,GREEN; //enum Objects
}
class Demo{
public static void main(String args[]){
Color color=[Link]("RED");
[Link](color);

}
}

17. Case V

enum Color{
RED(),BLACK(),BLUE(),GREEN;

Color(){
[Link]("Color()");
}
}
class Demo{
public static void main(String args[]){
Color c1=[Link];
}
}

18. Case VI

enum Color{
RED(1001),BLACK(1002),BLUE(1003),GREEN(1004);
private int code;
Color(int code){
[Link]=code;
}
public void setCode(int code){
[Link]=code;
}
public int getCode(){
return code;
}

Page 9 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

}
class Demo{
public static void main(String args[]){
Color c1=[Link];
[Link]([Link]());
[Link](2002);
[Link]([Link]());
}
}

Java Collection Framework

Class “ArrayList”
Generic type safe class
As a list
Indexing and fast Random accessing Insertion order

19.

import [Link];
class Customer {
private int code;
private String name;

Customer(int code, String name) {

[Link] = code;
[Link] = name;
}

public String toString() {

return code + "-" + name;
}
}

class Demo {
public static void main(String args[]) {
ArrayList<String> strList = new ArrayList<>();
[Link](new String("A"));
[Link](new String("B"));
[Link](new String("C"));

Page 10 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

[Link](new String("D"));
[Link](new String("E"));
[Link](strList); // [Link]"(;
ArrayList<Customer> custList = new ArrayList<>();
[Link](new Customer(1001, "Customer 1"));
[Link](new Customer(1002, "Customer 2"));
[Link](new Customer(1003, "Customer 3"));
[Link](new Customer(1004, "Customer 4"));
[Link](new Customer(1005, "Customer 5"));
[Link](custList);
}
}

20.

import [Link];
class Customer {
private int code;
private String name;
Customer(int code, String name) {
[Link] = code;
[Link] = name;
}
public String toString() {
return code + "-" + name;
}
}

class Demo {
public static void main(String args[]) {
ArrayList<Customer> custList = new ArrayList<>();
[Link](new Customer(1001, "Danapala"));
[Link](new Customer(1002, "Gunapala"));
[Link](new Customer(1003, "Siripala"));
[Link](new Customer(1004, "Somapala"));
[Link](new Customer(1005, "Amarapala"));
[Link](custList);
Customer c1 = [Link](2); // Indexing, Random access [Link]("Customer
of index 2 : "+c1);
[Link](2, new Customer(1111, "Sirisena"));
[Link](custList);
for (int i = 0; i < [Link](); i++) {

Page 11 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

Customer cust = [Link](i);

[Link](cust);
}
}
}

21. for-each with collection classes

import [Link];
class Customer {
private int code;
private String name;
Customer(int code, String name) {
[Link] = code;
[Link] = name;
}
public String toString() {
return code + "-" + name;
}
}

class Demo {
public static void main(String args[]) {
ArrayList<Customer> custList = new ArrayList<>();
[Link](new Customer(1001, "Danapala"));
[Link](new Customer(1002, "Gunapala"));
[Link](new Customer(1003, "Siripala"));
[Link](new Customer(1004, "Somapala"));
[Link](new Customer(1005, "Amarapala"));
[Link](custList);
for (Customer cust : custList) {
[Link](cust);
}
}
}

Page 12 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

22.

import [Link];

class Customer {
private int code;
private String name;

Customer(int code, String name) {

[Link] = code;
[Link] = name;
}

public String toString() {

return code + "-" + name;
}
}

class Demo {

public static void main(String args[]) {

ArrayList<String> strList = new ArrayList<>();
[Link](new String("A"));
[Link](new String("B"));
[Link](new String("C"));
[Link](new String("D"));
[Link](new String("E"));
[Link](strList);

boolean b = [Link](new String("C"));

[Link]("String C contains " + b); // true
b = [Link](new String("X"));
[Link]("String X contains " + b); // false
[Link](2);
[Link](strList);
[Link](new String("D"));
[Link](strList);

}
}

Page 13 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

23. Exercise

import [Link];

class Customer {
private int code;
private String name;

Customer(int code, String name) {

[Link] = code;
[Link] = name;
}

public String toString() {

return code + "-" + name;

}
}

class Demo {
public static void main(String args[]) {
ArrayList<Customer> custList = new ArrayList<>();
[Link](new Customer(1001, "Danapala"));
[Link](new Customer(1002, "Gunapala"));
[Link](new Customer(1003, "Siripala"));
[Link](new Customer(1004, "Somapala"));
[Link](new Customer(1005, "Amarapala"));
[Link](custList);
boolean b = [Link](new Customer(1003, "Siripala"));
[Link]("1003-Siripala : " + b); // false
[Link](new Customer(1003, "Siripala"));
[Link](custList);

}
}

Page 14 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

24. Method public boolean equals(Object)

import [Link];

class Customer {
private int code;
private String name;

Customer(int code, String name) {

[Link] = code;
[Link] = name;
}

/*
* public boolean equals(Object obj){
* return this==obj;
*}
*/
public String toString() {
return code + "-" + name;
}
}

class Demo {
public static void main(String args[]) {
Customer c1 = new Customer(1001, "Danapala");
Customer c2 = new Customer(1001, "Danapala");
Customer c3 = new Customer(1002, "Ganapala");
Customer c4 = c1;
[Link]("c1 equals c2 : " + [Link](c2));// false
[Link]("c1 equals c3 : " + [Link](c3));// false
[Link]("c1 equals c4 : " + [Link](c4));// true

}
}

Page 15 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

25 From 24. Overriding “public boolean equals(Object)”

import [Link];

class Customer {

private int code;

private String name;

Customer(int code, String name) {

[Link] = code;
[Link] = name;
}

/*
* public boolean euqlas(Object obj){
* return this==obj;
*}
*/
public boolean equals(Object obj) {
// return [Link]==[Link];
// Customer c1=obj;
Customer c1 = (Customer) obj; // object reference casting
return [Link]==[Link];
}

public String toString() {

return code + "-" + name;
}
}
class Demo {
public static void main(String args[]) {

Customer c1 = new Customer(1001, "Danapala");

Customer c2 = new Customer(1001, "Danapala");
Customer c3 = new Customer(1002, "Ganapala");
Customer c4 = c1;
[Link]("c1 equals c2 : " + [Link](c2));// true
[Link]("c1 equals c3 : " + [Link](c3));// false
[Link]("c1 equals c4 : " + [Link](c4));// true
}
}

Page 16 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

26 From 23.

import [Link];

class Customer {
private int code;
private String name;

Customer(int code, String name) {

[Link] = code;
[Link] = name;
// Illegal, [Link]

public boolean equals(Object obj) {

Customer c1 = (Customer) obj;
return [Link] == [Link];
}

public String toString() {

return code + "-" + name;
}
}

class Demo {
public static void main(String args[]) {

ArrayList<Customer> custList = new ArrayList<>();

[Link](new Customer(1001, "Danapala"));
[Link](new Customer(1002, "Gunapala"));
[Link](new Customer(1003, "Siripala"));
[Link](new Customer(1004, "Somapala"));
[Link](new Customer(1005, "Amarapala"));
[Link](custList);
boolean b = [Link](new Customer(1003, "Siripala"));
[Link]("1003-Siripala : " + b); // false
[Link](new Customer(1003, "Siripala"));
[Link](custList);
}

Page 17 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

27. Class “LinkedList” Speed, addition and deletion

import [Link];

class Customer {
private int code;
private String name;

Customer(int code, String name) {

[Link] = code;
[Link] = name;
}

public boolean equals(Object obj) {

Customer c1 = (Customer) obj;
return [Link] == [Link];
}

public String toString() {

return code + "-" + name;
}
}

class Demo {
public static void main(String args[]) {
LinkedList<Customer> custList = new LinkedList<>();
[Link](new Customer(1001, "Danapala"));
[Link](new Customer(1002, "Gunapala"));
[Link](new Customer(1003, "Siripala"));
[Link](new Customer(1004, "Somapala"));
[Link](new Customer(1005, "Amarapala"));
[Link](custList);

}
}

Page 18 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

28. Linked List as a “Stack”

import [Link];

class Customer {
private int code;
private String name;

Customer(int code, String name) {

[Link] = code;
[Link] = name;
}

public boolean equals(Object obj) {

Customer c1 = (Customer) obj;
return [Link] == [Link];
}

public String toString() {

return code + "-" + name;
}
}

class Demo {
public static void main(String args[]) {
LinkedList<Customer> custList = new LinkedList<>();
[Link](new Customer(1001, "Danapala"));
[Link](new Customer(1002, "Gunapala"));
[Link](new Customer(1003, "Siripala"));
[Link](new Customer(1004, "Somapala"));
[Link](new Customer(1005, "Amarapala"));
[Link](custList);
Customer c1 = [Link]();
[Link]("Top customer : " + c1);
[Link](custList);
c1 = [Link]();
[Link]("Top customer : " + c1);
}
}

Page 19 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

29. LinkedList as “Queue”

import [Link];

class Customer {
private int code;
private String name;

Customer(int code, String name) {

[Link] = code;
[Link] = name;
}

public boolean equals(Object obj) {

Customer c1 = (Customer) obj;
return [Link] == [Link];
}

public String toString() {

return code + "-" + name;
}
}

class Demo {
public static void main(String args[]) {

LinkedList<Customer> custList = new LinkedList<>();

[Link](new Customer(1001, "Danapala"));
[Link](new Customer(1002, "Gunapala"));
[Link](new Customer(1003, "Siripala"));
[Link](new Customer(1004, "Somapala"));
[Link](new Customer(1005, "Amarapala"));
[Link](custList);
Customer c1 = [Link](); // remove, first element of the Queue
[Link]("Top customer : " + c1);
[Link](custList);
c1 = [Link]();
[Link]("Top customer : " + c1);
[Link](custList);
}
}

Page 20 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

Generics in Java

30.

class List{
private int[] items = new int[10];
private int count;

public void add(int item){

items[count++] = item;
}

public int get(int index){

return items[index];
}
}
class Example {
public static void main(String[] args) {
List list = new List();
[Link](3);
}
}

31.

class List{

private int[] items = new int[10];

private int count;

public void add(int item){

items[count++] = item;
}

public int get(int index){

return items[index];
}
}

Page 21 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

Customer Array

class Customer{}
class CustomerList{
private Customer[] customers = new Customer[10];
private int count;
public void add(Customer customer){
customers[count++] = customer;
}
public Customer get(int index){
return customers[index];
}
}
class Example {
public static void main(String[] args) {
List list = new List();
[Link](3);
CustomerList customerList = new CustomerList();
[Link](new Customer());
}
}

32.

class Customer{}
class List{
private Object[] items = new Object[10];
private int count;
public void add(Object item){
items[count++] = item;
}
public Object get(int index){
return items[index];
}
}
class Example {
public static void main(String[] args) {
List list = new List();
[Link](3); //==> [Link](3); Wrapper Class
[Link]("3");
[Link](new Customer());}}

Page 22 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

33.

class Customer{}
class List{
private Object[] items = new Object[10];
private int count;
public void add(Object item){
items[count++] = item;
}
public Object get(int index){
return items[index];
}
}
class Example {
public static void main(String[] args) {
List list = new List();
[Link](3); //==> [Link](3); Wrapper Class
[Link]("3");
[Link](new Customer());

int number = (int) [Link](0); // Explicitly cast

Customer customer = (Customer) [Link](1); // ClassCastException That can identify only Runtime
}
}

34.

class Customer{}

class List<T>{ // Type Parameter for Class

private T[] items = (T[])new Object[10];
private int count;

public void add(T item){

items[count++] = item;
}

public T get(int index){

return items[index];
}
}

Page 23 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

class Example {
public static void main(String[] args) {
List<Integer> list = new List<>();
[Link](1);
[Link](0);
//[Link]("1"); //Illegal

List<Customer> customerList = new List<>();

[Link](new Customer());
}
}

35.

class Customer{}
class List<T>{ // Type Parameter for Class
private T[] items = (T[])new Object[10];
private int count;
public void add(T item){
items[count++] = item;
}
public T get(int index){
return items[index];
}
}
class Example {
public static void main(String[] args) {
///// Wrapper Classes //////////
//byte -> Byte
//short -> Short
//int -> Integer
//long -> Long
//float -> Float
//double -> Double
//char -> Character
//boolean -> Boolean
//List<int> list = new List<>(); // Compile Error.
List<Integer> list = new List<>();
[Link](1); // Boxing
int num = [Link](0); // Unboxing
}
}

Page 24 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

36.

class Customer{}

class List<T extends Number>{ // Type Parameter for Class

private T[] items = (T[])new Object[10];
private int count;

public void add(T item){

items[count++] = item;
}
public T get(int index){
return items[index];
}
}
class Example {
public static void main(String[] args) {
List<Number> list = new List<>();
List<Integer> listInt = new List<>();
List<Double> listDouble = new List<>();
//List<Customer> customers = new List<>(); // Illegal. Type can be only number or sub type of number
}
}

JDBC

37. Step 1 (Load MySQL Driver)

public class Main{

public static void main(String[] args) {
[Link]("[Link]");
}
}

38. Step 2 (Throw Exceptions)

public class Main{

public static void main(String[] args) throws ClassNotFoundException {
[Link]("[Link]");
}
}

Page 25 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

39. Step 3 (Create Connection)

import [Link];
import [Link];
import [Link];

public class Main{

public static void main(String[] args) throws ClassNotFoundException, SQLException {
[Link]("[Link]");
Connection connection =
[Link]("jdbc:mysql://localhost:3306/Supermarket", "root", "Xhq8nc3mcj");
}
}

40. Step 4 (Execute a Query)

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class Main{

public static void main(String[] args) throws ClassNotFoundException, SQLException {
[Link]("[Link]");
Connection connection =
[Link]("jdbc:mysql://localhost:3306/Supermarket", "root", "Xhq8nc3mcj");

Statement statement = [Link]();

ResultSet resultSet = [Link]("SELECT * FROM Customer");
while([Link]()){
[Link]([Link](1) + " " + [Link](3) + " " +
[Link](5));
}
}
}

Page 26 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

41. Step 4 (Execute an Update)

import [Link];
import [Link];
import [Link];
import [Link];

public class Main{

public static void main(String[] args) throws ClassNotFoundException, SQLException {
[Link]("[Link]");
Connection connection =
[Link]("jdbc:mysql://localhost:3306/Supermarket", "root", "Xhq8nc3mcj");

Statement statement = [Link]();

int result = [Link]("INSERT INTO Customer VALUES ('C033', 'Mr', 'Kapila', '1989-
10-15', 100000.00, 'Galle', 'Galle', 'Southern', 10002)");
[Link](result >0? "Success" : "Fail");
}
}

42 From 41

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class Main {

public static void main(String[] args) throws ClassNotFoundException, SQLException {
Scanner scanner = new Scanner([Link]);
[Link]("[Link]");
Connection connection =
[Link]("jdbc:mysql://localhost:3306/Supermarket", "root",
"Xhq8nc3mcj");

[Link]("Input customer id : ");

String custId = [Link]();

[Link]("Input customer title : ");

String title = [Link]();

Page 27 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

[Link]("Input customer name : ");

String name = [Link]();

[Link]("Input customer DOB : ");

String dob = [Link]();

[Link]("Input customer address : ");

String address = [Link]();

[Link]("Input customer city : ");

String city = [Link]();

[Link]("Input customer province : ");

String province = [Link]();

[Link]("Input customer zip : ");

String zip = [Link]();

[Link]("Input customer salary : ");

int salary = [Link]();

Statement statement = [Link]();

int result = [Link](
"INSERT INTO Customer VALUES ('"+custId+"', '"+title+"', '"+name+"', '"+dob+"', "+salary+",
'"+address+"', '"+city+"', '"+province"', '"+zip+"')");
[Link](result > 0 ? "Success" : "Fail");

}
}

43. Step 5 (PreparedStatement - Insert)

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class Main {

public static void main(String[] args) throws ClassNotFoundException, SQLException {
Scanner scanner = new Scanner([Link]);

Page 28 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

[Link]("[Link]");
Connection connection =
[Link]("jdbc:mysql://localhost:3306/Supermarket", "root",
"Xhq8nc3mcj");

[Link]("Input customer id : ");

String custId = [Link]();

[Link]("Input customer title : ");

String title = [Link]();

[Link]("Input customer name : ");

String name = [Link]();

[Link]("Input customer DOB : ");

String dob = [Link]();

[Link]("Input customer address : ");

String address = [Link]();

[Link]("Input customer city : ");

String city = [Link]();

[Link]("Input customer province : ");

String province = [Link]();

[Link]("Input customer zip : ");

String zip = [Link]();

[Link]("Input customer salary : ");

int salary = [Link]();

PreparedStatement statement = [Link]("INSERT INTO Customer VALUES

(?,?,?,?,?,?,?,?,?)");
[Link](1, custId);
[Link](2, title);
[Link](3, name);
[Link](4, dob);
[Link](5, salary);
[Link](6, address);
[Link](7, city);
[Link](8, province);

Page 29 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

[Link](9, zip);

int result = [Link]();

[Link](result > 0 ? "Success" : "Fail");
}
}

43. Step 6 (PreparedStatement - Select)

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class Main {

public static void main(String[] args) throws ClassNotFoundException, SQLException {
Scanner scanner = new Scanner([Link]);
[Link]("[Link]");
Connection connection =
[Link]("jdbc:mysql://localhost:3306/Supermarket", "root",
"Xhq8nc3mcj");

[Link]("Input customer province : ");

String province = [Link]();

PreparedStatement statement = [Link]("SELECT * FROM Customer WHERE

province = ?");
[Link](1, province);

ResultSet resultSet = [Link]();

while([Link]()){
[Link]([Link](1) + " " + [Link](3) + " " +
[Link](5));
}

}
}

Page 30 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

Singleton Design Pattern

44. Step 1

class A{
public A(){}
public void myMethod(){
[Link]("myMethod in : " + this);
}
}
public class Main {
public static void main(String[] args){
A a1 = new A();
[Link]();
A a2 = new A();
[Link]();

}
}

45. Step 2

class A{
private static A a;
public A(){}
public static A getInstance(){
if(a == null){
a = new A();
}
return a;
}
public void myMethod(){
[Link]("myMethod in : " + this);
}
}
public class Main {
public static void main(String[] args){
A a1 = new A();
[Link]();
A a2 = new A();
[Link](); }}

Page 31 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

46. Step 3

class A{
private static A a;
private A(){}

public static A getInstance(){

if(a == null){
a = new A();
}
return a;
}
public void myMethod(){
[Link]("myMethod in : " + this);
}
}

public class Main {

public static void main(String[] args){
A a1 = [Link]();
[Link]();

A a2 = [Link]();
[Link]();
}
}

47 from 43. (DB Connection using Singleton)

[Link]

import [Link];
import [Link];
import [Link];

public class DBConnection{

private Connection connection;
private static DBConnection dbConnection;

private DBConnection() throws ClassNotFoundException, SQLException{

[Link]("[Link]");
connection = [Link]("jdbc:mysql://localhost:3306/Supermarket", "root",

Page 32 of 33
 CMJD – Diploma in Comprehensive Master Java Developer

"Xhq8nc3mcj");
}

public static DBConnection getInstance() throws ClassNotFoundException, SQLException{

if(dbConnection == null){
dbConnection = new DBConnection();
}
return dbConnection;
}
public Connection getConnection(){
return connection;
}
}

[Link]

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class Main {

public static void main(String[] args) throws ClassNotFoundException, SQLException {
Scanner scanner = new Scanner([Link]);

Connection connection = [Link]().getConnection();

[Link]("Input customer province : ");

String province = [Link]();

PreparedStatement statement = [Link]("SELECT * FROM Customer WHERE

province = ?");
[Link](1, province);

ResultSet resultSet = [Link]();

while([Link]()){
[Link]([Link](1) + " " + [Link](3) + " " +
[Link](5));
}
}

Page 33 of 33