%@ 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 { %>