package com.ibs.emp;

public class EmpDetails {

    private int emp_id;
    private String emp_name;
    private int emp_age;
    private String emp_designation;
    private long emp_salary;
    private static String status;
    private static float rate;
    private static float orate;
    private static float hours;

    public int getEmp_id() {
        return emp_id;
    }
    public void setEmp_id(int emp_id) {
        this.emp_id = emp_id;
    }
    public String getEmp_name() {
        return emp_name;
    }
    public void setEmp_name(String emp_name) {
        this.emp_name = emp_name;
    }
    public int getEmp_age() {
        return emp_age;
    }
    public void setEmp_age(int emp_age) {
        this.emp_age = emp_age;
    }
    public String getEmp_designation() {
        return emp_designation;
    }
    public void setEmp_designation(String emp_designation) {
        this.emp_designation = emp_designation;
    }
    public long getEmp_salary() {
        return emp_salary;
    }
    public void setEmp_salary(long emp_salary) {
        this.emp_salary = emp_salary;
    }
    public static String getStatus() {
        return status;
    }
    public void setStatus(String status) {
        EmpDetails.status = status;
    }
    public static float getRate() {
        return rate;
    }
    public void setRate(float rate) {
        EmpDetails.rate = rate;
    }
    public static float getOrate() {
        return orate;
    }
    public void setOrate(float orate) {
        EmpDetails.orate = orate;
    }
    public static float getHours() {
        return hours;
    }
    public void setHours(float hours) {
        EmpDetails.hours = hours;
    }
}

package com.ibs.emp;

import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class DBConnection {

    public Connection getConnection() throws IOException, ClassNotFoundException, SQLException {
        Properties prop = new Properties();

        //FileInputStream fis = new FileInputStream("resources/config.properties");

            //InputStream  fis = getClass().getResourceAsStream("resources/config.properties");
        FileInputStream input = new FileInputStream("resources/config.properties");
        prop.load(input);
        //prop.load(fis);
            Class.forName(prop.getProperty("JDBC_DRIVER"));
            Connection con = DriverManager.getConnection(prop.getProperty("DB_URL"),
                    prop.getProperty("USER"),
                    prop.getProperty("PASS"));

        return con;
    }
}

