求牛人帮忙,java连接oracle数据库
驱动已经加载,我在catch里写的是e.getMessage()
网页中的错误时 ORACLE URL
小弟刚学,请高手耐心指教 谢谢!
代码如下:
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@page import="oracle.jdbc.OracleDriver"%>
<html>
<head>
<title>dbaccess.jsp</title>
</head>
<body>
<%
try{
Connection con;
Statement stmt;
ResultSet rs;
//加载驱动器
Class.forName("oracle.jdbc.driver.OracleDriver");
//注册驱动器
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//连接数据库
String dbUrl="jdbc:oracle:thin@localhost:1521:orcl";
String dbUser="text";
String dbPwd="text";
con= DriverManager.getConnection(dbUrl,dbUser,dbPwd);
stmt=con.createStatement();//创建一个sql声明
stmt.executeUpdate("insert into BOOKS(ID,NAME,TITLE,PRICE) values('999','tom','tomcat',44.5)");
rs=stmt.executeQuery("select Id,NAME,TITLE,PRICE from BOOKS");
out.println("<table border=1 width=400>");
while(rs.next()){
String col1=rs.getString(1);
String col2=rs.getString(2);
String col3=rs.getString(3);
float col4=rs.getFloat(4);
out.println("<tr><td>"+col1+"</td><td>"+col2+"</td><td>"+col3+"</td><td>"+col4+"</td></tr>");
}
out.println("</table>");
stmt.executeUpdate("delete from BOOKS where ID='999'");
rs.close();
stmt.close();
con.close();
}catch(Exception ee){
out.println(ee.getMessage());
}
%>
</body>
</html>