if no records found 1

[jass1220]

i want to have if condition after this query .. this condition is if there is no record found the session should be "" and error msg else the session = the username of the record found (actually this code for checking the login)

//////////

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"
Connection connection = DriverManager.getConnection("jdbcdbc:ClassMates"
Statement statement = connection.createStatement();
ResultSet columns = statement.executeQuery("select * from mates where username ='"+strUser+"'"

/////////

 

[sedj]

Please view the other question you posted, I think you are misunderstanding the correct usuage of session objects ... Maybe somthing like this will help :

  i want to have if condition after this query .. this condition is if there is no record found the session should be "" and error msg else the session = the username of the record found (actually this code for checking the login)
[code]
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection connection = DriverManager.getConnection("jdbc:odbc:ClassMates");
  Statement statement = connection.createStatement();
  ResultSet columns = statement.executeQuery("select * from mates where username ='"+strUser+"'");

  String dataFound = "";

  while (rs.next()) {
     // add in what you want from the ResultSet ...
    // this just gets the first column
     dataFound += (rs.getString(1) +" ");
  }

  // if nothing was returned from the sql ...
  if ((dataFound.trim()).equals("")) {
     dataFound = "Sorry, no data found ...";
  }

 

[jass1220]

thanks .. i'll try your code now ..

 

[jass1220]

its working fine .. thanks a lot .. so great