Welcome to CodeRanch! Your IDE is just the place you type. Since this is a coding question about databases, I'm going to move it to our JDBC forum. Where you will likely be suggested to have the database code in a Java class rather than a JSP. JSPs are meant for displaying info.