[jbdc]打开 connection 空指针异常

Question

小白才开始学JBDC 这是网上照着写的代码……
出现了

Exception in thread "main" java.lang.NullPointerException
at FirstExample.main(FirstExample.java:23)

空指针异常
但是不知道怎么改，求解。谢谢了

import java.sql.*;
public class FirstExample {
//JDBC driver name and databaase URL
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://localhost/EMP";

//Database credentials
static final String USER = "root";
static final String PASS = "2573718";

public static void main(String args[]) throws ClassNotFoundException{
    Connection conn = null;
    Statement stmt = null;
    try{
        //注册 JDBC driver
        Class.forName("com.mysql.jdbc.Driver");

        //打开 a connection
        System.out.println("Connecting to database..");
        stmt = conn.createStatement();
        String sql;
        sql= "SELECT s_no  FROM student";
        ResultSet rs = stmt.executeQuery(sql);

        //插入数据
        while(rs.next())
        {
            int no = rs.getInt("s_no");
            String name = rs.getString("s_name");

            System.out.println("NO"+no);
            System.out.println("Name"+name);
        }
        rs.close();
        stmt.close();
        conn.close();
    }
    catch(SQLException se){
        se.printStackTrace();
    }
    finally{
        try{
            if(stmt!=null)
                stmt.close();
            }
        catch(SQLException se2){

        }
        try{
            if(conn!=null)
                conn.close();
        }
        catch(SQLException se){
            se.printStackTrace();
        }
    }
}

}

Answer 1

你的数据库可能有问题，里边的字符不对