Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 29.625.103 Times

SQLizer 1.1

  Date Added: October 21, 2010  |  Visits: 826

SQLizer

Report Broken Link
Printer Friendly Version


Product Homepage
Download (75 downloads)



SQLizer is a Java utility library intended for generating sql from the search input. Synopsis: import stanford.netdb.utils.*; String sql_1 = Feild2SQL.parseField(type,table, column, input_str, field_display_name, post_filter); String sql_2 = Feild2SQL.parseStringField(table, column, input_str, field_display_name); String sql_3 = Feild2SQL.parseIntField(table, column, line, field_display_name); Given an input string it builds SQL select statement. It supports two types of inputs, numeric and string. The catch is that this library allows usage of operators in the input string. Supported operators are and, or and not. It also supports wildcards *, %, ? and _ in string searches. In case of numeric searches no wildcards are supported. To accommodate searches by strings, which have wildcards in them, backslashes can be used to escape appropriate characters. Obviously to search for it needs to be escaped as well. Strings with spaces needs to be enclosed in double quotes. The other possibility is to do a regex search, which is accomplished by enclosing string in forward slashes. The resulting SQL is targeted toward Oracle regex expressions. For example, following input strings will be appropriately evaluated. a or b -> ( ( select id from Record where name = a ) UNION ( select id from Record where name = b ) ) not a and not b -> ( ( select id from Record MINUS ( select id from Record where name = a ) ) INTERSECT ( select id from Record MINUS ( select id from Record where name = b ) ) ) "a b c" or a* -> ( ( select id from Record where name = a b c ) UNION ( select id from Record where name LIKE a\% ESCAPE ) ) /^.*[[:digit:]]$/ -> ( select id from Record where REGEXP_LIKE(name, ^.*[[:digit:]]$, i) ) We use unions and intersects in order to accomodate searches for objects with multi-value attributes..

Requirements: No special requirements
Platforms: Linux
Keyword: Id Java Utility Java Utility Library Libraries Name Programming Record Select Sql Sqlizer String Utility Library
Users rating: 0/10

License: Freeware Size: 6.14 KB
USER REVIEWS
More Reviews or Write Review


SQLIZER RELATED
Libraries  -  Java Fastest String Utility New
The Java Fastest String Utility was built as a Java library that can be used for string operations. The library is very easy-to-use, very fast and efficient in string operations such as split, toUpperCase, toLowerCase, replace, delete, regular...
 
