<%@ page contentType="text/html"%>

<%@ page import="com.sybase.jdbc2.jdbc.*" %>

<%@ page import="java.sql.*" %>

<%!

Connection con;

Statement st;

ResultSet rs;

String user,pwd;

%>

<%

try

{

user=request.getParameter("user");

pwd=request.getParameter("pwd");

String connstr="jdbc:sybase:Tds:softtrainer4:5000/kalees";

Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();

con=DriverManager.getConnection(connstr,"sa","");

st=con.createStatement();

String query="select * from login where Username='"+user+"'and Password='"+pwd+"'";

rs=st.executeQuery(query);

if(rs.next())

{

response.sendRedirect("add.html");

}

else

{

out.println("Invalid Username and Password");

response.sendRedirect("login.html");

}

con.close();

}

catch(Exception e)

{

out.println(e);

}

%>

import java.io.*;

import java.net.*;

import javax.servlet.*;

import javax.servlet.http.*;

import java.sql.*;

public class AdminLoginController extends HttpServlet {

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

try{

response.setContentType("text/html");

PrintWriter out = response.getWriter();

String login_id = request.getParameter("login_name");

String password = request.getParameter("password");

String query = "select login_id, password from admin_reg_tab";

String connstr = "jdbc:oracle:thin:@192.168.2.142:1521:peri";

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection con = DriverManager.getConnection(connstr,"system","manager");

Statement st = con.createStatement();

ResultSet rs = st.executeQuery(query);

ResultSetMetaData resultSetMetaData = rs.getMetaData();

int columnCount = resultSetMetaData.getColumnCount();

String Destination = "nothing";

while(rs.next()) {

if((rs.getString(1)).equals(login_id) && (rs.getString(2)).equals(password)){

Destination = "/AdminChoiceForm.jsp";

break;

}

else

Destination = "/AdminRegisterAlertForm.jsp";

}

RequestDispatcher dispatcher = getServletContext().getRequestDispatcher(Destination);

dispatcher.forward(request, response);

con.close();

} catch(ClassNotFoundException cnfe) {

System.err.println(cnfe);

}

catch(SQLException sqle) {

System.err.println(sqle);

}

catch(Exception e) {

System.err.println(e);

}

}}