svnno****@sourc*****
svnno****@sourc*****
2009年 4月 13日 (月) 01:10:39 JST
Revision: 3230 http://svn.sourceforge.jp/view?root=jiemamy&view=rev&rev=3230 Author: daisuke_m Date: 2009-04-13 01:10:39 +0900 (Mon, 13 Apr 2009) Log Message: ----------- Share project "jiemamy-tutorial" into "svn+ssh://svn.sourceforge.jp/svnroot/jiemamy" Added Paths: ----------- metis/jiemamy-tutorial/trunk/.classpath metis/jiemamy-tutorial/trunk/.project metis/jiemamy-tutorial/trunk/.settings/ metis/jiemamy-tutorial/trunk/.settings/org.eclipse.core.resources.prefs metis/jiemamy-tutorial/trunk/.settings/org.eclipse.jdt.core.prefs metis/jiemamy-tutorial/trunk/.settings/org.seasar.dblauncher.prefs metis/jiemamy-tutorial/trunk/.settings/org.seasar.dolteng.eclipse.prefs metis/jiemamy-tutorial/trunk/.tomcatplugin metis/jiemamy-tutorial/trunk/pom.xml metis/jiemamy-tutorial/trunk/run-jetty-server.bat metis/jiemamy-tutorial/trunk/run-jetty-server.sh metis/jiemamy-tutorial/trunk/src/ metis/jiemamy-tutorial/trunk/src/database/ metis/jiemamy-tutorial/trunk/src/database/jiemamy.jer metis/jiemamy-tutorial/trunk/src/main/ metis/jiemamy-tutorial/trunk/src/main/java/ metis/jiemamy-tutorial/trunk/src/main/java/org/ metis/jiemamy-tutorial/trunk/src/main/java/org/jiemamy/ metis/jiemamy-tutorial/trunk/src/main/java/org/jiemamy/tutorial/ metis/jiemamy-tutorial/trunk/src/main/java/org/jiemamy/tutorial/JiemamyServlet.java metis/jiemamy-tutorial/trunk/src/main/resources/ metis/jiemamy-tutorial/trunk/src/main/webapp/ metis/jiemamy-tutorial/trunk/src/main/webapp/WEB-INF/ metis/jiemamy-tutorial/trunk/src/main/webapp/WEB-INF/classes/ metis/jiemamy-tutorial/trunk/src/main/webapp/WEB-INF/classes/org/ metis/jiemamy-tutorial/trunk/src/main/webapp/WEB-INF/classes/org/jiemamy/ metis/jiemamy-tutorial/trunk/src/main/webapp/WEB-INF/classes/org/jiemamy/tutorial/ metis/jiemamy-tutorial/trunk/src/main/webapp/WEB-INF/classes/org/jiemamy/tutorial/JiemamyServlet.class metis/jiemamy-tutorial/trunk/src/main/webapp/WEB-INF/classes/src.main.webapp.WEB-INF.classes metis/jiemamy-tutorial/trunk/src/main/webapp/WEB-INF/lib/ metis/jiemamy-tutorial/trunk/src/main/webapp/WEB-INF/web.xml metis/jiemamy-tutorial/trunk/src/main/webapp/index.jsp metis/jiemamy-tutorial/trunk/src/test/ metis/jiemamy-tutorial/trunk/src/test/java/ metis/jiemamy-tutorial/trunk/src/test/resources/ Property Changed: ---------------- metis/jiemamy-tutorial/trunk/ -------------- next part -------------- Property changes on: metis/jiemamy-tutorial/trunk ___________________________________________________________________ Added: svn:ignore + target lib repo .externalToolBuilders Added: metis/jiemamy-tutorial/trunk/.classpath =================================================================== --- metis/jiemamy-tutorial/trunk/.classpath (rev 0) +++ metis/jiemamy-tutorial/trunk/.classpath 2009-04-12 16:10:39 UTC (rev 3230) @@ -0,0 +1,10 @@ +<?xml version="1.0" encoding="UTF-8"?> +<classpath> + <classpathentry including="**/*.java" kind="src" path="src/main/java"/> + <classpathentry excluding="**/*.java" including="**" kind="src" path="src/main/resources"/> + <classpathentry including="**/*.java" kind="src" output="target/test-classes" path="src/test/java"/> + <classpathentry excluding="**/*.java" including="**" kind="src" output="target/test-classes" path="src/test/resources"/> + <classpathentry kind="con" path="org.devzuz.q.maven.jdt.core.mavenClasspathContainer"/> + <classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER/org.eclipse.jdt.internal.debug.ui.launcher.StandardVMType/J2SE-1.5"/> + <classpathentry kind="output" path="src/main/webapp/WEB-INF/classes"/> +</classpath> Property changes on: metis/jiemamy-tutorial/trunk/.classpath ___________________________________________________________________ Added: svn:mime-type + text/plain Added: metis/jiemamy-tutorial/trunk/.project =================================================================== --- metis/jiemamy-tutorial/trunk/.project (rev 0) +++ metis/jiemamy-tutorial/trunk/.project 2009-04-12 16:10:39 UTC (rev 3230) @@ -0,0 +1,26 @@ +<?xml version="1.0" encoding="UTF-8"?> +<projectDescription> + <name>jiemamy-tutorial</name> + <comment></comment> + <projects> + </projects> + <buildSpec> + <buildCommand> + <name>org.eclipse.jdt.core.javabuilder</name> + <arguments> + </arguments> + </buildCommand> + <buildCommand> + <name>org.devzuz.q.maven.jdt.core.mavenIncrementalBuilder</name> + <arguments> + </arguments> + </buildCommand> + </buildSpec> + <natures> + <nature>org.devzuz.q.maven.jdt.core.mavenNature</nature> + <nature>org.seasar.dblauncher.nature</nature> + <nature>org.seasar.dolteng.eclipse.nature</nature> + <nature>org.maven.ide.eclipse.maven2Nature</nature> + <nature>org.eclipse.jdt.core.javanature</nature> + </natures> +</projectDescription> Property changes on: metis/jiemamy-tutorial/trunk/.project ___________________________________________________________________ Added: svn:mime-type + text/plain Added: metis/jiemamy-tutorial/trunk/.settings/org.eclipse.core.resources.prefs =================================================================== --- metis/jiemamy-tutorial/trunk/.settings/org.eclipse.core.resources.prefs (rev 0) +++ metis/jiemamy-tutorial/trunk/.settings/org.eclipse.core.resources.prefs 2009-04-12 16:10:39 UTC (rev 3230) @@ -0,0 +1,3 @@ +#Mon Jul 16 00:26:26 JST 2007 +eclipse.preferences.version=1 +encoding/<project>=UTF-8 Property changes on: metis/jiemamy-tutorial/trunk/.settings/org.eclipse.core.resources.prefs ___________________________________________________________________ Added: svn:mime-type + text/plain Added: metis/jiemamy-tutorial/trunk/.settings/org.eclipse.jdt.core.prefs =================================================================== --- metis/jiemamy-tutorial/trunk/.settings/org.eclipse.jdt.core.prefs (rev 0) +++ metis/jiemamy-tutorial/trunk/.settings/org.eclipse.jdt.core.prefs 2009-04-12 16:10:39 UTC (rev 3230) @@ -0,0 +1,61 @@ +#Fri Apr 18 16:39:55 GMT+09:00 2008 +eclipse.preferences.version=1 +org.eclipse.jdt.core.compiler.codegen.targetPlatform=1.5 +org.eclipse.jdt.core.compiler.compliance=1.5 +org.eclipse.jdt.core.compiler.problem.annotationSuperInterface=warning +org.eclipse.jdt.core.compiler.problem.assertIdentifier=error +org.eclipse.jdt.core.compiler.problem.autoboxing=ignore +org.eclipse.jdt.core.compiler.problem.deprecation=warning +org.eclipse.jdt.core.compiler.problem.deprecationInDeprecatedCode=disabled +org.eclipse.jdt.core.compiler.problem.deprecationWhenOverridingDeprecatedMethod=disabled +org.eclipse.jdt.core.compiler.problem.discouragedReference=warning +org.eclipse.jdt.core.compiler.problem.emptyStatement=ignore +org.eclipse.jdt.core.compiler.problem.enumIdentifier=error +org.eclipse.jdt.core.compiler.problem.fallthroughCase=ignore +org.eclipse.jdt.core.compiler.problem.fatalOptionalError=enabled +org.eclipse.jdt.core.compiler.problem.fieldHiding=ignore +org.eclipse.jdt.core.compiler.problem.finalParameterBound=warning +org.eclipse.jdt.core.compiler.problem.finallyBlockNotCompletingNormally=warning +org.eclipse.jdt.core.compiler.problem.forbiddenReference=error +org.eclipse.jdt.core.compiler.problem.hiddenCatchBlock=warning +org.eclipse.jdt.core.compiler.problem.incompatibleNonInheritedInterfaceMethod=warning +org.eclipse.jdt.core.compiler.problem.incompleteEnumSwitch=ignore +org.eclipse.jdt.core.compiler.problem.indirectStaticAccess=ignore +org.eclipse.jdt.core.compiler.problem.localVariableHiding=ignore +org.eclipse.jdt.core.compiler.problem.methodWithConstructorName=warning +org.eclipse.jdt.core.compiler.problem.missingDeprecatedAnnotation=warning +org.eclipse.jdt.core.compiler.problem.missingOverrideAnnotation=warning +org.eclipse.jdt.core.compiler.problem.missingSerialVersion=warning +org.eclipse.jdt.core.compiler.problem.noEffectAssignment=warning +org.eclipse.jdt.core.compiler.problem.noImplicitStringConversion=warning +org.eclipse.jdt.core.compiler.problem.nonExternalizedStringLiteral=ignore +org.eclipse.jdt.core.compiler.problem.nullReference=warning +org.eclipse.jdt.core.compiler.problem.overridingPackageDefaultMethod=warning +org.eclipse.jdt.core.compiler.problem.parameterAssignment=ignore +org.eclipse.jdt.core.compiler.problem.possibleAccidentalBooleanAssignment=warning +org.eclipse.jdt.core.compiler.problem.potentialNullReference=warning +org.eclipse.jdt.core.compiler.problem.rawTypeReference=warning +org.eclipse.jdt.core.compiler.problem.redundantNullCheck=warning +org.eclipse.jdt.core.compiler.problem.specialParameterHidingField=disabled +org.eclipse.jdt.core.compiler.problem.staticAccessReceiver=warning +org.eclipse.jdt.core.compiler.problem.suppressWarnings=enabled +org.eclipse.jdt.core.compiler.problem.syntheticAccessEmulation=ignore +org.eclipse.jdt.core.compiler.problem.typeParameterHiding=warning +org.eclipse.jdt.core.compiler.problem.uncheckedTypeOperation=warning +org.eclipse.jdt.core.compiler.problem.undocumentedEmptyBlock=ignore +org.eclipse.jdt.core.compiler.problem.unhandledWarningToken=warning +org.eclipse.jdt.core.compiler.problem.unnecessaryElse=ignore +org.eclipse.jdt.core.compiler.problem.unnecessaryTypeCheck=warning +org.eclipse.jdt.core.compiler.problem.unqualifiedFieldAccess=ignore +org.eclipse.jdt.core.compiler.problem.unusedDeclaredThrownException=ignore +org.eclipse.jdt.core.compiler.problem.unusedDeclaredThrownExceptionWhenOverriding=disabled +org.eclipse.jdt.core.compiler.problem.unusedImport=warning +org.eclipse.jdt.core.compiler.problem.unusedLabel=warning +org.eclipse.jdt.core.compiler.problem.unusedLocal=warning +org.eclipse.jdt.core.compiler.problem.unusedParameter=ignore +org.eclipse.jdt.core.compiler.problem.unusedParameterIncludeDocCommentReference=enabled +org.eclipse.jdt.core.compiler.problem.unusedParameterWhenImplementingAbstract=disabled +org.eclipse.jdt.core.compiler.problem.unusedParameterWhenOverridingConcrete=disabled +org.eclipse.jdt.core.compiler.problem.unusedPrivateMember=warning +org.eclipse.jdt.core.compiler.problem.varargsArgumentNeedCast=warning +org.eclipse.jdt.core.compiler.source=1.5 Property changes on: metis/jiemamy-tutorial/trunk/.settings/org.eclipse.jdt.core.prefs ___________________________________________________________________ Added: svn:mime-type + text/plain Added: metis/jiemamy-tutorial/trunk/.settings/org.seasar.dblauncher.prefs =================================================================== --- metis/jiemamy-tutorial/trunk/.settings/org.seasar.dblauncher.prefs (rev 0) +++ metis/jiemamy-tutorial/trunk/.settings/org.seasar.dblauncher.prefs 2009-04-12 16:10:39 UTC (rev 3230) @@ -0,0 +1,4 @@ +#Mon Jul 16 00:26:29 JST 2007 +baseDir=/jiemamy-test/src/main/webapp/WEB-INF/classes/data +eclipse.preferences.version=1 +initDB=/jiemamy-test/src/main/resources/data Property changes on: metis/jiemamy-tutorial/trunk/.settings/org.seasar.dblauncher.prefs ___________________________________________________________________ Added: svn:mime-type + text/plain Added: metis/jiemamy-tutorial/trunk/.settings/org.seasar.dolteng.eclipse.prefs =================================================================== --- metis/jiemamy-tutorial/trunk/.settings/org.seasar.dolteng.eclipse.prefs (rev 0) +++ metis/jiemamy-tutorial/trunk/.settings/org.seasar.dolteng.eclipse.prefs 2009-04-12 16:10:39 UTC (rev 3230) @@ -0,0 +1,7 @@ +#Tue Sep 18 01:09:23 JST 2007 +DefaultResourcePath=/jiemamy-test/src/main/resources +DefaultRootPackage=jp.xet.jiemamy.test +DefaultSrcPath=/jiemamy-test/src/main/java +ServletPath=/jiemamy-test +WebContentsRoot=src/main/webapp/ +eclipse.preferences.version=1 Property changes on: metis/jiemamy-tutorial/trunk/.settings/org.seasar.dolteng.eclipse.prefs ___________________________________________________________________ Added: svn:mime-type + text/plain Added: metis/jiemamy-tutorial/trunk/.tomcatplugin =================================================================== --- metis/jiemamy-tutorial/trunk/.tomcatplugin (rev 0) +++ metis/jiemamy-tutorial/trunk/.tomcatplugin 2009-04-12 16:10:39 UTC (rev 3230) @@ -0,0 +1,11 @@ +<?xml version="1.0" encoding="UTF-8"?> +<tomcatProjectProperties> +<rootDir>src/main/webapp/</rootDir> +<exportSource>false</exportSource> +<reloadable>false</reloadable> +<redirectLogger>true</redirectLogger> +<updateXml>true</updateXml> +<warLocation></warLocation> +<extraInfo></extraInfo> +<webPath>/jiemamy-test</webPath> +</tomcatProjectProperties> \ No newline at end of file Added: metis/jiemamy-tutorial/trunk/pom.xml =================================================================== --- metis/jiemamy-tutorial/trunk/pom.xml (rev 0) +++ metis/jiemamy-tutorial/trunk/pom.xml 2009-04-12 16:10:39 UTC (rev 3230) @@ -0,0 +1,169 @@ +<?xml version="1.0" encoding="UTF-8"?> +<project> + <modelVersion>4.0.0</modelVersion> + <groupId>org.jiemamy</groupId> + <artifactId>jiemamy-tutorial</artifactId> + <packaging>war</packaging> + <name>jiemamy-tutorial</name> + <version>0.2.0-SNAPSHOT</version> + <build> + <outputDirectory>src/main/webapp/WEB-INF/classes</outputDirectory> + <defaultGoal>validate</defaultGoal> + <plugins> + <plugin> + <groupId>org.jiemamy</groupId> + <artifactId>maven-jiemamy-plugin</artifactId> + <executions> + <execution> + <id>clean-schema</id> + <phase>process-resources</phase> + <goals> + <goal>cleanDatabase</goal> + </goals> + </execution> + <execution> + <id>create-sql</id> + <phase>process-resources</phase> + <goals> + <goal>jiemamy</goal> + </goals> + <configuration> + <inputFile>src/database/jiemamy.jer</inputFile> + <parameter> + <outputFile>target/jiemamy.sql</outputFile> + <drop>false</drop> + <DML>true</DML> + <schema>false</schema> + <overwrite>true</overwrite> + <dataSetIndex>0</dataSetIndex> + </parameter> + </configuration> + </execution> + </executions> + <dependencies> + <dependency> + <groupId>org.jiemamy</groupId> + <artifactId>jiemamy-dialect-postgresql</artifactId> + <version>0.2.0-SNAPSHOT</version> + </dependency> + <dependency> + <groupId>postgresql</groupId> + <artifactId>postgresql</artifactId> + <version>8.3-603.jdbc3</version> + </dependency> + </dependencies> + <configuration> + <username>${database.username}</username> + <password>${database.password}</password> + <driver>org.postgresql.Driver</driver> + <uri>jdbc:postgresql://localhost:5432/jiemamy</uri> + </configuration> + </plugin> + <plugin> + <groupId>org.codehaus.mojo</groupId> + <artifactId>sql-maven-plugin</artifactId> + <executions> + <!-- 最後に先ほど生成されたSQLを実行 --> + <execution> + <id>create-schema</id> + <phase>process-resources</phase> + <goals> + <goal>execute</goal> + </goals> + <configuration> + <autocommit>true</autocommit> + <srcFiles> + <srcFile>target/jiemamy.sql</srcFile> + </srcFiles> + </configuration> + </execution> + </executions> + <dependencies> + <dependency> + <groupId>postgresql</groupId> + <artifactId>postgresql</artifactId> + <version>8.2-504.jdbc3</version> + </dependency> + </dependencies> + <configuration> + <username>${database.username}</username> + <password>${database.password}</password> + <settingsKeys>sensibleKey</settingsKeys> + <driver>org.postgresql.Driver</driver> + <url>jdbc:postgresql://localhost:5432/jiemamy</url> + <skip>${maven.test.skip}</skip> + </configuration> + </plugin> + <!-- compileフェーズにおけるコンパイラの設定 --> + <plugin> + <artifactId>maven-compiler-plugin</artifactId> + <configuration> + <source>1.5</source> + <target>1.5</target> + <encoding>UTF-8</encoding> + </configuration> + </plugin> + <!-- packageフェーズで、source jarも作成する --> + <plugin> + <artifactId>maven-source-plugin</artifactId> + <executions> + <execution> + <id>source-jar</id> + <phase>package</phase> + <goals> + <goal>jar</goal> + </goals> + </execution> + </executions> + </plugin> + <!-- jettyにデプロイ --> + <plugin> + <groupId>org.mortbay.jetty</groupId> + <artifactId>maven-jetty-plugin</artifactId> + </plugin> + </plugins> + </build> + <pluginRepositories> + <pluginRepository> + <id>jiemamy.sourceforge.jp</id> + <name>jiemamy.sourceforge.jp</name> + <url>http://jiemamy.sourceforge.jp/maven2</url> + </pluginRepository> + </pluginRepositories> + <dependencies> + <dependency> + <groupId>postgresql</groupId> + <artifactId>postgresql</artifactId> + <version>8.2-504.jdbc3</version> + </dependency> + <dependency> + <groupId>org.mortbay.jetty</groupId> + <artifactId>jetty</artifactId> + <version>${jetty.version}</version> + <scope>provided</scope> + </dependency> + <dependency> + <groupId>org.mortbay.jetty</groupId> + <artifactId>jetty-util</artifactId> + <version>${jetty.version}</version> + <scope>provided</scope> + </dependency> + <dependency> + <groupId>org.mortbay.jetty</groupId> + <artifactId>jetty-management</artifactId> + <version>${jetty.version}</version> + <scope>provided</scope> + </dependency> + <dependency> + <groupId>javax.servlet</groupId> + <artifactId>servlet-api</artifactId> + <version>2.5</version> + <scope>provided</scope> + </dependency> + </dependencies> + <properties> + <jetty.version>6.1.4</jetty.version> + <database.username>postgres</database.username> + <database.password>postgres</database.password> + </properties> +</project> Property changes on: metis/jiemamy-tutorial/trunk/pom.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: metis/jiemamy-tutorial/trunk/run-jetty-server.bat =================================================================== --- metis/jiemamy-tutorial/trunk/run-jetty-server.bat (rev 0) +++ metis/jiemamy-tutorial/trunk/run-jetty-server.bat 2009-04-12 16:10:39 UTC (rev 3230) @@ -0,0 +1,5 @@ +cd %~p0 + +call mvn jetty:run + +pause \ No newline at end of file Added: metis/jiemamy-tutorial/trunk/run-jetty-server.sh =================================================================== --- metis/jiemamy-tutorial/trunk/run-jetty-server.sh (rev 0) +++ metis/jiemamy-tutorial/trunk/run-jetty-server.sh 2009-04-12 16:10:39 UTC (rev 3230) @@ -0,0 +1,3 @@ +#! /bin/bash + +mvn jetty:run Added: metis/jiemamy-tutorial/trunk/src/database/jiemamy.jer =================================================================== --- metis/jiemamy-tutorial/trunk/src/database/jiemamy.jer (rev 0) +++ metis/jiemamy-tutorial/trunk/src/database/jiemamy.jer 2009-04-12 16:10:39 UTC (rev 3230) @@ -0,0 +1,125 @@ +<?xml version="1.0" encoding="UTF-8"?> +<jiemamy xmlns="http://jiemamy.org/xml/ns/core" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" id="0018e785-8130-43bc-bf3e-0eec36230062" version="0.2-SNAPSHOT" xsi:schemaLocation="http://jiemamy.org/xml/ns/core ../../main/resources/jiemamy-core.xsd http://jiemamy.org/xml/ns/view ../../main/resources/jiemamy-view.xsd"> + <dialect>org.jiemamy.dialect.postgresql.PostgresqlDialect</dialect> + <domains/> + <entities> + <table id="f4970149-6db6-4637-9d1d-38266a14bd05"> + <name>T_ITEM</name> + <attributes> + <column id="78ba7e3e-53c3-4877-893f-a4b39d87052e"> + <name>ID</name> + <dataType> + <typeCategory>INTEGER</typeCategory> + <typeName>INTEGER</typeName> + </dataType> + </column> + <primaryKey id="31a61341-f204-42ba-9b38-26bd0a26d106"> + <columnRefs> + <columnRef ref="78ba7e3e-53c3-4877-893f-a4b39d87052e"/> + </columnRefs> + </primaryKey> + <column id="768f357b-6e74-497c-bbdb-bf678b8231ec"> + <name>ITEM_NAME</name> + <dataType> + <typeCategory>VARCHAR</typeCategory> + <typeName>VARCHAR</typeName> + <adapter class="org.jiemamy.model.datatype.adapter.SizedDataTypeAdapter"> + <size>64</size> + </adapter> + </dataType> + <notNull id="bf71c84c-5197-4a11-971b-f63135def257"/> + </column> + <column id="64f1bcb9-cd94-4e66-9961-845a66e10a9b"> + <name>PRICE</name> + <dataType> + <typeCategory>INTEGER</typeCategory> + <typeName>INTEGER</typeName> + </dataType> + <notNull id="e78950e7-6b0a-4c7c-8e75-e79b2c20925a"/> + </column> + </attributes> + <indexes/> + </table> + </entities> + <dataSets> + <dataSet id="090e561e-1e6f-41ae-9eda-b2de5bf61779"> + <name>DATASET_1</name> + <tableRef ref="f4970149-6db6-4637-9d1d-38266a14bd05"> + <record id="f6a2fbf0-41a2-4c51-8e25-9fc44468c39e"> + <columnRef ref="78ba7e3e-53c3-4877-893f-a4b39d87052e">1</columnRef> + <columnRef ref="768f357b-6e74-497c-bbdb-bf678b8231ec">Garnet</columnRef> + <columnRef ref="64f1bcb9-cd94-4e66-9961-845a66e10a9b">3000</columnRef> + </record> + <record id="f0a5586a-3ee1-4a3f-bb33-50f8f8a7172b"> + <columnRef ref="78ba7e3e-53c3-4877-893f-a4b39d87052e">2</columnRef> + <columnRef ref="768f357b-6e74-497c-bbdb-bf678b8231ec">Amethyst</columnRef> + <columnRef ref="64f1bcb9-cd94-4e66-9961-845a66e10a9b">1000</columnRef> + </record> + <record id="eeb106e8-1a58-4a3d-81e9-b5be504e94a4"> + <columnRef ref="78ba7e3e-53c3-4877-893f-a4b39d87052e">3</columnRef> + <columnRef ref="768f357b-6e74-497c-bbdb-bf678b8231ec">Aquamarine</columnRef> + <columnRef ref="64f1bcb9-cd94-4e66-9961-845a66e10a9b">10000</columnRef> + </record> + <record id="a9ad2516-a8af-4c78-8847-c9046bce9c9a"> + <columnRef ref="78ba7e3e-53c3-4877-893f-a4b39d87052e">4</columnRef> + <columnRef ref="768f357b-6e74-497c-bbdb-bf678b8231ec">Diamond</columnRef> + <columnRef ref="64f1bcb9-cd94-4e66-9961-845a66e10a9b">700000</columnRef> + </record> + <record id="69d8a0af-e28e-4371-8df4-00a725100d0e"> + <columnRef ref="78ba7e3e-53c3-4877-893f-a4b39d87052e">5</columnRef> + <columnRef ref="768f357b-6e74-497c-bbdb-bf678b8231ec">Emerald</columnRef> + <columnRef ref="64f1bcb9-cd94-4e66-9961-845a66e10a9b">100000</columnRef> + </record> + <record id="961e66de-fdc2-4d68-98ca-e06f0a98efaa"> + <columnRef ref="78ba7e3e-53c3-4877-893f-a4b39d87052e">6</columnRef> + <columnRef ref="768f357b-6e74-497c-bbdb-bf678b8231ec">Pearls</columnRef> + <columnRef ref="64f1bcb9-cd94-4e66-9961-845a66e10a9b">60000</columnRef> + </record> + <record id="3ccd83b6-3d97-47ee-a0e4-fbb4b72057f4"> + <columnRef ref="78ba7e3e-53c3-4877-893f-a4b39d87052e">7</columnRef> + <columnRef ref="768f357b-6e74-497c-bbdb-bf678b8231ec">Ruby</columnRef> + <columnRef ref="64f1bcb9-cd94-4e66-9961-845a66e10a9b">60000</columnRef> + </record> + <record id="a60fb2fb-33f2-4dce-a547-46f189eb2978"> + <columnRef ref="78ba7e3e-53c3-4877-893f-a4b39d87052e">8</columnRef> + <columnRef ref="768f357b-6e74-497c-bbdb-bf678b8231ec">Peridot</columnRef> + <columnRef ref="64f1bcb9-cd94-4e66-9961-845a66e10a9b">2000</columnRef> + </record> + <record id="f1bb34c1-ced5-47ec-9b01-405c42abbb29"> + <columnRef ref="78ba7e3e-53c3-4877-893f-a4b39d87052e">9</columnRef> + <columnRef ref="768f357b-6e74-497c-bbdb-bf678b8231ec">Sapphire</columnRef> + <columnRef ref="64f1bcb9-cd94-4e66-9961-845a66e10a9b">10000</columnRef> + </record> + <record id="ac3aecb6-7843-41a5-aace-09ab240f689c"> + <columnRef ref="78ba7e3e-53c3-4877-893f-a4b39d87052e">10</columnRef> + <columnRef ref="768f357b-6e74-497c-bbdb-bf678b8231ec">Opal</columnRef> + <columnRef ref="64f1bcb9-cd94-4e66-9961-845a66e10a9b">30000</columnRef> + </record> + <record id="d1c44070-1598-4de0-a471-bb452215b420"> + <columnRef ref="78ba7e3e-53c3-4877-893f-a4b39d87052e">11</columnRef> + <columnRef ref="768f357b-6e74-497c-bbdb-bf678b8231ec">Topaz</columnRef> + <columnRef ref="64f1bcb9-cd94-4e66-9961-845a66e10a9b">16000</columnRef> + </record> + <record id="7ef9b2b9-d423-43e4-bcf6-7d83e7a28729"> + <columnRef ref="78ba7e3e-53c3-4877-893f-a4b39d87052e">12</columnRef> + <columnRef ref="768f357b-6e74-497c-bbdb-bf678b8231ec">Turquoise</columnRef> + <columnRef ref="64f1bcb9-cd94-4e66-9961-845a66e10a9b">400</columnRef> + </record> + </tableRef> + </dataSet> + </dataSets> + <view:diagramPresentations xmlns:view="http://jiemamy.org/xml/ns/view"> + <view:diagramPresentation id="b1d4a9db-050a-4607-9e19-63afcff882eb"> + <name>default</name> + <view:mode>PHYSICAL</view:mode> + <view:level>ATTRTYPE</view:level> + <view:nodeProfiles> + <view:nodeProfile id="c1f3425b-1be2-4785-8c8e-4c2916c92dae"> + <view:nodeObjectRef ref="f4970149-6db6-4637-9d1d-38266a14bd05"/> + <view:boundary height="-1" width="-1" x="79" y="50"/> + </view:nodeProfile> + </view:nodeProfiles> + <view:connectionProfiles/> + </view:diagramPresentation> + </view:diagramPresentations> +</jiemamy> Added: metis/jiemamy-tutorial/trunk/src/main/java/org/jiemamy/tutorial/JiemamyServlet.java =================================================================== --- metis/jiemamy-tutorial/trunk/src/main/java/org/jiemamy/tutorial/JiemamyServlet.java (rev 0) +++ metis/jiemamy-tutorial/trunk/src/main/java/org/jiemamy/tutorial/JiemamyServlet.java 2009-04-12 16:10:39 UTC (rev 3230) @@ -0,0 +1,123 @@ +package org.jiemamy.tutorial; + +import java.io.IOException; +import java.sql.Connection; +import java.sql.DriverManager; +import java.sql.ResultSet; +import java.sql.SQLException; +import java.sql.Statement; + +import javax.servlet.ServletException; +import javax.servlet.http.HttpServlet; +import javax.servlet.http.HttpServletRequest; +import javax.servlet.http.HttpServletResponse; + +/** + * Jiemamyのチュートリアル用サーブレット。 + * + * @author daisuke + */ + @ SuppressWarnings("serial") +public class JiemamyServlet extends HttpServlet { + + private static final String NL = System.getProperty("line.separator"); + + private static final String PASSWORD = "postgres"; + private static final String USERNAME = "postgres"; + private static final String URI = "jdbc:postgresql://localhost:5432/jiemamy"; + + @Override + public void doGet(HttpServletRequest request, HttpServletResponse response) + throws ServletException, IOException { + + response.setContentType("text/html; charset=UTF-8"); + java.io.PrintWriter out = response.getWriter(); + out.println("<html>"); + out.println("<head>"); + out.println("<title>Hello, Jiemamy</title>"); + out.println("</head>"); + out.println("<body>"); + out.println("<h1>Hello, Jiemamy!</h1>"); + + out.println(databaseToTableHTML()); + + out.println("</body>"); + out.println("</html>"); + out.close(); + } + + private String databaseToTableHTML() { + + StringBuffer sb = new StringBuffer(); + + Connection db = null; // DB接続オブジェクト + Statement st = null; // SQL文オブジェクト + ResultSet rs = null; // 問合せ結果オブジェクト + + sb.append("<table border=\"1\">").append(NL); + sb.append("<caption>商品一覧</caption>").append(NL); + sb.append("<tr><th>商品名</th><th>価格</th></tr>").append(NL); + try { + Class.forName("org.postgresql.Driver"); + + db = DriverManager.getConnection(URI, USERNAME, PASSWORD); + st = db.createStatement(); + + rs = st.executeQuery("SELECT * FROM T_ITEM"); + if (rs != null) { + while (rs.next()) { + String item = rs.getString("ITEM_NAME"); + int price = rs.getInt("PRICE"); + + sb.append("<tr><th>"); + sb.append(item); + sb.append("</th><td>"); + sb.append(price); + sb.append("</td></tr>").append(NL); + } + rs.close(); + } + + st.close(); + db.close(); + } catch (Exception e) { + sb.append("<tr><td colspan=\"2\">"); + sb.append(e.getMessage()); + sb.append("</td></tr>").append(NL); + } finally { + sb.append("</table>").append(NL); + close(db); + close(st); + close(rs); + } + + return sb.toString(); + } + + private void close(Connection db) { + if(db != null) { + try { + db.close(); + } catch (SQLException e) { + } + } + } + + private void close(Statement st) { + if(st != null) { + try { + st.close(); + } catch (SQLException e) { + } + } + } + + private void close(ResultSet rs) { + if(rs != null) { + try { + rs.close(); + } catch (SQLException e) { + } + } + } +} Property changes on: metis/jiemamy-tutorial/trunk/src/main/java/org/jiemamy/tutorial/JiemamyServlet.java ___________________________________________________________________ Added: svn:mime-type + text/plain Added: metis/jiemamy-tutorial/trunk/src/main/webapp/WEB-INF/classes/org/jiemamy/tutorial/JiemamyServlet.class =================================================================== (Binary files differ) Property changes on: metis/jiemamy-tutorial/trunk/src/main/webapp/WEB-INF/classes/org/jiemamy/tutorial/JiemamyServlet.class ___________________________________________________________________ Added: svn:mime-type + application/octet-stream Added: metis/jiemamy-tutorial/trunk/src/main/webapp/WEB-INF/web.xml =================================================================== --- metis/jiemamy-tutorial/trunk/src/main/webapp/WEB-INF/web.xml (rev 0) +++ metis/jiemamy-tutorial/trunk/src/main/webapp/WEB-INF/web.xml 2009-04-12 16:10:39 UTC (rev 3230) @@ -0,0 +1,40 @@ +<?xml version="1.0"?> + +<!-- + * Copyright 2007-2008 MIYAMOTO Daisuke and the Others. + * + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, + * either express or implied. See the License for the specific language + * governing permissions and limitations under the License. +--> + +<!DOCTYPE web-app PUBLIC + "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" + "http://java.sun.com/dtd/web-app_2_3.dtd"> + +<web-app> + + <servlet> + <servlet-name>jiemamyTutorialServlet</servlet-name> + <servlet-class>org.jiemamy.tutorial.JiemamyServlet</servlet-class> + <load-on-startup>1</load-on-startup> + </servlet> + + <servlet-mapping> + <servlet-name>jiemamyTutorialServlet</servlet-name> + <url-pattern>/tutorial</url-pattern> + </servlet-mapping> + + <welcome-file-list> + <welcome-file>index.jsp</welcome-file> + </welcome-file-list> + +</web-app> Property changes on: metis/jiemamy-tutorial/trunk/src/main/webapp/WEB-INF/web.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Added: metis/jiemamy-tutorial/trunk/src/main/webapp/index.jsp =================================================================== --- metis/jiemamy-tutorial/trunk/src/main/webapp/index.jsp (rev 0) +++ metis/jiemamy-tutorial/trunk/src/main/webapp/index.jsp 2009-04-12 16:10:39 UTC (rev 3230) @@ -0,0 +1,12 @@ +<html> +<head> +<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> +<title>Jiemamt Tutorial</title> +</head> +<body> +<h1>Hello Jiemamy!</h1> + +<p><a href="tutorial">access to servlet</a></p> + +</body> +</html> \ No newline at end of file