Java, Netbeans, Mysql, Tomcat : insert value into database does not work while my search, view, delete working fine

i've been working on this problem and trying to find the solution here for a week now and still cant seem to find the problem, the data for view,search and delete is added manually on mysql thats why it worked. but the database didnt update any value when the data is insert through the system and didnt even produce error just direct to the error.jsp page. please help this rookie

main class

package job;

public class job {
private int j_id;
private String j_title;
private String j_description;
private String j_location;
private String j_type;
private String j_empType; 
//private int d_id;
private String d_name;


public int getJobid() {
    return j_id;
}

public void setJobid(int j_id) {
    this.j_id = j_id;
}

public String getJobtitle() {
    return j_title;
}

public void setJobtitle(String j_title) {
    this.j_title = j_title;
}

public String getJobdescription() {
    return j_description;
}

public void setJobdescription(String j_description) {
    this.j_description = j_description;
}

public String getJoblocation() {
    return j_location;
}

public void setJoblocation(String j_location) {
    this.j_location = j_location;
}

public String getJobtype() {
    return j_type;
}

public void setJobtype(String j_type) {
    this.j_type = j_type;
}

public String getJobemptype() {
    return j_empType;
}

public void setJobemptype(String j_empType) {
    this.j_empType = j_empType;
}

public String getDepartmentname() {
    return d_name;
}

public void setDepartmentname(String d_name) {
    this.d_name = d_name;
}
}

and this is my dao

package job;

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

public class jobDAO {
public static String user= "root"; //username same as the database
public static String password = "KPSAdmin1234!";
public static Connection getConnection() throws ClassNotFoundException{
    Connection conn=null;
    try{
        Class.forName("com.mysql.jdbc.Driver");
        conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/kps","root","KPSAdmin1234!");
        System.out.println("Connected");
    }catch(SQLException e){System.err.println(e);}

    return conn;
}


public static int save(job a){
    int status = 0;
    try{
        Connection con = jobDAO.getConnection();
        PreparedStatement ps = con.prepareStatement("insert into job(j_title,j_description,j_location,j_type,j_empType, d_name) values(?,?,?,?,?,?)");

        ps.setString(1,a.getJobtitle());
        ps.setString(2, a.getJobdescription());
        ps.setString(3, a.getJoblocation());
        ps.setString(4, a.getJobtype());
        ps.setString(5, a.getJobemptype());
        ps.setString(6, a.getDepartmentname());

        ps.executeUpdate();
        con.close();
        //ps.close();
    }catch(Exception ex){ ex.printStackTrace(); }

    return status;
}

public static int update(job a){
    int status = 0;
    try{
        Connection con=jobDAO.getConnection();
        PreparedStatement ps = con.prepareStatement("update job set j_title=?,j_description=?,j_location=?,j_type=?,j_empType=?, d_name=? where j_id=?");
        ps.setString(1,a.getJobtitle());
        ps.setString(2, a.getJobdescription());
        ps.setString(3, a.getJoblocation());
        ps.setString(4, a.getJobtype());
        ps.setString(5, a.getJobemptype());
        ps.setString(7, a.getDepartmentname());

        status = ps.executeUpdate();
        con.close();
    }catch(Exception ex){ ex.printStackTrace(); }

    return status;
}

public static int delete(int j_id){
    int status = 0;
    try{
        Connection con = jobDAO.getConnection();
        PreparedStatement ps = con.prepareStatement("DELETE FROM JOB WHERE J_ID=?");
        ps.setInt(1, j_id);
        status = ps.executeUpdate();

        PreparedStatement pss = con.prepareStatement("DELETE FROM JOB WHERE J_ID=?");
        pss.setInt(1, j_id);
        status = pss.executeUpdate();

        con.close();
    }catch(Exception e){ e.printStackTrace(); }

    return status;
}

    public static job getJobById(int j_id){
    job j = new job();

    try{
        Connection con = jobDAO.getConnection();
        PreparedStatement ps = con.prepareStatement("select * from job where j_id=?");
        ps.setInt(1, j_id);
        ResultSet rs = ps.executeQuery();
        if(rs.next()){
            j.setJobid(rs.getInt(1));
            j.setJobtitle(rs.getString(2));
            j.setJobdescription(rs.getString(3));
            j.setJoblocation(rs.getString(4));
            j.setJobtype(rs.getString(5));
            j.setJobemptype(rs.getString(6));
            j.setDepartmentname(rs.getString(7));
        }
        con.close();
    }catch(Exception ex){ ex.printStackTrace(); }

    return j;
}

