1.1 --- a/pom.xml Sat Feb 05 14:05:29 2011 +0300
1.2 +++ b/pom.xml Sat Feb 05 16:50:30 2011 +0300
1.3 @@ -8,7 +8,34 @@
1.4 <jetty.version>6.1.26</jetty.version>
1.5 <vaadin.version>6.5.0</vaadin.version>
1.6 <gwt.version>2.1.1</gwt.version>
1.7 + <oracle.jdbc.version>10.1.0.5.0</oracle.jdbc.version>
1.8 </properties>
1.9 + <repositories>
1.10 + <repository>
1.11 + <id>archiva.internal</id>
1.12 + <url>http://10.17.0.7/archiva/repository/internal</url>
1.13 + <releases>
1.14 + <enabled>true</enabled>
1.15 + </releases>
1.16 + <snapshots>
1.17 + <enabled>true</enabled>
1.18 + </snapshots>
1.19 + </repository>
1.20 + <repository>
1.21 + <id>vaadin</id>
1.22 + <url>http://oss.sonatype.org/content/repositories/vaadin/</url>
1.23 + <releases>
1.24 + <enabled>true</enabled>
1.25 + </releases>
1.26 + <snapshots>
1.27 + <enabled>false</enabled>
1.28 + </snapshots>
1.29 + </repository>
1.30 + <repository>
1.31 + <id>vaadin-addons</id>
1.32 + <url>http://maven.vaadin.com/vaadin-addons</url>
1.33 + </repository>
1.34 + </repositories>
1.35 <build>
1.36 <resources>
1.37 <resource>
1.38 @@ -44,6 +71,11 @@
1.39 <version>${vaadin.version}</version>
1.40 </dependency>
1.41 <dependency>
1.42 + <groupId>org.vaadin.addons</groupId>
1.43 + <artifactId>vaadin-sqlcontainer</artifactId>
1.44 + <version>1.0.0</version>
1.45 + </dependency>
1.46 + <dependency>
1.47 <groupId>com.google.gwt</groupId>
1.48 <artifactId>gwt-dev</artifactId>
1.49 <version>${gwt.version}</version>
1.50 @@ -53,5 +85,10 @@
1.51 <artifactId>gwt-user</artifactId>
1.52 <version>${gwt.version}</version>
1.53 </dependency>
1.54 + <dependency>
1.55 + <groupId>com.oracle</groupId>
1.56 + <artifactId>ojdbc14</artifactId>
1.57 + <version>${oracle.jdbc.version}</version>
1.58 + </dependency>
1.59 </dependencies>
1.60 </project>
1.61 \ No newline at end of file
2.1 --- a/src/main/java/ru/indvdum/mywork/vaadin/MyWorkApplication.java Sat Feb 05 14:05:29 2011 +0300
2.2 +++ b/src/main/java/ru/indvdum/mywork/vaadin/MyWorkApplication.java Sat Feb 05 16:50:30 2011 +0300
2.3 @@ -1,7 +1,17 @@
2.4 package ru.indvdum.mywork.vaadin;
2.5
2.6 +import java.sql.SQLException;
2.7 +
2.8 import com.vaadin.Application;
2.9 -import com.vaadin.ui.Label;
2.10 +import com.vaadin.addon.sqlcontainer.SQLContainer;
2.11 +import com.vaadin.addon.sqlcontainer.connection.JDBCConnectionPool;
2.12 +import com.vaadin.addon.sqlcontainer.connection.SimpleJDBCConnectionPool;
2.13 +import com.vaadin.addon.sqlcontainer.query.FreeformQuery;
2.14 +import com.vaadin.addon.sqlcontainer.query.TableQuery;
2.15 +import com.vaadin.addon.sqlcontainer.query.generator.OracleGenerator;
2.16 +import com.vaadin.ui.TabSheet;
2.17 +import com.vaadin.ui.Table;
2.18 +import com.vaadin.ui.VerticalLayout;
2.19 import com.vaadin.ui.Window;
2.20
2.21 /**
2.22 @@ -9,12 +19,89 @@
2.23 *
2.24 */
2.25 public class MyWorkApplication extends Application {
2.26 +
2.27 + private static JDBCConnectionPool connectionPool = null;
2.28 + static{
2.29 + try {
2.30 + connectionPool = new SimpleJDBCConnectionPool(
2.31 + "oracle.jdbc.OracleDriver",
2.32 + "jdbc:oracle:thin:@minidev:1521:ora",
2.33 + "velievd",
2.34 + "1",
2.35 + 2,
2.36 + 2
2.37 + );
2.38 + } catch (SQLException e) {
2.39 + e.printStackTrace();
2.40 + }
2.41 + }
2.42
2.43 @Override
2.44 public void init() {
2.45 Window window = new Window();
2.46 setMainWindow(window);
2.47
2.48 + VerticalLayout vlWorkAll = new VerticalLayout();
2.49 + VerticalLayout vlTasks = new VerticalLayout();
2.50 + VerticalLayout vlDays = new VerticalLayout();
2.51 + VerticalLayout vlWork = new VerticalLayout();
2.52 + VerticalLayout vlReportForCurrentMonth = new VerticalLayout();
2.53 + VerticalLayout vlReportForLastMonth = new VerticalLayout();
2.54 + vlWorkAll.setMargin(true);
2.55 + vlTasks.setMargin(true);
2.56 + vlDays.setMargin(true);
2.57 + vlWork.setMargin(true);
2.58 + vlReportForCurrentMonth.setMargin(true);
2.59 + vlReportForLastMonth.setMargin(true);
2.60 +
2.61 + TabSheet tabSheet = new TabSheet();
2.62 + tabSheet.setSizeFull();
2.63 + window.setContent(tabSheet);
2.64 +
2.65 + tabSheet.addTab(vlWorkAll, "WorkAll", null);
2.66 + tabSheet.addTab(vlTasks, "Tasks", null);
2.67 + tabSheet.addTab(vlDays, "Days", null);
2.68 + tabSheet.addTab(vlWork, "Work", null);
2.69 + tabSheet.addTab(vlReportForCurrentMonth, "Report for current month", null);
2.70 + tabSheet.addTab(vlReportForLastMonth, "Report for last month", null);
2.71 + try {
2.72 + Table tWorkAll = new Table("WorkAll", new SQLContainer(new FreeformQuery("select * from myworkall", connectionPool)));
2.73 + tWorkAll.setSelectable(true);
2.74 + tWorkAll.setImmediate(true);
2.75 + tWorkAll.setSizeFull();
2.76 + vlWorkAll.addComponent(tWorkAll);
2.77 +
2.78 + Table tTasks = new Table("Tasks", new SQLContainer(new TableQuery("tasks", connectionPool, new OracleGenerator())));
2.79 + tTasks.setSelectable(true);
2.80 + tTasks.setImmediate(true);
2.81 + tTasks.setSizeFull();
2.82 + vlTasks.addComponent(tTasks);
2.83 +
2.84 + Table tDays = new Table("Days", new SQLContainer(new TableQuery("days", connectionPool, new OracleGenerator())));
2.85 + tDays.setSelectable(true);
2.86 + tDays.setImmediate(true);
2.87 + tDays.setSizeFull();
2.88 + vlDays.addComponent(tDays);
2.89 +
2.90 + Table tWork = new Table("Work", new SQLContainer(new TableQuery("work", connectionPool, new OracleGenerator())));
2.91 + tWork.setSelectable(true);
2.92 + tWork.setImmediate(true);
2.93 + tWork.setSizeFull();
2.94 + vlWork.addComponent(tWork);
2.95 +
2.96 + Table tReportForCurrentMonth = new Table("Report for current month", new SQLContainer(new FreeformQuery("select * from reportforcurrentmonth", connectionPool)));
2.97 + tReportForCurrentMonth.setSelectable(true);
2.98 + tReportForCurrentMonth.setImmediate(true);
2.99 + tReportForCurrentMonth.setSizeFull();
2.100 + vlReportForCurrentMonth.addComponent(tReportForCurrentMonth);
2.101 +
2.102 + Table tReportForLastMonth = new Table("Report for last month", new SQLContainer(new FreeformQuery("select * from reportforlastmonth", connectionPool)));
2.103 + tReportForLastMonth.setSelectable(true);
2.104 + tReportForLastMonth.setImmediate(true);
2.105 + tReportForLastMonth.setSizeFull();
2.106 + vlReportForLastMonth.addComponent(tReportForLastMonth);
2.107 + } catch (SQLException e) {
2.108 + e.printStackTrace();
2.109 + }
2.110 }
2.111 -
2.112 }