Select checkbox for exactly one record

I hav a jsp page whch dynamically displays the records from database into table. On the left side of each row in a table i use checkbox for users to select for deleting single/multiple records from database.. if database contains muliple records i can easily check the checkboxes of required rows in a table and delete thm from database.. But i can't select a checkbox in a table if database contains exactly one record..
Help me plz.. it's urgent..

Thank u..

Jan 7 '12 #1

Subscribe Post Reply

2210

Rabbit

12,516

Expert Mod 8TB

It would help to see the code

Jan 8 '12 #2

Sindhu Kumar

pcdelform

Expand|Select|Wrap|Line Numbers

 <%@ page language="java" import="java.sql.*"%>

<% Class.forName("oracle.jdbc.driver.OracleDriver"); %>

<html>

<head>

<title>PC Deletion Page</title>

<script language="javascript">
 
function validation()

{

var count=0;

for(var i=0;i<del.chbox.length;i++)

{

if(del.chbox[i].checked)

{

count++;

}
 
}
 
if(count==0)

{

return false;

} 

else

{

return true;

}
 
}
 
</script>

</head>

<style type="text/css">@import url("style.css");</style>

<body>

<form name="del" method="post" action="pcdelprocess.jsp" onClick="return validation()">

<h2 align="center">PC Details Table</h2></br></br></br>

<% 

try {

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@10.1.223.151:1521:ERPDVP","td_edc","td_edc");

PreparedStatement ps=conn.prepareStatement("select * from pc_data order by asset_id");

ResultSet rs=ps.executeQuery();

%>

<center><table border="1">

<tr>

    <th>ASSETID</th><th>PLANT</th><th>LOCATION</th><th>DEPARTMENT</th><th>IP ADDR</th><th>USERNAME</th><th>EMP ID</th><th>EMAIL ID</th><th>SL NO</th><th>TYPE</th><th>MAKE</th><th>MODEL</th><th>PROCESSOR</th><th>SPEED</th><th>RAM</th><th>HDD</th><th>EXT STORAGE</th><th>OS</th><th>WARRANTY</th><th>CDE</th><th>REMARKS</th>

</tr>

<%

while(rs.next())

{

%> 
 
<tr>

    <td><input type="checkbox" name="chbox" value="<%=rs.getString(1)%>" checked><%=rs.getString(1)%></td><td><%=rs.getString(2)%></td><td><%=rs.getString(3)%></td><td><%=rs.getString(4)%></td><td><%=rs.getString(5)%></td><td><%=rs.getString(6)%></td><td><%=rs.getString(7)%></td><td><%=rs.getString(8)%></td><td><%=rs.getString(9)%></td><td><%=rs.getString(10)%></td><td><%=rs.getString(11)%></td><td><%=rs.getString(12)%></td><td><%=rs.getString(13)%></td><td><%=rs.getString(14)%></td><td><%=rs.getString(15)%></td><td><%=rs.getString(16)%></td><td><%=rs.getString(17)%></td><td><%=rs.getString(18)%></td><td><%=rs.getString(19)%></td><td><%=rs.getString(20)%></td><td><%=rs.getString(21)%></td>

</tr>
 
<% 

}
 
}

catch(Exception e)

{

out.println(e.getMessage());

}
 
%>

</table></center><br/><br/>

<center><input type="submit" value=" DELETE "/></center>
 
</form>

</body>

</html>

pcdelprocess

Expand|Select|Wrap|Line Numbers

 <%@ page language="java" import="java.sql.*"%>

<% Class.forName("oracle.jdbc.driver.OracleDriver"); %>

<html>

<head>

<title>Delete page</title>
 
</head>
 
<body>
 
<% 

try

{ 

String s="";

String d[]= request.getParameterValues("chbox");
 
if(d!=null)

{

    if(d.length==1)

    {

        s="'"+d[0]+"'";

        out.println(s);

    }

    else

    {

        for(int i=0;i<d.length;i++)

        {

            s+="'"+d[i]+"'";

            if(i<d.length-1)

            {

                s+=",";

            }

        }

        out.println(s);

    }

}
 
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@10.1.223.151:1521:ERPDVP","td_edc","td_edc");

Statement stmt = conn.createStatement();

String qy = "delete from pc_data where asset_id in("+s+") "; 

stmt.executeUpdate(qy);
 
Statement st = conn.createStatement();

String qy1= "delete from id_data1 where asset_id in("+s+") "; 

st.executeUpdate(qy1);

out.println("Successfully Deleted");
 
}

catch(Exception e)

{
 
out.println(e.getMessage());

}

%>
 
</body>

</html>

Jan 8 '12 #3

Rabbit

12,516

Expert Mod 8TB

You can't select the checkbox? Or do you mean the server side script doesn't delete the record?

Jan 9 '12 #4

Sindhu Kumar

sir,
I can't select a check box if table contains only one record..

Jan 10 '12 #5

Rabbit

12,516

Expert Mod 8TB

Unless you've disabled the checkbox, and I see nothing to indicate that is the case, there's nothing that will prevent it from being clickable. So at this point I have no idea what you're talking about.

Perhaps if you posted some screenshots illustrating your point, that can clear things up.

Jan 10 '12 #6

by: Earl Teigrob | last post by:

I am considering writing a Class that Selects, Adds, Updates and Deletes Nodes in an XML File but do not what to reinvent the wheel. (See XML file below) That data format would emulate records...

.NET Framework

Select the latest record for each ID from a table of historic records

by: Henry | last post by:

Dear all, I am now designing a table for storing inventory of servers in a DB2 DB. However, I am new to SQL and would like to seek advice whether the design could work as expect with DB2 SQL. ...

DB2 Database

How do I select (highlight) a record in a datasheet using VBA?

by: Barry Edmund Wright | last post by:

This simple stupid thing has me stumped! The cursor is on a record in a datasheet. How do I select that record (highlight) like I would if I clicked on the Record Selector using VBA. Regards....

Microsoft Access / VBA

Using one form to select the current record in another..

by: Robin S. | last post by:

Originally I wanted a list box which selects which record is the current one within the same form. Easy enough until Access takes a dump when one is deleted and then someone tries to select it in...

Microsoft Access / VBA

how to select checkbox from value in cookie ?

by: find clausen | last post by:

qqq = GetCookie("whatever"); How do I select a chekbox in a form if qqq = yes TIA -- find clausen press photos from denmark www.photopress.dk

Javascript

select checkbox on click of row

by: ASAP | last post by:

there is a checkbox in every row of a table. i need to check the checkbox on click of the corresponding row and vice -versa. means on again clicking of the same row it should get delected.

Javascript

How to Select Checkbox group based of database value

by: inamul | last post by:

I want to select CheckBox based on data retrieved from mysql database table. Could anyone show me the simple way of doing it. Data store in table under colum "sectionOfInterest" is shown below...

ASP / Active Server Pages

I select checkbox "Remeber my login on this computer"?

by: tvnaidu | last post by:

Why firefox doesn't remember userid and password eventhough I select checkbox "Remeber my login on this computer"?

Linux

How to select Checkbox by clicking on a table element td

by: Rodney Ferguson | last post by:

Hi, I'm programming a questionnaire but I'm having trouble with some checkboxes. I would like to have the user select or deselect the checkbox by clicking on the table cell that it is in. ...

Java

How to select a single record from a recordset based on datasheet view

by: David Patz | last post by:

Hi, Im currently building a database for users to edit or manipulate train maintanence parts. For one of my forms - I display the inactive parts in stock. I've designed the form to have a...

Microsoft Access / VBA

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Select checkbox for exactly one record

Similar topics