How can I delete mySQL records from an html or jsp page?

**bigz008** · 03-05-2010, 06:26 AM

Hi guys, I've created a .jsp page which gets all the records I put in the database (from mySQL Query browser) and displays them in a table.

Code:

<html>

<table style="width: 100%" class="style4" cellspacing="1" cellpadding="3">
            
<tr>
<td style="width: 90px" id="tableheadercell" class="style3">
<strong>Organsation ID</strong></td>
<td style="width: 50px"  id="tableheadercell" class="style3">
<strong>Length</strong></td>
<td style="width: 50px" id="tableheadercell" class="style3">
<strong>Amount</strong></td>
<td style="width: 80px"  id="tableheadercell" class="style3">
<strong>Trial Period</strong></td>
<td style="width: 90px" id="tableheadercell" class="style3">
<strong>Promo Minutes</strong></td>                             
</tr>
<% 
           String skuResult[][];
           skuResult = null;
        try {
        
String []  skuFields = {"orgID", "length", "amount", "trial_period", "promoMins"};

CRUD skuCRUD = new CRUD ("sku", "skuID");  
skuResult = skuCRUD.getRecords(skuFields,0,0);

        } catch (Exception e) { Tracer.logERROR("[sku/skuContent.jsp] "+e); e.printStackTrace();    } 
                         

String    skuID="";  
String    organisationID="";  
String    cc_flag="";   
String    length="";  
String    amount="";  
String    active="";  
String    trialPeriod="";  
String    description="";  
String    promoText="";  
String    promoMinutes="";  
        
for (int i = 0; i < skuResult.length; i++) {
organisationID = skuResult[i][0]; 
length = skuResult[i][1] ;
amount = skuResult[i][2];
trialPeriod = skuResult[i][3];
promoMinutes = skuResult[i][4];
%> 

<tr>
<td style="width: 90px" class="ms-list1-0001-odd"><%= organisationID %></td>
<td style="width: 50px" class="ms-list1-0001-odd"><%= length %></td>
<td style="width: 50px" class="ms-list1-0001-odd"><%= amount %></td>
<td style="width: 80px" class="ms-list1-0001-odd"><%= trialPeriod %></td>
<td style="width: 90px" class="ms-list1-0001-odd"><%= promoMinutes %></td>
</tr>
<%     Tracer.logERROR("[sku/skContent.jsp] "+"errors are after this"); } %>
                                        
</table>                                
</html>

*The CRUD file is where I connect to the db....

How can I add the functionality to add/delete the records from within my .jsp code?

Thanks in advance.

**gokuajmes** · 03-05-2010, 07:25 AM

i donno much on JSp but are there controls to present data like what .NET has,because .net controls provide functionality to add ,delete,update on the fly

**bigz008** · 03-05-2010, 09:37 AM

Yea, I guess I can try opening the .jsp file with another program which contains those controls like Microsoft Expression Web2...
Thanks.

Thread: How can I delete mySQL records from an html or jsp page?

LinkBack

Thread Tools

Search Thread

Display

How can I delete mySQL records from an html or jsp page?

Re: How can I delete mySQL records from an html or jsp page?

Re: How can I delete mySQL records from an html or jsp page?

Thread Information

Users Browsing this Thread

Similar Threads

mysql records

well I need to get elements of an specific id from a HTML page to display on my page

Displaying records from a mySQL DB

ill pay for this php/mysql script .. generating html pages, pages by alphabet,page #s

getting the value of checkboxes to delete the records in the sql table

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions