|
עמוד:205
} str += " " ; } usersFormattedStr += " < td > User " ; else { } usersFormattedStr += " < td > Manager " ; if ( "Y" . equalsIgnoreCase ( usersResultSet . getString ( "isManager" ))) { str += " < td style = 'border : 2 px solid blue' > " + usersResultSet . getString ( "birthYear" ) . toString () + " " ; str += " " ; % > } return str ; } System . out . println ( "error in connecting" ); catch ( Exception ex ) { } // end of try -- % > עיצוב הפלט למשתמש < body > < title > test database < head > < html > < % -- connectDB (); < % < tr > < table > The table of users < h 1 > שאילתת out . print ( formatUsersForHtml ( usersResultSet ));; usersResultSet = statement . executeQuery ( sql ); String sql = "SELECT * FROM tblUsers" ; // SQL
|