0

Hi, I'm a intern as a web developer in a bank.. I really don't know much about this field but still im trying.
I am a given a project "Service Request Monitoring System".

IDE: Eclipse Europa
Database Mgt System: Postgre SQL 9.0
Server: Tomcat 6.0

my task now, is to make a printable version / hard copy of all the information and the status' request of the employee.

I made a hard.jsp ( How am I supposed to connect from the database and get all the needed data to insert it into the appropriate rows in the table? )

<%@page contentType="text/html" %> 

<html>
      <link rel=StyleSheet href="myStyle.css" type="text/css">
  
  <body class="hard"> 
 <table width = "709" cellpadding="10" border="1" align="center"> 
 </table><div align="center"><img height="51" width="51" src="C:\Documents and Settings\Rachelle\Workspaces\try2\WebContent\abiLogo.gif"><br></div><table cellpadding="4" border="1" align="center"> 
  <caption><font face="courier new" color="blue">ALLIED BANK <BR/>IT SERVICE REQUEST FORM</font><BR/><font size="2">ITSRF no.</font></caption>
<TR class="try">

<TD colspan=1> Requesting Unit : &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>Date ITSRF Prepared:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>

<TR class="try">
<TD>Contact Person :
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</TD>
<TD>Contact<br/> Number : &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>

<TR class="try">
<TD  COLSPAN= 2>Description of Request :<br><br><blockquote></blockquote></TD>
</TR>

<TR class="try">
<TD COLSPAN = 2>Purpose / Justification :<br><br><blockquote></blockquote>
</TD>
</TR>

<TR class="try">
<TD COLSPAN="2">Approved By:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Noted By:<br><blockquote>______________________&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; __________________<br/>Requesting Unit/Branch&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Group/DivisionHead<BR/></blockquote></TD>
</TR>
</table>
<br/>
 <table width = "709" cellpadding="10" border="1" align="center"> 
<TR class="try">
<TD ROWSPAN="2" width = "500" valign="top" >Concerned Hit Department's<br/> Evaluation/Recommendation :<br><br><br><br>
</TD>
<TD valign ="top"> Date ITSRF Received :<br><br></TD>

</TR>
<TR class="try">
<TD> Assigned To: &nbsp;&nbsp;&nbsp;&nbsp;_________________<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Project Manager<br></TD>
</TR>

<TR class="try">
<TD ROWSPAN="2" valign ="top"> &nbsp;
Reason :<br><br><br><br><div align="right">___________________<br></div><div align="right">HIT Division Head&nbsp;<br></div></TD>
<TD>
<input type="checkbox" name="approved"> Approved &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="checkbox" name="disapproved">Disapproved
</TD>

</TR>
<TR class ="try">

<TD> Date :</TD>

</TR>

 
 </table>
 

  </body>
</html>

Thank You.

3
Contributors
3
Replies
4
Views
6 Years
Discussion Span
Last Post by peter_budo
0

check this tutorial..
and also this.

CREATE DATABASE "tryDatabase"
  WITH OWNER = postgres
       ENCODING = 'UTF8';


-----------SOLUTION TABLE------------- successful
CREATE TABLE SOLUTION(
Solution_code numeric(5) PRIMARY KEY,
Description character(100),
Service_code numeric(5) REFERENCES SERVICE(Service_code),
Schedule_ID numeric(5) REFERENCES Schedule_Main(Schedule_ID),
URL_link character(100) );


-----------SCHEDULE MAIN TABLE--------- successful
CREATE TABLE Schedule_Main(
Schedule_ID numeric(5) PRIMARY KEY,
ITSRF_code character(10) REFERENCES ServiceRequest(ITSRF_code));


