Add files via upload

Kuassim · web-flow · commit 25d70175dcc3 · 2017-05-26T15:21:14.000-07:00
diff --git a/javascript/nashorn/select.js b/javascript/nashorn/select.js
@@ -3,25 +3,29 @@ var selectQuery = function(id)
    var Driver = Packages.oracle.jdbc.OracleDriver;
    var oracleDriver = new Driver();
    var url = "jdbc:default:connection:";
-   var query = "";
    var output = "";
-   if(id == 'all') {
-    query ="SELECT a.data FROM employees a";
-   } else {
-       query ="SELECT a.data FROM employees a WHERE a.data.EmpId=" + id;
-   }
    var connection = oracleDriver.defaultConnection();
+   var prepStmt;
+
    // Prepare statement
-   var preparedStatement = connection.prepareStatement(query);
+    if(id == 'all') {
+       prepStmt = connection.prepareStatement("SELECT a.data FROM employees a");
+      } else {
+       prepStmt = connection.prepareStatement("SELECT a.data FROM employees a WHERE a.data.EmpId = ?");
+       prepStmt.setInt(1, id);
+       }
+
    // execute Query
-    var resultSet = preparedStatement.executeQuery();   
+	var resultSet = prepStmt.executeQuery();
+
    // display results
-   while(resultSet.next()) {
-   output = output + resultSet.getString(1) + " ";
-   }   
-    // cleanup
+	while(resultSet.next()) {
+		output = output + resultSet.getString(1) + "<br>";
+	}
+
+   // cleanup
     resultSet.close();
-    preparedStatement.close();
+    prepStmt.close();
     connection.close();
     return output;
-  }
+}
