Open A Form Depending On Username And Password Entered

I am creating a login form for my project and it works great,the issue is that i want to open up different forms dependent on the username and password that i enter.for example if i enter a password 'manager' then it should open the manager page,or 'employee' should open the employee page.

I'm thinking that it is just a case of creating another sql query but i have tried and i cannot see the solution,i can open the employee page by default but that is not what i am trying to achieve. I am using an sqlite database which holds the username and password.

Here is my code
 
private void btn_LoginActionPerformed(java.awt.event.ActionEvent evt) {
// code to login to the back office system
String sql =" select username,password from Employee where username =? AND password =?";//sql query
try{
pst =conn.prepareStatement(sql);

[Code] ......