Home > Database > Mysql Tutorial > mysql-[jbdc]打开 connection 空指针异常

mysql-[jbdc]打开 connection 空指针异常

WBOY
Release: 2016-06-06 09:32:59
Original
1317 people have browsed it

mysqljbdcjava异常

小白才开始学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";

<code>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();        }    }}</code>
Copy after login

}

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template