diff --git a/.gitignore b/.gitignore
index ea2c229..4bac95b 100644
--- a/.gitignore
+++ b/.gitignore
@@ -2,5 +2,4 @@
 .DS_Store
 target/
 
-
-
+*.patn
diff --git a/pom.xml b/pom.xml
index 8153945..00d0497 100644
--- a/pom.xml
+++ b/pom.xml
@@ -15,6 +15,21 @@
     <maven.compiler.target>11</maven.compiler.target>
   </properties>
 
+  <repositories>
+    <repository>
+      <id>nuxeo</id>
+      <name>nuxeo</name>
+      <url>https://maven-eu.nuxeo.org/nexus/content/repositories/public-releases/</url>
+    </repository>
+    <repository>
+      <id>redhat GA</id>
+      <name>redhat GA</name>
+      <url>https://maven.repository.redhat.com/ga/</url>
+    </repository>
+
+
+  </repositories>
+
   <build>
     <plugins>
       <plugin>
@@ -83,6 +98,16 @@
       <version>3.0.1</version>
       <!-- <type>bundle</type> -->
     </dependency>
+    <dependency>
+      <groupId>net.sf.josql</groupId>
+      <artifactId>josql</artifactId>
+      <version>2.2</version>
+    </dependency>
+    <dependency>
+      <groupId>net.sf.josql</groupId>
+      <artifactId>gentlyweb-utils</artifactId>
+      <version>1.5</version>
+    </dependency>
     <!-- <dependency>
       <groupId>piccolo2d_core</groupId>
       <artifactId>piccolo2d.core</artifactId>
diff --git a/src/main/java/cit/PureATN/MultiNote/KeyEvent_on_MultiNote.java b/src/main/java/cit/PureATN/MultiNote/KeyEvent_on_MultiNote.java
index bcddde5..c2f68e5 100644
--- a/src/main/java/cit/PureATN/MultiNote/KeyEvent_on_MultiNote.java
+++ b/src/main/java/cit/PureATN/MultiNote/KeyEvent_on_MultiNote.java
@@ -43,6 +43,10 @@
             MultiNote mn = (MultiNote)Note.theapp;
             mn.iroduke();            
         }
+        if (e.getKeyCode() == KeyEvent.VK_R) {
+            MultiNote mn = (MultiNote)Note.theapp;
+            mn.showStat();            
+        }
 
         if (e.getKeyCode() == KeyEvent.VK_Z) {
             // System.out.println("SimpleATN zoomLevel = "+getZoomLevel());
diff --git a/src/main/java/cit/PureATN/MultiNote/MultiNote.java b/src/main/java/cit/PureATN/MultiNote/MultiNote.java
index abde0ca..75d2540 100644
--- a/src/main/java/cit/PureATN/MultiNote/MultiNote.java
+++ b/src/main/java/cit/PureATN/MultiNote/MultiNote.java
@@ -3,10 +3,18 @@
 import java.awt.Color;
 import java.util.ArrayList;
 import java.util.Enumeration;
+import java.util.Iterator;
+import java.util.List;
+import java.util.Map;
 
 import javax.swing.WindowConstants;
 
+import org.josql.Query;
+import org.josql.QueryExecutionException;
+import org.josql.QueryParseException;
+import org.josql.QueryResults;
 import org.piccolo2d.PCanvas;
+import org.piccolo2d.PNode;
 
 import cit.PureATN.Note;
 import cit.PureATN.PenUser;
@@ -14,7 +22,6 @@
 
 public class MultiNote extends Note {
 
-
     public MultiNote() {
         this(null);
         setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
@@ -54,14 +61,14 @@
     public void iroduke() {
         Enumeration<String> ite = PenUser.penusers.keys();
         while (ite.hasMoreElements()) {
-            String penidStr =ite.nextElement();
+            String penidStr = ite.nextElement();
             String penid0x = penidStr.substring(3);
             int penid = Integer.parseInt(penid0x);
             // System.out.println(penid+" "+penid*penid); //pen06
 
-            Color c = Color.getHSBColor((float)(penid/10.0f), 0.8f, 0.8f);
+            Color c = Color.getHSBColor((float) (penid / 10.0f), 0.8f, 0.8f);
             ArrayList<ShortStroke> sss = PenUser.find(penidStr).strokes;
-            for(ShortStroke s: sss){
+            for (ShortStroke s : sss) {
                 s.setStrokePaint(c);
                 System.out.println(s.time);
             }
@@ -69,6 +76,46 @@
         repaint();
     }
 
+    /**
+     * 筆記数の確認サンプル：PenIDごとに、筆記数を表示する
+     */
+    public void showStat() {
+        // 検索対象をあつめる
+        ArrayList<ShortStroke> ass = new ArrayList<ShortStroke>();
+        var ite = getCanvas().getLayer().getAllNodes().iterator();
+        while (ite.hasNext()) {
+            var n = ite.next();
+            if (n instanceof ShortStroke) {
+                ShortStroke ss = (ShortStroke) n;
+                ass.add(ss);
+            }
+        }
 
+        // (n ->
+
+        Query q5 = new Query();
+        try {
+            q5.parse("select * from cit.PureATN.ShortStroke group by penid");
+        } catch (QueryParseException e) {
+            e.printStackTrace();
+        }
+        QueryResults qr5 = null;
+        try {
+            qr5 = q5.execute(ass);
+            Map grpBys = qr5.getGroupByResults();
+            Iterator iter = grpBys.keySet().iterator();
+            while(iter.hasNext()){
+                List key = (List)iter.next();
+                List res = (List) grpBys.get(key);
+                System.out.println(key.toString()+" "+res.size());
+            }
+            // for (ShortStroke ss : (List<ShortStroke>) qr5.getResults()) {
+            //     System.out.println(ss.penid);
+            // }
+        } catch (QueryExecutionException e) {
+            e.printStackTrace();
+        }
+
+    }
 
 }
diff --git a/src/main/java/cit/PureATN/PenUser.java b/src/main/java/cit/PureATN/PenUser.java
index bcc64de..682dbae 100644
--- a/src/main/java/cit/PureATN/PenUser.java
+++ b/src/main/java/cit/PureATN/PenUser.java
@@ -211,6 +211,7 @@
 				}
 			} else {
 				squiggle.applyTempPtsToAry();
+				squiggle.penid = num; //整数型のPenID
 				squiggle = null;
 			}
 		}