combo box in JavaScript and store the combo box values into database

Dear sir,

By your information, i am able to retrieve but not able to store into database ,

i will show you the codings, please give your valuable suggestions

<%

String s1=(String)session.getAttribute("eid");

String s3[]=request.getParameterValues("language");

int j=0;

try {

for (int i = 0; i < s3.length; i++)

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:langskill");

PreparedStatement pStmt = con.prepareStatement("update lang set(language) values (?) where eid=? ");

// pStmt.setString(2, s3);

pStmt.setString(1, s1);

pStmt.execute();

}

}

catch(Exception e)

{

System.out.println(e);

}

%>

<%

if(j>0)

{

%>

datas are updated

<%

}

else

{

%>

datas are not updated

<%

}

%>

senthil_yogaa at 2007-7-12 3:02:33 >

thank you a lot sir for ur valuable suggestions,

i have changed my codings but still i am not able to store, i will show the

codings, please give ur valuable suggestions soon as possible sir !!!!

<%

String s1=(String)session.getAttribute("eid");

String s3[]=request.getParameterValues("language");

int j=0;

//int i=0;

try {

for (int i = 0; i < s3.length; i++)

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:langskill");

PreparedStatement pStmt = con.prepareStatement("update lang set language='" + s3[i] + "' where eid=" + s1+"");

pStmt.setString(1, s1);

pStmt.executeUpdate();

}

}

catch(Exception e)

{

System.out.println(e);

}

%>

<%

if(j>0)

{

%>

<%=(String)session.getAttribute("ename")%>

datas are updated

<%

}

else

{

%>

<%=(String)session.getAttribute("ename")%>

datas are not updated

<%

}

%>

senthil_yogaa at 2007-7-12 3:02:33 >

Thank you for your valuable suggestions.....

i have applied as you said , its not showing any error but the datas

are not updated and i am getting the message in the next jsp page as not updated...

i will show you the codings as what i have did

<%

String s1=(String)session.getAttribute("eid");

String s3[]=request.getParameterValues("language");

int j=0;

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:langskill");

PreparedStatement pStmt = con.prepareStatement("update lang set language= ? where eid=" + s1+"");

for (int i = 0; i < s3.length; i++)

{

pStmt.setString(1, s3[i]);

pStmt.executeUpdate();

}

}

catch(Exception e)

{

System.out.println(e);

}

%>

<%

if(j>0)

{

%>

<%=(String)session.getAttribute("ename")%>

datas are updated

<%

}

else

{

%>

<%=(String)session.getAttribute("ename")%>

datas are not updated

<%

}

%>

senthil_yogaa at 2007-7-12 3:02:33 >

>are not updated and i am getting the message in the next jsp page as not updated...

Obviously you'll get the message as not updated, you're not changing the value of 'j'. You initialize it to 0 and then check whether or not it's zero. It's value is not being modified anywhere.

And are you sure you're not getting any exceptions? With System.out.println(), they'll get printed in your server logs. With Tomcat, it'll be in stdout.txt under the logs folder.

And if you really aren't getting any errors, then there is no record in your database that has the value of eid that s1 has.

Also, you're getting 'language' from a combo-box right? Is it multiple select? Or a drop-down? Because if it's a drop down, there is no point in using getParameterValues(), you'll get a single value only. So you might as well use getParameter().

And secondly, if you are getting multiple values, what is the point of the SQL update? You'll just overwrite the language attribute for eid = s1 multiple times and will always end up with just one value, the absolute last one that you get.

Your code has more than one problems. I think you need to rethink what you're trying to do and also maybe brush up on JDBC basics.

nogoodatcodinga at 2007-7-12 3:02:34 >

Dear sir,

can you please help me in solving this , please sir........

How to select a particular data from database .........

i will show you the codings .....please refer it

<%@page import="java.sql.*" %>

<%@page import="java.io.*" %>

<%

String s2=request.getParameter("language");

%>

<%

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:langskill");

PreparedStatement pr=con.prepareStatement("select eid from lang where language =?");

pr.setString(2,s2);

// pr.setString(1,eid);

ResultSet rs=pr.executeQuery();

if(rs.next())

{

out.println("the employees are "+eid);

}

}

catch(Exception e)

{

System.out.println(e);

}

//rs.close();

%>

not found

<a href="search.jsp"><h4>Back</h4></a>

</body>

</html>

senthil_yogaa at 2007-7-12 3:02:34 >

Dear sir,

i able to update only a single data , but i am sending only through array (pStmt.setString(1, s3);) ,

but still other data's are not updating.....

i will show u the code ...please provide ur valuable suggestionss

<%@page import="java.lang.*" %>

<%@page import="java.sql.*" %>

<%@page import="java.io.*" %>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

</head>

<body >

<center><h4><u> Employee Assessment Application</u></h4></center>

<%

String s1=(String)session.getAttribute("eid");

String s3[]=request.getParameterValues("language");

int i=0;

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:langskill");

PreparedStatement pStmt = con.prepareStatement("update lang set language=? where eid=" + s1+"");

for ( i = 0; i < s3.length; i++)

{

pStmt.setString(1, s3[i]);

pStmt.executeUpdate();

out.println(s3[i]);

}

}

catch(Exception e)

{

System.out.println(e);

}

%>

<%

if(i>0)

{

%>

<%=(String)session.getAttribute("ename")%>

datas are updated

<%

}

else

{

%>

<%=(String)session.getAttribute("ename")%>

datas are not updated

<%

}

%>

senthil_yogaa at 2007-7-12 3:02:34 >

Dear sir,

thank u for spending ur precious moments for me.....

how can i use insert query for a particular employee....

i think ,only thru update we update data for a particular employee

please refer this, and help me sir......

<%

String s1=(String)session.getAttribute("eid");

String s3[]=request.getParameterValues("language");

int i=0;

//int j=0;

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:langskill");

PreparedStatement pStmt = con.prepareStatement("insert into lang(language) values(?) ");

pStmt.setString(1, s3[i]);

pStmt.executeUpdate();

}

catch(Exception e)

{

System.out.println(e);

}

%>

senthil_yogaa at 2007-7-12 3:02:34 >