Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * 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.
- */
- package com.Servlet;
- import static com.sun.corba.se.spi.presentation.rmi.StubAdapter.request;
- import java.sql.*;
- import java.io.IOException;
- import java.io.PrintWriter;
- import java.io.StringWriter;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.util.Scanner;
- import javax.servlet.RequestDispatcher;
- import javax.sql.DataSource;
- import javax.servlet.ServletException;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- /**
- *
- * @author Jony
- */
- public class LoginServlet extends HttpServlet {
- private static Object request;
- public static void main(String[] args) throws SQLException, ClassNotFoundException {
- Connection connection = null;
- Statement stmt = null;
- try {
- //STEP 2: Register JDBC driver
- Class.forName("com.mysql.jdbc.Driver");
- } catch (Exception e) {
- }
- //STEP 3: Open a connection
- System.out.println("Connecting to database...");
- connection = DriverManager
- .getConnection("jdbc:mysql://localhost:3306/user_pass", "root", "zeitoun");
- //STEP 4: Execute a query
- System.out.println("Creating statement...");
- stmt = connection.createStatement();
- String sql;
- sql = "SELECT username, password FROM information";
- ResultSet rs = stmt.executeQuery(sql);
- while (rs.next()) {
- //retrieve by column name
- String usernamedb = rs.getString("username");
- String passworddb = rs.getString("password");
- if (usernamedb.equals(inputUsername) && passworddb.equals(inputPassword)) {
- System.out.println("Login successful " + usernamedb + " " + passworddb);
- } else {
- System.out.println("Login failed " + usernamedb + " " + passworddb);
- }
- }
- }
- /**
- *
- * @param request
- * @param response
- * @throws ServletException
- * @throws IOException
- */
- @Override
- protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- PrintWriter out = response.getWriter();
- String title = "Welcome";
- String docType =
- "<!doctype html public "-//w3c//dtd html 4.0 " +
- "transitional//en">n";
- out.println(docType + title);
- String inputUsername = request.getParameter("Name");
- String inputPassword = request.getParameter("Pass");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement