<%
try
{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//String url="jdbc:odbc:ODVS";
Connection conn=null;//DriverManager.getConnection(url,"downtime","downtime");
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:SID:@10.10.10.2:1521:PLMDM","abc","abc");
String uid=request.getParameter("Username");
String pwd=request.getParameter("Password");
String sqlQry=("select * from USR_PASS_TB where Username='"+uid+"' and Password='"+pwd+"'");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(sqlQry);
if(rs.next()==true)
{
//response.sendRedirect("../HTML/index_group.htm");
%>
<jsp:forward page="../HTML/index_group.htm" />
<%
}
else
{
//response.sendRedirect("..HTML/invalid_login.htm");
%>
<jsp:forward page="../HTML/invalid_login.htm" />
<%
}
rs.close();
conn.close();
}
catch(Exception e1)
{
System.out.println(e1);
}
%>
this code is not forwarding to index_group page..plzz help me out...plzzz