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

Advertisements

data insertion from xml file to database table
data insertion from xml file to database table Hi all, I have data in the XML file. I need to insert it into table in the database using servlet. so please reply me . ThankYou

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 Please All , I need Insertion sort applet program

Insertion Sort Applet
Insertion Sort Applet I need Insertion Sort Applet code was design by Dr. Daniel Liang Please

insertion sort applet code
insertion sort applet code i need Insertion Sort Applet Program

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<

database
database database

database
database database application

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

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

Inserting content(DOM Insertion)
Inserting content(DOM Insertion) Inserting content(DOM Insertion) Inserting... : DOM insertion DOM insertion, Around DOM

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 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

Ads