</f:view>
</body>
</html>

package gov.adjd.appBusiness;

import gov.adjd.dao.TasksDao;

import gov.adjd.tables.Task;

public class Business {

    private TasksDao taskdao;

    public String SaveTask(Task t) {

        String returnVal;
        try {
            taskdao.AddTask(t);
            returnVal = "success";
        } catch (Exception e) {
            returnVal = "failure";
            e.printStackTrace();
        }
        // System.out.println(this.getClass().getName() + ".saveTask()nreturnVal
        // = " + returnVal);
        return returnVal;

    }

}

package gov.adjd.dao;

import java.sql.*;
import java.util.Calendar;

import gov.adjd.tables.Task;
import oracle.jdbc.pool.OracleDataSource;

public class TasksDao {

    private static Connection con = null;
    private static PreparedStatement stmt = null;

    public TasksDao() {
        con = TasksDao.openDB();
    }

    public static Connection openDB() {
        try {
            OracleDataSource ods = new OracleDataSource();

            ods.setURL("jdbc:oracle:thin:@localhost:1521:XE");
            ods.setUser("task");
            ods.setPassword("task");

            con = ods.getConnection();
            System.out.println("connected.");
        } catch (Exception e) {
            System.out.print("Unable to load driver " + e);
            System.exit(1);
        }
        return con;
    }

    public static void closeDB() {
        try {
            con.close();
            System.out.print("Connection closed");
        } catch (SQLException e) {
            System.out.print("Could not close connection ");
            e.printStackTrace();
        }

    }

    ////Tasks
    // To add new task
    public String AddTask(Task t) {

        try {
            String insertSql = "INSERT INTO Tasks"
                    + "(task_name, description, status, start_date, end_date, task_type, e_id, priority) "
                    + "values(?, ?,?, ?, ?, ?, ?, ?)";
            stmt = con.prepareStatement(insertSql);

            stmt.setString(1, t.getTASK_NAME());
            stmt.setString(2, t.getDESCRIPTION());
            stmt.setString(3, t.getSTATUS_CODE());
            if (t.getSTART_DATE() == null)
                stmt.setNull(4, Types.DATE);
            else
                stmt.setDate(4, null, Calendar.getInstance());

            if (t.getEND_DATE() == null)
                stmt.setNull(5, Types.DATE);
            else
                stmt.setDate(5, null, Calendar.getInstance());

            stmt.setInt(6, t.getTASK_TYPE_CODE());
            stmt.setInt(7, t.getE_ID());
            stmt.setInt(8, t.getPRIORITY_CODE());

            stmt.executeUpdate();

            System.out.println("Record is inserted into Task table");

        } catch (SQLException e) {
            System.out.print("SQL Exception " + e);
            e.printStackTrace();
            System.exit(1);
        }
        return t.toString();

    }


    ///// To add new status
    /*public String AddStatus(Task t) {

        try {
            String insertSql = "INSERT INTO Tasks"
                    + "(task_name, description, status, start_date, end_date, task_type, e_id, priority) "
                    + "values(?, ?,?, ?, ?, ?, ?, ?)";
            stmt = con.prepareStatement(insertSql);

            stmt.setString(1, t.getTASK_NAME());
            stmt.setString(2, t.getDESCRIPTION());
            stmt.setString(3, t.getSTATUS_CODE());
            if (t.getSTART_DATE() == null)
                stmt.setNull(4, Types.DATE);
            else
                stmt.setDate(4, null, Calendar.getInstance());

            if (t.getEND_DATE() == null)
                stmt.setNull(5, Types.DATE);
            else
                stmt.setDate(5, null, Calendar.getInstance());

            stmt.setInt(6, t.getTASK_TYPE_CODE());
            stmt.setInt(7, t.getE_ID());
            stmt.setInt(8, t.getPRIORITY_CODE());

            stmt.executeUpdate();

            System.out.println("Record is inserted into Task table");

        } catch (SQLException e) {
            System.out.print("SQL Exception " + e);
            e.printStackTrace();
            System.exit(1);
        }
        return t.toString();

    }*/





    public static void main(String args[]) {
        //TasksDao td = new TasksDao();
        //td.AddTask("test", "R", "new", "2016/03/03", "2016/03/03", "report", "1", "important");
        //td.DeleteTask("11");
        //td.SearchTask("19");

    }

}

package gov.adjd.tables;

import java.sql.Date;

public class Task {

    String TASK_ID;
    String TASK_NAME;
    String DESCRIPTION;
    String STATUS_CODE;
    Date START_DATE;
    Date END_DATE;
    int TASK_TYPE_CODE;
    int PRIORITY_CODE;
    int E_ID;
    public String getTASK_ID() {
        return TASK_ID;
    }
    public void setTASK_ID(String tASK_ID) {
        TASK_ID = tASK_ID;
    }
    public String getTASK_NAME() {
        return TASK_NAME;
    }
    public void setTASK_NAME(String tASK_NAME) {
        TASK_NAME = tASK_NAME;
    }
    public String getDESCRIPTION() {
        return DESCRIPTION;
    }
    public void setDESCRIPTION(String dESCRIPTION) {
        DESCRIPTION = dESCRIPTION;
    }
    public String getSTATUS_CODE() {
        return STATUS_CODE;
    }
    public void setSTATUS_CODE(String sTATUS_CODE) {
        STATUS_CODE = sTATUS_CODE;
    }
    public Date getSTART_DATE() {
        return START_DATE;
    }
    public void setSTART_DATE(Date sTART_DATE) {
        START_DATE = sTART_DATE;
    }
    public Date getEND_DATE() {
        return END_DATE;
    }
    public void setEND_DATE(Date eND_DATE) {
        END_DATE = eND_DATE;
    }
    public int getTASK_TYPE_CODE() {
        return TASK_TYPE_CODE;
    }
    public void setTASK_TYPE_CODE(int tASK_TYPE_CODE) {
        TASK_TYPE_CODE = tASK_TYPE_CODE;
    }
    public int getPRIORITY_CODE() {
        return PRIORITY_CODE;
    }
    public void setPRIORITY_CODE(int pRIORITY_CODE) {
        PRIORITY_CODE = pRIORITY_CODE;
    }
    public int getE_ID() {
        return E_ID;
    }
    public void setE_ID(int e_ID) {
        E_ID = e_ID;
    }
    @Override
    public String toString() {
        return "Task [TASK_ID=" + TASK_ID + ", TASK_NAME=" + TASK_NAME + ", DESCRIPTION=" + DESCRIPTION
                + ", STATUS_CODE=" + STATUS_CODE + ", START_DATE=" + START_DATE + ", END_DATE=" + END_DATE
                + ", TASK_TYPE_CODE=" + TASK_TYPE_CODE + ", PRIORITY_CODE=" + PRIORITY_CODE + ", E_ID=" + E_ID + "]";
    }

}