Example usage for org.hibernate Session delete

List of usage examples for org.hibernate Session delete

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.*
  5. Session
  6. delete

Introduction

In this page you can find the example usage for org.hibernate Session delete.

Prototype

void delete(Object object);

Source Link

Document

Remove a persistent instance from the datastore.

Usage

From source file:deletarProfessor.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.//from w  w  w .  j a  v a  2 s.co m
 *
 * @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 processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    response.setContentType("text/html;charset=UTF-8");
    try (PrintWriter out = response.getWriter()) {

        Session sessao = HibernateUtil.getSessionFactory().openSession();

        String nome = request.getParameter("nome");

        Professor prof = (Professor) sessao.get(Professor.class, nome);

        if (prof != null) {
            Transaction t = sessao.beginTransaction();
            try {
                t.begin();
                sessao.delete(prof);
                t.commit();
                out.println("Professor removido: " + prof.getNome() + " " + prof.getSobrenome());
            } catch (Exception ex) {
                t.rollback();
                out.println("Erro ao deletar prof." + ex.getMessage());
            }
        } else {
            out.println("Nao encontrei professor com nome: " + nome);
        }
        sessao.close();

    }
}

From source file:SortedMapJUnitTest.java

@Test
public void deleteCar() {
    //tworzymy obiekt
    Session session = sessionFctry.openSession();
    Transaction tx = null;/* w ww .  j a v a 2  s. c om*/
    Integer returned_id = null;

    try {
        tx = session.beginTransaction();

        TreeMap carAdditions = new TreeMap();

        carAdditions.put("Skrzana kierownica", new CarAddition("MVC239Kierownica"));
        carAdditions.put("Skrzane siedzenia", new CarAddition("Cw3GDSSiedzenia"));
        carAdditions.put("Podgrzewane lusterka", new CarAddition("OPEL23432 lustra"));
        carAdditions.put("Chromowane felgi SkullCar 321", new CarAddition("SKULLCAR321"));

        Car newCar = new Car("Opel", "Corsa Mk2", 1998, 3700, "Diesel 2.0", carAdditions);

        returned_id = (Integer) session.save(newCar);

        tx.commit();
    } catch (HibernateException e) {
        if (tx != null)
            tx.rollback();
        e.printStackTrace();
    } finally {
        session.close();
    }

    //usuwamy obiekt
    session = sessionFctry.openSession();
    try {
        tx = session.beginTransaction();

        Car car = (Car) session.get(Car.class, returned_id);
        assertNotNull(car); //sprawdzamy czy nie pusty (bo nie powinien by pusty!)
        session.delete(car);

        tx.commit();
    } catch (HibernateException e) {
        if (tx != null)
            tx.rollback();
        e.printStackTrace();
    } finally {
        session.close();
    }

    //sprawdzamy czy zosta usunity z bazy
    session = sessionFctry.openSession();
    try {
        tx = session.beginTransaction();

        Car car = (Car) session.get(Car.class, returned_id);
        assertNull(car); //powinno by puste poniewa usunelimy wczeniej ten obiekt

        tx.commit();
    } catch (HibernateException e) {
        if (tx != null)
            tx.rollback();
        e.printStackTrace();
    } finally {
        session.close();
    }

}

From source file:SortedMapJUnitTest.java

