print data to textarea

[Tapan Prajapati]

 

public class form extends javax.swing.JFrame {

   // private IntTextField intField;
      JFrame frame;
    PreparedStatement pstatement = null;
    PreparedStatement statement = null;
String url = "jdbc:mysql://localhost:3306/";
String db =  "entry";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "aaaa";
Connection con = null;
int count=0;
    /** Creates new form form */
    public form() {
        initComponents();
        try {
            Class.forName(driver).newInstance();
            con = DriverManager.getConnection(url + db , user, pass);
            //PreparedStatement statement = con.prepareStatement();
           // con.commit();
        }catch(Exception e){
            System.out.println("*** "+e.getMessage());
        }
    }

        private void GetRecordButtonActionPerformed(java.awt.event.ActionEvent evt) {                                                
            // TODO add your handling code here:
            try{
                //ResultSet rs = null;
                pstatement = con.prepareStatement("SELECT name,phonenumber FROM entrytable");
                con = DriverManager.getConnection(url + db, user, pass);
                ResultSet rs = pstatement.executeQuery();
            
                while(rs.next()){
                    String name = rs.getString(1);
                    int phonenumber = rs.getInt(2);
                    count ++;
                    System.out.println(name +"\t" + "-"+ phonenumber);
                    }
                System.out.println("No of record found"+count);
                
                StringWriter sw = new StringWriter();
                PrintWriter pw = new PrintWriter(sw);
                pw.println("DataBase Contents are.....");
                while(rs.next()){
                    String name = rs.getString(1);
                    String phonenumber = rs.getString(2);
                }
                    String name = sw.toString();
                    recordTextArea.setText(name);
                    String phonenumber = sw.toString();
                    recordTextArea.setText(phonenumber);
                  pw.println( name + "\t" + phonenumber);
                    }catch(Exception e){
                System.out.println("error in retriving"+ e.getMessage());

            }
        }                                               
   
    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new form().setVisible(true);
            }
        });
    }

   

m use net bean and i want to print the data to text area but i only print them it in command prompt not in text area

[Jeanne Boyarsky]

This sounds like a Swing question since it is about outputting data to a JTextArea. Moving to our Swing forum.

[Michael Dunn]

you have in your code this:
System.out.println(name +"\t" + "-"+ phonenumber);

and this:
pw.println( name + "\t" + phonenumber);

and this:
recordTextArea.setText(phonenumber);

it seems you know how to access the textArea (unless this is not your code),
so just refer to the JTextArea apidocs for a method to add, or append (hint), text.

[Tapan Prajapati]

ya but i had already define them in private field

  private javax.swing.JButton GetRecordButton;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTextField nameTextField;
    private javax.swing.JButton okbutton;
    private javax.swing.JTextField phonenumberTextField;
    private javax.swing.JTextArea recordTextArea;

now tell me what can i do

[Michael Dunn]

> now tell me what can i do

I already told you 'where' and 'what'.

if you want someone to write it for you, try rent-a-coder

[Tapan Prajapati]

i don't know what you want to say , you reply if you know answer. i just want to print the database data to my text area that's all.

[Michael Dunn]

> you reply if you know answer.

I do, because I've read the documentation.

I even gave you a hint in my first reply.

[Maneesh Godbole]

Tapan,
Please use the quote button only when you want to quote something. For your own replies, please use the Post Reply button

[Rob Spoor]

Tapan Prajapati wrote:i just want to print the database data to my text area that's all.

Have you even read Michael's first reply?

Michael Dunn wrote:so just refer to the JTextArea apidocs for a method to add, or append (hint), text.

Click on JTextArea if you don't know how to find the API docs.