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