createStatement上的Java NullPointerException

Question

Possible Duplicate:
What can I do to avoid a NullPointerException?

我正在为一家餐馆开发一个应用程序。当我尝试初始化某个类时会发生错误。这是代码

public class DbItem {

private static Connection conn = null;

static {
    conn = DBConnection.connect();
}
public static ArrayList<Item> fetchAll() {
    ArrayList<Item> items = new ArrayList<>();
    String sql = "select * from itens";
    try {
        Statement st = conn.createStatement();
        ResultSet rs = st.executeQuery(sql);
        while(rs.next()) {
            items.add(new Item(rs.getString("nome"), rs.getString("descricao"), rs.getFloat("preco")));
        }
        return items;
    } catch (SQLException ex) {
        Logger.getLogger(DbItem.class.getName()).log(Level.SEVERE, null, ex);
    }
    return null;
}
}

该连接取自该类

public class DBConnection {

private static Connection conn;

public static Connection connect() {
    if(conn == null) {
        String url = "jdbc:mysql://localhost:3306/";
        String dbName = "restaurante_comandas_jonnathan";
        String driver = "com.mysql.jdbc.Driver";
        String userName = "root";
        String password = "root";
        try {
            Class.forName(driver).newInstance();
            conn = DriverManager.getConnection(url + dbName, userName, password);
            System.out.println("Connected to " + dbName + " with " + userName);
            JOptionPane.showMessageDialog(null, conn == null);
            return conn;
        } catch (ClassNotFoundException | InstantiationException | IllegalAccessException | SQLException e) {
            e.printStackTrace();
        }
    }
    return null;
}

}

我尝试使用弹出框进行调试。我在返回命令之前检查了连接是否为null，发现不是。然后，在调用第一个脚本之后，我检查了一下，发现它确实是空的。现在，如果一个对象不是在返回之前，那么它在检索之后怎么可能是空的呢

编辑：

给你。堆栈跟踪

Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at model.data.DbItem.fetchAll(DbItem.java:48)
at model.Item.getAll(Item.java:76)
at view.PedidoForm.<init>(PedidoForm.java:22)
at view.Login$2.run(Login.java:99)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:251)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:721)
at java.awt.EventQueue.access$200(EventQueue.java:103)
at java.awt.EventQueue$3.run(EventQueue.java:682)
at java.awt.EventQueue$3.run(EventQueue.java:680)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:691)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

Answer 1

我已经修改了你的代码并做了一些更改。请试试这个

public class DBConnection {

private static Connection conn;

public static Connection connect() {
    if(conn == null) {
    String url = "jdbc:mysql://localhost:3306/";
    String dbName = "restaurante_comandas_jonnathan";
    String driver = "com.mysql.jdbc.Driver";
    String userName = "root";
    String password = "root";
    try {
        Class.forName(driver).newInstance();
        conn = DriverManager.getConnection(url + dbName, userName, password);
        System.out.println("Connected to " + dbName + " with " + userName);
        JOptionPane.showMessageDialog(null, conn == null);            
    } catch (ClassNotFoundException | InstantiationException | IllegalAccessException | SQLException e) {
        e.printStackTrace();
    }
}
return conn;
}

}