Mysql database authentication check - Revision history

George2 at 15:21, 9 March 2016

2016-03-09T15:21:21Z

George2 at 15:13, 9 March 2016

2016-03-09T15:13:24Z

George2: Created page with " Statement stmt = null; ResultSet rs = null; String userName = "argus"; String passWord = "C1n0bbwT"; Stri..."

2016-03-09T15:12:29Z

Created page with "<source lang="sql"> Statement stmt = null; ResultSet rs = null; String userName = "argus"; String passWord = "C1n0bbwT"; Stri..."

New page

<source lang="sql">
Statement stmt = null;
ResultSet rs = null;
String userName = "argus";
String passWord = "C1n0bbwT";
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");

</source>

← Older revision		Revision as of 15:13, 9 March 2016
Line 1:		Line 1:
		+	This is not stand alone code, it depends of other classes<br>
	<source lang="sql">		<source lang="sql">
	Statement stmt = null;		Statement stmt = null;

@@ Line 3: / Line 3: @@
            Statement stmt = null;
            ResultSet rs = null;
-           String userName = "argus";
+           String userName = "xxxxx";
-           String passWord = "C1n0bbwT";
+           String passWord = "xxxxxxxxx";
            String url = "jdbc:mysql://localhost/argus";
        try {