Aula BD 16/02/2009 - Tutorial JDBC (rascunho)

Tutorial JDBC

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TutorialJDBC {
public static void main(String[] args) {
Connection conn = null;
try {
Class.forName("org.postgresql.Driver");
conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/jdbc", "postgres", "database");
Statement st = conn.createStatement();
// String sql = "INSERT INTO aluno (id, nome) values (2, 'luis')";
// st.executeUpdate(sql);
String sql = "SELECT * FROM aluno";
ResultSet resultSet = st.executeQuery(sql);
while (resultSet.next()){
System.out.println("Id: " + resultSet.getInt("id"));
System.out.println("Nome: " + resultSet.getString("nome"));
}
st.close();
System.out.println("Tudo certo!");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally {
if (conn != null) {
try {
conn.close();
}
catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
}