com.github.drinkjava2.jdialects.tinyjdbc

Class TinyJdbc

java.lang.Object

com.github.drinkjava2.jdialects.tinyjdbc.TinyJdbc

public class TinyJdbc
extends Object

A tiny JDBC tool to access database

Version:

1.0.0

Author:

Yong Zhu

Field Summary

Fields

Modifier and Type	Field and Description
static boolean	show_sql

Constructor Summary

Constructors

Constructor and Description
TinyJdbc()

Method Summary

Methods

Modifier and Type	Method and Description
static void	closeConnection(Connection con)
static boolean	execute(Connection con, String... sqls)
static void	executeManySqls(Connection con, String... sqls)
static TinyResult	executeQuery(Connection con, String... sqls)
static boolean	executeQuiet(Connection con, String... sqls)
static void	executeQuietManySqls(Connection con, String... sqls)
static int	executeUpdate(Connection con, String... sqls)
static Connection	getConnection(DataSource datasource)
static int	getTableCount(Connection con)
static String	P(Object... parameters) Return a empty string and cache parameters in thread local for SQL use
static String	P0(Object... parameters) Clear cache first, then return a empty string and cache parameters in thread local for SQL use
static Integer	queryForInteger(Connection con, String... sqls)
static Object	queryForObject(Connection con, String... sqls)
static String	queryForString(Connection con, String... sqls)

Methods inherited from class java.lang.Object

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

Field Detail

show_sql

public static boolean show_sql

Constructor Detail

TinyJdbc

public TinyJdbc()

Method Detail

P0

public static String P0(Object... parameters)

Clear cache first, then return a empty string and cache parameters in thread local for SQL use

P

public static String P(Object... parameters)

Return a empty string and cache parameters in thread local for SQL use

getConnection

public static Connection getConnection(DataSource datasource)

closeConnection

public static void closeConnection(Connection con)

executeQuery

public static TinyResult executeQuery(Connection con,
                      String... sqls)

queryForInteger

public static Integer queryForInteger(Connection con,
                      String... sqls)

queryForObject

public static Object queryForObject(Connection con,
                    String... sqls)

queryForString

public static String queryForString(Connection con,
                    String... sqls)

executeUpdate

public static int executeUpdate(Connection con,
                String... sqls)

executeQuiet

public static boolean executeQuiet(Connection con,
                   String... sqls)

executeManySqls

public static void executeManySqls(Connection con,
                   String... sqls)

executeQuietManySqls

public static void executeQuietManySqls(Connection con,
                        String... sqls)

execute

public static boolean execute(Connection con,
              String... sqls)

getTableCount

public static int getTableCount(Connection con)