/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
/**
*
* @author HP
*/
@WebServlet(urlPatterns = {"/LoginServlet"})
public class LoginServlet extends HttpServlet {
Connection connection;
String url = "jdbc:postgresql://localhost:5432/TestDB";
String user = "postgres";
String pass = "root123";
public void dbConnection(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
PrintWriter out = response.getWriter();
out.println("hiiiiii");
try {
Class.forName("org.postgresql.Driver");
} catch(ClassNotFoundException e ){
//e.getMessage();
out.println(e.getMessage());
}
try {
String _username = request.getParameter("username");
String _password = request.getParameter("password");
String username = null;
String password = null;
Boolean found = false;
connection = DriverManager.getConnection(url, user, pass);
out.println("Connected");
Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery("select * from public.\"Login\"");
while(rs.next())
{
username = rs.getString("username");
password = rs.getString("password");
if (username.equals(_username)&&password.equals(_password))
{
found = true;
break;
}
}
if (true == found)
{
out.println("Login success");
}
else
{
out.println("Login Failed");
}
connection.close();
} catch (SQLException ex) {
out.println(ex.getMessage());
}
}
/**
* Processes requests for both HTTP GET and POST
* methods.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
try (PrintWriter out = response.getWriter()) {
/* TODO output your page here. You may use following sample code. */
out.println("");
out.println("");
out.println("");
out.println("Servlet LoginServlet");
out.println("");
out.println("");
out.println("Servlet LoginServlet at " + request.getContextPath() + "
");
out.println("");
out.println("");
}
}
//
/**
* Handles the HTTP GET method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Handles the HTTP POST method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//processRequest(request, response);
dbConnection(request, response);
}
/**
* Returns a short description of the servlet.
*
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}//
}