@Test(expected = IllegalArgumentException.class)
public void testDeleteCarException01() {
    //tworzymy obiekt
    Session session = sessionFctry.openSession();
    Transaction tx = null;//from   w w  w  . ja v a2s .co m
    Integer returned_id = null;

    tx = session.beginTransaction();

    TreeMap carAdditions = new TreeMap();

    carAdditions.put("Skrzana kierownica", new CarAddition("MVC239Kierownica"));
    carAdditions.put("Skrzane siedzenia", new CarAddition("Cw3GDSSiedzenia"));
    carAdditions.put("Podgrzewane lusterka", new CarAddition("OPEL23432 lustra"));
    carAdditions.put("Chromowane felgi SkullCar 321", new CarAddition("SKULLCAR321"));

    Car newCar = new Car("Opel", "Corsa Mk2", 1998, 3700, "Diesel 2.0", carAdditions);

    returned_id = (Integer) session.save(newCar);

    tx.commit();
    session.close();

    //usuwamy obiekt
    session = sessionFctry.openSession();
    tx = session.beginTransaction();

    Car car = (Car) session.get(Car.class, returned_id);
    assertNotNull(car); //sprawdzamy czy nie pusty (bo nie powinien by pusty!)
    session.delete(null);

    tx.commit();
    session.close();

    //sprawdzamy czy zosta usunity z bazy
    session = sessionFctry.openSession();
    tx = session.beginTransaction();

    car = (Car) session.get(Car.class, returned_id);
    assertNull(car); //powinno by puste poniewa usunelimy wczeniej ten obiekt

    tx.commit();
    session.close();
}

From source file:SortedMapJUnitTest.java

@Test(expected = MappingException.class)
public void testDeleteCarException02() {
    //tworzymy obiekt
    Session session = sessionFctry.openSession();
    Transaction tx = null;/*from  w  w w  . j  ava2 s  .  co  m*/
    Integer returned_id = null;

    tx = session.beginTransaction();

    TreeMap carAdditions = new TreeMap();

    carAdditions.put("Skrzana kierownica", new CarAddition("MVC239Kierownica"));
    carAdditions.put("Skrzane siedzenia", new CarAddition("Cw3GDSSiedzenia"));
    carAdditions.put("Podgrzewane lusterka", new CarAddition("OPEL23432 lustra"));
    carAdditions.put("Chromowane felgi SkullCar 321", new CarAddition("SKULLCAR321"));

    Car newCar = new Car("Opel", "Corsa Mk2", 1998, 3700, "Diesel 2.0", carAdditions);

    returned_id = (Integer) session.save(newCar);

    tx.commit();
    session.close();

    //usuwamy obiekt
    session = sessionFctry.openSession();
    tx = session.beginTransaction();

    String asd = new String("sas");
    session.delete(asd);

    tx.commit();
    session.close();

    //sprawdzamy czy zosta usunity z bazy
    session = sessionFctry.openSession();
    tx = session.beginTransaction();

    Car car = (Car) session.get(Car.class, returned_id);
    assertNull(car); //powinno by puste poniewa usunelimy wczeniej ten obiekt

    tx.commit();
    session.close();
}

From source file:HibernateCoursework.java

public void deleteEmployee(Employee deleteEmployee) {

    System.out.println("Delete Employee");

    Session hibernate = sessionFactory.openSession();
    hibernate.beginTransaction();/*  w  ww.  j  a v a  2  s.  c  o  m*/
    System.out.println("***Session started***");

    System.out.println("***Delete employee***");

    hibernate.delete(deleteEmployee);

    hibernate.getTransaction().commit();
    hibernate.flush();
    hibernate.close();
    System.out.println("***Session closed***");

}

From source file:StudentJUnitTest.java

@Test
public void usuwanieStudenta() {
    Session session = sessionFctry.openSession();
    Transaction tx = null;/*from w w w  . j av  a  2  s  .co  m*/
    Integer idTemporaryStudent = null;

    /***********************/
    /*dodaj studenta do db*/
    /**********************/
    tx = session.beginTransaction();

    Student temporaryStudent = new Student("Karol", "Marzyciel", "Malinowa 23");
    idTemporaryStudent = (Integer) session.save(temporaryStudent);

    tx.commit();
    session.close();

    /****************************/
    /*usu nowododanego studenta*/
    /****************************/
    session = sessionFctry.openSession();
    tx = session.beginTransaction();
    try {
        Student usuwany = (Student) session.get(Student.class, idTemporaryStudent);
        session.delete(usuwany);

        tx.commit();
    } catch (Exception e) {
        if (tx != null)
            tx.rollback();
        e.printStackTrace();
    } finally {

        session.close();
    }

    /******************************/
    /*sprbuj pobra tego studenta*/
    /******************************/
    session = sessionFctry.openSession();
    tx = session.beginTransaction();

    Student poszukiwany = (Student) session.get(Student.class, idTemporaryStudent); //to powinno wyrzuci wyjtek

    assertNull(poszukiwany);

    tx.commit();
    session.close();

}

