Expand|Select|Wrap|Line Numbers
- <%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%> <%
- String path = request.getContextPath();
- String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
- %> <html> <head> <title>Assessment Call List</title> <script language="javascript">
- function validation()
- {
- var count=0;
- for(vari=0;i<admin.chbox.length;i++)
- {
- if(admin.chbox[i].checked)
- {
- count++;
- }
- }
- if(count==0)
- {
- alert("check the messages to delete & u had limited msg");
- //document.msgchbox.checkbox.focus();
- return false;
- }
- else
- {
- return true;
- }
- }
- </script> </head> <body> <form name="admin" method="post" action="http://bytes.com/Delete.jsp" onClick="return validation()"> <h2 align="center"><font color="800000"></>Assessment Call List</font></h2> <div align="right"><input type="submit" value=" DELETE "/>********& nbsp;*****
- </div> <div> <table border="3" width="95%"> <%@page import="java.sql.DriverManager"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.Connection"%> <%@page import="com.list.*"%> <%
- Connection con = null;
- Statement stmt = null;
- ResultSet rs=null;
- %> <tr> <td width="10%"></td> <td width="32%">Names</td> <td width="40%">Date of Assessment</td> </tr></table> </div> </form> <%
- try
- {
- //Class.forName("com.mysql.jdbc.Driver");
- //con = DriverManager.getConnection("jdbc:mysql://localhost:3306/ram","root","sun");
- //stmt = con.createStatement();
- stmt=DB.getConnection().createStatement();
- String qy = "select * from Edate";
- rs = stmt.executeQuery(qy);
- while(rs.next())
- {
- String NAMES=rs.getString(1);
- String DATES=rs.getString(2);
- %> <table width="95%"> <tr><td width="12%"><input type="checkbox" name="chbox" value="<%=rs.getString(0)%>"/></td> <td width="33%"><%=rs.getString(1)%></td> <td width="41%"><%=rs.getString(2)%></td> </tr></table> <%
- }
- }
- catch(Exception e)
- {
- out.println(e.getMessage());
- }
- %> </body> </html>
Invalid Column Index