JSP with JDBC

[jith87]

How do you get the values from the controls in a JSP page to the code in JDBC so that it can be stored in MySql database?

[jith87]

What command will you use to get the values from controls (for eg.... text box, check box, list box) in a JSP page to the JDBC code so that they can be stored in MySql database?

[dmjpro]

What command will you use to get the values from controls (for eg.... text box, check box, list box) in a JSP page to the JDBC code so that they can be stored in MySql database?

Have a look at this code.

void storeValueIntoDatabase(HttpServletRequest request)
{
 String value1 = request.getParameter("control1");
 .
 .
 String value_n = request.getParameter("control_n");
 String database_url = ""; //your database url
 String insert_query = ""; //your insert query
 Class.forName("driver_class");
 Connection con = DriverManager.getConnection(database_url,"user_name","password");
 Statement st = con.createStatement();
 st.executeUpdate(insert_query);
 con.commit();
}
 

Good Luck :-)

Kind regards,
Dmjpro.

[JosAH]

How do you get the values from the controls in a JSP page to the code in JDBC so that it can be stored in MySql database?

You should've asked your question in the Java Forum section, not in the Java
Articles section. I'll move your question for you.

kind regards,

Jos

[jith87]

Have a look at this code.

void storeValueIntoDatabase(HttpServletRequest request)
{
 String value1 = request.getParameter("control1");
 .
 .
 String value_n = request.getParameter("control_n");
 String database_url = ""; //your database url
 String insert_query = ""; //your insert query
 Class.forName("driver_class");
 Connection con = DriverManager.getConnection(database_url,"user_name","password");
 Statement st = con.createStatement();
 st.executeUpdate(insert_query);
 con.commit();
}
 

Good Luck :-)

Kind regards,
Dmjpro.

Thanx....I understood it.. What i want to know now is "Is the same function being used for all the controls?"

[r035198x]

Thanx....I understood it.. What i want to know now is "Is the same function being used for all the controls?"

For array types you use getParameterValues.
Which control do you want specifically?

[dmjpro]

Thanx....I understood it.. What i want to know now is "Is the same function being used for all the controls?"

Have a look at this.

<input value = "some_value1" name = "same_name">
<input value = "some_value2" name = "same_name">
<input value = "another_value" name = "another_name">
 

String value1 = request.getParameter("same_name");
//it will retrieve first one, means some_value1
String value2[] = request.getParameterValues("same_name");
//it will retrieve the array of values
 

So you can call both for any, means for single named control or multiple named controls. It does not matter.

Kind regards,
Dmjpro.