delete row using id
package pkg2;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
public class NewClass3
{
public static void main(String[] args) {
// TODO Auto-generated method stub
Session sess = null;
try {
SessionFactory fact = new
Configuration().configure().buildSessionFactory();
sess = fact.openSession();
org.hibernate.Transaction tx = sess.beginTransaction();
String hql = "delete from Insurance insurance where id = 2";
Query query = sess.createQuery(hql);
int row = query.executeUpdate();
if (row == 0){
System.out.println("Doesn't deleted any row!");
}
else{
System.out.println("Deleted Row: " + row);
}
tx.commit();
sess.close();
}
catch(Exception e){
System.out.println(e.getMessage());
}
}
}
this is the code m using .
Error is -query must begin with SELECT or FROM: delete [delete from pkg2.Insurance insurance where id = 2]
View Answers
Ads
Related Tutorials/Questions & Answers:
delete row using id
delete row using id package pkg2;
import org.hibernate.Query;
import... = "
delete from Insurance insurance where
id = 2";
Query query = sess.createQuery...:
delete [
delete from pkg2.Insurance insurance where
id = 2
Delete a row from database by id
Delete a
row from database by id I m creating a small application
using servlet.
There is a form (index.jsp)having 10 fields on submitting the form...) for "
DELETE" AND "UPDATE".
On clicking
delete which is hyper link that particular
row
Advertisements
delete multiple row using checkbox
delete multiple
row using checkbox
delete multiple
row using...) Create delete.jsp
<%@page import="java.sql.*"%>
<%String
id[]= new String[10];
for(int i=0;i<10;i++){
id[i]=request.getParameter("check"+i
delete row from a table using hibernate
delete row from a table
using hibernate //code in java file
String hql="
delete from CONTACT c where
ID=6";
Query query=session.createQuery... [
delete from CONTACT]
int i=query.executeUpdate
delete row
delete row how to
delete row using checkbox and button in php...[]" value="<?php echo $
row['
id'];?>"></td>
<td><?php echo...
if(isset($_POST['
delete']))
{
for($i=0;$i<$
row;$i++)
{
$
delete
sqlite database delete row
sqlite database
delete row How to
delete row from SQLite Database?
NSString *updateSQL = [NSString stringWithFormat: @"
DELETE FROM aListDB WHERE
id='%@'",details.ids
row_id
row_id sir i have created a table my_table with two rows n two column with smillar name in each cell without any primary key , how can i change the first
row and third column's name in sql server 2005 , kindly send me the query
row_id
row_id sir i have created a table my_table with two rows n two column with smillar name in each cell without any primary key , how can i change the first
row and third column's name in sql server 2005 , kindly send me the query
uitableview manually delete row
uitableview manually
delete row uitableview manually
delete row
NSMutableIndexSet *indexes = [NSMutableIndexSet indexSet];
[array removeObjectAtIndex:indexPath.row];
if(![array count])
[indexes addIndex
JDBC: Delete Record using Prepared Statement
JDBC:
Delete Record
using Prepared Statement
In this section, we will discuss how to
delete row of a table
using Prepared Statements.
Delete Record ... statement.
You can
delete any specific record under some condition
using WHERE
JDBC ResultSet Delete Row Example
JDBC ResultSet
Delete Row Example:
Learn how to
delete row using ResultSet. We....
6. Finally call deleteRow() ResultSet method for
delete the current
row form...;
In this example we are deleting
row that have user_
id == 1.
Now we will run
JDBC Delete Row In Table Example
JDBC
Delete Row In Table Example :
In this tutorial we will learn how
delete... or more specific
row delete from
table that follow any given condition...
Mysql query "
DELETE FROM user where user_
id=1 "
Delete Query using HQL
Delete Query
using HQL Can we write 'AND' with 'WHERE' clause in
delete query
using HQL?
For example:
delete from table name
where field1... is
"
delete from table where field1 = 'value1' and field2 = 'value2'.
Have
Delete row and column from table through java code
will
delete the
row having minimum
value of
ID then
delete the column named...
Delete row and column from table through java code... will see how to
delete row and
column from given table through java code. Java code
How to delete objects using Hibernate?
How to
delete objects
using Hibernate? Hi,
How to
delete objects
using Hibernate? I want to
delete an object (record) in table.
Thanks
Hi,
Hibernate Session API provides function to
delete object.
For deleting
Shifting Row Using JSP
Shifting
row using JSP
In this program we are going to shift the
row using
java... up. The starting
row is 5 and end
row is 10 and
which will be shifted up 5 rows
Printing Session Id Using Variable
Printing Session
Id Using Variable Hi,
I am a learner in PHP language. Could any one guide me, how to print session
Id using variable in PHP.
Thanks
SQL Server row comparison using two tables
SQL Server
row comparison
using two tables insertion process are completed in table1.string comparison
using table2 to table1 if any changes in these tables and then upadated
Delete and edit data in xml file using JSP
in the xml file,I want to
delete and edit some tasks
using task
id then how can i do...
Delete and edit data in xml file
using JSP I want to know how... TASK
ID(Enter taskid to
delete) and it will
delete that
id and relatd other