[feature] complete image list for image management system

[incomlete] detail image view of each image
cashlalala · Nov 23, 2014 · f77af26 · f77af26
1 parent cab942f
commit f77af26
Show file tree

Hide file tree

Showing 4 changed files with 305 additions and 79 deletions.
diff --git a/src/camera/Frm_ConfirmImage.java b/src/camera/Frm_ConfirmImage.java
@@ -28,19 +28,6 @@
 
 public class Frm_ConfirmImage extends JFrame {
 
-	private class TwoColumeClass {
-		public String col1;
-		public String col2;
-		public TwoColumeClass(String _col1, String _col2) {
-			col1 = _col1;
-			col2 = _col2;
-		}
-		public String toString()  
-        {  
-            return col2;  
-        } 
-	}
-
 	private static final long serialVersionUID = 1L;
 
 	private Vector<TwoColumeClass> cobCategoryData;
@@ -72,7 +59,7 @@ public String toString()
 	private String mType;
 	//private JFrame mParent;
 
-	public void getCategoryData() {
+	private void getCategoryData() {
 		String sql = "SELECT * FROM body_code";
    		try{
             ResultSet rs = DBC.executeQuery(sql);
@@ -86,10 +73,10 @@ public void getCategoryData() {
          }
 	}
 
-	public void getKeywordData() {
+	private void getKeywordData() {
 		cobKeywordData.add(new TwoColumeClass("", ""));
 
-		String sql = "SELECT distinct keyword FROM image_meta WHERE type='wound' AND keyword is not null";
+		String sql = "SELECT distinct keyword FROM image_meta WHERE type='wound' AND keyword is not null order by keyword ASC";
    		try{
             ResultSet rs = DBC.executeQuery(sql);
             //String[] rowData = new String[5];