Create your own awesome maps

Even on the go

with our free apps for iPhone, iPad and Android

Get Started

Already have an account?
Log In

package java.sql by Mind Map: package java.sql
0.0 stars - 0 reviews range from 0 to 5

package java.sql

DriverManager

static Connection getConnection(String url, String user, String password)

Connection

Statement createStatement()

Statement createStatement(int tipo, int concorrência)

PreparedStatement prepareStatement(String sql)

PreparedStatement prepareStatement(String sql, int tipo, int concorrência)

tipo, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

concorrência, CONCUR_READ_ONLY, CONCUR_UPDATABLE

void setAutoCommint(boolean autoCommit)

void commit()

void rollback()

void close()

ResultSet

boolean next()

Xxx getXxx(int coluna)

"Xxx" é um tipo boolean, byte, Date, double, float, int, long, Object, short, String, Time, Timestamp etc.

Xxx getXxx(String coluna)

"Xxx" é um tipo boolean, byte, Date, double, float, int, long, Object, short, String, Time, Timestamp etc.

int findColumn(String coluna)

void close()

boolean previous()

int getRow()

boolean absolute(int r)

Move o cursor para a linha "r". Retorna "true" se o cursor estiver posicionado em uma linha.

boolean relative(int d)

Move o cursor por "d" linhas. Se "d" for negativo, o cursor é movido para trás. Retorna "true" se o cursor estiver posicionado em uma linha.

boolean first()

boolean last()

boolean beforeFirst()

boolean afterLast()

boolean isFirst()

boolean isLast()

boolean isBeforeFirst()

boolean isAfterLast()

void moveToInsertRow()

void moveToCurrentRow()

void insertRow()

void deleteRow()

void updateXxx(int coluna, Xxx x)

"Xxx" é um tipo boolean, byte, Date, double, float, int, long, Object, short, String, Time, Timestamp etc.

void updateXxx(String coluna, Xxx x)

"Xxx" é um tipo boolean, byte, Date, double, float, int, long, Object, short, String, Time, Timestamp etc.

void updateRow()

void cancelRowUpdates()

Statement

ResultSet executeQuery(String sql)

int executeUpdate(String sql)

void addBatch(String sql)

int[] executeBatch()

void clearBatch()

void close()

PreparedStatement

void setXxx(int n, Xxx x)

"n" refere-se ao n-ésimo parâmetro. "Xxx" é um tipo boolean, byte, Date, double, float, int, long, Object, short, String, Time, Timestamp etc.

void clearParameters()

ResultSet executeQuery()

int executeUpdate()

SQLException

String getSQLState

int getErrorCode

SQLException getNextException