连接oracle数据库空指针异常,jdbc 连接Oracle 报空指针错误

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class JdbcBasicTwo {

private static String driver = "oracle.jdbc.driver.OracleDriver";

private static String url = "jdbc:oracle:thin:@localhost:1521:XE";

private static String user = "wang";

private static String password = "wang";

public static void main(String[] args) {

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

try {

//1.注册驱动

System.setProperty("jdbc.drivers", driver);

//2.获取连接

conn = DriverManager.getConnection(url, user, password);

//3.获取statement

stmt = conn.createStatement();

String sql = "select * from t_clazz";

//4.执行

rs = stmt.executeQuery(sql);

//5.处理结果集

while(rs.next()){

Long id = rs.getLong("id");

String name = rs.getString(1);

System.out.println(id+"--"+name);

}

} catch (Exception e) {

e.printStackTrace();

}finally{

//6.释放资源

try {

if(rs!=null){

rs.close();

}

if(stmt!=null){

stmt.close();

}

if(conn!=null){

conn.close();

}

} catch (Exception e2) {

}

}

}

}