Fiz a cópia do meu projecto, apois cópiar e colar surgiu este erro:
ERRRRRRcom.microsoft.sqlserver.jdbc.SQLServerDriver
ERRRRRRcom.microsoft.sqlserver.jdbc.SQLServerDriver
Exception in thread “AWT-EventQueue-0” java.lang.NullPointerException
at ClienteLinkedServer.SQL.BuscaDeRegistos.buscarLocalizacoes(BuscaDeRegistos.java:224)
at ClienteLinkedServer.View.EncomendaNaoSatisfeitas.carregarLista(EncomendaNaoSatisfeitas.java:238)
at ClienteLinkedServer.View.EncomendaNaoSatisfeitas.formInternalFrameOpened(EncomendaNaoSatisfeitas.java:725)
at ClienteLinkedServer.View.EncomendaNaoSatisfeitas.access$000(EncomendaNaoSatisfeitas.java:30)
at ClienteLinkedServer.View.EncomendaNaoSatisfeitas$1.internalFrameOpened(EncomendaNaoSatisfeitas.java:305)
at javax.swing.JInternalFrame.fireInternalFrameEvent(JInternalFrame.java:1567)
at javax.swing.JInternalFrame.show(JInternalFrame.java:1743)
at java.awt.Component.show(Component.java:1671)
at java.awt.Component.setVisible(Component.java:1623)
at javax.swing.JComponent.setVisible(JComponent.java:2644)
at ClienteLinkedServer.View.EncomendaNaoSatisfeitas$16.run(EncomendaNaoSatisfeitas.java:836)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
BUILD SUCCESSFUL (total time: 2 seconds)
package ClienteLinkedServer.SQL;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Conectar {
private static final String URL = "jdbc:sqlserver://localhost:1433;databaseName=PROJECTOD;user=cawende;password=vivi";
public static Connection getConnection() {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
return DriverManager.getConnection(URL);
} catch (Exception ex) {
System.out.println("ERRRRRR"+ex.getMessage());
}
return null;
}
public static void closseConnection (Connection con){
if(con!=null){
try {
con.close();
} catch (SQLException ex) {
System.err.println("Erro de sessão"+ex);
}
}
}
public static void closseConnection (Connection con,PreparedStatement stmt ){
if(stmt!=null){
try {
stmt.close();
} catch (SQLException ex) {
System.err.println("Erro de sessão"+ex);
}
}
closseConnection(con);
}
public static void closeConnection (Connection con,PreparedStatement stmt, ResultSet rs ){
if(rs!=null){
try {
rs.close();
} catch (SQLException ex) {
System.err.println("Erro de sessão"+ex);
}
}
closseConnection(con, stmt);
}
}