Ummu Hanisah

Greenhorn
+ Follow
since Aug 26, 2013
Ummu likes ...
Eclipse IDE Oracle Tomcat Server
Merit badge: grant badges
For More
Malaysia
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
2
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Ummu Hanisah

Thank you for your response. I'm aware with some of your suggestion. My project's dateline is around the corner. I will try my best to implement all of them. Thanks again.
10 years ago
JSP
Hi,

I would like to display certain data from database by passing the parameters from a jsp page to a servlet. Instead of displaying the records, it keeps displaying 27 lines of the same parameter that I pass from jsp page on the console. The 27 lines of printed parameters seems to be the quantity of rows of the selected data that should be displayed. This is the first time I'm using the standard coding in displaying certain data from database. I cannot trace which line that I should make the changes.


Here is my jsp code, PatronForm.jsp


This is my servlet, PatronReservationProcess.java


DisplayPatronReservation.jsp
10 years ago
JSP
Thanks!

Both options work fine. Since I need to pass the date as a parameter, the second approach is what I need.
Hi,

I need to display the total number of faculty by using month and year as a date. It return 0 result. I'm using Oracle database.

Here's my sql query

SELECT COUNT(*) FACULTY FROM RESERVATIONS WHERE RESERVEDATE=to_date('NOV-13', 'MM-YY') AND FACULTY='FST' AND STATUS='BOOKED';
Thanks Bear Bibeault for the hint.

I use requestParameter and put it as a link for each reserve button. By passing the reservationid which is a primary key, the room can now be book.
10 years ago
JSP
Hi,

I would like to create a room reservation system where the users need to complete a form according to their room preferences
and the system will display the result of the available rooms. (I already settled this part)

For each row of the displayed result there will be a button to reserve the selected room. I don't have any idea how to pass the room's details displayed
on the result when the user click the reserve button. I'm not sure if this even possible. Is there another way to reserve the room by click the reserve button?

I'm using JSP technology and Oracle database.
10 years ago
JSP
Thanks a lot!

At first I encounter exception "Session Time Zone not set!".
Now it works fine. Finally I can move to my next module.

K. Tsang wrote:Welcome.

Your error is "invalid column name". Have you tried the run the query directly in Oracle? Does the table have those column names?

I'm not aware that Oracle can just store time. Usually the type is date with timestamp.


I've already run the query in Oracle and it did display the data on those column.
Yup, Oracle store both date and timestamp and it can also show only the time.

Hi, I need to display certain column from Oracle database. But the columns for stime, etime and reservedate doesn't display in my jsp page.
I use data type timestamp in those three columns.

My program throw an exception "Exception is ;java.sql.SQLException: Invalid column name"



My servlet code snippet.




Here is my jsp code