import java.sql.*;
public class ConectaBD {

private static String drivername, servername, banco, url, username, password; private static Connection connection = null;
private static Statement meustate; // conexão com a tabela do banco de dados

public static boolean conectar () {
try {
// Criando a conexão com o banco de dados bdteste
drivername = "org.postgresql.Driver";
Class.forName(drivername); servername = "localhost";
banco = "teste";
url="jdbc:postgresql://localhost:5432/teste";
username = "postgres"; password = "";

// Conexão com o banco de dados connection = DriverManager.getConnection(url,username,password);
// Tabelas e registros de cada tabela
meustate = connection.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
}
catch(ClassNotFoundException e) { }
catch(SQLException e) { }

return true;
} // Fecha o método conexão

public static Statement getMeuState () {
return meustate;
}

public static void fecharconexao () {
try {
connection.close();
}
catch (SQLException e) { }

}

} // fecha a Classe ConectaBD