From source file:DbConnectionJUnitTest.java

@Test
public void usuwanieStudenta() {
    Session session = sessionFctry.openSession();
    Transaction tx = null;//from ww w.  ja  v a  2s.  c o m
    Integer idTemporaryStudent = null;

    /***********************/
    /*dodaj studenta do db*/
    /**********************/
    tx = session.beginTransaction();

    Student temporaryStudent = new Student("Karol", "Marzyciel", "Malinowa 23");
    idTemporaryStudent = (Integer) session.save(temporaryStudent);

    tx.commit();
    session.close();

    /****************************/
    /*usu nowododanego studenta*/
    /****************************/
    session = sessionFctry.openSession();
    tx = session.beginTransaction();
    try {
        Student usuwany = (Student) session.get(Student.class, idTemporaryStudent);
        session.delete(usuwany);

        tx.commit();
    } catch (Exception e) {
        if (tx != null)
            tx.rollback();
        e.printStackTrace();
    } finally {

        session.close();
    }

    /******************************/
    /*sprbuj pobra tego studenta*/
    /******************************/
    session = sessionFctry.openSession();
    tx = session.beginTransaction();

    Student poszukiwany = (Student) session.get(Student.class, idTemporaryStudent); //to powinno wyrzuci null

    assertNull(poszukiwany);

    tx.commit();
    session.close();

}

From source file:DbConnectionJUnitTest.java

@Test(expected = IllegalArgumentException.class)
public void TestDeleteException01() {
    Session session = sessionFctry.openSession();
    Transaction tx = null;//from ww w  . j  ava2 s .co m
    Integer idTemporaryStudent = null;

    /***********************/
    /*dodaj studenta do db*/
    /**********************/
    tx = session.beginTransaction();

    Student temporaryStudent = new Student("Karol", "Marzyciel", "Malinowa 23");
    idTemporaryStudent = (Integer) session.save(temporaryStudent);

    tx.commit();
    session.close();

    /****************************/
    /*usu nowododanego studenta*/
    /****************************/
    session = sessionFctry.openSession();
    tx = session.beginTransaction();

    Student usuwany = (Student) session.get(Student.class, idTemporaryStudent);
    session.delete(null);

    tx.commit();

    session.close();

    /******************************/
    /*sprbuj pobra tego studenta*/
    /******************************/
    session = sessionFctry.openSession();
    tx = session.beginTransaction();

    Student poszukiwany = (Student) session.get(Student.class, idTemporaryStudent); //to powinno wyrzuci null

    assertNull(poszukiwany);

    tx.commit();
    session.close();

}

From source file:DbConnectionJUnitTest.java

@Test(expected = MappingException.class)
public void TestDeleteException02() {
    Session session = sessionFctry.openSession();
    Transaction tx = null;/*from   www. j a  v  a2s  .c om*/
    Integer idTemporaryStudent = null;

    /***********************/
    /*dodaj studenta do db*/
    /**********************/
    tx = session.beginTransaction();

    Student temporaryStudent = new Student("Karol", "Marzyciel", "Malinowa 23");
    idTemporaryStudent = (Integer) session.save(temporaryStudent);

    tx.commit();
    session.close();

    /****************************/
    /*usu nowododanego studenta*/
    /****************************/
    session = sessionFctry.openSession();
    tx = session.beginTransaction();

    String usuwany = new String("asd");
    session.delete(usuwany);

    tx.commit();

    session.close();

    /******************************/
    /*sprbuj pobra tego studenta*/
    /******************************/
    session = sessionFctry.openSession();
    tx = session.beginTransaction();

    Student poszukiwany = (Student) session.get(Student.class, idTemporaryStudent); //to powinno wyrzuci null

    assertNull(poszukiwany);

    tx.commit();
    session.close();

}