Libraries  -  Westhawks Java SNMP stack 5.0
Westhawk SNMP is a lightweight SNMP stack in Java, with Java applet, application, and servlet examples. The stack provides manager functionality for SNMPv1, SNMPv2c, and SNMPv3 (authentication and privacy). Westhawks Java SNMP stack is capable...
1.9 MB  
Libraries  -  PLIB 1.8.5 RC1
PLIB project includes sound effects, music, a complete 3D engine, font rendering, a simple Windowing library, a game scripting language, a GUI, networking, 3D math library and a collection of handy utility functions. All are 100% portable across...
788.48 KB  
Utilities  -  BlueJ 2.2.0
BlueJ project is an integrated Java environment (Java IDE) specifically designed for introductory teaching. The BlueJ environment was developed as part of a university research project about teaching object-orientation to beginners. The system...
3.1 MB  
ActiveX Components  -  Multi-Lingual String Table Library 1.0
Multi-Lingual String Table Library provides the easiest way to make a Win32 application multi-lingual by wrapping the string-table picking and string loading by routines. The library provides a Windows application the functions to pick an external...
17 KB  
Libraries  -  XNap Commons 0.9.6
XNap Commons project provides a set of utility Java classes for easy handling of common tasks like sortable tables, auto completion, and internationalization, a settings framework, and Swing components like common dialogs, a wizard, a closeable...
419.84 KB  
Libraries  -  Java::Import::Examples 0.03
Java::Import::Examples is an example of how to use Java::Import to call into Java classes. Making RMI calls from Perl One nice thing about Java is the extremely straight forward manner in which it allows you to make calls to remote objects...
28.67 KB  
Libraries  -  Java-Gnome 4.0.3
Java-GNOME application is a set of Java bindings for the GNOME and GTK libraries that allow GNOME and GTK applications to be written in Java. The Java-Gnome API has been carefully designed to be easy to use, maintaining a good OO paridigm, yet...
174.08 KB  
Libraries  -  Java::Build::JVM 0.05
Java::Build::JVM is a Perl module that starts one JVM for compiling. SYNOPSIS use Java::Build::JVM; my $compiler = Java::Build::JVM->getCompiler(); $compiler->destination("some/path");...
30.72 KB  
Libraries  -  Parse::Java 0.01
Parse::Java is a Perl module that acts like a parser for Java code. SYNOPSIS use Parse::Java; my $ast = Parse::Java->parse_file(MyClass.java); Parse::Java parses Java code into an Abstract Syntax Tree which can be used for many things like...
18.43 KB  
NEW DOWNLOADS IN PROGRAMMING, LIBRARIES
Programming  -  FLEX-db Digital Asset Manager 3.0.9
FLEX-db - an enterprise Digital Asset Manager (DAM). It ingests and links metadata with files, creates thumbnails, and processes files using business rules. FLEX-db has a JSP client, Java app server for file input and output and an EJB metadata...
21.57 MB  
Programming  -  Libicom 0.9.0
The libicom library is a character based dynamicly linked library for Linux. It is used to remotely control the Icom IC-R8500 wide band receiver via an RS232 link. All call and return parameters to the control functions are character string based....
20.48 KB  
Programming  -  dotdesktop 0.3
Dotdesktop library provides ability to parse desktop entry file and access the information in a convenient way. Desktop entry file format is defined by freedesktop.org, it is used to describe information about an application such as the name and...
327.68 KB  
Programming  -  Cedalion for Linux 0.2.6
Cedalion is a programming language that allows its users to add new abstractions and define (and use) internal DSLs. Its innovation is in the fact that it uses projectional editing to allow the new abstractions to have no syntactic limitations.
471.04 KB  
Programming  -  libyasl 0.2
Libyasl is a C++ class library to easily realize TCP/UDP/Multicast clientsand servers in IPv4 and IPv6 environments under GNU/Linux systems.
143.36 KB  
Libraries  -  wolfSSL 3.11.0
The wolfSSL embedded SSL/TLS library is a lightweight SSL library written in ANSI standard C and targeted for embedded and RTOS environments - primarily because of its small size, speed, and feature set. It is commonly used in standard operating...
2.73 MB  
Libraries  -  EuGTK 4.8.9
Makes it easy to develop good- looking, fast, cross-platform programs that run on Linux, OS X, and Windows. Euphoria is a very fast interpreted/compiled language with straight-forward syntax. EuGTK allows programming in a clean, object-oriented...
10.68 MB  
Libraries  -  Linux User Group Library Manager 1.0
The LUG Library Manager is a project to help Linux User Groups start their own library. A LUG library is helpful to the community at large because it increases access to information, and gives everyone the opportunity to become more knowledgeable.
5.35 KB  
Libraries  -  Module::MakefilePL::Parse 0.12
Module::MakefilePL::Parse is a Perl module to parse required modules from Makefile.PL. SYNOPSIS use Module::MakefilePL::Parse; open $fh, Makefile.PL; $parser = Module::MakefilePL::Parse->new( join("", ) ); $info = $parser->required;...
8.19 KB  
Libraries  -  sqlpp 0.06
sqlpp Perl package is a SQL preprocessor. sqlpp is a conventional cpp-alike preprocessor taught to understand SQL ( PgSQL, in particular) syntax specificities. In addition to the standard #define/#ifdef/#else/#endif cohort, provides also...
10.24 KB