What is query in my sql to delete multiple records?

Question

//this is my query for single deletion of record.
  public void deleteEmpDetails(int emp_Id){
         String sql="delete from EmpDetails where emp_Id="+emp_Id;
         JdbcTemplate jdbcTemplate=new JdbcTemplate(dataSource);
         jdbcTemplate.update(sql);
     }

Will u please tell me wat is query for multiple rows deletion.Please give me the solution.

Use a predicate (read: WHERE) condition that matches multiple records .. and for the love of all programmers, please [use a prepared statement / placeholder](http://stackoverflow.com/questions/621884/database-development-mistakes-made-by-application-developers/621891#621891). — user2864740, Aug 19 '15 at 10:03

Priyank · Answer 1 · 2015-08-19T10:11:28.303

0

Try this Code,

  public void deleteEmpDetails(int emp_Id){
         String sql="delete from EmpDetails where emp_Id IN "+emp_Id;
         JdbcTemplate jdbcTemplate=new JdbcTemplate(dataSource);
         jdbcTemplate.update(sql);
  }

edited Aug 19 '15 at 10:11

answered Aug 19 '15 at 10:03

Priyank

1,009
12
35

where are you using input parameter to the method? – Ravinder Reddy Aug 19 '15 at 10:05
I need take emp_Id entered dynamically? – mamata yadav Aug 19 '15 at 10:08
is `emp_Id` is `array`...?? – Sagar Naliyapara Aug 19 '15 at 10:10
than what type of multiple record you want to delete other than emp_Id?? – Priyank Aug 19 '15 at 10:12

score 0 · Answer 2 · answered Aug 19 '15 at 10:04

0

delete from EmpDetails where emp_Id in (1, 2, ...)

answered Aug 19 '15 at 10:04

pkalinow

1,619
1
17
43

What is query in my sql to delete multiple records?

2 Answers2