<%@ page import="java.sql.*, java.util.*, java.text.*, java.lang.*, com.iitguide.utils.dbutils.*" %> <%@ page errorPage="../error.jsp" %>

The VIDEO CHAT way of coaching!
Contact us at - Tel: 91-8954000504  or   e-mail: contact@iitguide.com

Chemistry @ Dr. P. Bahadur (Physical Chemistry) and Dr. V. Sharan (Organic and Inorganic Chemistry)

<% ResultSet rs1; ResultSet rs2; // Every year you just need to change these four strings -- start String offered_course_package_code = "chemistry_main_2016_1"; // One year course String offered_course_package_code_all = "all_main_2016_1"; //One year course // Every year you just need to change these four strings -- end String profName = "Dr. P. Bahadur (Physical Chemistry) and Dr. V. Sharan (Organic and Inorganic Chemistry)"; %>

All classes are online, live and interactive and will be taught by <%=profName%> . You can join these classes from your home, cyber cafe or school. [ In case you miss a class then you can watch HD video recording anytime and as many times you want ]

<% try { Connection connDB=new DBConnection().getConnection(); Statement stmt1 = connDB.createStatement(); Statement stmt2 = connDB.createStatement(); //checking if the courses are full. String strsql = "select offered_course_package_code, packagestatus from offeredcoursepackages where offered_course_package_code='"+offered_course_package_code+"'"; rs1 = stmt1.executeQuery(strsql); int i = 0; while (rs1.next()) { if (rs1.getString("packagestatus").equals("Available")) { strsql = "select * from offeredcoursepackages where offeredcoursepackages.offered_course_package_code='"+offered_course_package_code_all+"'"; rs2 = stmt2.executeQuery(strsql); rs2.next(); strsql = "select DATE_FORMAT(schedule, '%W, %M %D %Y, ' '%H:%i:%s'), chapter_name, lecture_duration, status, offeredcoursepackages.offeredcoursepackages_name, offeredcoursepackages.price, offeredcoursepackages.subject_code from offeredcourses , courses, offeredcoursepackages where offeredcourses.chapter_code=courses.chapter_code and offeredcourses.offered_course_package_code=offeredcoursepackages.offered_course_package_code and offeredcoursepackages.offered_course_package_code='"+offered_course_package_code+"' order by schedule"; rs2 = stmt2.executeQuery(strsql); while (rs2.next() ) { i++; %> <% } } } stmt1.close(); connDB.close(); } catch(SQLException r){out.println("no"+r);} %>
Sr. No. Chapter Name Duration
<%=i%> <%=rs2.getString("chapter_name")%> <%=rs2.getString("lecture_duration")%>


 



Welcome to iitguide.com!

Get online and learn from experts.