我是在oracle11g 配置
先把数据库的驱动程序放在lib包下
代码配置如下
<welcome-file>index.html</welcome-file>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<context-param>
<param-name>driver</param-name>
<param-value>oracle.jdbc.driver.OracleDriver</param-value>
</context-param>
<context-param>
<param-name>url</param-name>
<param-value>jdbc:oracle:thin:@localhost:1521:orcl</param-value>
</context-param>
<context-param>
<param-name>user</param-name>
<param-value>scott</param-value>
</context-param>
<context-param>
<param-name>password</param-name>
<param-value>root</param-value>
</context-param>
jsp代码如下
<%@ page contentType="text/html; charset=UTF-8" language="java" errorPage="" %>
<%@ page import="java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<title>Web_param</title>
</head>
<body>
<%
String DBDRIVER=application.getInitParameter("driver");
String DBURL=application.getInitParameter("url");
String DBUSER=application.getInitParameter("user");
String DBPASS=application.getInitParameter("password");
String sql="select * from emp";
%>
<%
Class.forName(DBDRIVER);
Connection conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
PreparedStatement pstmt=conn.prepareStatement(sql);
ResultSet rs=pstmt.executeQuery();
while(rs.next()){
out.println(rs.getString(2)+"<br>");
}
%>
<!--PreparedStatement prepareStatement 注意大小写-->
<%conn.close();%>
</body>
</html>