From source file:submitaction.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./*w ww  .j a  va  2 s. c o m*/
 *
 * @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 processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    response.setContentType("text/html;charset=UTF-8");
    PrintWriter out = response.getWriter();

    String username = (String) session.getAttribute("username");
    String dpimage = (String) session.getAttribute("dpimage");

    if (username == null)
        response.sendRedirect("login.jsp");
    else {

        String problemcode = (String) request.getParameter("q");
        String contestcode = (String) request.getParameter("c");
        String contestpath = Path.getArgPath("contests", contestcode);
        String userpath = Path.getArgPath("users", username);

        /* =========================== user not registered : redirect to index page ====================*/
        Connection con = null;
        Config c = new Config();
        int check = 0;
        Timestamp sdate = null, edate = null, ts = null;
        try {

            con = c.getcon();
            Statement stmt7 = con.createStatement();
            Statement stmt8 = con.createStatement();

            String sq = "Select count(*) as col from " + contestcode + "ranking where userid='" + username
                    + "'";
            String sq2 = "Select * from ContestInfo where contestcode='" + contestcode + "'";
            ResultSet rs8 = stmt8.executeQuery(sq2);
            if (rs8.next()) {
                sdate = rs8.getTimestamp("starttime");
                edate = rs8.getTimestamp("endtime");
            }
            java.util.Date date = new java.util.Date();
            ts = new Timestamp(date.getTime());

            //out.println(sq);
            ResultSet rs7 = stmt7.executeQuery(sq);
            if (rs7.next())
                check = Integer.parseInt(rs7.getString("col"));

        } catch (Exception e) {
        }

        if (!(ts.compareTo(sdate) > 0 && ts.compareTo(edate) < 0))
            response.sendRedirect("contestshow.jsp?c=PRACTICE");
        else if (check == 0)
            response.sendRedirect("index.jsp?register=True");
        else {
            /* ========================== get browsefile or editorfile  ==================== */

            Part filePart = null;
            String browsefile = null, ext = null, editorfile = null, language = null;
            int l = 0;
            try {
                MultipartRequest m = new MultipartRequest(request, userpath);
                filePart = request.getPart("test2");
                browsefile = (String) m.getFilesystemName("test2");

                editorfile = (String) m.getParameter("test1");

                language = (String) m.getParameter("language");

                HashMap<String, String> map = new HashMap<String, String>();
                map.put("AWK", "awk");
                map.put("Bash", "sh");
                map.put("C++", "cpp");
                map.put("C", "c");
                map.put("C#", "cs");
                map.put("Java", "java");
                map.put("Haskell", "hs");
                map.put("Perl", "pl");
                map.put("Pike", "pike");
                map.put("Python2.7", "py");
                map.put("Python3", "py");
                map.put("PHP", "php");
                map.put("Pascal", "pas");
                map.put("Ruby", "rb");
                ext = (String) map.get(language);
                l = editorfile.length();
            } catch (Exception e) {
                out.print("hi");
                out.flush();
            }

            if (l == 0 && browsefile == null) {
                //no file selected 
                response.sendRedirect("submit.jsp?q=" + problemcode + "&c=" + contestcode);
            } else {

                BufferedReader br = null;
                BufferedWriter bout = null;

                SessionFactory factory = new ConnectionProvider().getSessionFactory();
                Session s = factory.openSession();
                String id = "", st = "";
                Query q = null;
                Object[] ob = null;
                Transaction t = null;
                /* ==================== unique name : get from id table ============= */

                try {

                    st = "FROM Id id";
                    q = s.createQuery(st);
                    List<Id> users = q.list();
                    ob = users.toArray();
                    int preid = ((Id) ob[0]).getId();
                    id = "" + (preid + 1);
                    t = s.beginTransaction();
                    s.delete((Id) ob[0]);
                    s.saveOrUpdate(new Id(preid + 1));
                    t.commit();
                } catch (Exception e) {
                }

                /* ================== rename filenames and create folder and copy files in env =========== */
                //out.print(browsefile);out.flush();
                String browsefilepath = userpath + browsefile;
                String problempath = Path.getArgPath("contests", contestcode, problemcode); // for stdin.txt

                String codefilename = "Main" + id;

                //       rename procedure
                File file = new File(browsefilepath);
                // File (or directory) with new name
                File file2 = new File(userpath + codefilename + "." + ext);
                // Rename file (or directory)
                boolean success = file.renameTo(file2);

                //creating new folder for each sumission in env dir.

                String envPath = Path.getArgPath("env", codefilename);
                File dir = new File(envPath);
                if (!dir.exists()) {
                    dir.mkdir();
                }

                // copy file to env folder inside mkdir folder
                String userfilepath = userpath + codefilename + "." + ext;
                envPath = envPath + ("Main" + id + "." + ext);

                try {

                    if (editorfile.length() != 0) {
                        //out.print("this running");
                        bout = new BufferedWriter(new FileWriter(userfilepath), 10000);
                        bout.write(editorfile);
                        bout.close();

                        bout = new BufferedWriter(new FileWriter(envPath), 10000);
                        bout.write(editorfile);
                        bout.close();

                    } else {
                        br = new BufferedReader(new FileReader(userfilepath));
                        bout = new BufferedWriter(new FileWriter(envPath), 10000);
                        String line = "";
                        while ((line = br.readLine()) != null) {
                            bout.write(line + "\n");
                            bout.flush();
                        }
                        bout.flush();
                        bout.close();
                        br.close();
                    }

                } catch (Exception e) {
                }

                /* ======================= Running judge now  | ranking update  | status update ============ */

                // out.print((String)m.getParameter("language"));out.flush();
                Problems now = null;
                Date d = null;
                try {
                    st = "FROM Problems S WHERE S.problemcode='" + (String) request.getParameter("q") + "'";
                    q = s.createQuery(st);
                    List<Problems> ques = q.list();
                    ob = ques.toArray();
                    now = (Problems) ob[0];
                    d = new Date();
                    //out.print(now.toString());out.flush();

                } catch (Exception e) {
                    out.print("msg1=" + e.getMessage());
                }

                try {
                    Timestamp tmp = new Timestamp(d.getTime());

                    //out.println(language);
                    Q queue = new Q(codefilename, username, language, ext, problempath, "unjudge",
                            Double.parseDouble(now.getTimelimit()), "null", tmp, 0, 0, contestcode, 0,
                            problemcode, now.getTestfiles());
                    //do the judge work ;
                    t = s.beginTransaction();
                    s.saveOrUpdate(queue);
                    t.commit();
                } catch (Exception ex) {
                    out.print("msg2=" + ex.getMessage());
                } finally {
                    s.close();
                    factory.close();
                }

                // Show exit code of process
                //         out.println("Procefdsfdsfdsss exited with code = ");
                try {

                    //judge the solution         
                    //out.print("judge process starts "); out.flush();
                    final String[] cmd = { "/bin/bash", "-c", "cd " + Path.getPath() + " ; python judge.py" };
                    Runtime.getRuntime().exec(cmd);
                    //p.waitFor();

                    // inner class to run process without wait  outside main thread
                    /*  new Thread(new Runnable() {
                           public void run() {
                             try
                             {
                                 Runtime.getRuntime().exec(cmd);
                                 //p.waitFor();
                             }catch(Exception e){}
                       }
                     }).start(); 
                            
                    */
                    String problemid = (String) request.getParameter("q");
                    response.sendRedirect(
                            "status.jsp?q=" + problemid + "&c=" + contestcode + "&code=" + codefilename);
                    /* int chk = 0;   
                     while(chk == 0)
                     {
                            Thread.sleep(1);   
                            String query="Select count(*) as ch , status from " + contestcode+"submissions where username='"+username + "' and codefilename='"+codefilename+"'";
                            //out.println(query);
                                   
                            String pid = ""+problemid.charAt(problemid.length()-1);
                            //out.println(query);
                            ResultSet rs = stmt.executeQuery(query);
                            if(rs.next()){
                                chk = Integer.parseInt(rs.getString("ch"));
                                if(chk == 0)
                                 continue;
                                        
                                out.print("<style>#loading{visibility: hidden;</style>");              
                                out.println(rs.getString("status"));
                                        
                                if(rs.getString("status").compareTo("Accepted")==0)
                                {
                                    String sq = "Select * from "+contestcode+"ranking where userid='"+username+"'";
                                    //out.println(sq);
                                    ResultSet rs6 = stmt6.executeQuery(sq);
                                    if(rs6.next())
                                    {
                                        //out.println("hhhdsffsdkbhn");
                                        if(rs6.getString(pid+"score").compareTo("0") == 0)
                                        {
                    query = "UPDATE "+contestcode+"ranking SET "+pid+"score=100.0, "+pid+"time="+tc+" where userid='"+username+"'"; 
                    //out.println(query);
                    stmt2.executeUpdate(query);
                                        }
                                    }
                                }
                                else{
                                    String sql = "Select * from "+contestcode+"ranking where userid='"+username+"'";
                                    //out.println(sql);
                                    ResultSet rs3 = stmt2.executeQuery(sql);
                                    if(rs3.next())
                                    {
                                        //out.println("hhhdsffsdkbhn");
                                        if(rs3.getString(pid+"score").compareTo("0") == 0)
                                        {
                    int penalty = Integer.parseInt(rs3.getString(pid+"penalty"));
                    penalty += 1;
                    query = "UPDATE "+contestcode+"ranking SET "+pid+"penalty="+penalty+" where userid='"+username+"'";
                     //out.println(query);
                    stmt3.executeUpdate(query);
                                        }
                                    }
                                                
                                }
                                        
                                String sql = "Select * from "+contestcode+"ranking where userid='"+username+"'";
                                ResultSet rs5 = stmt5.executeQuery(sql);
                                //out.println("hi"+nop);
                                int total_penalty = 0;
                                Double total_score=0.0;
                                long total_time = 0;
                                char ch='A';
                                if(rs5.next())
                                {
                                    //out.println(rs5.getString("Apenalty"));
                            
                                    for(int i=0;i<nop;i++,ch++)
                                    {
                                        //out.println(ch);
                                        total_penalty += Integer.parseInt(rs5.getString(ch+"penalty"));
                                        total_score += Double.parseDouble(rs5.getString(ch+"score"));
                                        total_time += Long.parseLong(rs5.getString(ch+"time"));
                                        //out.println(total_penalty+" "+total_score+" "+total_time);
                                    }
                                    //out.println("hello");
                                    total_time += total_penalty * 20000*60;
                                    //Timestamp nt = new Timestamp(total_time);
                                    query = "UPDATE "+contestcode+"ranking SET penalty="+total_penalty+", score="+total_score+", time="+total_time+" where userid='"+username+"'";
                                    //out.println(query);
                                    stmt4.executeUpdate(query);
                                    out.flush();
                                }
                            }
                     }//while
                    */
                    con.close();
                    //  response.sendRedirect("index.jsp");
                } catch (Exception e) {
                } finally {
                    out.close();
                }

                /*
                        
                    out.print("<style>#loading{visibility: hidden;</style>");
                }
                          
                */
            }
        } //inner else due to sendRedirect
    } //else due to sendRedirect
}