Java EE (Java Enterprise Edition) General Discussion

Could someone please tell what's wrong with this code? Any help will be greatly appreciated

<%@ page import="java.util.Date"%>
<%@ page import="java.util.*,Website.*" %>
<%@ page import="java.net.*"%>
<jsp:useBean id="myForm"scope="session"class="Website.UserLogin"/>
<jsp:setProperty name="myForm" property="*"/>
<%
myForm.MakeConnection();
myForm.login();
String name = myForm.getUsername();
System.out.println("\nusername from String: "+name);
System.out.println("\nusername from database: "+myForm.getUsername());
System.out.println("\nresult of boolean: "+myForm.getbool());

if(myForm.getbool() == true && myForm.getpreferences().equals("swimming"))
{
%>
<jsp:forward page = "swimming.jsp"/>
<%
}
else if(myForm.getbool() == true && myForm.getpreferences().equals("Tennis"))
{
%>
<jsp:forward page= "Tennis.jsp"/>
<%
}
else if(myForm.getbool() == true && myForm.getpreferences().equals("Soccer"))
{
%>
<jsp:forward page= "Soccer.jsp"/>
<%
}
else
{
System.out.println("failure");
%>
<jsp:forward page = "Login.html"/>
<%
}
myForm.close();
%>

package Website;

import java.io.*;
import java.sql.*;
import java.text.*;

public class UserLogin
{
  Connection db;	
  Statement  st;	
  
  	private ResultSet rsetlogin;
  
  	private static String Username;
	private String Cust_Password;
	private String Prefered_Sport;
  
  	public String getUsername() 		{return Username;   }
	public String getCust_Password	()   {return Cust_Password;   }
	public String getpreferences() {return Prefered_Sport	;}
	
	
	public void setUsername				(String username1)	  { Username    = username1;   }
	public void setCust_Password		(String password1)	  { Cust_Password    = password1;   }
	public void setpreferences  (String preferences1) { Prefered_Sport = preferences1;}
	
  
  public UserLogin(String args[]) throws ClassNotFoundException, FileNotFoundException, IOException, SQLException
  {
  	MakeConnection();
  	
  	 System.out.println("Now closing the connection");
    st.close();
    db.close();
    
    }
    
    public void MakeConnection()throws ClassNotFoundException, FileNotFoundException, IOException, SQLException
   {
   	String url = "jdbc:postgresql:database";
    String usr = "postgres";
    String pwd = "dune";
    
    // Load the driver
    Class.forName("org.postgresql.Driver");
    
    // Connect to database
    System.out.println("Connecting to Database URL = " + url);
    db = DriverManager.getConnection(url, usr, pwd);
    
    System.out.println("Connected...Now creating a statement");
    st = db.createStatement();
   	
   }
   
   boolean validpass = false;
//method to log in.
//------------------------------------------------------------------------------
    public boolean getbool(){return validpass;}
	public void login()
	{
		String usernameIn;
		String passwordIn;
		try
		{
			Statement stmt = db.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
			rsetlogin = stmt.executeQuery("SELECT Username,Cust_Password, Prefered_Sport  FROM Customer WHERE Username ='"+getUsername()+"'");
			while(rsetlogin.next())
			{
				usernameIn = rsetlogin.getString(1);
				passwordIn = rsetlogin.getString(2);
				
				if(usernameIn.equals(getUsername()) && passwordIn.equals(getCust_Password()))
				{
					validpass = true;
					System.out.println("log in success");
					setUsername(rsetlogin.getString(1));
					setCust_Password(rsetlogin.getString(2))	;
				}
				else if(!usernameIn.equals(getUsername()) || !passwordIn.equals(getCust_Password()))
				{
					System.out.println("log in failure");
					validpass = false;
				}
			}
		}
		catch (SQLException e)
		{
			System.out.print("Error at login");
			e.printStackTrace();
		}
	}
	

	public static void main(String args[])
  {
    System.out.println("PostgreSQL basic test v6.3 rev 1\n");
       }
  }