|
|
עמוד:204
% > } } System . out . println ( "error in connecting" ); catch ( Exception ex ) { } statement = connection . createStatement (); connection = DriverManager . getConnection ( connectionURL , "root" , ""); Class . forName ( "com . mysql . jdbc . Driver" ) . newInstance (); -- % > אחזור מחרוזת המכילה את נתוני טבלת המשתמשים המעוצבת כטבלה < td > Address < td > Phone No . < td > Cell Phone < td > Email str += " < tr >< td > Id < td > User Name < td > First Name < td > Last Name String str = " < table style = 'border : 2 px solid blue' > " ; public String formatUsersForHtml ( ResultSet usersResultSet ) { < % ! < % -- str += " < td style = 'border : 2 px solid blue' > " + usersResultSet . getString ( "firstName" ) . toString () + " " ; str += " < td style = 'border : 2 px solid blue' > " + usersResultSet . getString ( "userName" ) . toString () + " " ; str += " < td style = 'border : 2 px solid blue' > " + usersResultSet . getString ( "id" ) . toString () + " " ; str += " < tr > " ; while ( usersResultSet . next ()) { try { < td > Gender < td > Birth Year " ; str += " < td style = 'border : 2 px solid blue' > " ; str += " < td style = 'border : 2 px solid blue' > " + usersResultSet . getString ( "email" ) . toString () + " " ; str += " < td style = 'border : 2 px solid blue' > " + usersResultSet . getString ( "cellPhone" ) . toString () + " " ; str += " < td style = 'border : 2 px solid blue' > " + usersResultSet . getString ( "Phone" ) . toString () + " " ; str += " < td style = 'border : 2 px solid blue' > " + usersResultSet . getString ( "address" ) . toString () + " " ; str += " < td style = 'border : 2 px solid blue' > " + usersResultSet . getString ( "lastName" ) . toString () + " " ; } str += "Male" ; else { } str += "Female" ; if ( "F" . equals ( usersResultSet . getString ( "gender" ))) {
|
|