Pessoal… o que tem de errado:
package banco;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Conexao {
public static Connection getConnection() throws SQLException {
try {
Class.forName("org.postgresql.Driver");
System.out.println("Conectado ao Banco");
return DriverManager.getConnection("jdbc:postgresql://localhost:5432/teste","postgres","postgres");
}
catch (ClassNotFoundException e) {
throw new SQLException(e.getMessage());
}
}
}
package banco;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class teste {
/**
* @param args
*/
public static void main(String[] args) {
PreparedStatement ps = null;
String query = "SELECT nome from ln";
Connection con;
try {
con = Conexao.getConnection();
PreparedStatement stmt = con.prepareStatement(query);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
System.out.println("Teste"+rs.getString("nome"));
}
} catch (SQLException e) {
System.out.println("ERRO");
}
}
}Olha o erro q recebo:
Conectado ao Banco
Exception in thread “main” java.lang.NullPointerException
at banco.teste.main(teste.java:25)
Java Result: 1
Alguem pode me ajudar???
Obrigada
:lol:
