java - Inserting multiple rows in mysql Db and retrieving same rows after successfully in one query store procedure -

-

table t1. want write such store procedure take array of string. insert string 1 one in t1 using loop. after 1 insertion should store id of inserted row in temp variable. , after insertion should return inserted id's.

i calling stored procedure java.

can 1 me solve problem?.

thnaks in advance.


Comments

Post a Comment

Popular posts from this blog

mysql - java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0) -

-
after validation of select combo box have selected not able insert in database. tomcat gives following error java.sql.sqlexception: parameter index out of range (1 > number of parameters, 0). how caused , how can solve it? you error when call of setxxx() methods on preparedstatement , while sql query string not have placeholders ? this. for example wrong : string sql = "insert tablename (col1, col2, col3) values (val1, val2, val3)"; // ... preparedstatement = connection.preparestatement(sql); preparedstatement.setstring(1, val1); // fail. preparedstatement.setstring(2, val2); preparedstatement.setstring(3, val3); you need fix sql query string accordingly specify placeholders. string sql = "insert tablename (col1, col2, col3) values (?, ?, ?)"; // ... preparedstatement = connection.preparestatement(sql); preparedstatement.setstring(1, val1); preparedstatement.setstring(2, val2); preparedstatement.setstring(3, val3); note parameter i...
Read more

c - ALSA programming: how to stop immediately -

-
i building audio app playback , stop features. function playaudio() playback, stopaudio() stop. expected file format wav. the main implementation of playaudio() below: playaudio() { ... ... int err = snd_pcm_open(&handle, "default", snd_pcm_stream_playback, 0); if ( err < 0 ) { printf("scm open failed: %s\n", snd_strerror(err)); exit(err); } while ( 0 < numofframes) { ... ... ssize_t frames = snd_pcm_writei(handle, &buffer[0], periodsize); ... ... } snd_pcm_drain(handle); snd_pcm_close(handle); } stopaudio() { snd_pcm_drop( m_handle ); } while audio playing back, program blocked @ line of snd_pcm_drain(handle); until playback completion. during period, expect stop audio play. action click stop button on ui , call snd_pcm_drop( m_handle ) finally. voice stopped, programm running still staying @ line of snd_pcm_drain(handle) untils several seconds later...
Read more