static {
logger.info("Initializing marks");
TableQuery table = new TableQuery("Mark", DB.pool);
table.setVersionColumn("VERSION");
try {
container = new SQLContainer(table);
} catch (SQLException e) {
throw new Error(e);
}
}
@Test
public void itemWithExistingVersionColumnIsRemoved() throws SQLException {
container.setAutoCommit(true);
query.setVersionColumn(ID);
assertTrue(container.removeItem(container.lastItemId()));
}
@Test(expected = SQLException.class)
public void itemWithNonExistingVersionColumnCannotBeRemoved() throws SQLException {
query.setVersionColumn("version");
container.removeItem(container.lastItemId());
container.commit();
}
public WindowManagerTeacher() {
setCaption("quan ly bo mon "); // Constants.USER_CAPTION) ;
mainLayout = new HorizontalLayout();
mainLayout.setImmediate(false);
mainLayout.setWidth(Constants.WIDTH_MAX, Sizeable.UNITS_PIXELS);
mainLayout.setMargin(false);
mainLayout.setSpacing(true);
mainLayout.addComponent(new leftSide());
rContentList = new VerticalLayout();
rContentList.setWidth("100%");
mainLayout.addComponent(rContentList);
mainLayout.setExpandRatio(rContentList, 1.0f);
rContentModify = new rightContentAddNewTeacher(1);
rContentModify.setWidth("100%");
VerticalLayout v = new VerticalLayout();
v.setWidth("100%");
v.setStyleName("bl-mainContent");
v.addComponent(mainLayout);
v.setComponentAlignment(mainLayout, Alignment.MIDDLE_CENTER);
addComponent(new topLogin());
addComponent(new topPanel());
addComponent(new mainMenu());
addComponent(v);
addComponent(new bottom());
// --------------------bl
Label title = new Label("<center><h1>Danh sách giang vien<h1></center>", Label.CONTENT_XHTML);
table = new Table();
table.setWidth("100%");
table.setPageLength(20);
rContentList.addComponent(title);
rContentList.addComponent(table);
Connection conn = null;
Statement stmt = null;
try {
JDBCConnectionPool pool =
new SimpleJDBCConnectionPool(
JDBC_DRIVER,
DB_URL + QlgiangvienApplication.DB_DBNAME,
QlgiangvienApplication.DB_USER,
QlgiangvienApplication.DB_PASS);
String mysql = "SELECT * from GiangVien";
TableQuery query = new TableQuery("GiangVien", pool);
query.setVersionColumn("OPTLOCK");
SQLContainer container = new SQLContainer(query);
container.setAutoCommit(true);
// container.re
table.setContainerDataSource(container);
// FreeformQuery query = new FreeformQuery(mysql, pool, "MaGV") ;
// container = new SQLContainer(query);
// table.setContainerDataSource(container) ;
table.addGeneratedColumn(
"Chinh Sua",
new Table.ColumnGenerator() {
public Component generateCell(Table source, Object itemId, Object columnId) {
final Item item = table.getItem(itemId);
Button btnModify =
new Button(
"Chinh Sua",
new Button.ClickListener() {
@Override
public void buttonClick(ClickEvent event) {
// rContentList.setVisible(false);
// rContentModify.setVisible(true);
System.out.println(item.toString());
rContentModify.setUpdateData(
item.getItemProperty("MaGV").getValue().toString());
mainLayout.removeComponent(rContentList);
mainLayout.addComponent(rContentModify);
mainLayout.setExpandRatio(rContentModify, 1.0f);
}
});
return btnModify;
}
});
confirmDelete();
table.addGeneratedColumn(
"Xoa",
new Table.ColumnGenerator() {
public Component generateCell(Table source, Object itemId, Object columnId) {
// Item item = table.getItem(itemId);
Button btnModify =
new Button(
"Xoa",
new Button.ClickListener() {
@Override
public void buttonClick(ClickEvent event) {
if (subwindow.getParent() == null) {
getWindow().addWindow(subwindow);
}
}
});
return btnModify;
}
});
} catch (Exception e) {
System.out.println("in right COntent: " + e.toString());
}
} // end of container