Authentication in Java

[thiruvasagamani]

Authentication in JSP

Here is the source code for Authentication

Code Select Expand

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);

}

}}