Like this
</sql:connection>
<%-- insert a row into the database --%>
<sql:statement id="stmt1" conn="RBH"> <%-- set the SQL query --%>
<sql:query> insert into rbh.fdbk (uid,date,comm,instime)
values ( '<%=LogInBean.getUid()%>',
current_date ,
'<%=request.getParameter("comments")%>',
current_time)
</sql:query>
<%-- execute the query --%>
<sql:execute/>
</sql:statement>
<%-- close a database connection --%>
or this
<%-- update the database --%>
<sql:statement id="stmt1" conn="RBH">
<%-- set the SQL query --%>
<sql:query>
delete from RBH.fdbk WHERE UID = '<%=request.getParameter("uid")%>' and
date = '<%=request.getParameter("date")%>' and instime =
'<%=request.getParameter("instime")%>'
</sql:query>
<%-- execute the query --%>
<sql:execute/>
</sql:statement>
<%-- close a database connection --%>
Good luck.
Kevin
-----Original Message-----
From: Maarten van Heiningen [mailto:[EMAIL PROTECTED]]
Sent: 03 July 2002 14:42
To: [EMAIL PROTECTED]
Subject: updating records in a Mysql db using jsp.
Hi,
I am using a mysql db with jdbc on a win2000 server with Tomcat. I wonder
how I can update or delete items in a row or delete a complete row. I can
select the specific data in the table and put it on the webpage, but I also
want to edit this selected item.
any sugestions?
Maarten
sample code:
<%@ taglib uri="http://jakarta.apache.org/taglibs/dbtags"; prefix="sql" %>
<%-- open a database connection --%>
<sql:connection id="conn1">
<sql:url>jdbc:mysql://localhost/producten</sql:url>
<sql:driver>org.gjt.mm.mysql.Driver</sql:driver>
</sql:connection>
<%-- open a database query --%>
<form name='form'>
<table>
<sql:statement id="stmt1" conn="conn1">
<sql:query>
SELECT manuf, type, prijs FROM mobile WHERE
manuf='<%=request.getParameter("manuf") %>' AND
type='<%=request.getParameter("type") %>'
order by 1
</sql:query>
<%-- loop through the rows of your query --%>
<sql:resultSet id="rset2">
<tr>
<td><sql:getColumn position='1'/></td>
<td><sql:getColumn position='2'/></td>
<td><input type="text" name="price" size="20" value="<sql:getColumn
position='3'/>"/></td>
<td><input type="button" name="submit" value="update" onClick="
UPDATE mobile SET prijs = ' + price + ' WHERE manuf = ' + manuf + '
AND type = ' + type + '"
/></td>
</tr>
</sql:resultSet>
</sql:statement>
</table>
</form>
<table width='100%'>
<hr height='2'/>
</table>
<%-- close a database connection --%>
<sql:closeConnection conn="conn1"/>
Disclaimer
This communication together with any attachments transmitted with it ('this
E-mail') is intended only for the use of the addressee and may contain
information which is privileged and confidential. If the reader of this
E-mail is not the intended recipient or the employee or agent responsible
for delivering it to the intended recipient you are notified that any use of
this E-mail is prohibited. Addressees should ensure this E-mail is checked
for viruses. The Carphone Warehouse Group PLC makes no representations as
regards the absence of viruses in this E-mail. If you have received this
E-mail in error please notify our ISe Response Team immediately by telephone
on + 44 (0)20 8896 5828 or via E-mail at [EMAIL PROTECTED] Please then
immediately destroy this E-mail and any copies of it.
Please feel free to visit our website:
UK
http://www.carphonewarehouse.com
Group
http://www.phonehouse.com
