Thread: Unable to read '#' value using getParameter

I have written a Java Servlet which queries the database and returns the result to JSP. I am executing the SQL Statement based on the parameters passed from the URL

//Reading Parameter
String User = request.getParameter("userid");

//Executing the SQL
String sqluser = "SELECT 1 FROM <table name> WHERE username = ?
pstmt = con.prepareStatement(sqluser);
pstmt.setString(1, User); //Setting the value passed from URL
rset = pstmt.executeQuery();

The sample URL: http:\testenv.com\test?userid=tana
The above URL displays correct result since user='tana'.

But there are some users that have "#" in their user name.

For e.g: http:\testenv.com\test?userid=la#na

The SQL Statement does not return any value because User= 'la' in above case even though the URL has "la#na". Can i get the value "la#na" using getParameter? If so what do i need to do?

That '#' is the Fragment Identifier:

Fragment identifier - Wikipedia, the free encyclopedia

You won't see it at the server because most user agents (browsers) don't send it to the originating server - it's used for identifying locations *within* the resource. If you're using '#' as a valid character in fields in your application, then you must encode the # characters before you build them into request URLs. Both javascript and Java have functions for 'URL encoding' # characters.