spv03

package com.inventory.servlet; pst=con.prepareStatement("insert into onscreen_record (add_name, price, zone, cinema, audi, priority, start_date, end_date, length_min, length_sec, client_detail)values(?,?,?,?,?,?,?,?,?,?,?)"); System.out.println(audi); pst.setString(1,add); pst.setString(2,price); pst.setString(3,"ok"); pst.setString(4,cinema[0]); for (int x=0;x<audi.length;x++){ pst.addBatch(); pst.setString(5,audi[x]); } pst.setString(6,position); pst.setString(7,sdate); pst.setString(8,edate); pst.setString(9,min); pst.setString(10,sec); pst.setString(11, client); pst.executeUpdate();

Hello guys, I am working on a project that deals with a store. but here is my problem i am having problem inserting multiple record into the database instead my code is summing it up. Can anyone give me an idea on how to insert multiple record into a database. …