jsp code for dynamic time table generation

Home Answers Viewqa JSP-Servlet jsp code for dynamic time table generation

raghavendra

jsp code for dynamic time table generation
1 Answer(s) 3 years and a month ago
Posted in : JSP-Servlet

hi
I am doing my academic project college automation.
I want to generate time table dynamically for each btech and mca,mba branches.Pls provide a solution how to process this requirement.

pls...

View Answers

June 5, 2010 at 1:18 PM

Hi Friend,

Try the following code:

<%@page import="java.sql.*"%>
<%String course=request.getParameter("course");%>
<html>
<script>
function get(course){
var val =course.options[course.selectedIndex].text;
window.location.replace("timetable.jsp?course="+val);
}
</script>
<form name="form">
<select name="course" onchange="get(this);">
<option >Select</option>
<option value="BTech">BTech</option>
<option value="MBA">MBA</option>
<option value="MCA">MCA</option>

</select>
</form>
<%
if(course!=null){
%>
<h2>TIMETABLE</h2>
<h4><font color="red"><%=course%></font></h4>
<table border="1">
<tr bgcolor="red"><th>Days</th><th>I</th><th>II</th><th>III</th><th>IV</th><th>V</th><th>VI</th><th>VII</th><th>VIII</th></tr>
<%
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql","root";, "root");
Statement st=connection.createStatement();
ResultSet rs=st.executeQuery("select * from "+course);
while(rs.next()){
%>
<tr><th bgcolor="red"><%=rs.getString("days")%></th><td><%=rs.getString("1")%></td><td><%=rs.getString("2")%></td><td><%=rs.getString("3")%></td><td><%=rs.getString("4")%></td><td><%=rs.getString("5")%></td><td><%=rs.getString("6")%></td><td><%=rs.getString("7")%></td><td><%=rs.getString("8")%></td></tr>
<%
}
}
catch(Exception e){}
%>
</table>
<%
}
%>

For the above code, we have created three database tables

1)btech:

CREATE TABLE `btech` (
`days` varchar(255) default NULL,
`1` varchar(255) default NULL,
`2` varchar(255) default NULL,
`3` varchar(255) default NULL,
`4` varchar(255) default NULL,
`5` varchar(255) default NULL,
`6` varchar(255) default NULL,
`7` varchar(255) default NULL,
`8` varchar(255) default NULL
)
2)mba:

CREATE TABLE `mba` (
`days` varchar(255) default NULL,
`1` varchar(255) default NULL,
`2` varchar(255) default NULL,
`3` varchar(255) default NULL,
`4` varchar(255) default NULL,
`5` varchar(255) default NULL,
`6` varchar(255) default NULL,
`7` varchar(255) default NULL,
`8` varchar(255) default NULL
)

3)mca:

CREATE TABLE `btech` (
`days` varchar(255) default NULL,
`1` varchar(255) default NULL,
`2` varchar(255) default NULL,
`3` varchar(255) default NULL,
`4` varchar(255) default NULL,
`5` varchar(255) default NULL,
`6` varchar(255) default NULL,
`7` varchar(255) default NULL,
`8` varchar(255) default NULL
)

Thanks

jsp code for dynamic time table generation - JSP-Servlet
jsp code for dynamic time table generation hi I am doing my academic project college automation. I want to generate time table dynamically... For the above code, we have created three database tables 1)btech: CREATE TABLE

Time table generation
in the time table is there any calculations possible to do this work? The code you...Time table generation Hi I am 3rd year bca student i want create time table generator for my project.i am going to create it as school time table

Time table generation
Time table generation Hi I am 3rd year bca student i want create time table generator for my project.i am going to create it as school time table...: Generate TimeTable using JSP