    public static List<job> getAllJob(){
    List<job> list = new ArrayList<job>();

    try{
        Connection con = jobDAO.getConnection();
        PreparedStatement ps = con.prepareStatement("select * from job");
        ResultSet rs = ps.executeQuery();

        while(rs.next()){
            job j = new job();
            j.setJobid(rs.getInt(1));
            j.setJobtitle(rs.getString(2));
            j.setJobdescription(rs.getString(3));
            j.setJoblocation(rs.getString(4));
            j.setJobtype(rs.getString(5));
            j.setJobemptype(rs.getString(6));
            j.setDepartmentname(rs.getString(7));
            list.add(j);
        }
        con.close();
    }catch(Exception e) { e.printStackTrace(); }

    return list;
}
}

servlet

package job;

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet(name = "SaveJob", urlPatterns = {"/SaveJob"})
public class SaveJob extends HttpServlet {

    /**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
    response.setContentType("text/html");
    PrintWriter out=response.getWriter();

    String j_title = request.getParameter("j_title");
    String j_description = request.getParameter("j_description");
    String j_location = request.getParameter("j_location");
    String j_type = request.getParameter("j_type");
    String j_empType = request.getParameter("j_empType"); 
    String d_name = request.getParameter("d_name");


    job j=new job();
    j.setJobtitle(j_title);
    j.setJobdescription(j_description);
    j.setJoblocation(j_location);
    j.setJobtype(j_type);
    j.setJobemptype(j_empType);
    j.setDepartmentname(d_name);

    int status=jobDAO.save(j);
    if(status>0){
        out.print("<p>Record saved successfully!</p>");
        request.getRequestDispatcher("index.jsp").include(request, response);
    }else{
        response.sendRedirect("error.jsp");
    }

    out.close();
    }

}

jsp

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="Creative - Bootstrap 3 Responsive Admin Template">
<meta name="author" content="GeeksLabs">
<meta name="keyword" content="Creative, Dashboard, Admin, Template, Theme, Bootstrap, Responsive, Retina, Minimal">
<link rel="shortcut icon" href="img/favicon.png">

<title>Job Form</title>
<link rel="shortcut icon" href="img/favicon1.ico">

<!-- Bootstrap CSS -->    
<link href="css/bootstrap.min.css" rel="stylesheet">
<!-- bootstrap theme -->
<link href="css/bootstrap-theme.css" rel="stylesheet">
<!--external css-->
<!-- font icon -->
<link href="css/elegant-icons-style.css" rel="stylesheet" />
<link href="css/font-awesome.min.css" rel="stylesheet" />    
<!-- full calendar css-->
<link href="assets/fullcalendar/fullcalendar/bootstrap-fullcalendar.css" rel="stylesheet" />
<link href="assets/fullcalendar/fullcalendar/fullcalendar.css" rel="stylesheet" />
<!-- easy pie chart-->
<link href="assets/jquery-easy-pie-chart/jquery.easy-pie-chart.css" rel="stylesheet" type="text/css" media="screen"/>
<a href="1AppPersonalDetails.jsp"></a>
<!-- owl carousel -->
<link rel="stylesheet" href="css/owl.carousel.css" type="text/css">
<link href="css/jquery-jvectormap-1.2.2.css" rel="stylesheet">
<!-- Custom styles -->
<link rel="stylesheet" href="css/fullcalendar.css">
<link href="css/widgets.css" rel="stylesheet">
<link href="css/style.css" rel="stylesheet">
<link href="css/style-responsive.css" rel="stylesheet" />
<link href="css/xcharts.min.css" rel=" stylesheet"> 
<link href="css/jquery-ui-1.10.4.min.css" rel="stylesheet">
<script type="text/javascript">
    $(function(){
         $("#datepicker").datepicker({ minDate: 0 });
    });

</script>
</head>

<body>
<!-- container section start -->
<section id="container" class="">


  <header class="header dark-bg">
        <div class="toggle-nav">
            <div class="icon-reorder tooltips" data-original-title="Toggle Navigation" data-placement="bottom"><i class="icon_menu"></i></div>
        </div>

        <!--logo start-->
        <a href="index.jsp" class="logo">KUMPULAN PERANGSANG SELANGOR BERHAD</span></a>
        <!--logo end-->

        <!--search function start-->
        <div class="nav search-row" id="top_menu">
            <!--  search form start -->
            <ul class="nav top-menu">                    
                <li>
                    <form class="navbar-form" method="post" name="frm" action="SearchJob">
                        <input class="form-control"  title = "Search Job"placeholder="Search" type="text" name="j_title" id="j_title">
                    </form>
                </li>                    
            </ul>
            <!--  search form end -->                
        </div>
        <!--search function end-->

        <div class="top-nav notification-row">                
            <!-- notificatoin dropdown start-->
             <ul class="nav pull-right top-menu">


                <!-- user login dropdown start-->
                <li class="dropdown">
                    <a data-toggle="dropdown" class="dropdown-toggle" href="#">
                        <span class="profile-ava">
                            <img alt="" src="img/avatarmini.png">
                        </span>
                        <span class="username">Admin</span>
                        <b class="caret"></b>
                    </a>
                    <ul class="dropdown-menu extended logout">
                        <div class="log-arrow-up"></div>
                        <li class="eborder-top">
                            <a href="homepage.jsp"><i class="icon_key_alt"></i> Log Out</a>
                        </li>
                    </ul>
                </li>
                <!-- user login dropdown end -->
            </ul>
            <!-- notificatoin dropdown end-->
        </div>
  </header>      
  <!--header end-->

  <!--sidebar start-->
  <aside>
      <div id="sidebar"  class="nav-collapse ">
          <!-- sidebar menu start-->
          <ul class="sidebar-menu">                
              <li>
                  <a class="" href="index.jsp">
                      <i class="icon_house_alt"></i>
                      <span>Home</span>
                  </a>
              </li>
              <li class="sub-menu" class="active">
                  <a href="javascript:;" class="">
                      <i class="icon_table"></i>
                      <span>Job</span>
                      <span class="menu-arrow arrow_carrot-right"></span>
                  </a>
                  <ul class="sub">
                      <li><a class="" href="jobForm.jsp">Post Job</a></li>                          
                      <li><a class="" href="ViewJob">View</a></li>
                      <li><a class="" href="searchJob.jsp">Search</a></li>
                  </ul>
              </li>       
              <li class="sub-menu">
                  <a href="javascript:;" class="">
                      <i class="icon_document_alt"></i>
                      <span>Applicant</span>
                      <span class="menu-arrow arrow_carrot-right"></span>
                  </a>
                  <ul class="sub">
                      <li><a class="" href="1AppPersonalDetails.jsp">Register Applicant</a></li>
                      <li><a class="" href="aView">View</a></li>
                      <li><a class="" href="searchApplicant.jsp">Search</a></li>
                  </ul>
              </li>
          <!-- sidebar menu end-->
      </div>
  </aside>
  <!--sidebar end-->

  <!--main content start-->
  <section id="main-content">
      <section class="wrapper">            
          <!--overview start-->
          <div class="row">
            <div class="col-lg-12">
                                <h3 class="page-header"><i class="fa fa-files-o"></i>Job Form</h3>
                                <ol class="breadcrumb">
                                    <li><i class="fa fa-home"></i><a href="index.jsp">Home</a></li>
                                    <li><i class="icon_table"></i>Job </li>
                                    <li><i class="icon_document_alt"></i>Post Job</li>  
                                </ol>
            </div>
          </div>
          <!--overview end-->

          <!-- Job form -->
          <div class='row'>
          <div class="col-lg-12">
              <section class="panel">
                  <header class="panel-heading">Job</header>
                  <div class="panel-body">
                      <div class="form">
                          <form id="form" action="SaveJob" method="post" class="form-validate form-horizontal">
                              <div class="form-group ">
                                   <label class="control-label col-lg-2">Job Title <span class="required">*</span></label>
                                   <div class="col-lg-10">
                                       <input class = "form-control" name="j_title" type="text" class = "required" />
                                   </div>
                              </div>

                              <div class="form-group ">
                                  <label  class="control-label col-lg-2">Job Description <span class="required">*</span></label>
                                  <div class="col-lg-10">
                                       <!--<input  id="editor" class="form-control" data-role="editor-toolbar" data-target="#editor" rows="50" name="eventdate" type="textarea" required  />-->
                                       <!--<textarea class="form-control ckeditor" name="j_description" rows="6" placeholder="1. Venue &#10;2. Why Join Us? &#10;3. Job Responsibility &#10;4. Requirement &#10;5. Salary &#10;6. Other Benefits "required></textarea>-->
                                       <input class = "form-control" name="j_description" type="text" class = "required" />
                                  </div>
                              </div>

                              <div class="form-group ">
                                   <label class="control-label col-lg-2">Location <span class="required">*</span></label>
                                   <div class="col-lg-10">
                                       <input class = "form-control" name="j_location" type="text" class = "required" />
                                   </div>
                              </div>

                              <div class="form-group ">
                                   <label class="control-label col-lg-2">Job Type <span class="required">*</span></label>
                                   <div class="col-lg-10">
                                       <input placeholder = "Ex : Permanent" class = "form-control" name="j_type" type="text" class = "required" />
                                   </div>
                              </div>

                              <div class="form-group ">
                                   <label class="control-label col-lg-2">Employment Type <span class="required">*</span></label>
                                   <div class="col-lg-10">
                                       <input placeholder = "Ex : Full Time, Part Time" class = "form-control" name="j_empType" type="text" class = "required" />
                                   </div>
                              </div>

                              <div class="form-group ">
                                   <label class="control-label col-lg-2">Department <span class="required">*</span></label>
                                   <div class="col-lg-10">
                                       <select class="form-control m-bot15" name="d_name" required>
                                               <option value="" selected disabled>Please Select...</option>
                                               <option value="Strategic Planning and Investments">Strategic Planning and Investments</option>
                                               <option value="Islamic Religious">Islamic Religious</option>
                                               <option value="Finance">Finance</option>
                                               <option value="Information Technology">Information Technology</option>
                                               <option value="Human Resource">Human Resource</option>
                                               <option value="HR-Admin & Procurement">HR-Admin & Procurement</option>
                                               <option value="Audit Management">Audit Management</option>
                                               <option value="PR Media & CSR">PR Media & CSR</option>
                                               <option value="Legal">Legal</option>
                                               <option value="Building Management Services">Building Management Services</option>
                                               <option value="Secretarial">Secretarial</option>
                                               <option value="Risk Management">Risk Management</option>
                                       </select>
                                   </div>
                              </div>

                              <!-- button start-->
                              <div class="form-group">
                                      <div class="col-lg-offset-2 col-lg-10">
                                          <button class="btn btn-primary" type="submit">Submit</button>
                                          <!--<button class="btn btn-default" type="button">Cancel</button>-->
                                          <button class="btn btn-default" type="button" onclick="myFunction()" value="Reset form">Reset</button>
                                      </div>
                              </div>
                              <!--button end-->

                          </form>
                      </div>
                  </div>
              </section>
          </div>
          </div>
      </section>
  </section>
</section>
<!--main content end-->

<!-- javascripts -->
<script src="js/jquery.js"></script>
<script src="js/jquery-ui-1.10.4.min.js"></script>
<script src="js/jquery-1.8.3.min.js"></script>
<script type="text/javascript" src="js/jquery-ui-1.9.2.custom.min.js"></script>
<!-- bootstrap -->
<script src="js/bootstrap.min.js"></script>
<!-- nice scroll -->
<script src="js/jquery.scrollTo.min.js"></script>
<script src="js/jquery.nicescroll.js" type="text/javascript"></script>
<!-- charts scripts -->
<script src="assets/jquery-knob/js/jquery.knob.js"></script>
<script src="js/jquery.sparkline.js" type="text/javascript"></script>
<script src="assets/jquery-easy-pie-chart/jquery.easy-pie-chart.js"></script>
<script src="js/owl.carousel.js" ></script>
<!-- jQuery full calendar -->
<script src="js/fullcalendar.min.js"></script> <!-- Full Google Calendar - Calendar -->
<script src="assets/fullcalendar/fullcalendar/fullcalendar.js"></script>
<!--script for this page only-->
<script src="js/calendar-custom.js"></script>
<script src="js/jquery.rateit.min.js"></script>
<!-- custom select -->
<script src="js/jquery.customSelect.min.js" ></script>
<script src="assets/chart-master/Chart.js"></script>

<!--custom script for all page-->
<script src="js/scripts.js"></script>
<!-- custom script for this page-->
<script src="js/sparkline-chart.js"></script>
<script src="js/easy-pie-chart.js"></script>
<script src="js/jquery-jvectormap-1.2.2.min.js"></script>
<script src="js/jquery-jvectormap-world-mill-en.js"></script>
<script src="js/xcharts.min.js"></script>
<script src="js/jquery.autosize.min.js"></script>
<script src="js/jquery.placeholder.min.js"></script>
<script src="js/gdp-data.js"></script>  
<script src="js/morris.min.js"></script>
<script src="js/sparklines.js"></script>    
<script src="js/charts.js"></script>
<script src="js/jquery.slimscroll.min.js"></script>
<!-- ck editor -->
<script type="text/javascript" src="assets/ckeditor/ckeditor.js"></script>
<!-- custom form component script for this page-->
<script src="js/form-component.js"></script>
<!-- custom script for all page -->
<script src="js/scripts.js"></script>
<script>


  $(function() {
    $(".knob").knob({
      'draw' : function () { 
        $(this.i).val(this.cv + '%')
      }
    })
  });

  $(document).ready(function() {
      $("#owl-slider").owlCarousel({
          navigation : true,
          slideSpeed : 300,
          paginationSpeed : 400,
          singleItem : true

      });
  });



  $(function(){
      $('select.styled').customSelect();
  });


$(function(){
  $('#map').vectorMap({
    map: 'world_mill_en',
    series: {
      regions: [{
        values: gdpData,
        scale: ['#000', '#000'],
        normalizeFunction: 'polynomial'
      }]
    },
    backgroundColor: '#eef3f7',
    onLabelShow: function(e, el, code){
      el.html(el.html()+' (GDP - '+gdpData[code]+')');
    }
  });
});
function myFunction() {
            document.getElementById("form").reset();
        }
 $(function(){
     $("#datepicker").datepicker({ minDate: 0 });
});
</script>