Package com.anlavn.net

Class SQL

java.lang.Object

com.anlavn.net.SQL

public class SQL
extends Object

The SQL class supports to connect, execute mySQL and SQL server.

Constructor Summary

Constructors

Constructor	Description
SQL(String DB_url, String DB_username, String DB_password)	Create a SQL connect with full information.

Method Summary

Modifier and Type	Method	Description
final void	Connect()	Use this method to connect your Database.
final Connection	getConnect()	Use this method to get connection of SQL.
final boolean	isConnectNull()	Use this method to check the connection of SQL is null.
final ResultSet	Query(String Query, Object... args)	Use this method to execute Query with multiple arguments Object Varargs.
final int	Update(String Query, Object... args)	Use this method to execute Update Query with multiple arguments Object Varargs.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

SQL

public SQL(String DB_url,
 String DB_username,
 String DB_password)

Create a SQL connect with full information.

Parameters:

DB_url - is Database URL to connect.

DB_username - is Database Username.

DB_password - is Database Password.

Method Details

isConnectNull

public final boolean isConnectNull()

Use this method to check the connection of SQL is null.

Returns:

true if SQL connection is null, false in the opposite.

getConnect

public final Connection getConnect()

Use this method to get connection of SQL.

Returns:

Connection of your SQL.

Connect

public final void Connect()
                   throws ClassNotFoundException,
SQLException

Use this method to connect your Database.

Throws:

ClassNotFoundException

SQLException

See Also:

• SQL(java.lang.String, java.lang.String, java.lang.String)

Update

public final int Update(String Query,
 Object... args)

Use this method to execute Update Query with multiple arguments Object Varargs.

Parameters:

Query - is a String SQL Query statement.

args - is array multiple arguments Object Varargs.

Returns:

number of row affected after execute the Query.

See Also:

• Query(java.lang.String, java.lang.Object...)

Query

public final ResultSet Query(String Query,
 Object... args)

Use this method to execute Query with multiple arguments Object Varargs.

Parameters:

Query - is a String SQL Query statement.

args - is array multiple arguments Object Varargs.

Returns:

a Result Set after execute the Query.

See Also:

• Update(java.lang.String, java.lang.Object...)