网上找了很多资料
1.将D:/oracle/ora90/jdbc/lib下的classes12.jar拷贝到自己所在工程的WEB-INF/lib下
2.
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>连接oracle</title>
</head>
<body>
<%
Connection conn=null; //加载数据库驱动
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();//数据库连接url
String url="jdbc:oracle:thin:@localhost:1521:zw"; //数据库用户名
String user="zw"; //用户名
String password="821023"; //密码
conn=DriverManager.getConnection(url,user,password);
//out.println("ok");
//out.println(conn.toString());
%>
</body>
</html>
3,数据库删除
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>连接oracle</title>
</head>
<body>
<%
Connection conn=null; //加载数据库驱动
Statement stat=null;
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();//数据库连接url
String url="jdbc:oracle:thin:@localhost:1521:zw"; //数据库用户名
String user="zw"; //用户名
String password="821023"; //密码
conn=DriverManager.getConnection(url,user,password);
//out.println("ok");
//out.println(conn.toString());
stat=conn.createStatement();
String sql="delete from test where id='2'";
try{
int count =stat.executeUpdate(sql);
out.println("删除了"+count+"条记录");
}catch(Exception ex)
{
out.println("出错!");
System.out.println(ex.getMessage());
}
//资源释放
if (stat!=null)
{
stat.close();
}
if (conn!=null)
{
conn.close();
}
%>
</body>
</html>
4,显示表中所有内容
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>连接oracle</title>
</head>
<body>
<%
Connection conn=null; //加载数据库驱动
Statement stat=null;
ResultSet rs=null;
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();//数据库连接url
String url="jdbc:oracle:thin:@localhost:1521:zw"; //数据库用户名
String user="zw"; //用户名
String password="821023"; //密码
conn=DriverManager.getConnection(url,user,password);
//out.println("ok");
//out.println(conn.toString());
stat=conn.createStatement();
String sql="select * from test";
rs=stat.executeQuery(sql);
%>
<table width="260" cellSpacing="0" height="12" style="font-size:12pt;border:1pt">
<tr style="border:soild 1pt">
<td style="border:soild 1pt">编号</td>
<td style="border:soild 1pt">姓名</td>
<%
while(rs.next())
{
out.println("<tr style='border:soild 1pt'>");
out.println("<td style='border:soild 1pt'>"+rs.getInt("id")+"</td>");
out.println("<td style='border:soild 1pt'>"+rs.getString("name")+"</td>");
out.println("</tr>");
}
//资源释放
if (stat!=null)
{
stat.close();
}
if (conn!=null)
{
conn.close();
}
%>
</table>
</body>
</html>