Query Mysql
From MyWiki
Connection con = null; HttpSession session = request.getSession(true); Statement stmt = null; ResultSet rs = null; String userName = "<username>"; String passWord = "<password>"; String url = "jdbc:mysql://<servername>/argus"; try{ con = DriverManager.getConnection (url, userName, passWord); String getIt = "SELECT user from sessions where session = '"+session.getId()+"'"; stmt = con.createStatement(); rs = stmt.executeQuery(getIt); rs.next(); String USERNAME = rs.getString("user"); //out.println("Logged in as :"+USERNAME); //int length = USERNAME.length(); } catch(Exception e ) { }