具体情况如图所示
已导入jar包
代码如下
public class DBUtil {
private static final String url="jdbc:Oracle:thin:@localhost:1521:od";
private static final String user="system";
private static final String password="yzj9454";
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//加载驱动程序
Class.forName("oracle.jdbc.driver.OracleDriver");
//获得数据库的连接
Connection conn =DriverManager.getConnection(url, user, password);
//通过数据库的连接操作数据库
Statement stmt = conn.createStatement();
ResultSet rs= stmt.executeQuery("select USER_NAME from imooc_goddess ");
while(rs.next()){
System.out.println(rs.getString("USER_NAME"));
}
}
}