by tamnc » Sun Mar 14, 2010 9:11 pm
Hello everybody, I need helps to solve my trouble. I have mysql database and swt table. All records are displayed in table correctly, but I wanna delete particular row in table at the same time the compatible record in mysql database will be dropped effectively. I've tried several times, It's still a problem for me.
Any help will be appreciated. Thanks a lot. Here are my code for DELETE button.
btnDelete.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
int select = table.getSelectionIndex();
try {
Class.forName("com.mysql.jdbc.Driver");
Cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/Invdatabase","root","12345");
Ps = Cn.prepareStatement("Delete from Employee where EmployeeID='"+select+"'");
Ps.executeUpdate();
if(select>-1){
final Listener changeTableItemHeight = new Listener() {
public void handleEvent(Event event) {
event.height = (int)(event.gc.getFontMetrics().getHeight() * 1.5);
}
};
table.removeListener(SWT.MeasureItem, changeTableItemHeight);
table.clear(select);
table.remove(select);
table.addListener(SWT.MeasureItem, changeTableItemHeight);
}
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
});
Last edited by
tamnc on Fri Mar 26, 2010 7:53 pm, edited 1 time in total.