473,323 Members | 1,589 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Need to borrow your brain for large <table>

RC
Dear Dudes,

I post this in multiple groups for opening brain storm.

Sometime I need to query the data from database server then display them
into user's browser in HTML <table>. But if the <table> is very LARGE,
let's say 20 columns, hundreds rows. Usually you have header <th> tags
on 1st (top) row and 1st (most left) column. For a such LARGE <table>.
you really want:

1) When scroll the vertical scroll bar, you want the top row header
<thead> stay in the same position, the rest of rows are move up/down
(this will include the most left column).

I am success doing this part.

2) When you scroll the horizontal scroll bar, you want the most left
column stay in the same position, the rest of columns are move
left/right (this will include the top header row).

I don't know how to do this part, need to borrow your brain for help!
Thank Q very much in advance!

You can check out my test page from

http://amazon.nws.noaa.gov/hads/test/15C2C420.html

Here is basicly what I do

<html><title>Scrollable Table</title><head>
<script language="JavaScript">
var preRow = null;
function changeRow(thisRow) {
if (preRow != null)
preRow.bgColor = "white";
thisRow.bgColor = "cyan";
preRow = thisRow;
}
</script>
<style type="text/css">
tbody { max-height: 30em; overflow: auto; }
th { background-color: lightgrey; }
th.left { background-color: cyan; }
</style></head><body>

<table border=1 width="100%">

<thead>
<tr><th class="left">col1,row1</th>..... <th>coln,row1</th></tr>
</thead>

<tbody>
<tr onClick="changeRow(this)">
<th class="left">col1,row2</th><td>col2,row2</td>......
<td>coln,row2</td></tr>
.....
.....
<tr onClick="changeRow(this)">
<th class="left">col1,rown</th><td>col2,rown</td>......
<td>coln,rown</td></tr>

</tbody>
</table></body></html>

I prefer doing this by CSS, HTML/DHTML/XDHTML, XML and little
Javascript. Java <applet> Swing JTable will be last resource,
because user has different browser, some not support Java 1.x.
And load large data into *.jar for <applet> will take time.

I did some Google search, I found two sites doing this by JavaScript.
But I prefer not to load huge file, run the JavaScript on client site.
I prefer load plain text HTML from server. Of cource, I'll keep mind
open use JavaScript grid as 2nd choice.

Here are those two good sites:

http://www.activewidgets.com/

Above site the most left column is label in sequence row number, like
preadsheet. Not very good.

http://www.theopensourcery.com/jsgrids.htm
Dec 6 '05 #1
7 1604

"RC" <ra**********@nospam.noaa.gov> wrote in message
news:dn**********@news.nems.noaa.gov...
Dear Dudes,

I post this in multiple groups for opening brain storm.
Big mistake! It is bad Usenet netiquette to crosspost to many different
newsgroups on the same problem, especially such diverse ones. The netiquette
people are going to be all over you....
Sometime I need to query the data from database server then display them
into user's browser in HTML <table>. But if the <table> is very LARGE,
let's say 20 columns, hundreds rows. Usually you have header <th> tags
on 1st (top) row and 1st (most left) column. For a such LARGE <table>.
you really want:

1) When scroll the vertical scroll bar, you want the top row header
<thead> stay in the same position, the rest of rows are move up/down
(this will include the most left column).

I am success doing this part.

2) When you scroll the horizontal scroll bar, you want the most left
column stay in the same position, the rest of columns are move
left/right (this will include the top header row).

I don't know how to do this part, need to borrow your brain for help!
Thank Q very much in advance!

You can check out my test page from

http://amazon.nws.noaa.gov/hads/test/15C2C420.html

Here is basicly what I do

<html><title>Scrollable Table</title><head>
<script language="JavaScript">
var preRow = null;
function changeRow(thisRow) {
if (preRow != null)
preRow.bgColor = "white";
thisRow.bgColor = "cyan";
preRow = thisRow;
}
</script>
<style type="text/css">
tbody { max-height: 30em; overflow: auto; }
th { background-color: lightgrey; }
th.left { background-color: cyan; }
</style></head><body>

<table border=1 width="100%">

<thead>
<tr><th class="left">col1,row1</th>..... <th>coln,row1</th></tr>
</thead>

<tbody>
<tr onClick="changeRow(this)">
<th class="left">col1,row2</th><td>col2,row2</td>......
<td>coln,row2</td></tr>
....
....
<tr onClick="changeRow(this)">
<th class="left">col1,rown</th><td>col2,rown</td>......
<td>coln,rown</td></tr>

</tbody>
</table></body></html>

I prefer doing this by CSS, HTML/DHTML/XDHTML, XML and little
Javascript. Java <applet> Swing JTable will be last resource,
because user has different browser, some not support Java 1.x.
Then I strongly suggest that you keep your problem out of the
comp.lang.java.* newsgroups until you have thoroughly explored CSS,
HTML/DHTML/XDHTML, XML and Javascript to see if they can help you with your
problem.