---------SERVICE REQUEST TABLE--------successful
CREATE TABLE ServiceRequest (
ITSRF_code character(10) PRIMARY KEY,
Service numeric(5) REFERENCES SERVICE(Service_code),
Description character(100), 
URL_link character(100),
RU_Code numeric(5) REFERENCES DEPARTMENT(Department_code),
RU_ContactPerson character(100),
ApprovedBy numeric(5) REFERENCES EndUser(User_code),
ApprovalDate date,
NotedBy numeric(5) REFERENCES EndUser(User_code),
ULQA_LogDate date,
ULQA_Personnel numeric(5) REFERENCES EndUser(User_code),
HIT_Department numeric(5) REFERENCES DEPARTMENT(Department_code),
HIT_Personnel numeric(5) REFERENCES EndUser(User_code),
Status character(10),
StartDate date,
Actual_StartDate date,
EndDate date,
Actual_EndDate date,
AcceptedBy numeric(5) REFERENCES EndUser(User_code),
DateAccepted date,
Remarks character(100) );

/*ALTER TABLE ServiceRequest ALTER COLUMN ITSRF_code TYPE character(10);

ALTER TABLE ServiceRequest ADD COLUMN Solution numeric(5) REFERENCES SOLUTION(Solution_code);

SELECT ITSRF_code AS ITSRF FROM ServiceRequest;

SELECT * FROM ServiceRequest;*/

----------USER TABLE---------- successful

CREATE TABLE EndUser(
User_code numeric(5) PRIMARY KEY,
LastName character(100),
FirstName character(100),
MiddleName character(100),
Pwd character(100), --Pwd - Password
Department_code numeric(5) REFERENCES DEPARTMENT(Department_code),
Position_code numeric(5) REFERENCES POS(Position_code), --Pos - Position
Access_code numeric(5) REFERENCES UserAccess(Access_code),
Signatory boolean,
Active boolean );


--DROP TABLE EndUser;


----------USER ACCESS TABLE------- successful

CREATE TABLE UserAccess(
Access_code numeric(5) PRIMARY KEY,
Module character(50),
Rights character(10) );


/*ALTER TABLE UserAccess ALTER COLUMN Access_code SET NOT NULL;
ALTER TABLE UserAccess ALTER COLUMN Rights SET NOT NULL;
ALTER TABLE UserAccess ALTER COLUMN Rights DROP DEFAULT;

select * from UserAccess;

DROP TABLE UserAccess;*/

---------SERVICE TABLE---------- successful

CREATE TABLE SERVICE(
Service_code numeric(5) PRIMARY KEY,
Description character(100) );

-------------POS TABLE------------ successful
CREATE TABLE POS(
Position_code numeric(5) PRIMARY KEY,
Description character(100) );

----------DEPARTMENT TABLE---------- successful

CREATE TABLE DEPARTMENT(
Department_code numeric(5) PRIMARY KEY,
DepartmentName character(100),
Branch_code numeric(5) REFERENCES BRANCH(Branch_code) );


--------BRANCH TABLE--------- successful

CREATE TABLE BRANCH(
Branch_code numeric(5) PRIMARY KEY,
BranceName character(100) );




------------SCHEDULE DETAIL TABLE---------successful

CREATE TABLE Schedule_Detailed(
Schedule_SubCode numeric(5) PRIMARY KEY,
Module character(100),
StartDate date,
EndDate date );

-----------INSERT INTO STATEMENTS----------


    
SELECT ITSRF_code FROM ServiceRequest;

SELECT Rights FROM UserAccess;
	

INSERT INTO ServiceRequest(Status)
	VALUES('Approved');
	
INSERT INTO ServiceRequest(Status,ITSRF_code)
	VALUES('Disapproved', '');


--successful
INSERT INTO UserAccess(Rights, Access_code)
	VALUES('Write', 1);
INSERT INTO UserAccess(Rights, Access_code)
	VALUES('Read', 2);

    
INSERT INTO ServiceRequest(ITSRF_code) 
SELECT (CAST(Department_code AS VARCHAR) || '99999' ) 
FROM DEPARTMENT;
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.