如何用jsp连接oracle数据库

2025-02-05 18:08:45
推荐回答(1个)
回答1:

<%

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery("select * from emp");

%>



<% while(rs.next()){ %>











<% } %>

<%=rs.getString(1)%> <%=rs.getString(2)%> <%=rs.getString(3)%>