Storing multiple values in the Database.

[Pandurang Shenoy]

Hello all,
I am making use of a parameter in JSP that has multiple values(say 3 different values). I want to store all the values of that parameter in the DataBase under a single column.How can i do that..?If you know,please let me know..
Regards
Pandurang

[Chris Baron]

Hi,
given an existing Connection con

String[] arr = request.getParameterValues("parameterGroup");
for( int i = 0; i < arr.length; i++ )
{
Statement stm = con.createStatement();
        stm.execute("INSERT INTO table ( GRUPCOL ) VALUES ("[B] + arr[i] + [/B]") ");
        stmt.close();
}

i didn't test it, but it should work
cb

[Rajeshwari Natarajan]

But by Christian Baron's code u'll be trying to execute multiple insert statements.
Create a delimiter separated string with all the values u want to insert and then call an insert statement.
[ April 03, 2003: Message edited by: Rajeshwari Natarajan ]

[Andy Bowes]

If you are going to use the SQL statement many times but with different values you should really use a PreparedStatement rather than a statement. It is a lot faster as the DB doesn't need to re-parse the SQL statement.
Example shown below:

String[] arr = request.getParameterValues"parameterGroup");
PreparedStatement stm = con.prepareStatement("INSERT INTO table ( GRUPCOL ) VALUES (?)");
for( int i = 0; i < arr.length; i++ ){
stm.setString(1, arr[i]);
        stm.executeUpdate();
}
stm.close();

[Chris Baron]

Aaah,
i was allways wondering what PreparedStatement was good for. Learned something.
thx Andy

[Pandurang Shenoy]

Thanx to all for replying to my Qn..