save(), saveOrUpdate(), persist() in Hibernate

Introduction In this tutorial we will discuss about the differences among save(), saveOrUpdate() and persist() method in leading ORM(Object Relational Mapping) tool Hibernate framework. The key thing is all these methods are used to store object(s) into database and they also make transient object(s) into persistent. Hibernate framework’s Session class provides a few ways to save objects by methods save(), saveOrUpdate() and persist() based on requirements for persisting objects into database.

Continue

Delete Multiple Table Rows from Server using Angular 9

Introduction In this tutorial we will see how to delete multiple rows from HTML table as well as from database server at one go. We have seen tutorial how to display data from server to client side and how to select multiple rows on HTML table. We will put checkbox against each row on the table so that user will be able to select a particular row for deletion. We will also put a checkbox on the table header and selecting this checkbox all rows on the table will be…

Continue

Delete Multiple Rows from Table using PHP, MySQL, AJAX, jQuery

Introduction In this tutorial we will see how to delete multiple rows from table using PHP, MySQL, AJAX, jQuery. We are going to delete rows from HTML as well as MySQL database table. We will use IN clause with WHERE condition in MySQL query to delete multiple rows from database table. We will put checkbox against each row on the table so that user will be able to select a particular row for deletion. We will also put a checkbox on the table header and selecting this checkbox all rows on the table will…

Continue

Spring Data JPA IN Clause Example with WHERE Condition

Introduction In this example we will see how to work with IN clause with WHERE condition in SQL statement in Spring Data JPA. We will use MySQL server for this example. We will fetch selected rows or multiple rows selection as well as we will delete selected rows or multiple rows deletion from the table using IN operator with WHERE clause. We will use Spring transaction because we want to rollback our changes from database if any issue occurs during row deletion. The IN operator allows us to specify multiple…

Continue

Delete Multiple Rows from Table using Flask, AJAX, jQuery, MySQL

In this tutorial we build an application using Python based Flask framework to fetch all products from MySQL database and display on the HTML table. This example is all about to delete multiple rows from HTML as well as database tables. We will use IN clause with WHERE condition in MySQL query to delete multiple rows from database table. We will put checkbox against each row on the table so that user will be able to select a particular row for deletion. We will also put a checkbox on the…

Continue

How to delete multiple rows from table using Codeigniter, AJAX, jQuery, MySQL

Introduction In this tutorial we build an application using Codeigniter framework to fetch all the products from MySQL database and display on the HTML table. We will put checkbox against each row on the table so that user will be able to select a particular row for deletion. We will also put a checkbox on the table header and selecting this checkbox all rows on the table will be selected for deletion. We are using jQuery to check or check the checkbox. If user selects manually all checkboxes for rows…

Continue

jQuery AJAX based Voting or Rating System using Flask and MySQL

Introduction In this post we will see how to create voting or rating system using Flask, MySQL and AJAX. We post tutorials, articles or blogs either on our own blog site or as a guest user to other sites. Sometimes we need to let user rate on our tutorials or articles or blogs so that we know how much that blog is famous or how much that blog is intended to be accepted by readers. In this example I have given one sample content on which you can rate this.…

Continue

How to work with IN, OUT and INOUT Parameters in Stored Procedures using Spring Data JPA

Introduction In this tutorial we will see how to work with IN, OUT and INOUT parameters in Stored Procedure using Spring Data JPA. We will also call a stored procedure having no parameter at all. I am going to use MySQL server, so there may be some limitations on MySQL server or there may be some limitations on Spring Data JPA itself on calling the stored procedure but I will at least show you the work around how to call stored procedures in different ways depending upon the type of…

Continue

Spring Boot MVC and Hibernate CRUD Example

Introduction In this tutorial we will create an example on Spring Boot MVC and Hibernate CRUD. CRUD is an acronym that means Create, Read, Update and Delete operations. In my other tutorial I had also created Spring Boot MVC and JDBC CRUD Example. We will build the tutorial example using both maven and gradle build tools. We will create the annotation based hibernate configuration with Spring Boot framework. We are going to use MySQL database as a persistence storage for our application.

Continue

How to deploy Python Flask MySQL based application in Heroku Cloud

Introduction In this example I will show you thorough example on how to deploy Python Flask MySQL based application in Heroku Cloud. I will use free account to use the cloud services from Heroku. I will show you how to import existing MySQL database into Heroku. I will also tell how to turn on/off the app in maintenance mode. I will use the existing application written on Python Flask and MySQL database is used to store data for the application.

Continue