Query Mysql - Revision history

George2 at 19:19, 3 November 2014

2014-11-03T19:19:52Z

George2 at 19:13, 3 November 2014

2014-11-03T19:13:48Z

George2 at 19:13, 3 November 2014

2014-11-03T19:13:19Z

George2: Created page with " Connection con = null; HttpSession session = request.getSession(true); Statement stmt = null; ResultSet rs = null; String userName = ""; String..."

2014-11-03T19:10:47Z

Created page with "<source lang="java"> Connection con = null; HttpSession session = request.getSession(true); Statement stmt = null; ResultSet rs = null; String userName = "<username>"; String..."

New page

<source lang="java">

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 ) { }

</source>

@@ Line 5: / Line 5: @@
 Statement stmt = null;                              // For the query
 ResultSet rs = null;                                //
-Statement stmt2 = null;                                 // For the update
+Statement stmt2 = null;                           // For the update
-ResultSet rs2 = null;                                   //
+ResultSet rs2 = null;                             //
 String userName = "<username>";
 String passWord = "<password>";

@@ Line 21: / Line 21: @@
               //out.println("Logged in as  :"+USERNAME);
               //int length = USERNAME.length();
+}
 catch(Exception e ) { }