mardi 8 décembre 2015

How can I display data into my Jtextarea from my Data Base SQLite

private void jButton_Add_TeacherActionPerformed(java.awt.event.ActionEvent evt) {
    try {
        String sql = "Insert into Faculty_Manager (ID,Name,Remarks) values (?,?,?)";
        pst = conn.prepareStatement(sql);
        pst.setString(1, jTextField_TID.getText());
        pst.setString(2, jTextField_TName.getText());
        pst.setString(3, jTextField_TRemarks.getText());
        pst.execute();
        String s1 = jTextField_TID.getText();
        String s2 = jTextField_TName.getText();
        jTextArea_TManagerList.append(s1 + ". " + s2 + "\n");;
        JOptionPane.showMessageDialog(null, "Faculty Added Successfully!");
    } catch (Exception e) {
        JOptionPane.showMessageDialog(null, e);
    }
    Update_Faculty_Manager_Table();
    jTextField_TID.setText("");
    jTextField_TName.setText("");
    jTextField_TRemarks.setText("");
}

all i want is to display into jTextArea all the added and existing name data saved in my database. I am using SQLite. Thanks

Aucun commentaire:

Enregistrer un commentaire