package com.ibs.emp;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class DBConnectionTest {

    static ResultSet rs;
    static ResultSetMetaData rm;
    static int ch, nof;
    static double tax, total;
    static EmpDetails empDetails = new EmpDetails();

    public static double gross(){
        if(EmpDetails.getHours() > 40)
            return EmpDetails.getHours() * EmpDetails.getOrate();
        else
            return EmpDetails.getHours() * EmpDetails.getRate();
    }

    public static double net(){
        if(EmpDetails.getStatus().equalsIgnoreCase("married"))
            return total *= 0.75;
        else
            return total *= 0.70;
    }

    public static void display(double total, double tax){
        System.out.println("Gross pay: " + total);
        System.out.println("Net pay: " + tax);
    }

    public static void main(String[] args) throws NumberFormatException, IOException, SQLException, ClassNotFoundException {

        DBConnection dbConnection = new DBConnection();

        System.out.println("Connecting to a selected database...");
        Connection con = dbConnection.getConnection();
        System.out.println("Connected database successfully...");
        Statement st = con.createStatement();
        BufferedReader bin = new BufferedReader(new InputStreamReader(System.in));

        while(true){
            System.out.println("Choose Option");
            System.out.println("1. Select");
            System.out.println("2. Insert");
            System.out.println("3. Update");
            System.out.println("4. Delete");
            System.out.println("5. Payslip");
            System.out.println("0. Exit");
            ch = Integer.parseInt(bin.readLine());
            if (ch==1){
                rs = st.executeQuery("select * from emp");
                rm = rs.getMetaData();
                nof = rm.getColumnCount();
                for(int i=1; i<=nof; i++)
                {
                    System.out.print(rm.getColumnName(i)+"tt");
                }
                System.out.println();
                while(rs.next())
                {
                    for(int i=1; i<=nof; i++)
                    {
                        System.out.print(rs.getString(i) +"tt");
                    }
                    System.out.println();
                }
            }
            else if(ch==2)
            {
                System.out.println("Enter Name");
                empDetails.setEmp_name(bin.readLine());
                System.out.println("Enter Designation");
                empDetails.setEmp_designation(bin.readLine());
                System.out.println("Enter Emp_age");
                empDetails.setEmp_age( bin.read());
                System.out.println("Enter Salary");
                empDetails.setEmp_salary(bin.read());
                System.out.println("How many hours worked?");
                empDetails.setHours(bin.read());
                System.out.println("Rate of pay?");
                empDetails.setRate(bin.read());
                System.out.println("Over time rate?");
                empDetails.setOrate(bin.read());
                System.out.println("Married or Single?");
                empDetails.setStatus(bin.readLine());
                total = gross();
                tax = net();

                st.execute("insert into emp values('"+empDetails.getEmp_name()+"','"+empDetails.getEmp_age()+"','"+empDetails.getEmp_designation()+"','"+empDetails.getEmp_salary()+"','"+empDetails.getStatus()+"','"+empDetails.getOrate()+"','"+empDetails.getRate()+"','"+empDetails.getHours()+"','toatal','tax')");
                System.out.println("1 Record inserted");
            }
            else if(ch==3)
            {
                System.out.println("Enter Emp_id");
                empDetails.setEmp_id(bin.read());
                System.out.println("Enter Name");
                empDetails.setEmp_name( bin.readLine());
                System.out.println("Enter Designation");
                empDetails.setEmp_designation(bin.readLine());
                System.out.println("Enter Emp_age");
                empDetails.setEmp_age( bin.read());
                System.out.println("Enter Salary");
                empDetails.setEmp_salary(bin.read());
                System.out.println("How many hours worked?");
                empDetails.setHours(bin.read());
                System.out.println("Rate of pay?");
                empDetails.setEmp_name(bin.readLine());
                System.out.println("Over time rate?");
                empDetails.setEmp_name(bin.readLine());
                System.out.println("Married or Single?");
                empDetails.setEmp_name(bin.readLine());
                total = gross();
                tax = net();

                st.execute("update emp set emp_name='"+empDetails.getEmp_name()+"',emp_age='"+empDetails.getEmp_age()+"',emp_designation='"+empDetails.getEmp_designation()+"',emp_salary='"+empDetails.getEmp_salary()+"',status='"+empDetails.getStatus()+"',orate='"+empDetails.getOrate()+"',rate='"+empDetails.getRate()+"',hours='"+empDetails.getHours()+"',taotal='toatal',tax='tax' where emp_id ="+empDetails.getEmp_id());
                System.out.println("1 Record Updated");

            }
            else if(ch==4)
            {
                System.out.println("Enter Emp_id. to Delete :");
                empDetails.setEmp_id(bin.read());
                st.execute("delete from emp where eno ="+empDetails.getEmp_id());
                System.out.println("Record Deleted");
            }
            else if(ch==5)
            {
                System.out.println("Enter Emp_id");
                empDetails.setEmp_id(bin.read());
                rs = st.executeQuery("select * from emp");
                rm = rs.getMetaData();
                nof = rm.getColumnCount();
                for(int i=1; i<=nof; i++)
                {
                    System.out.print(rm.getColumnName(i)+"tt");
                }
                System.out.println();
                while(rs.next())
                {
                    for(int i=1; i<=nof; i++)
                    {
                        System.out.print(rs.getString(i) +"tt");
                    }
                    System.out.println();
                }
                display(total, tax);
            }
            else if(ch==0)
            {
                bin.close();
                con.close();
                System.exit(0);
            }
        }
    }
}

JDBC_DRIVER = com.mysql.jdbc.Driver
DB_URL = jdbc:mysql://localhost:3306/company
USER = root
PASS = admin

Exception in thread "main" java.lang.NumberFormatException: For input string: ""
    at java.lang.NumberFormatException.forInputString(Unknown Source)
    at java.lang.Integer.parseInt(Unknown Source)
    at java.lang.Integer.parseInt(Unknown Source)
    at com.ibs.emp.DBConnectionTest.main(DBConnectionTest.java)