[Squirrel-sql-commits] SF.net SVN: squirrel-sql:[5947] trunk/sql12/ squirrelsql-integration-environment/src/test/java

[<man...@us...>]

Revision: 5947
          http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=5947&view=rev
Author:   manningr
Date:     2010-10-30 18:17:22 +0000 (Sat, 30 Oct 2010)

Log Message:
-----------
Simple test driver for executing arbitrary SQL against a database for testing purposes.

Added Paths:
-----------
    trunk/sql12/squirrelsql-integration-environment/src/test/java/adhoc/
    trunk/sql12/squirrelsql-integration-environment/src/test/java/adhoc/ExecuteSQLTest.java

Added: trunk/sql12/squirrelsql-integration-environment/src/test/java/adhoc/ExecuteSQLTest.java
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/java/adhoc/ExecuteSQLTest.java	                        (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/java/adhoc/ExecuteSQLTest.java	2010-10-30 18:17:22 UTC (rev 5947)
@@ -0,0 +1,69 @@
+package adhoc;
+
+import java.sql.Connection;
+import java.sql.Driver;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.sql.Statement;
+import java.util.Properties;
+
+public class ExecuteSQLTest {
+
+    public static void main(String[] args) 
+        throws Exception 
+    {
+        if (args.length < 4) {
+            printUsage();
+        }
+        String driver = args[0];
+        String url = args[1];
+        String user = args[2];
+        String pass = args[3];
+        String sql = args[4];
+        
+        Connection connection = getConnection(driver, url, user, pass, null);
+
+        System.out.println("Connected to: " + connection.getMetaData().getURL());
+        
+        System.out.println("Running SQL: "+sql);
+        
+        Statement stmt = connection.createStatement();
+        
+        ResultSet rs = stmt.executeQuery(sql);
+        
+        while (rs.next()) {
+      	  System.out.println("rs.getString(1): "+rs.getString(1));
+        }
+        
+    }
+
+    private static void printUsage() {
+        System.out.println("SQuirreLConnectTest: <driver> <url> <user> <pass> <sql statement>");
+        System.exit(-1);
+    }
+    
+    /**
+     * @param props
+     *            may be null
+     */
+    public static Connection getConnection(String driver, String url,
+            String user, String pw, Properties props)
+            throws ClassNotFoundException, IllegalAccessException,
+            InstantiationException, SQLException {
+        if (null == props) {
+            props = new Properties();
+        }
+
+        props.put("user", user);
+        props.put("password", pw);
+
+        Driver driverInst = (Driver) Class.forName(driver).newInstance();
+
+        Connection jdbcConn = driverInst.connect(url, props);
+        if (jdbcConn == null) {
+            throw new RuntimeException("Connect failed");
+        }
+
+        return jdbcConn;
+    }
+}


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.