<%@ page contentType="text/html;charset=windows-1252" import="java.util.*" %> <%! String currDate=""; String Str_Code=""; String Str_Desc=""; java.sql.Statement stmt = null; java.sql.ResultSet ResSet = null; java.sql.Connection cn = null; List ls_Rcc_units; List ls_Mother_tongue; List ls_Income_category; List ls_Family_history; List ls_District; List ls_Education; List ls_Sex; List ls_Religion; List ls_Marital_status; List ls_Relation; %> <% try { Class.forName("oracle.jdbc.driver.OracleDriver"); cn = java.sql.DriverManager.getConnection("jdbc:oracle:thin:@172.16.18.170:1521:onconet","onco","net"); ls_Rcc_units=new ArrayList(); ls_Mother_tongue=new ArrayList(); ls_Income_category=new ArrayList(); ls_Family_history=new ArrayList(); ls_District=new ArrayList(); ls_Education=new ArrayList(); ls_Sex=new ArrayList(); ls_Religion=new ArrayList(); ls_Marital_status=new ArrayList(); ls_Relation=new ArrayList(); stmt= cn.createStatement(); ResSet=stmt.executeQuery("select UNIT_NAME,UNIT_ID,ACTIVE from RCC_UNITS order by UNIT_NAME"); while(ResSet.next()) { ls_Rcc_units.add(ResSet.getString("UNIT_NAME")); ls_Rcc_units.add(ResSet.getString("UNIT_ID")); ls_Rcc_units.add(ResSet.getString("ACTIVE")); } ResSet.close(); ResSet=stmt.executeQuery("select CODE,DESCRIPTION from MOTHER_TONGUE order by DESCRIPTION"); while(ResSet.next()) { ls_Mother_tongue.add(ResSet.getString("DESCRIPTION")); ls_Mother_tongue.add(ResSet.getString("CODE")); } ResSet.close(); ResSet=stmt.executeQuery("select CODE,DESCRIPTION from INCOME_CATEGORY order by DESCRIPTION"); while(ResSet.next()) { ls_Income_category.add(ResSet.getString("DESCRIPTION")); ls_Income_category.add(ResSet.getString("CODE")); } ResSet.close(); ResSet=stmt.executeQuery("select FAMILY_HISTORY_ID, DESCRIPTION from FAMILY_HISTORY order by DESCRIPTION"); while(ResSet.next()) { ls_Family_history.add(ResSet.getString("DESCRIPTION")); ls_Family_history.add(ResSet.getString("FAMILY_HISTORY_ID")); } ResSet.close(); ResSet=stmt.executeQuery("select CODE, DESCRIPTION from DISTRICT order by DESCRIPTION"); while(ResSet.next()) { ls_District.add(ResSet.getString("DESCRIPTION")); ls_District.add(ResSet.getString("CODE")); } ResSet.close(); ResSet=stmt.executeQuery("select CODE, DESCRIPTION from Education order by DESCRIPTION"); while(ResSet.next()) { ls_Education.add(ResSet.getString("DESCRIPTION")); ls_Education.add(ResSet.getString("CODE")); } ResSet.close(); ResSet=stmt.executeQuery("select CODE, DESCRIPTION from Sex order by DESCRIPTION"); while(ResSet.next()) { ls_Sex.add(ResSet.getString("DESCRIPTION")); ls_Sex.add(ResSet.getString("CODE")); } ResSet.close(); ResSet=stmt.executeQuery("select CODE, DESCRIPTION from Religion order by DESCRIPTION"); while(ResSet.next()) { ls_Religion.add(ResSet.getString("DESCRIPTION")); ls_Religion.add(ResSet.getString("CODE")); } ResSet.close(); ResSet=stmt.executeQuery("select CODE, DESCRIPTION from Marital_status order by DESCRIPTION"); while(ResSet.next()) { ls_Marital_status.add(ResSet.getString("DESCRIPTION")); ls_Marital_status.add(ResSet.getString("CODE")); } ResSet.close(); ResSet=stmt.executeQuery("select CODE, DESCRIPTION from Relation order by DESCRIPTION"); while(ResSet.next()) { ls_Relation.add(ResSet.getString("DESCRIPTION")); ls_Relation.add(ResSet.getString("CODE")); } ResSet.close(); ResSet=stmt.executeQuery("select Rdate from Dateview"); while(ResSet.next()) { currDate=ResSet.getString("Rdate"); } ResSet.close(); stmt.close(); cn.close(); %> <% String strValid=request.getParameter("valid"); strValid="TRUE"; if(strValid==null) strValid=""; if((!(strValid.toUpperCase().equals("TRUE"))) || (strValid.equals(""))){ response.sendRedirect("OPNetRegistration.jsp"); } else { %> Op New Registration
REGIONAL CANCER CENTRE
PATIENT REGISTRATION

Name of Patient *
:
Sex *
:
Education *
:
Mother Tongue *
:
Religion *
:
Foriegner *
:
DOB (dd/mm/yyyy)
:
Click Here to Pick up the date
Age *
:
Yrs Months
     
House Name/No *
:
Place/Street *
:
Post office *
:
District *
:
Pin
:
Phone No
:
Duration of stay
:
 Years
     
Relative Name *
:
Relation *
:
House Name/No *
:
Place/Street *
:
Post office *
:
District *
:
Pin
:
Phone No
:
Name of Father *
:
Name of Mother *
:
Marital Status *
:
Name of Spouse
:
Occupation of Patient *
:
Monthly family Income *
:
Birth Place
:
Family History of Cancer
:
<< Home

Regional Cancer Centre, Medical College Campus, Post Box: 2417,
Thiruvananthapuram - 695 011, Kerala, India.
Phone: 91-471-2442541 Fax: 91-471-2447454

Designed and Developed by
Best viewed in IE 5+ with resolution 1024*768
<% } } catch(Exception Exp) { System.out.println("Final Exception"); Exp.printStackTrace(); } finally{ if (ResSet != null) try { ResSet.close(); } catch (Exception e){ e.printStackTrace(); } if (stmt != null) try { stmt.close(); } catch (Exception e){ e.printStackTrace(); } if (cn != null) try { cn.close(); } catch (Exception e){ e.printStackTrace(); } } %>