Package org.apache.ibatis.jdbc

Class SqlRunner

java.lang.Object

org.apache.ibatis.jdbc.SqlRunner

public class SqlRunner
extends Object

Author:

Clinton Begin

Field Summary

Fields

Modifier and Type	Field	Description
static final int	NO_GENERATED_KEY

Constructor Summary

Constructors

Constructor	Description
SqlRunner(Connection connection)

Method Summary

Modifier and Type	Method	Description
void	closeConnection()	Deprecated. Since 3.5.4, this method is deprecated.
int	delete(String sql, Object... args)	Executes a DELETE statement.
int	insert(String sql, Object... args)	Executes an INSERT statement.
void	run(String sql)	Executes any string as a JDBC Statement.
List<Map<String,Object>>	selectAll(String sql, Object... args)	Executes a SELECT statement that returns multiple rows.
Map<String,Object>	selectOne(String sql, Object... args)	Executes a SELECT statement that returns one row.
void	setUseGeneratedKeySupport(boolean useGeneratedKeySupport)
int	update(String sql, Object... args)	Executes an UPDATE statement.

Methods inherited from class java.lang.Object

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

Field Details

NO_GENERATED_KEY

public static final int NO_GENERATED_KEY

See Also:

• Constant Field Values

Constructor Details

SqlRunner

public SqlRunner(Connection connection)

Method Details

setUseGeneratedKeySupport

public void setUseGeneratedKeySupport(boolean useGeneratedKeySupport)

selectOne

public Map<String,Object> selectOne(String sql,
 Object... args)
                             throws SQLException

Executes a SELECT statement that returns one row.

Parameters:

sql - The SQL

args - The arguments to be set on the statement.

Returns:

The row expected.

Throws:

SQLException - If less or more than one row is returned

selectAll

public List<Map<String,Object>> selectAll(String sql,
 Object... args)
                                   throws SQLException

Executes a SELECT statement that returns multiple rows.

Parameters:

sql - The SQL

args - The arguments to be set on the statement.

Returns:

The list of rows expected.

Throws:

SQLException - If statement preparation or execution fails

insert

public int insert(String sql,
 Object... args)
           throws SQLException

Executes an INSERT statement.

Parameters:

sql - The SQL

args - The arguments to be set on the statement.

Returns:

The number of rows impacted or BATCHED_RESULTS if the statements are being batched.

Throws:

SQLException - If statement preparation or execution fails

update

public int update(String sql,
 Object... args)
           throws SQLException

Executes an UPDATE statement.

Parameters:

sql - The SQL

args - The arguments to be set on the statement.

Returns:

The number of rows impacted or BATCHED_RESULTS if the statements are being batched.

Throws:

SQLException - If statement preparation or execution fails

delete

public int delete(String sql,
 Object... args)
           throws SQLException

Executes a DELETE statement.

Parameters:

sql - The SQL

args - The arguments to be set on the statement.

Returns:

The number of rows impacted or BATCHED_RESULTS if the statements are being batched.

Throws:

SQLException - If statement preparation or execution fails

run

public void run(String sql)
         throws SQLException

Executes any string as a JDBC Statement. Good for DDL

Parameters:

sql - The SQL

Throws:

SQLException - If statement preparation or execution fails

closeConnection

@Deprecated
public void closeConnection()

Deprecated.

Since 3.5.4, this method is deprecated. Please close the Connection outside of this class.