java - How to insert multiple records generated by select group by query -

java - How to insert multiple records generated by select group by query -

the actual sql query generates result based on practicecode , count.as contains multiple rows ,i not able insert database using insert query.please help me this..??

query

select practicecode,count(id) ccr empi_ccr_export_preview delflag=0 grouping practicecode

code

public void doinsertdata2(httpservletrequest request,httpservletresponse response, resultset rs92, resultset rs102,resultset rs112) { seek { while(rs9.next()&& rs10.next()&& rs11.next()) { integer t1=integer.parseint(rs9.getstring("practicecode")); integer t2=integer.parseint(rs9.getstring("ccr")); integer t3=integer.parseint(rs10.getstring("optinpracticecode")); integer t4=integer.parseint(rs10.getstring("lab")); integer t5=integer.parseint(rs11.getstring("sourcepracticecode")); integer t6=integer.parseint(rs11.getstring("doc")); seek { seek { class.forname("com.mysql.jdbc.driver"); } grab (classnotfoundexception e) { e.printstacktrace(); } connection3 = drivermanager.getconnection("driver details"); string query = "insert practice_count (community_id,practice_code,ccrcount,labcount,doccount) values (?,?,?,?,?)"; preparedstatement preparedstmt = connection3.preparestatement(query); preparedstmt.setint(1, 101); preparedstmt.setint(2, t1); preparedstmt.setint(3, t2); preparedstmt.setint(4, t4); preparedstmt.setint(5, t6); preparedstmt.execute(); } grab (exception e) { system.err.println("duplicate entry found"+e); } }

try , preparedstmt.executeupdate();

java mysql