Advertisement
Guest User

Untitled

a guest
Aug 8th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. <%@page import="java.sql.*" %>
  2. <%
  3. try
  4. {
  5. Class.forName("oracle.jdbc.driver.OracleDriver");
  6. Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott", "tiger");
  7. PreparedStatement ps=con.prepareStatement("select * from studinfo");
  8. ResultSet rs=ps.executeQuery();
  9. while(rs.next())
  10. out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3));
  11. con.close();
  12. }
  13. catch(Exception e)
  14. {
  15. e.printStackTrace();
  16. }
  17. %>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement