Select Query of MySql in Java

For any Select query in java write::

public boolean is_login(String username,String pass_word)
{
boolean having=false;

String query="SELECT * FROM userinfo WHERE username='"+username+"'"+"AND password='"+pass_word+"';";
try
{
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery(query);
having=rs.next();
rs.close();
stmt.close();
}
catch (Exception e)
{
errmsg ="Cannot connect to database server/*/*/*/*"+e.getMessage();
JOptionPane.showMessageDialog(null,errmsg, "Error msg", JOptionPane.ERROR_MESSAGE);
}
return having;
}