I certainly don't want to be bothered trying to show you how this problem
can be solved via Java if you don't want to use Java in the first place.
And load large data into *.jar for <applet> will take time.
You don't normally load data of the kind you are describing into jars. It is
much more common to access data from databases like MySQL or DB2 via JDBC,
rather than storing the data in jars. After all, the data will presumably be
changing regularly so you will always want to access the "latest and
greatest" data; the best place to do that is in a database.
I did some Google search, I found two sites doing this by JavaScript.
But I prefer not to load huge file, run the JavaScript on client site.
I prefer load plain text HTML from server. Of cource, I'll keep mind
open use JavaScript grid as 2nd choice.

Here are those two good sites:

http://www.activewidgets.com/

Above site the most left column is label in sequence row number, like
preadsheet. Not very good.

http://www.theopensourcery.com/jsgrids.htm


I am relatively sure that the behaviour you want can be accomplished fairly
easily in Java via JTables but I am not going to waste time describing this
if you don't want to use Java in the first place.

Why don't you try the other approaches first, then come back to
comp.lang.java.gui if the other approaches don't work to your satisfaction?

Rhino
Dec 6 '05 #2
RC
Rhino wrote:

You don't normally load data of the kind you are describing into jars. It is
much more common to access data from databases like MySQL or DB2 via JDBC,
rather than storing the data in jars. After all, the data will presumably be
changing regularly so you will always want to access the "latest and
greatest" data; the best place to do that is in a database.


For security reason, you really don't want people direct access your
database server from <applet>. Prefer use JDBC on server side connect
to my database server with Tomcat (servlet/jsp).
Dec 6 '05 #3
On Tue, 06 Dec 2005 10:43:26 -0500, RC <ra**********@nospam.noaa.gov>
wrote, quoted or indirectly quoted someone who said :

Sometime I need to query the data from database server then display them
into user's browser in HTML <table>. But if the <table> is very LARGE,
let's say 20 columns, hundreds rows. Usually you have header <th> tags
on 1st (top) row and 1st (most left) column. For a such LARGE <table>.
you really want:


There are ways of doing that with CSS/HTML but they are pretty flaky.
I tried many of the hacks and gave up because, every browser behaves a
different way.

Take the bull by the horns and put an Applet in JAWS app in your
client with a JTable and a TableModel. Then you can make it do tricks
like a circus pony.
--
Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.
Dec 6 '05 #4

"RC" <ra**********@nospam.noaa.gov> wrote in message
news:dn**********@news.nems.noaa.gov...
Rhino wrote:

You don't normally load data of the kind you are describing into jars. It
is much more common to access data from databases like MySQL or DB2 via
JDBC, rather than storing the data in jars. After all, the data will
presumably be changing regularly so you will always want to access the
"latest and greatest" data; the best place to do that is in a database.


For security reason, you really don't want people direct access your
database server from <applet>. Prefer use JDBC on server side connect
to my database server with Tomcat (servlet/jsp).


I wouldn't be particularly concerned about _READING_ database data via an
applet but I'd be a lot more reluctant to let people update the data.
Fortunately, that is easily prevented via GRANTs and REVOKEs on the database
side, assuming you are using something SQL based.

I'd also prefer a servlet to an applet for displaying database data but you
didn't mention servlets so I assumed you had some reason not to use them.
But I'm not sure a servlet would help you either; unless you want to use
something like Struts or something similar to handle the
displaying/scrolling of the data - and I'm not even sure Struts can do such
a thing - you'll have trouble getting the scrolling you want.

If it was me, I'd use an applet and a database for this job. I'm 90+% sure
that you can get the scrolling you want with a JTable in an applet. The
following page,
http://www.esus.com/javaindex/j2se/j...le/jtable.html,
lists
a variety of JTable techniques; one of the ones you'll need is at the "How
do I create a JTable with fixed rows?" link and costs nothing. The preceding
link, "How do I create a JTable with fixed columns?", requires you to buy a
membership from the website for $15. That might be worth it if you can't
find the tip somewhere else or infer it from the technique shown for the
fixed rows technique.

These tips are a bit dated though, going back to Java 1.2, so you may find
better techniques if you Google for them or ask at comp.lang.java.gui. Or
you can use a CSS/HTML/Javascript technique that is probably buggy and very
sensitive to which browser and browser version you are using. Your call....

Rhino
Dec 6 '05 #5
Rhino <no***********************@nospam.com> wrote:
I wouldn't be particularly concerned about _READING_ database data via an
applet but I'd be a lot more reluctant to let people update the data.
Fortunately, that is easily prevented via GRANTs and REVOKEs on the database
side, assuming you are using something SQL based.


It's really just silly to talk about "data" this way. Obviously,
security requirements only exist for SPECIFIC data, not for data in the
abstract. If the data is my credit card number, then I'd much rather
that a security hole lets someone overwrite it (update) than read it.

In any case, whether an applet is sufficient for security depends on two
things:

1) Is it acceptable for the database server to accept incoming
connections from arbitrary IP addresses?

2) Will clients know their authentication credentials, so that the
applet doesn't need to contain its own authentication information on the
client?

