Archives: JDBC

Java – JDBC 4 – Update Annotation Example

March 20, 2011 | By Prasanna Sherekar | Post comment

JDBC 4 Annotation Example using Update Query

The Update annotation is used to decorate a Query interface method to update one or more records in a database table.
An Update annotation must include a sql annotation type element.

interface LoanAppDetailsQuery extends BaseQuery {
    @Update(sql="update LoanDetails set LoanStatus = ?1 where loanId = ?2")
    boolean updateLoanStatus(String loanStatus, int loanId);
}

interface LoanAppDetailsQuery extends BaseQuery {

@Update(sql="update LoanDetails set LoanStatus = ?1 where loanId = ?2")

boolean updateLoanStatus(String loanStatus, int loanId);

}

Java – JDBC 4 – Select Annotation Example

March 15, 2011 | By Prasanna Sherekar | Post comment

JDBC 4 Annotation Example using Select Query

Here’s an example of Select annotation to get all the active loans from the loan database:

interface LoanAppDetailsQuery extends BaseQuery {
    @Select("SELECT * FROM LoanDetais where LoanStatus = 'A'")
    DataSet<LoanApplication> getAllActiveLoans();
}

interface LoanAppDetailsQuery extends BaseQuery {

@Select("SELECT * FROM LoanDetais where LoanStatus = 'A'")

DataSet<LoanApplication> getAllActiveLoans();

}

The sql annotation allows I/O parameters as well (a parameter marker is represented with a question mark followed by an integer). Here’s an example of a parameterized sql query.

interface LoanAppDetailsQuery extends BaseQuery {
    @Select(sql="SELECT * from LoanDetails where borrowerFirstName= ?1 and borrowerLastName= ?2")
    DataSet<LoanApplication> getLoanDetailsByBorrowerName(String borrFirstName, String borrLastName);
}

interface LoanAppDetailsQuery extends BaseQuery {

@Select(sql="SELECT * from LoanDetails where borrowerFirstName= ?1 and borrowerLastName= ?2")

DataSet<LoanApplication> getLoanDetailsByBorrowerName(String borrFirstName, String borrLastName);

}

Java JDBC – Connect to PostgreSQL Database

August 1, 2010 | By Prasanna Sherekar | Post comment

Download PostgreSQL JDBC Driver:
http://jdbc.postgresql.org/download.html

Class.forName("org.postgresql.Driver");
Connection connection = null;
connection = DriverManager.getConnection("jdbc:postgresql://hostname:port/dbname", "username", "password");
connection.close();

Class.forName("org.postgresql.Driver");

Connection connection = null;

connection = DriverManager.getConnection("jdbc:postgresql://hostname:port/dbname", "username", "password");

connection.close();