Java

Blue_Boy wrote:

ResultSet rs = stmt.executeQuery("SELECT Username,Password FROM LoginDetails where Username='"+tf_Fname+"' AND Password ='"+tf_Lname+"'");

chdboy wrote:

The row count is 0 when I debug it....but I'm using the same username and password what's in the database,why is it not accepting it?

PreparedStatement preparedStatement = Connectionstring().prepareStatement(
			    "Select Username from dbo.LoginDetails where Username = ? and Password =?");
	  String User = tf_Fname.getText();
	  String _Pass = new String(tf_Lname.getPassword());
			preparedStatement.setString(1, User);
			preparedStatement.setString(2, _Pass);
			ResultSet resultSet = preparedStatement.executeQuery();
			while (resultSet.next()) 
			{
			    System.out.println("Username is "+ resultSet.getString(1)+"Password is "+resultSet.getString(2));  
			}

+"Password is "+resultSet.getString(2)

com.microsoft.sqlserver.jdbc.SQLServerException: The index 2 is out of range.

com.microsoft.sqlserver.jdbc.SQLServerException: The result set has no current row.

for(i=oct4;i<host;i++){
    int value = i / 256;
    int rem = i % 256;
    oct3 += value;
    System.out.println(oct1 + "." + oct2 + "." + oct3 + "." + rem + "\t \t" + sMask);
}

oct3 += value;

oct3 = value;

for(i=oct4;i<host;i++){
            int value = i / 256;
            int rem = i % 256;
            oct3 = value;
            System.out.println(oct1 + "." + oct2 + "." + oct3 + "." + rem + "\t \t" + sMask);
        }

value += oct3;
System.out.println(oct1 + "." + oct2 + "." + value + "." + rem + "\t \t" + sMask);