Insertion into database
Hi,
I need code for inserting the multiple select box values into database.Please do send me the code.
Thanks for ur immediate replies its helping a lot.
View Answers
April 12, 2011 at 3:31 PM
1)selectmultiple.jsp:
<html>
<form method="post" action="insertmultiple.jsp">
<pre>
Select Languages <select name="sel" multiple>
<option value="English">English</option>
<option value="Hindi">Hindi</option>
<option value="French">French</option>
<option value="German">German</option>
<option value="Chinese">Chinese</option>
</select>
<input type="submit" value="submit">
</pre>
</form>
</html>
2)insertmultiple.jsp:
<%@page import="java.sql.*"%>
<%
String languages="";
String lang[]=request.getParameterValues("sel");
for(int i=0;i<lang.length;i++){
languages+=lang[i]+" ";
}
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
Statement st=con.createStatement();
int i=st.executeUpdate("insert into student(languages) values('"+languages+"')");
out.println("Data is successfully inserted into database.");
}
catch(Exception e){
System.out.println(e);
}
%>
Ads
Related Tutorials/Questions & Answers:
Insertion into database
Insertion into database Hi,
I need code for inserting the multiple select box values into database.Please do send me the code.
Thanks for ur immediate replies its helping a lot
Advertisements
insertion sort
insertion sort write a program in java using
insertion sort
insertion sort
insertion sort write a program in java using
insertion sort
insertion sort
insertion sort write a program in java using
insertion sort
insertion sort
insertion sort write a program in java using
insertion sort
insertion sort
insertion sort how many arrays needed for
insertion sort and why
Insertion Sort Applet
Insertion Sort Applet I need
Insertion Sort Applet code was design by Dr. Daniel Liang
Please
Insertion Sort Timer
Insertion Sort Timer Welcome all
I wanna program in java find the timer of
insertion sort and find time complexity for random value
thanks all
Java insertion sort question
Java
insertion sort question I've got another program that I need help with. I am trying to write a Java method that accepts an array of strings, and sorts the strings using the
insertion sort algorithm. Then I need to write
Insertion Sort Problem
Insertion Sort Problem So I have this in a class file. It is supposed to be an
insertion sorter:
int min, index=0, temp;
for(int i=0;i<sorted.length;i++){
min=sorted[i];
for(int j=i+1;j<
PHP SQL Insertion
PHP SQL
Insertion
PHP SQL
Insertion is used to execute MySQL queries in PHP script....
Understand with Example
The Tutorial illustrate an example from 'PHP SQL
Insertion
dynamic delete and insertion in tables
dynamic delete and
insertion in tables hey... i have a problem..I am working on a problem management system..my code for a particular jsp page is as follows in this page i want to show the admin the already present records
dynamic delete and insertion in tables
dynamic delete and
insertion in tables hey... i have a problem..I am working on a problem management system..my code for a particular jsp page is as follows in this page i want to show the admin the already present records
data insertion and fetch 1
data
insertion and fetch 1 @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type
database
database the code for initializing the
database connection
database
database i want to let the user select the name of
database and then delete that
database.......im doing project in swings netbeans
database
database use of hyperlink to show the data from
database
database
database i need to insert time in my
database. i need a code to insert time in my
database. its very urgent
database
database im doing my project in netbeans swings...wn a user wants to create a
database from the gui...i want to display an error msg if a
database with that name already exists and if it does not exist new
database should
database
database tell me use about
database and give me a small program.
It is secure and can easily be accessed, managed, and updated. Moreover... links:
Connect JSP with
database Mysql
Connect Java with
database Mysql
database
database tell me use about
database and give me a small program.
It is secure and can easily be accessed, managed, and updated. Moreover... links:
Connect JSP with
database Mysql
Connect Java with
database Mysql
database
database tell me use about
database and give me a small program.
It is secure and can easily be accessed, managed, and updated. Moreover... links:
Connect JSP with
database Mysql
Connect Java with
database Mysql
database
database I wanted to know if it is possible to create a
database in mysql by letting the user enter the name of the
database in swing gui..im doing my project in netbeans...Thank You
database
database I wanted to know if it is possible to establish
database connection on a remote pc with mysql using java swings from netbeans and then create a
database on the remote pc....
Kindly help me