Querying the Database

ResultSet rs = dbs.stat.executeQuery(

"SELECT * FROM " + DBConstants.table + " " +

"WHERE login=’ " + login + “ ’ ”

) ;

if(rs.next()) {

lastname = rs.getString(2) ;

firstnames = rs.getString(3) ;

email = rs.getString(4) ;

dept = rs.getString(5) ;

} else {

response.sendError(HttpServletResponse.SC_OK,

"Record not found") ;

return ;

}

Previous slide

Next slide

Back to first slide

View graphic version