id generation
this code, useful for u thanks CREATE TABLE mohan2 ( sno bigint(20...id generation CREATE TABLE `mohan2` ( `sno` bigint(20) NOT NULL...; <title>My JSP 'index.jsp' starting page</title> <

generating time table - JSP-Servlet
..the code should be in jsp/servlet.. so please help me friends...generating time table hi friends, i want generate examination timetable for examinations of courses like btech(cse,ece,eee..etc),if i give starting

Dynamic row genertion in javascript? - JSP-Servlet
Dynamic row genertion in javascript? Hi roseindia, I want coding in javascript to add a dynamic row in jsp..This row contain 3 fields(2..., Use the following code: function addRow(tableID){ var table

JSP: Dynamic Linking - JSP-Servlet
inside your result set loop to provide them a dynamic link. JSP Code...JSP: Dynamic Linking Hi I am fetching data as a search result from database and displaying it in a table(id and name)using while(rs.next()){...}.I

jsp code for date generation - JSP-Servlet
jsp code for date generation hai i am meyis i need a jsp program code for date generation.(mssql-back end) Fields are fromdate and todate both... thanks Hi friend, For more information on Date in JSP

Dynamic form
Dynamic form I need to make a dynamic form using jsp for example, i...; For the above code, we have created two database tables: CREATE TABLE `country...; Here is an application of jsp dependent dropdown where we have a dropdown

JSP:Dynamic Linking - JSP-Servlet
JSP:Dynamic Linking Hi This is extension to my previous question... it in a table(id and name)using while(rs.next()){...}.I want to provide hyper link... friend, Code to help in solving the problem : "view1.jsp" All

Dynamic retrieval od data from database and display it in the table at jsp
Dynamic retrieval od data from database and display it in the table at jsp ... the details of 20 members in a table format at jsp page by dynamically retrieving...; Here is a jsp code that retrieves the data from the database and display

jsp code for storing login and logout time to an account
jsp code for storing login and logout time to an account I need simple jsp code for extracting and storing login and logout time in a database table...://www.roseindia.net/jsp/loginstatus.shtml

dynamic generation of html:select tag from textbox value
dynamic generation of html:select tag from textbox value Hi, I am a newbie to java and struts. In my application, I have a requirement like when i... action class? And i have no idea how to implement this. I am using jsp. Any help

Play framework dynamic form generation
Play framework dynamic form generation I want to generate dynamic forms using play framework can any one give me some idea about dynamic form generation using play framework

how to insert value in dynamic table
a dynamic table for every company.but whenever i'm inserting values to the company sql server showing a syntax error. my code is as follows:- PreparedStatement ps1...how to insert value in dynamic table i am creating a project

how to add the calendar to the dynamic rows in html or jsp page - JSP-Servlet
how to add the calendar to the dynamic rows in html or jsp page Hi Sir, i have 3 columns in my jsp page date of payment,amount recieved,no and i have 2 button in my jsp page ADD and delete button. when i click on add

dynamic report
dynamic report i need complete code for generating dynamic report in jsp

java with jsp and dynamic database retrival for bar charts
java with jsp and dynamic database retrival for bar charts Hi, I am having a table name tablelogin,it consists of columns userid,logintime... dynamically for the table values logintime and userid from database.. can u please

Hibernate generation Id to postgreSQL
have a table (that entries were done with Hibernate script): carId|car_description 1|john 2|mike 3|Peter 2 - Now, I clean the table, and next time I...Hibernate generation Id to postgreSQL Hi, I'm trying to implement

Dynamic include of multiple files
Dynamic include of multiple files I want to include a series... to be a call to a table-building routine, each will look something like this: out.write...; fileArray.length; i++) { String fn = "./" + fileArray[i] + ".inc.jsp"; %><jsp: include

dynamic delete and insertion in tables
dynamic delete and insertion in tables hey... i have a problem..I am working on a problem management system..my code for a particular jsp page... which the admin has to enter. print("code sample"); <table width="205

Dynamic Proxies - Short Tutorial
Dynamic Proxies - Short Tutorial 2001-01-18 The Java Specialists' Newsletter [Issue 005] - Dynamic Proxies - Short Tutorial Author: Dr. Christoph G...! Christoph started writing Java code at the end of 1999 for a very innovative

dynamic drop down
dynamic drop down I have created 2 drop downs in jsp.1... into the designation drop down (use jsp+javascript+servlet) reply soon 1...(Exception e){ System.out.println(e); } %> For the above code

Create dynamic page through JSP
Create dynamic page through JSP This is detailed jsp code that shows how to create dynamic page. This code shows one by one record of student from

Creating dynamic jsp file in java file to include another jsp file
Creating dynamic jsp file in java file to include another jsp file I am able to create jsp file in java that includes ; table tr td and img tags..... Need to include jsp file in the same content. The below code doesn't help me

Table generation error - EJB
Table generation error Hi friends I am using EJB3.0 with sun java... an EJB it gives the following exception and doesnt generate any table... "CREATE TABLE BookShop (ID INTEGER NOT NULL, BOOKNAME VARCHAR(255), AUTHOR VARCHAR

Dynamic link in JSP
Dynamic link in JSP Hii everyone...I have stuck from last 2 days... selecting One source and multiple Targets, i have to generate one table using... jsp page which contains some checkboxes, so from that checkboxes , i have

dynamic display - JSP-Servlet
dynamic display hi, i want to display dynamic values in drop drown box in a jsp page.these values are in the form of arraylist's object which... Friend, Try the following code: 1)DataServlet.java: import java.io.

report generation using jsp
report generation using jsp report generation coding using jsp

dynamic retrivel of data from mysql database in table format at jsp
dynamic retrivel of data from mysql database in table format at jsp ... the data from database and display it as table format in jsp... For example, i have... and also details of each member should be displayed in the table format in jsp

dynamic form
dynamic form I need to make a dynamic form using php, for example, i...['city']?></option> <? } ?> </select> For the above code, you need to create following database tables. CREATE TABLE `country` ( `id

jsp code - JSP-Servlet
jsp code hi my requirement is generate dynamic drop down lists... the second drop down list is displayed from mysql data base table by using select statement? pls provide code how to get first selected drop down list value

Dependant & dynamic drop down list
Dependant & dynamic drop down list I don't know this should be in this or AJAX forum. I have one dynamic drop down list from data base (working fine) Use can select random entries from this table & hit "RETRIEVE

jsp code - JSP-Servlet
jsp code i want to add below code data in mysql database using jsp... using below code we got data in text box i want to add multiple data in database... Add/Remove dynamic rows in HTML table

java code to insert select at run time....????
java code to insert select at run time....???? java database code... jsp and withot jsp 1)application.jsp: <%@ page import="java.sql....="post" name="form"> <table border="1"> <tr><th>Name<

PHP Page generation time
PHP Page generation time In this tutorial I'll show you how to capture... current time before code is executed. Then we will have to get current time again... and end time values. Before your main PHP code write: //Get current time

JavaScript generate dynamic row
dynamically to the table with these 3 fields. Here is the code...JavaScript generate dynamic row In this section, you will learn how to generate dynamic row using JavaScript. Here a row contain 3 fields(2 textfields,1 text

JSP Code - JSP-Servlet
For the above code,we have created a table 'student'. CREATE TABLE `student...JSP Code Hi, I have a problem in limiting the number of row display in the table. For example, if i have 1000 records in my table & want

jsp code - JSP-Servlet
colum. Hi Friend, Try the following code: Add/Remove dynamic rows in HTML table var i=0,j=0,sum=0; arr = new Array(); arr1=new...jsp code i want to add and remove rows dynamically ... in that row 3

jsp code - JSP-Servlet
jsp code hi i am doing project work i am generating time table for this i have taken form courseyear textbox semistername textbox no of periods... will be allotted to six days. pls send me code for this pls thankyou

Date Time Problem In Jsp code - Development process
Date Time Problem In Jsp code Hi Friends, By using this code , am storing date and time into msaccess database. But while retriving i want to get same date and time .send me code for that. SimpleDateFormat

report generation
report generation i need to show the report between two dates in jsp is it possible

Dynamic-update not working in Hibernate.
Dynamic-update not working in Hibernate. Why is dynamic update not working in hibernate? Dynamic-update is not working. It means when you are running your update, new data is added in your table in place

dynamic retrival of data from mysql database to dropdownlist in jsp
)For the above code, we have created following table: CREATE TABLE `dept...dynamic retrival of data from mysql database to dropdownlist in jsp ... database to the dropdownlist in jsp. Example: 1st i want to display the list

report generation
report generation hi i need a code to generate reports in bar graph and pie charts.i found these codes in roseindia.in unfortunately its not working................. plz help me

report generation
report generation hi i found some source codes related to barchart and pie chart .when i try to run thise code its showing me the error as :- java.lang.NoSuchMethodError: org.jfree.text.TextBlock.setLineAlignment(Lorg/jfree/ui

resize dynamic image in jsp - JSP-Servlet
resize dynamic image in jsp Sir, I am saving the images in mysql database with Blob. An I am retrieving the images with this code:- I am getting my image with this code but all I need that I want to resize

frame generation
dthe code

Latest
Frameworks
Category