注释:本次用jsp连接ORACLE数据库,以查询scott表中的部分数据并以表格形式在网页显示为例
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>员工信息</title>
</head>
<body>
<table width="90%" border="1px">
<tr>
<td>员工编号</td>
<td>员工姓名</td>
<td>员工工资</td>
<td>所在部门</td>
</tr>
<%
//导包
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//建立连接
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL","scott","a");
//创建执行语块
String sql="select * from emp e,dept d where e.deptno=d.deptno";
PreparedStatement pstmt=con.prepareStatement(sql);
//执行并获取结果或结果集
ResultSet rs=pstmt.executeQuery();
while(rs.next()){
%>
<tr>
<td><%=rs.getString("empno") %></td>
<td><%=rs.getString("ename") %></td>
<td><%=rs.getString("sal") %></td>
<td><%=rs.getString("dname") %></td>
</tr>
<%
}
%>
</table>
</body>
</html>
结果:
注:详细操作见注释,和之前在java中连接数据库步骤一样