<form name="log" method="post" action="login.htm">    
        
    <%
       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:thin:@10.10.10.2:1521:PLMDM","vvv","vvv");
         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="login_cae.htm" />
         

       <%
       }
         else
         {
             //response.sendRedirect("..HTML/invalid_login.htm");
       %>
          <jsp:forward page="index_group.htm" />
              
       <%
         }
         rs.close();
         conn.close();
		            
         }
         catch(Exception e1)
       	 {
            System.out.println(e1);
	 }
    %>