Hiii
View Answers
October 10, 2008 at 7:14 PM
Hi Gudiya
there is two way u can insert data into two table
1) Manually use two insert query
2) use stored procedure
Supose u getting data from a form like this--> name, age, id,state,location.
so u can write insert query like this
String query1 = insert into tab1 values(name, age ,id);
String query2 = insert into tab2 values (id,state,location)
Resultset rs = stmt.executeUpdate(query1);
rs1 = stmt.executeUpdate(query2);
or else use store procedure (change the variable declaration in oracle way)
ALTER PROCEDURE InsertNewImage
@ImageTitle nvarchar(30),
@ImageDescription nvarchar(100),
@ImageFilename nvarchar(50),
@ImageThumbnail image,
@AlbumID int
AS
Begin
Set Nocount On
DECLARE @ImageID int
INSERT INTO Images(ImageTitle, ImageDescription, ImageFilename, ImageThumbnail)
VALUES (@ImageTitle, @ImageDescription, @ImageFilename, @ImageThumbnail)
SELECT @ImageID=@@IDENTITY
INSERT INTO ImageInAlbum(ImageId, AlbumId)
VALUES (@ImageID, @AlbumID)
End
Related Tutorials/Questions & Answers:
Hiii...Hiii... How to display blinking character in html?
User blink tag to blink any string or chracter.
<html>
<title>Blink Text</title>
<body>
<blink>Welcome To Roseindia</blink>
Advertisements
Ajax typeAjax type
hiii,
Is Ajax a technology platform or is it an architectural style
iphoneiphone
hiii,
how can we use table recursively in iphone
HEAP tableHEAP table
hiii,
What is HEAP table?
hello,ADS_TO_REPLACE_1
This type of table is stored in the memory. Speed of execution of this table is very commendable
lock on a classlock on a class hello,
Can a lock be acquired on a class?
hiii,,ADS_TO_REPLACE_1
Yes, a lock can be acquired on a class. This lock is acquired on the class's Class object
Implement the Serializable InterfaceImplement the Serializable Interface hii
How many methods do u implement if implement the Serializable Interface?
hiii,ADS_TO_REPLACE_1
The Serializable interface is just a "marker" interface, with no methods
What is Dojo? What is Dojo?
hiii,
What is Dojo?
hi,ADS_TO_REPLACE_1
Dojo is a third-party javascript toolkit for creating rich featured applications.
Dojo is an Open Source DHTML toolkit written in JavaScript
file i/o - Java Beginnersfile i/o
hiii,
i have to read some integers from a text file and store them in link list..
so please can i have source code for it.??
thanks
What is ETSI ? What is ETSI ?
hiii,
What is ETSI ?
hello,ADS_TO_REPLACE_1
ETSI stands for European Telecommunications Standards Institute. This is a non-profit organization that establishes telecommunications standards
pixel into xml - XMLpixel into xml
hiii
can i store image pixels in a xml file and access easily...
suggest the better way... hi friend,
201
171
81
203
175
78
210
176
87
198
string to floatstring to float
hiii.
how can i change my string value in float for some operation??
give me some code for this??ADS_TO_REPLACE_1
hello,
if rate is your textfield
thenADS_TO_REPLACE_2
float FloPri
Icon imageIcon image
hiii
how can we set image on the icon by which we can launch the application???
hello,
when you will save a image named icon.png then it is automatically show this image on the icon ...ADS
want help regarding a projectwant help regarding a project
hiii this is hemangi and I want guidance that I am working on a project of hospital management system so I want guidance that how can i implement that in swings or with other frame work? and any
Resource files in iphoneResource files in iphone
hiii
how can we use resource files in iphone development ???
hello, ADS_TO_REPLACE_1
if you want to use any file in your application the first you have to added it in your resource folder
DML and DDL DML and DDL
hiii,
Explain DML,DDL.
HELLO,ADS_TO_REPLACE_1
Data Definition Language (DDL) statements are used to define the database structure or schema.
CREATE, ALTER, DROP, TRUNCATE, COMMENT, RENAME
Data
Serializalble and ExternalizableSerializalble and Externalizable hello,
What is the difference between Serializalble and Externalizable interface?
hiii,ADS_TO_REPLACE_1
When you use Serializable interface, your class is serialized automatically
Active vibrationActive vibration hello
is it possible to active vibration from code ?
if yes give me solution!!!ADS_TO_REPLACE_1
hiii
To trigger vibration in iPhone, use System Audio Services (AudioToolbox/AudioServices.h
What is GSM ?What is GSM ? hello,
What is GSM ?
hiii,ADS_TO_REPLACE_1
The Global System for Mobile Communications (GSM) is a wireless network system that is widely used in Europe, Asia, and Australia.
GSM is used at three
concat and appendconcat and append hello,
What is the difference between concat and append?
hiii,ADS_TO_REPLACE_1
Concat is used to add a string at the end of another string.But append() is used with String Buffer to append
Difference between translate and replace Difference between translate and replace
hiii,
What is the difference between translate and replace?
hello,ADS_TO_REPLACE_1
Replace replace every instence of character with character sting by the given charator
servlet - JSP-Servletservlet
hiii.....!!! pls help me answering this....
what can be the xml code which will describe a servlet and mapps an instance of it with specific url..??? Hi friend,
Servlet
Dirty page and Dirty reportDirty page and Dirty report
hiii,
Explain dirty page and dirty report?
hello,ADS_TO_REPLACE_1
Dirty Pages: Data that which is modified and Stored in the buffer cache but has not yet been written
Basic for iphone development??Basic for iphone development??
hiii...
I want to go for iphone development .. What are the basic for iphone development can some body tell me...?????
hello,
if you want to go in iphone development then i
readXML - XMLreadXML
hiii i face problems in reading a xml file..
pixvalue1
path1
pixvalue2
path2
..
i need the path1,path2,.. from it.. i use the DOM parser and get error messages like
readXML - XMLreadXML
hiii i face problems in reading a xml file.. pixvalue1path1 pixvalue2path2..i need the path1,path2,.. from it.. i use the DOM parser and get error messages like
convert a file .doc to .zipconvert a file .doc to .zip
hiii,
I uploaded a file with extension .doc now i required with .zip
Hi Friend,
Try the following code:
1)page.jsp:
<%@ page language="java" %>
<HTml>
<HEAD><
STRUTS 2 Could not find action or resultSTRUTS 2 Could not find action or result
hiii..i am new to struts 2 framework...i developed my jsp code into sturs frame work...but its showing some warning and the "menujsp.jsp" page is not opening...its showing the following