Re: JSPs/DBs and HTML Forms
Thank you very much for the code tip, I'm going to look it today, hopefully
it shouldn't be too much of a problem. Looks like the mailing list cut most
of my JSP out of my last email :(
Thanks again,
Graeme :)
Public Sub House()
On Error Resume drink
If PintGlass.empty = True Then
PintGlass.refill
Else
PintGlass.drink
End if
stomach.add PintGlass
MsgBox I've had stomach.count Pints
MsgBox VERY DRUNK
End Sub
From: Bhushan_Bhangale [EMAIL PROTECTED]
Reply-To: A mailing list about Java Server Pages specification and
reference [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: JSPs/DBs and HTML Forms
Date: Tue, 16 Apr 2002 09:10:18 +0530
MIME-Version: 1.0
Received: from [192.18.99.108] by hotmail.com (3.2) with ESMTP id
MHotMailBE84EABB007A4004310CC012636CAA3C0; Mon, 15 Apr 2002 20:52:06 -0700
Received: from swjscmail1 (swjscmail1.Sun.COM [192.18.99.107])by
swjscmail2.java.sun.com (Postfix) with ESMTPid 1E75D21FBC; Mon, 15 Apr 2002
21:49:34 -0600 (MDT)
Received: from JAVA.SUN.COM by JAVA.SUN.COM (LISTSERV-TCP/IP release 1.8d)
with spool id 1598261 for [EMAIL PROTECTED]; Mon, 15 Apr
2002 21:48:20 -0600
Received: from bosvwl01.infy.com (bosvwl01.infy.com [216.52.49.35]) by
swjscmail1.java.sun.com (Postfix) with SMTP id 4607E4858 for
[EMAIL PROTECTED]; Mon, 15 Apr 2002 21:38:20 -0600 (MDT)
Received: from 192.168.200.82 by bosvwl01.infy.com (InterScan E-Mail
VirusWall NT); Mon, 15 Apr 2002 23:38:05 -0400
Received: from punmsg02.ad.infosys.com ([192.168.170.15]) by
INDHUBBHS02.ad.infosys.com with Microsoft SMTPSVC(5.0.2195.4905);
Tue, 16 Apr 2002 09:10:18 +0530
From [EMAIL PROTECTED] Mon, 15 Apr 2002 20:52:53 -0700
Delivered-To: [EMAIL PROTECTED]
X-MimeOLE: Produced By Microsoft Exchange V6.0.5762.3
content-class: urn:content-classes:message
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
Thread-Topic: JSPs/DBs and HTML Forms
Thread-Index: AcHk0WSpygu/NF3lQSicyk7RdYwBFAAIuYOg
X-OriginalArrivalTime: 16 Apr 2002 03:40:18.0822 (UTC)
FILETIME=[6DCC6A60:01C1E4F8]
Message-ID:
[EMAIL PROTECTED]
Sender: A mailing list about Java Server Pages specification and reference
[EMAIL PROTECTED]
Its very simple to write a SQL after getting all the form elements values
in some variables. You just need to concatenate all the values and need to
create a INSERT statement. See for example :-
String var1 = request.getParameter(var1);
String var2 = request.getParameter(var2);
String var3 = request.getParameter(var3);
String query = INSERT INTO TABLENAME(VAR1, VAR2, VAR3) VALUES(;
if (var1 != null var1.trim().length() != 0)
query += ' + var1 ',;
if (var2 != null var2.trim().length() != 0)
query += ' + var2 ',;
if (var3 != null var3.trim().length() != 0)
query += ' + var3 ',;
if (query.charAt(query.length() - 1) == ',')
query = query.substring(0, query.length());
Now your whole query is ready in query variable.
If still have any doubt then you can ask me.
This is just an approach. You can take care of all kinds of types here like
int, date, etc and instead of String for query use StringBuffer which is
much more efficient.
-Original Message-
From: Graeme McLaren [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 4:20 AM
To: [EMAIL PROTECTED]
Subject: JSPs/DBs and HTML Forms
Hi everyone, I'm completely new to JSPs and I'm finding a somewhat daunting
area. Specifically I'm having a problem inserting information from an html
form to a database using a JSP.
Basically I've got the problem of getting the parameter and the value from
the form then inserting it in to the database with SQL.
I can use mystring=request.getParameter(TheNameOfTheFormInput); to get
the value from the form elements. Once I've done this I'm completely lost
as to how to write the SQL to insert the values from the form elements INTO
the database.
Can anyone guide me through this, point me in the right direction or give
me
any tips at all. Any advice would be greatly appreciated.
Thank you in advance,
Graeme :)
P.S. Currently I've got a JSP like this:
!-- imports the JDBC functions --
%@ page import=java.sql.* %
html
head
titleJDBC Example/title
/head
body
h1JDBC with JSP/h1
%
/* various variable declarations */
Connection dbc;
Statement st;
String sql;
ResultSet rs;
ResultSetMetaData rsmd;
try {
/* load JDBC driver for PostgreSQL database */
Class.forName(postgresql.Driver);
/* make a connection to the database */
dbc=DriverManager.getConnection(jdbc:postgresql://localhost/webtest,www-d
ata,);
/* create and execute a statement */
st=dbc.createStatement();
sql=(SELECT * FROM example);
st.executeQuery(sql);
/* get the results and metadata */
rs=st.getResultSet();
rsmd=rs.getMetaData();
/* how many columns are there? */
int numcols=rsmd.getColumnCount();
/* start table and print headings */
out.println(table\nthead\ntr);
int i;
for (i=1;i
Re: JSPs/DBs and HTML Forms
I really suggest buying a book to learn JSP, that's the way I learnt and
is really the best way. I can recommend Beginning JSP Web Development by
Wrox Press -
http://www.amazon.com/exec/obidos/ASIN/1861002092/qid=1018940667/sr=8-1/
ref=sr_8_71_1/102-7390197-2280917 Its really made step by step and shows
you all the import points, including setting up databases etc...
Regards,
Peter Dolukhanov
-Original Message-
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]] On Behalf Of Graeme McLaren
Sent: 15 April 2002 23:50
To: [EMAIL PROTECTED]
Subject: JSPs/DBs and HTML Forms
Hi everyone, I'm completely new to JSPs and I'm finding a somewhat
daunting
area. Specifically I'm having a problem inserting information from an
html
form to a database using a JSP.
Basically I've got the problem of getting the parameter and the value
from
the form then inserting it in to the database with SQL.
I can use mystring=request.getParameter(TheNameOfTheFormInput); to
get
the value from the form elements. Once I've done this I'm completely
lost
as to how to write the SQL to insert the values from the form elements
INTO
the database.
Can anyone guide me through this, point me in the right direction or
give me
any tips at all. Any advice would be greatly appreciated.
Thank you in advance,
Graeme :)
P.S. Currently I've got a JSP like this:
!-- imports the JDBC functions --
%@ page import=java.sql.* %
html
head
titleJDBC Example/title
/head
body
h1JDBC with JSP/h1
%
/* various variable declarations */
Connection dbc;
Statement st;
String sql;
ResultSet rs;
ResultSetMetaData rsmd;
try {
/* load JDBC driver for PostgreSQL database */
Class.forName(postgresql.Driver);
/* make a connection to the database */
dbc=DriverManager.getConnection(jdbc:postgresql://localhost/webtest,w
ww-d
ata,);
/* create and execute a statement */
st=dbc.createStatement();
sql=(SELECT * FROM example);
st.executeQuery(sql);
/* get the results and metadata */
rs=st.getResultSet();
rsmd=rs.getMetaData();
/* how many columns are there? */
int numcols=rsmd.getColumnCount();
/* start table and print headings */
out.println(table\nthead\ntr);
int i;
for (i=1;i=numcols;i++)
out.print(th+rsmd.getColumnLabel(i)+/th);
out.println(/tr\n/thead\ntbody);
/* print the rows of the table */
while (rs.next()) {
out.print(tr);
for (i=1;i=numcols;i++)
out.print(td+rs.getObject(i)+/td);
out.print(/tr);
}
/* end table and close DB */
out.print(/tbody\n/table\n);
dbc.close();
/* error handling */
} catch (Exception e) {
out.println(pError in JDBC database access/p);
out.println(p+e+/p);
} ;
%
/body
/html
Thanks again,
G :)
Public Sub House()
On Error Resume drink
If PintGlass.empty = True Then
PintGlass.refill
Else
PintGlass.drink
End if
stomach.add PintGlass
MsgBox I've had stomach.count Pints
MsgBox VERY DRUNK
End Sub
_
Join the world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com
===
To unsubscribe: mailto [EMAIL PROTECTED] with body: signoff
JSP-INTEREST.
For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST
DIGEST.
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
===
To unsubscribe: mailto [EMAIL PROTECTED] with body: signoff JSP-INTEREST.
For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST DIGEST.
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
Re: JSPs/DBs and HTML Forms
I'm not quite clear on what you're after here, however at the risk of being
simplistic,
The SQL to insert value1 - 3 into field 1 -3 of table tblname would be:
INSERT into tblname (field1, field2, field3) VALUES (value1, value2, value3)
The JSP to execute would be:
/* create and execute a statement */
st=dbc.createStatement();
sql=(INSERT into tblname (field1, field2, field3) VALUES (value1,
value2, value3));
st.executeUpdate(sql);
ie: use executeUpdate() instead of executeQuery();
Hope that helps
Tref Gare
Web Developer MCSD/SCJP
eCommerce Group
Phone: (03) 9221 4106
Mobile: 0409 556 478
Fax:(03) 9941 4295
-Original Message-
From: Graeme McLaren [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday,16 April 2002 8:50
To: [EMAIL PROTECTED]
Subject: JSPs/DBs and HTML Forms
Hi everyone, I'm completely new to JSPs and I'm finding a somewhat
daunting
area. Specifically I'm having a problem inserting information from an
html
form to a database using a JSP.
Basically I've got the problem of getting the parameter and the value from
the form then inserting it in to the database with SQL.
I can use mystring=request.getParameter(TheNameOfTheFormInput); to get
the value from the form elements. Once I've done this I'm completely lost
as to how to write the SQL to insert the values from the form elements
INTO
the database.
Can anyone guide me through this, point me in the right direction or give
me
any tips at all. Any advice would be greatly appreciated.
Thank you in advance,
Graeme :)
P.S. Currently I've got a JSP like this:
!-- imports the JDBC functions --
%@ page import=java.sql.* %
html
head
titleJDBC Example/title
/head
body
h1JDBC with JSP/h1
%
/* various variable declarations */
Connection dbc;
Statement st;
String sql;
ResultSet rs;
ResultSetMetaData rsmd;
try {
/* load JDBC driver for PostgreSQL database */
Class.forName(postgresql.Driver);
/* make a connection to the database */
dbc=DriverManager.getConnection(jdbc:postgresql://localhost/webtest,www
-d
ata,);
/* create and execute a statement */
st=dbc.createStatement();
sql=(SELECT * FROM example);
st.executeQuery(sql);
/* get the results and metadata */
rs=st.getResultSet();
rsmd=rs.getMetaData();
/* how many columns are there? */
int numcols=rsmd.getColumnCount();
/* start table and print headings */
out.println(table\nthead\ntr);
int i;
for (i=1;i=numcols;i++)
out.print(th+rsmd.getColumnLabel(i)+/th);
out.println(/tr\n/thead\ntbody);
/* print the rows of the table */
while (rs.next()) {
out.print(tr);
for (i=1;i=numcols;i++)
out.print(td+rs.getObject(i)+/td);
out.print(/tr);
}
/* end table and close DB */
out.print(/tbody\n/table\n);
dbc.close();
/* error handling */
} catch (Exception e) {
out.println(pError in JDBC database access/p);
out.println(p+e+/p);
} ;
%
/body
/html
Thanks again,
G :)
Public Sub House()
On Error Resume drink
If PintGlass.empty = True Then
PintGlass.refill
Else
PintGlass.drink
End if
stomach.add PintGlass
MsgBox I've had stomach.count Pints
MsgBox VERY DRUNK
End Sub
_
Join the world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com
==
=
To unsubscribe: mailto [EMAIL PROTECTED] with body: signoff
JSP-INTEREST.
For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST
DIGEST.
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
===
To unsubscribe: mailto [EMAIL PROTECTED] with body: signoff JSP-INTEREST.
For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST DIGEST.
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
Re: JSPs/DBs and HTML Forms
Look into struts, it works great on forms Daniel Jaffa Stuff i say i know: Java, JSP, JavaBeans, TagLibs, J2EE, EJB Before asking someone, do a search on google: Google will set you free If you are not happy, I am not happy _ Chat with friends online, try MSN Messenger: http://messenger.msn.com === To unsubscribe: mailto [EMAIL PROTECTED] with body: signoff JSP-INTEREST. For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST DIGEST. Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
JSPs/DBs and HTML Forms
Hi everyone, I'm completely new to JSPs and I'm finding a somewhat daunting
area. Specifically I'm having a problem inserting information from an html
form to a database using a JSP.
Basically I've got the problem of getting the parameter and the value from
the form then inserting it in to the database with SQL.
I can use mystring=request.getParameter(TheNameOfTheFormInput); to get
the value from the form elements. Once I've done this I'm completely lost
as to how to write the SQL to insert the values from the form elements INTO
the database.
Can anyone guide me through this, point me in the right direction or give me
any tips at all. Any advice would be greatly appreciated.
Thank you in advance,
Graeme :)
P.S. Currently I've got a JSP like this:
!-- imports the JDBC functions --
%@ page import=java.sql.* %
html
head
titleJDBC Example/title
/head
body
h1JDBC with JSP/h1
%
/* various variable declarations */
Connection dbc;
Statement st;
String sql;
ResultSet rs;
ResultSetMetaData rsmd;
try {
/* load JDBC driver for PostgreSQL database */
Class.forName(postgresql.Driver);
/* make a connection to the database */
dbc=DriverManager.getConnection(jdbc:postgresql://localhost/webtest,www-d
ata,);
/* create and execute a statement */
st=dbc.createStatement();
sql=(SELECT * FROM example);
st.executeQuery(sql);
/* get the results and metadata */
rs=st.getResultSet();
rsmd=rs.getMetaData();
/* how many columns are there? */
int numcols=rsmd.getColumnCount();
/* start table and print headings */
out.println(table\nthead\ntr);
int i;
for (i=1;i=numcols;i++)
out.print(th+rsmd.getColumnLabel(i)+/th);
out.println(/tr\n/thead\ntbody);
/* print the rows of the table */
while (rs.next()) {
out.print(tr);
for (i=1;i=numcols;i++)
out.print(td+rs.getObject(i)+/td);
out.print(/tr);
}
/* end table and close DB */
out.print(/tbody\n/table\n);
dbc.close();
/* error handling */
} catch (Exception e) {
out.println(pError in JDBC database access/p);
out.println(p+e+/p);
} ;
%
/body
/html
Thanks again,
G :)
Public Sub House()
On Error Resume drink
If PintGlass.empty = True Then
PintGlass.refill
Else
PintGlass.drink
End if
stomach.add PintGlass
MsgBox I've had stomach.count Pints
MsgBox VERY DRUNK
End Sub
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
===
To unsubscribe: mailto [EMAIL PROTECTED] with body: signoff JSP-INTEREST.
For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST DIGEST.
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
Re: JSPs/DBs and HTML Forms
Its very simple to write a SQL after getting all the form elements values in some
variables. You just need to concatenate all the values and need to create a INSERT
statement. See for example :-
String var1 = request.getParameter(var1);
String var2 = request.getParameter(var2);
String var3 = request.getParameter(var3);
String query = INSERT INTO TABLENAME(VAR1, VAR2, VAR3) VALUES(;
if (var1 != null var1.trim().length() != 0)
query += ' + var1 ',;
if (var2 != null var2.trim().length() != 0)
query += ' + var2 ',;
if (var3 != null var3.trim().length() != 0)
query += ' + var3 ',;
if (query.charAt(query.length() - 1) == ',')
query = query.substring(0, query.length());
Now your whole query is ready in query variable.
If still have any doubt then you can ask me.
This is just an approach. You can take care of all kinds of types here like int, date,
etc and instead of String for query use StringBuffer which is much more efficient.
-Original Message-
From: Graeme McLaren [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 4:20 AM
To: [EMAIL PROTECTED]
Subject: JSPs/DBs and HTML Forms
Hi everyone, I'm completely new to JSPs and I'm finding a somewhat daunting
area. Specifically I'm having a problem inserting information from an html
form to a database using a JSP.
Basically I've got the problem of getting the parameter and the value from
the form then inserting it in to the database with SQL.
I can use mystring=request.getParameter(TheNameOfTheFormInput); to get
the value from the form elements. Once I've done this I'm completely lost
as to how to write the SQL to insert the values from the form elements INTO
the database.
Can anyone guide me through this, point me in the right direction or give me
any tips at all. Any advice would be greatly appreciated.
Thank you in advance,
Graeme :)
P.S. Currently I've got a JSP like this:
!-- imports the JDBC functions --
%@ page import=java.sql.* %
html
head
titleJDBC Example/title
/head
body
h1JDBC with JSP/h1
%
/* various variable declarations */
Connection dbc;
Statement st;
String sql;
ResultSet rs;
ResultSetMetaData rsmd;
try {
/* load JDBC driver for PostgreSQL database */
Class.forName(postgresql.Driver);
/* make a connection to the database */
dbc=DriverManager.getConnection(jdbc:postgresql://localhost/webtest,www-d
ata,);
/* create and execute a statement */
st=dbc.createStatement();
sql=(SELECT * FROM example);
st.executeQuery(sql);
/* get the results and metadata */
rs=st.getResultSet();
rsmd=rs.getMetaData();
/* how many columns are there? */
int numcols=rsmd.getColumnCount();
/* start table and print headings */
out.println(table\nthead\ntr);
int i;
for (i=1;i=numcols;i++)
out.print(th+rsmd.getColumnLabel(i)+/th);
out.println(/tr\n/thead\ntbody);
/* print the rows of the table */
while (rs.next()) {
out.print(tr);
for (i=1;i=numcols;i++)
out.print(td+rs.getObject(i)+/td);
out.print(/tr);
}
/* end table and close DB */
out.print(/tbody\n/table\n);
dbc.close();
/* error handling */
} catch (Exception e) {
out.println(pError in JDBC database access/p);
out.println(p+e+/p);
} ;
%
/body
/html
Thanks again,
G :)
Public Sub House()
On Error Resume drink
If PintGlass.empty = True Then
PintGlass.refill
Else
PintGlass.drink
End if
stomach.add PintGlass
MsgBox I've had stomach.count Pints
MsgBox VERY DRUNK
End Sub
_
Join the world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com
===
To unsubscribe: mailto [EMAIL PROTECTED] with body: signoff JSP-INTEREST.
For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST DIGEST.
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
==To
unsubscribe: mailto [EMAIL PROTECTED] with body: signoff JSP-INTEREST.
For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST DIGEST.
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
