plz let me know how to insert multiple values from the form for the single database column..below i have used query for the single values for the single database coulumn and its working...but how to insert multiple values in a database at a one time.

Statement s=conn.createStatement();

Code = request.getParameter("code");
Description = request.getParameter("Description");//takes values from forms
Dr_Amount=request.getParameter("DrAmount");
Cr_Amount=request.getParameter("CrAmount");
Type = request.getParameter("type");
Pct=request.getParameter("pct");

sql1 = "insert into gl_mast values (" + "'" + Code + "', '" + Description + "' , '" + Dr_Amount + "', '" + Cr_Amount + "', '" + Type + "', '" + Pct + "')" ;
s.executeUpdate(sql1);


sql = conn.prepareStatement("SELECT * FROM gl_mast WHERE gl_code = '" + Code + "'");

Hi abhit
     i am charith this is my first post at p2p .I am sure that i can help u with this if you provide me some details .Some part of u'r quection is not clear. Tell me your requirmant suerly i will help
by the way i have included the method i use for a single insertion in database.

Normally i use like this

   Connection con;
   PreparedStatement prst=null;
   con = ConnectionManager.getConnection(this);
   String sSql = "INSERT INTO employee(emp_no, emp_fname, emp_mname, emp_sname, emp_address,phoneno)VALUES (?,?,?,?,?,?)";

 prst.setString(1, getEmployeeNo());
 prst.setString(2, getEmpoyeeFName());
 prst.setString(3, getEmpoyeeMName());
 prst.setString(4, getEmpoyeeLName());
 prst.setString(5, getEmpoyeeAddress());
 prst.setInt(6, getEmpoyeeTel().intValue());
 prst.executeUpdate();


bye
Charith
 :)

can u help me in my code..

what would be changes has to be made..

For multiple row entries in a single SQL query, it usually looks something like this:

sql1 = "INSERT INTO gl_mast VALUES('name', 'address', 'zipcode'),
('name2', 'address2', 'zipcode2')
('name3', 'address3', 'zipcode3')";

You could use a loop to build the SQL string, then submit it to the database.

d-