HI all, I have a file called StudentFrame when I click "Submit " button to show all data from database ,but it doesn't show although connected database successfully.
public class StudentFrame extends javax.swing.JFrame {
/**
* Creates new form StudentFrame
*/
public StudentFrame() {
initComponents();
header=new Vector();
header.add("name");
header.add("mark");
header.add("grade");
header.add("class");
}
public ArrayList<Student> getAllRows() {
try {
Connection con = ConnectData.getConnection();
ArrayList<Student> lst = new ArrayList<>();
String sql = " select * from StudentInfo";
PreparedStatement pr;
pr = con.prepareStatement(sql);
ResultSet rs = pr.executeQuery();
Student std = new Student();
while (rs.next()) {
rs.getString("name");
rs.getFloat("mark");
rs.getString("grade");
rs.getString("class");
lst.add(std);
}
return lst;
} catch (SQLException ex) {
return null;
}
}
public boolean ExcuteStudent(String name, String UpdateField, String UpdateValue) {
try {
Connection con = ConnectData.getConnection();
// String sql="update StudentInfo set " +UpdateField+"=?"+"where name = ?";
String sql = "update StudentInfo set";
sql += UpdateField + "=? ";
sql += "where name=?";
PreparedStatement pr = con.prepareStatement(sql);
pr.setString(1, UpdateValue);
pr.setString(2, name);
return pr.executeUpdate() > 0;
} catch (SQLException ex) {
return false;
}
}
private void btnSubmitActionPerformed(java.awt.event.ActionEvent evt) {
data =new Vector();
tablemodel=new DefaultTableModel(data, header);
tablemodel.fireTableDataChanged();
jTable1.setModel(tablemodel);
btnSubmit.setEnabled(true);
getAllRows();
}
private void btnEditActionPerformed(java.awt.event.ActionEvent evt) {
:
ExcuteStudent(null, null, null);
}