JSP 连接Oracle数据库

<%@ page import="java.sql.*" %>

<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
     String url="jdbc:oracle:thin:@localhost:1521:ly";
     String user="tggis";
     String password="tggis";
     Connection conn= DriverManager.getConnection(url,user,password);
     Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
     String sql="select * from DD";
     ResultSet rs=stmt.executeQuery(sql);
     while(rs.next()){%>
     <%=rs.getString(1) %>
     <%}%>
    <%System.out.println("数据库操作成功！");
      rs.close();
      stmt.close();
      conn.close();
    %>