If the answer to either #1 or #2 is "no", then security requirements
cannot be met, and a different approach is required.

--
www.designacourse.com
The Easiest Way To Train Anyone... Anywhere.

Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation
Dec 6 '05 #6

"Chris Smith" <cd*****@twu.net> wrote in message
news:MP************************@news.altopia.net.. .
Rhino <no***********************@nospam.com> wrote:
I wouldn't be particularly concerned about _READING_ database data via an
applet but I'd be a lot more reluctant to let people update the data.
Fortunately, that is easily prevented via GRANTs and REVOKEs on the
database
side, assuming you are using something SQL based.
It's really just silly to talk about "data" this way. Obviously,
security requirements only exist for SPECIFIC data, not for data in the
abstract. If the data is my credit card number, then I'd much rather
that a security hole lets someone overwrite it (update) than read it.

Agreed! In that specific case, of course you wouldn't want people to read
and wouldn't care too much about updating.

In most cases though, at least the ones I had in mind where you are dealing
with some sort of innocuous information like products available for sale at
a website, you aren't likely to want any prohibitions against reading but
would certainly want to prevent inserts, updates and deletes. That is the
sort of situation I had in mind. I suppose I should have been more specific
and said that. It didn't occur to me though because it didn't sound like the
original poster's data was something like credit card numbers.
In any case, whether an applet is sufficient for security depends on two
things:

1) Is it acceptable for the database server to accept incoming
connections from arbitrary IP addresses?

2) Will clients know their authentication credentials, so that the
applet doesn't need to contain its own authentication information on the
client?

If the answer to either #1 or #2 is "no", then security requirements
cannot be met, and a different approach is required.

Agreed.

Rhino
Dec 6 '05 #7
Tex
> You can check out my test page from
http://amazon.nws.noaa.gov/hads/test/15C2C420.html


Consider a JVM 1.1 Applet as virtually everyone has that, and then
your can build an application rather than a web page. In your example
your data appears to include:
1. Temp: Readings, Avg, Max, Min
2. Wind Speed: Readings, Hr Avg, Daily Avg, Peak
3. Wind Direction: Readings, Hr Avg, Daily Avg, @ Peak
etc.

With an applet you can download the readings and build all else
on the client machine and present it anyway you want including
scrollable tables and graphs, and the graphs can be scrolled
and the scale changed. You could add movable brackets to
a graph so user could get Avg, Min, Max, etc over any period
desired.

And the applet can download very compact data. As one example,
I had several tables which as a text file was 85K, as a binary file
was 15K which packed into a Jar as 5K.

You could pack the readings into binary and then to zip files by say
month, or quarter, or whatever is best for the application, and an
applet can spawn threads to download additional files while
working on initial data.

A TMY hourly weather file for a given city for a while year is approx
146K in binary and 72K as zip. An applet can unpack zip files and
can decode binary, e.g. TMY weather files.

So, your initial request was help building same-old, same-old,
web page w/ a little jazz via a scrollable table. With applets you
can consider building an application, and they are much more
valuable to your users.

--tex

Dec 7 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: bearclaws | last post by:
I am looping through a list of categories and want to display the list horizontally (instead of vertically). I want to create a single row with 4 list items in each cell of the row. I thought...
3
by: Paul Thompson | last post by:
When I put a <div ...> inside a <table> specification, functionality is not there. When I put the <table> inside the <div> everything works. Why is that?
61
by: Toby Austin | last post by:
I'm trying to replace <table>s with <div>s as much as possible. However, I can't figure out how to do the following… <table> <tr> <td valign="top" width="100%">some data that will...
19
by: CMAR | last post by:
I have the following markup. The problem is that the browser, e.g., IE6, inserts several lines of blank space between the <div> and the following table. Is there a way to minimize that vertical...
10
by: BuddhaBuddy | last post by:
Platform is DB2/NT 7.2.9 The table was created like this: CREATE TABLE MYTEST ( MYTESTOID bigint not null primary key, FK_OTHEROID bigint not null references other, FK_ANOTHEROID bigint not...
0
by: timnels | last post by:
I've got a bizzare issue where I have an XML file to load into a data set like: <conversion> <table name="parent"> <table name="child"> </table> </table> <table name="another parent"> ....
3
by: RC | last post by:
Dear Dudes, I post this in multiple groups for opening brain storm. Sometime I need to query the data from database server then display them into user's browser in HTML <table>. But if the...
1
by: prefersgolfing | last post by:
I'm not using Master Pages, yet I'd like to display the contents of an HTML page within a <table><tr><td> on a .aspx. I have a lengthy guide already paginated in html. I'd like to embed the...
2
by: BD | last post by:
Hi, all. My background is more Oracle than db2. My skills at SQL tuning are quite limited. I'm running 8.2 on Windows. I'm tasked with some SQL optimization, and am doing some explain plans...
3
by: PYG | last post by:
Hi everybody I have a simple question : If i use this code : <body style="font-size:24px;color:blue;"> Text in body <table> <tr><td> Text in table
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.