Guest User

Untitled

a guest
Nov 15th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. try {
  2. Connection con = DriverManager.getConnection( "jdbc:mysql://localhost:3306/mysql", "root", "root" );
  3. Statement st = con.createStatement( );
  4. String rs = "select iid,fname,lname,phonenum,addr,email from mysql57.addressbook";
  5. PreparedStatement preparedStatement = con.prepareStatement( rs );
  6. ResultSet r = preparedStatement.executeQuery( );
  7.  
  8. while (r.next())
  9. {
  10. // System.out.println("reccord" +i );
  11. TextField T1=new TextField("RECORD " );
  12. TextField T2=new TextField( "ID : " +r.getInt( 1 ) );
  13. TextField T3=new TextField( "FIRST NAME : " +r.getString( 2 ) );
  14. TextField T4=new TextField( "LAST NAME : " + r.getString( 3 ));
  15. TextField T5=new TextField( "PHONE NUMBER : " + r.getInt( 4 ));
  16. TextField T6=new TextField( "ADDRESS : " + r.getString( 5 ));
  17. TextField T7=new TextField( "EMAIL ID : " + r.getString( 6 ));
Add Comment
Please, Sign In to add comment