<%@page import="java.sql.*" %>
      <%@page contentType="text/html" pageEncoding="UTF-8"%>
      <%
int j=0;
// Define parameters for retrieving database results
int m[] = new int[5000];

String user=request.getParameter("uname");
String password=request.getParameter("pwd");

Class.forName("com.mysql.jdbc.Driver");

String myDatabase = "jdbc:mysql://localhost:3306/mydb1?user=root&password=rootP";

Connection myConnection = DriverManager.getConnection(myDatabase);

// Create object to execute statements
Statement st = myConnection.createStatement();
ResultSet rs=st.executeQuery("select * from users where user='"+user+"'");
if(rs.next())
{
    if(rs.getString(1).isEmpty()||rs.getString(2).isEmpty()){
        out.println("enter sth");

    }
    else if(rs.getString(2).equals(password))
    {
    out.println("Welcome"+user);

    }
    else
    {
    out.println("Invalid password try again");

    }
}

%>