Changes between Version 9 and Version 10 of UTGBCore/SQLite

Timestamp:

10/12/07 21:27:28 (18 years ago)

Author:

leo

Comment:

--

UTGBCore/SQLite

@@ -11 +11 @@
 The source code of this servlet is here:
 source:trunk/utgb/utgb-core/src/main/java/org/utgenome/gwt/utgb/server/app/SQLiteAccessSample.java
+{{{
+public class SQLiteAccessSample implements RequestHandler
+{
+    private static Logger _logger = Logger.getLogger(SQLiteAccessSample.class);
+        
+    public void handle(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
+    {
+        ArrayList<String> speciesList = new ArrayList<String>();
+        try
+        {
+            // this will load database file from utgb-core/resource folder 
+            SQLiteAccess sqlite = UTGB.getSQLiteAccess("legacy-track.db");
+            List<String> queryResult = sqlite.query("select distinct species from tracks order by species", "species", String.class);
+            _logger.debug("species: " + queryResult);
+            speciesList.addAll(queryResult);
+            
+            response.getWriter().println(StringUtil.join(queryResult, ", "));
+        }
+        catch (DBException e)
+        {
+            _logger.error(e);
+        }
 
+    }
+
+}
+
+}}}
 
 == Simple SQL query processing with BeanUtil ==