Expand|Select|Wrap|Line Numbers
- <%@ page import="java.sql.*"%>
- <jsp:include page="home.jsp" />
- <div style="left:200;top:0;height:100%;width:800;background-color:#d6d6d6;position:absolute">
- <HTML>
- <HEAD>
- <TITLE> Add B.Tech Project Details </TITLE>
- <META NAME="Generator" CONTENT="EditPlus">
- <META NAME="Author" CONTENT="">
- <META NAME="Keywords" CONTENT="">
- <META NAME="Description" CONTENT="">
- <style>
- TD
- {
- FONT-WEIGHT: bold;
- }
- </style>
- <!-- calendar stylesheet -->
- <link rel="stylesheet" type="text/css" media="all" href="calendar-win2k-cold-1.css" title="win2k-cold-1" />
- <!-- main calendar program -->
- <script type="text/javascript" src="calendar.js"></script>
- <!-- language for the calendar -->
- <script type="text/javascript" src="calendar-en.js"></script>
- <!-- the following script defines the Calendar.setup helper function, which makes
- adding a calendar a matter of 1 or 2 lines of code. -->
- <script type="text/javascript" src="calendar-setup.js"></script>
- <script type="text/javascript" language="javascript">
- function show()
- {
- if(""==document.forms.contact.college.value)
- {
- document.getElementById("1").style.visibility="visible";
- return false;
- }
- if(""==document.forms.contact.code.value)
- {
- document.getElementById("2").style.visibility="visible";
- return false;
- }
- if(""==document.forms.contact.place.value)
- {
- document.getElementById("3").style.visibility="visible";
- return false;
- }
- if(""==document.forms.contact.login.value)
- {
- document.getElementById("4").style.visibility="visible";
- return false;
- }
- if(""==document.forms.contact.pass.value)
- {
- document.getElementById("5").style.visibility="visible";
- return false;
- }
- }
- function reset1()
- {
- if(""==document.forms.contact.college.value)
- document.getElementById("1").style.visibility="visible";
- else
- document.getElementById("1").style.visibility="hidden";
- if(""==document.forms.contact.code.value)
- document.getElementById("2").style.visibility="visible";
- else
- document.getElementById("2").style.visibility="hidden";
- if(""==document.forms.contact.place.value)
- document.getElementById("3").style.visibility="visible";
- else
- document.getElementById("3").style.visibility="hidden";
- if(""==document.forms.contact.login.value)
- document.getElementById("4").style.visibility="visible";
- else
- document.getElementById("4").style.visibility="hidden";
- if(""==document.forms.contact.pass.value)
- document.getElementById("5").style.visibility="visible";
- else
- document.getElementById("5").style.visibility="hidden";
- }
- var emptyRow=null;
- function init() {
- var table = document.getElementById( 'insert' );
- var tbody = table.getElementsByTagName( 'TBODY' )[ 0 ];
- var tr = tbody.firstChild;
- while ( tr && tr.nodeName != 'TR' ) {
- tr = tr.nextSibling;
- }
- emptyRow = tr.cloneNode( true );
- }
- function AddRow() {
- var table = document.getElementById( 'insert' );
- var tbody = table.getElementsByTagName( 'TBODY' )[ 0 ];
- var numRows = tbody.rows.length;
- if(numRows >12)return false;
- var where = tbody.rows[ numRows - 1 ];
- var newRow = emptyRow.cloneNode( true );
- for(var i=0; i<tbody.rows.length; i++)
- {
- var new_name = "l2pn";
- for(var j=0; j<tbody.rows[i].childNodes.length; j++)
- {
- alert(">>"+tbody.rows[i].childNodes[j].getAttribute("Name")+">>");
- }
- }
- insertAfter( where, newRow, numRows );
- }
- function insertAfter( here, newNode, numRows)
- {
- here.parentNode.insertBefore( newNode, here.nextSibling );
- var newNode_name = '';
- }
- </script>
- </HEAD>
- <body onload='init()' bgcolor="d6d6d6" >
- <%
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:Driver={Oracle in XE}","system","charanteja");
- String code=(String)session.getAttribute("user1");
- PreparedStatement st=con.prepareStatement("select count(*) from revenue where staff_id=?");
- st.setString(1,code);
- ResultSet rs=st.executeQuery();
- rs.next();
- int sno=Integer.parseInt(rs.getString(1));
- %>
- <center>
- <div id ="a" ></div>
- </center>
- <FORM METHOD=POST action="./btechnext.jsp" onSubmit="return show(contact)" align="center" name="contact">
- <div id="divarea" style="visibility:hidden;color:green;size:18px" align="center"><b>B.Tech Project details added successfully</b></div>
- <b style="color:green;size:18px"><center>Add Details of B.Tech Projects</center></b><br><br>
- <table align="center">
- <tr width="400">
- <td align="left">S.No</td>
- <td align="right"><INPUT TYPE="text" NAME="sno4" readonly="readonly" value="<%=sno+1%>"></td></tr>
- <tr><td align="left">Title</td>
- <td align="right" ><INPUT TYPE="text" NAME="tit" onchange="reset1()"></td></tr>
- <tr><td align="left">Area</td>
- <td align="right" ><INPUT TYPE="text" NAME="area" onchange="reset1()"></td></tr>
- <tr><td align="left">Hours Spent/Week</td>
- <td align="right" ><INPUT TYPE="text" NAME="hpw1" onchange="reset1()"></td></tr>
- <tr><td align="left">Total Hours</td>
- <td align="right" ><INPUT TYPE="text" NAME="th1" onchange="reset1()"></td></tr>
- <tr>
- <td align="left" >From Date</td>
- <td >
- <input align="right" type="text" name="date1" id="date1" tabindex="6"></td>
- <td width="22"><img border="0" src="calendar.gif" id="f_trigger_c1" style="cursor: pointer; border: 1px solid red;" onmouseover="this.style.background='red';" onMouseOut="this.style.background=''" width="20" height="14" /></td>
- <script type="text/javascript">
- Calendar.setup({
- inputField : "date1", // id of the input field
- ifFormat : "%d/%m/%Y", // format of the input field
- button : "f_trigger_c1", // trigger for the calendar (button ID)
- align : "Tl", // alignment (defaults to "Bl")
- singleClick : true
- });
- </script>
- </tr>
- <tr>
- <td align="left">To Date</td>
- <td ><acronym title="Enter the Expected date of completion in case of ongoing projects">
- <input align="right" type="text" name="date2" id="date2" tabindex="7"> </acronym></td>
- <td width="22">
- <img border="0" src="calendar.gif" id="f_trigger_c2" style="cursor: pointer; border: 1px solid red;" onmouseover="this.style.background='red';" onMouseOut="this.style.background=''" width="20" height="14" /></td>
- <script type="text/javascript">
- Calendar.setup({
- inputField : "date2", // id of the input field
- ifFormat : "%d/%m/%Y", // format of the input field
- button : "f_trigger_c2", // trigger for the calendar (button ID)
- align : "Tl", // alignment (defaults to "Bl")
- singleClick : true
- });
- </script>
- </tr>
- </table>
- <table align="center"" id="insert" >
- <thead>
- <tr>
- <th align="left" >Student Name</th>
- <th align="right">Roll Number</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <th align="left" width="40"><INPUT TYPE="text" NAME="n1" onchange="reset1()"></th>
- <th align="right" width="40"><INPUT TYPE="text" NAME="r1" onchange="reset1()"></th>
- </tr>
- </tbody>
- </table>
- <table align="center"><th> </th>
- <th align="right"><input type='button' value='Add Student' onclick='AddRow()'></th></table>
- <center><br>
- <INPUT TYPE="submit" value="Save" onclick="show()" onclick="show()">
- <INPUT TYPE="Reset" value="Reset">
- </center>
- <br/>
- <table align="center">
- <tr>
- <td> <a href="viewmtech.jsp" style="color:green"><u>View M.Tech Projects Details</u> </a></td>
- </tr>
- </table>
- </FORM>
- </div>
- <%
- con.close();
- }
- catch(Exception e)
- {
- out.println(e);
- }
- %>
- </BODY>
- </HTML>