import java.sql.*;
...
...
Connection conn = null;
try
{
Class.forName("DRIVER");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
try
{
conn = DriverManager.getConnection("jdbc database", "user", "password");
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("QUERY");
while(rset.next())
{
// do something
}
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
if(conn != null)
{
try
{
conn.close();
conn = null;
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}
...
...
DAOData Access Object
DTOData Transfer Object
-