public Boolean doCreateBatch(List<Emp> values) throws Exception

{

    try

    {

        String sql = " INSERT INTO emp(empno,ename,job,hiredate,sal,comm) VALUES "

                + " (?,?,?,?,?,?) ";

        this.conn.setAutoCommit(false);

        PreparedStatement stmt =  this.conn.prepareStatement(sql);

        for(Emp emp : values)

        {

            stmt.setInt(1, emp.getEmpno());

            stmt.setString(2, emp.getEname());

            stmt.setString(3, emp.getJob());

            stmt.setDate(4, new java.sql.Date(emp.getHiredate().getTime()));

            stmt.setDouble(5, emp.getSal());

            stmt.setDouble(6, emp.getComm());

            stmt.addBatch();

        }

        System.out.println("before executing batch...");

        stmt.executeBatch();

        this.conn.commit();

        System.out.println("after batch executed!");

        this.conn.setAutoCommit(true);

        return true;

    }

    catch(Exception e)

    {

        throw e;

    }

}