Mysql database authentication check

From MyWiki
Revision as of 15:21, 9 March 2016 by George2 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

This is not stand alone code, it depends of other classes

          Statement stmt = NULL;
          ResultSet rs = NULL;
          String userName = "xxxxx";
          String passWord = "xxxxxxxxx";
          String url = "jdbc:mysql://localhost/argus";
      try {
          Class.forName ("com.mysql.jdbc.Driver").newInstance ();
          conn = DriverManager.getConnection (url, userName, passWord);
          String getIt   =  "SELECT user from sessions where session = '"+SESSION.getId()+"'";
          stmt = conn.createStatement();
          rs = stmt.executeQuery(getIt);
          IF ( rs.NEXT() )
                         {
                         String USERNAME = rs.getString("user");
 
                         INT LENGTH = USERNAME.LENGTH();
                         }
          String ff = SESSION.getId();
          String myUrl = "ExtAttrs";
          CheckSessionId  qq = NEW CheckSessionId();
          String ab=qq.checkIt(ff,myUrl);
          IF ( ab.LENGTH() < 3) response.sendRedirect("login.jsp");