Utils (ExtenXLS v10.2-20120430)

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.extentech.ExtenBean
Class Utils

java.lang.Object
  com.extentech.ExtenBean.Utils

public class Utils
extends java.lang.Object
extends java.lang.Object

Constructor Summary
`Utils()`

Method Summary
`static java.lang.String`	`handleDBParams(java.lang.String sql, java.lang.String params, java.util.Map vals, boolean SQLreplaceWithParamName)` Utility Method to parameterize SQL Statements take a query like: SELECT * FROM products WHERE product_id=? AND organization='?' take parameters like: product_id, organization take Hashtable like: product_id="100",organization="Extentech" End up with Query Like: SELECT * FROM products WHERE product_id=100 AND organization='Extentech'

Method Summary

static java.lang.String handleDBParams(java.lang.String sql, java.lang.String params, java.util.Map vals, boolean SQLreplaceWithParamName)
Utility Method to parameterize SQL Statements take a query like: SELECT * FROM products WHERE product_id=? AND organization='?' take parameters like: product_id, organization take Hashtable like: product_id="100",organization="Extentech" End up with Query Like: SELECT * FROM products WHERE product_id=100 AND organization='Extentech'

Methods inherited from class java.lang.Object
`equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Constructor Detail

Utils

public Utils()

Method Detail

handleDBParams

public static java.lang.String handleDBParams(java.lang.String sql,
                                              java.lang.String params,
                                              java.util.Map vals,
                                              boolean SQLreplaceWithParamName)

Utility Method to parameterize SQL Statements take a query like: SELECT * FROM products WHERE product_id=? AND organization='?' take parameters like: product_id, organization take Hashtable like: product_id="100",organization="Extentech" End up with Query Like: SELECT * FROM products WHERE product_id=100 AND organization='Extentech'