Cho mình hỏi để xóa 1 hàng thì phải làm ntn. Giúp mình với nhé
Mã:
private void btnAllActionPerformed(java.awt.event.ActionEvent evt) {
try {
// B1: Dang ky Driver
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
// B2 Tao ket noi
Connection connection = DriverManager.getConnection("jdbc:sqlserver://localhost:1433; database = C1208GV", "sa", "1234567");
// B3: Thao tac vao CSDL
String sql = "SELECT rollNo,student,age,phone,avgMark,gender,birth FROM tblStudent";
// Gui truy van len Server
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery(sql);
// B4: Kiem tra ket qua
DefaultTableModel model = new DefaultTableModel();
model.addColumn("STT");
model.addColumn("rollNo");
model.addColumn("student");
model.addColumn("age");
model.addColumn("phone");
model.addColumn("avgMark");
model.addColumn("gender");
model.addColumn("birth");
int cnt = 1;
while (rs.next()) {
Vector row = new Vector();
row.add(cnt);
row.add(rs.getString(1));
row.add(rs.getString(2));
row.add(rs.getString(3));
row.add(rs.getString(4));
row.add(rs.getString(5));
row.add(rs.getString(6));
row.add(rs.getString(7));
model.addRow(row);
cnt++;
}
tblStudent.setModel(model);
table.add(rs);
} catch (Exception ex) {
}
}
private void btnAddNewActionPerformed(java.awt.event.ActionEvent evt) {
FrmAdd frm = new FrmAdd();
frm.setVisible(true);
}
private void btnDeleteActionPerformed(java.awt.event.ActionEvent evt) {
// int[] row = tblStudent.getSelectedRows();
// Object ob = tblStudent.getValueAt(row, cols);
int[] cols = tblStudent.getSelectedColumns();
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection connection = DriverManager.getConnection("jdbc:sqlserver://192.168.1.100:1433; database = C1208GV", "thachtu", "ngochey");
String sql = "DELETE FROM tblStudent WHERE '"+cols+"'";
Statement statement = connection.createStatement();
int result = statement.executeUpdate(sql);
if (result > 0) {
JOptionPane.showMessageDialog(this, "Xoa thanh cong");
} else {
JOptionPane.showMessageDialog(this, "Xoa khong thanh cong");
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(FrmMain.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(FrmMain.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(FrmMain.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(FrmMain.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new FrmMain().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton btnAddNew;
private javax.swing.JButton btnAll;
private javax.swing.JButton btnDelete;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JLabel lblName;
private javax.swing.JTable tblStudent;
// End of variables declaration
}
View more random threads:
Không chỉ dừng lại ở việc sử dụng nguyên liệu cao cấp, mỗi công trình còn được "chăm sóc" bằng 4 dịch vụ xuất sắc của Tre Nghệ. Từ việc tư vấn, thiết kế đến thi công và hoàn thiện, mọi quy trình đều...
Chất Lượng và Sáng Tạo: Kiến Trúc...