import java.sql.*;
public class DisplayAuthors {
static final String JDBC_DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
static final String DATABASE_URL ="jdbc:sqlserver://PIU-LAB/Acervo";
public static void main(String args[]){
Connection connection = null;
Statement statement = null;
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
connection =
DriverManager.getConnection("jdbc:sqlserver://PIU-LAB:1433/Acervo","","");
statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("select * from TblTitulo");
ResultSetMetaData metaData = resultSet.getMetaData();
int numberOfColumns = metaData.getColumnCount();
System.out.println("Deu certo");
for(int i =1; i<=numberOfColumns;i++ )
System.out.printf("%-8s\t",metaData.getColumnName(i));
System.out.println("Falou");
while(resultSet.next()){
for(int i =1;i<=numberOfColumns;i++)
System.out.printf("%-8s\t",resultSet.getObject(i));
System.out.println("Falou");
}
}
catch(SQLException sqlException){
sqlException.printStackTrace();
System.exit(1);
}
catch(ClassNotFoundException classNotFound){
classNotFound.printStackTrace();
System.exit(1);
}
finally{
try{
statement.close();
connection.close();
}
catch(Exception exception){
exception.printStackTrace();
System.exit(1);
}
}
}
}
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at DisplayAuthors.main(DisplayAuthors.java:20)
Process completed.