multivalued attribute

Ads

Share on Google+

maithri

multivalued attribute
1 Answer(s) 6 years and 7 months ago
Posted in : JSP-Servlet

I have a author as multivalued attribute and i have inserted values for it in database but now how to insert values in the database through form .I have written query as shown below and iam getting error .

String query4="INSERT INTO author_det(accno,isbn,author) VALUES ('"+accno+"','"+isbn+"','"+author+"')"; stmt.executeUpdate(query4);

Ads

View Answers

March 4, 2011 at 12:37 PM

Jsp insert data into database

1)form.jsp:

<html>
<form method="post" action="insertdata.jsp">
<table>
<tr><td>Enter Acc No:</td><td><input type="text" name="accno"></td></tr>
<tr><td>Enter ISBN:</td><td><input type="text" name="isbn"></td></tr>
<tr><td>Enter Author:</td><td><input type="text" name="author"></td></tr>
<tr><td></td><td><input type="submit" value="submit"></td></tr>
</table>
</form>
</html>

2)insertdata.jsp:

<%@page import="java.sql.*,java.util.*"%>
<%
int ano=Integer.parseInt(request.getParameter("accno"));
int isbn=Integer.parseInt(request.getParameter("isbn"));
String name=request.getParameter("author");
ArrayList list=new ArrayList();
        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 author_det(accno, isbn,author) values("+ano+","+isbn+",'"+name+"')");
        con.close();
        out.println("Data is successfully inserted into database.");
        }
        catch(Exception e){
        System.out.println(e);
        }
        %>

3)table author_det:

CREATE TABLE `author_det` (                              
              `id` bigint(255) NOT NULL auto_increment,              
              `accno` int(255) default NULL,                         
              `isbn` int(255) default NULL,                          
              `author` varchar(255) default NULL,                    
              PRIMARY KEY  (`id`)                                    
            );

Ads

Advertisements

jsf attribute
jsf attribute What is the different between value and binding attribute of jsf

MySQL Attribute
MySQL Attribute This example illustrates how to use the COLLATE attribute in MySQL. In this example we use the COLLATE attribute to define the attribute... and collation for the column. Query CREATE TABLE atttribute (attribute_name CHAR

Quotes around attribute values.
Quotes around attribute values. Should I put quotes around attribute values

Language Attribute In Page Directive
Language Attribute In Page Directive How use language attribute in page directive

What is attribute oriented programming?
What is attribute oriented programming? Hi, What is attribute oriented programming? Thanks

Use of immediate attribute
Use of immediate attribute What is the use of immediate attribute

JSF Rendered Attribute
JSF Rendered Attribute i need the example for jsf with rendered attribute

value and binding attribute
value and binding attribute What is the difference between value and binding attribute in jsf

Language Attribute In Page Directive
Language Attribute In Page Directive How use language attribute in page directive ? This attribute is used to denote the language used... of language attribute for page directive is : <%@ page language = "lang" %> <

value and binding attribute
value and binding attribute What is the difference between value and binding attribute of jsf tag

JavaScript Defer Attribute
JavaScript Defer Attribute defer attribute in javascript Hi Friend, The defer attribute gives a hint to the browser that the script does not create any content so the browser can optionally defer interpreting

contentType attribute in the page directive
contentType attribute in the page directive How use contentType attribute in the page directive ? contentType attribute is used to set the mime type and character set of the JSP. The user can make use of any MIME

Import attribute of page directive
Import attribute of page directive How use import attribute of page directive ? The import attribute is used to import all the classes in a java package into the current JSP page. If there are many Java packages

errorPage attribute in the page directive
errorPage attribute in the page directive How use errorPage attribute in the page directive ? If the programmer wants to place errors... in this attribute as errorPage. Syntax : <%@ page errorPage="relativeURL" %>

Buffer attribute in the page directive
Buffer attribute in the page directive How use buffer attribute in the page directive? The buffer size in kilobytes used by the out object to handle output sent from the compiled JSP page to the client Web browser

AutoFlush attribute in the page directive
AutoFlush attribute in the page directive How use autoFlush attribute in the page directive? Whether the buffered output should be flushed automatically when the buffer is full. If set to true (the default value

Extends Attribute of page Directive
Extends Attribute of page Directive How use language extends in page directive ? This is used to signify the fully qualified name of the Super class of the Java class used by the JSP engine for the translated

isThreadSafe attribute in the page directive
isThreadSafe attribute in the page directive How use autoFlush attribute in the page directive? autoFlush means it will not clear. it send to the desitation. Whether thread safety is implemented

isErrorPage attribute in the page directive
isErrorPage attribute in the page directive How use isErrorPage attribute in the page directive ? isErrorPage attribute is used... attribute is used to specify whether or not a JSP page displays an error page

retrieve multiple attribute values
retrieve multiple attribute values Hello All Am a beginner. Would like some help with this. The following is part of my XML file: <process... like is to retrieve both the attribute values of process:Output during execution

retrieve multiple attribute values
XML retrieve multiple attribute values Hello All Am a beginner. Would like some help with this. The following is part of my XML file: <...; What I would like is to retrieve both the attribute values of process

How to use contentType Attribute in JSP?
How to use contentType Attribute in JSP? Hi, I am learning JSP and now trying to use the contentType Attribute in JSP. tell me how to use the contentType Attribute in JSP? Thanks

Page Directive attribute - language
Page Directive attribute - language This section contains description of language attribute of page Directive. language Attribute : The language attribute is one of attribute of page directive. Its functionality to specify

attribute in action tag - Java Beginners
attribute in action tag I'm just a beginner to struts. The name tag(name="bookListForm") is used to define the form used with the action class. But i`m not clear about the attribute tag(attribute

Version of nanning>nanning-attribute dependency
List of Version of nanning>nanning-attribute dependency

<html:option > with "selected" attribute - Struts
with "selected" attribute how to display formbean object with "selected" attribute in . please help me

Page Directive attribute - isThreadSafe
Page Directive attribute - isThreadSafe This tutorial contains description of isThreadSafe attribute of page Directive. isThreadSafe Attribute : isThreadSafe attribute is one of attribute of page directives. It is used

Ads

Advertisement null

Ads