怎样向oracle数据库中插入数据？

jancky2001 2001-11-14 03:07:37

...全文

116 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

zero_wgh 2001-11-15

打赏
举报

imp

fanshaorong 2001-11-15

打赏
举报

如果您想在服务端插入的话，请使用JDBC的本地方法
若是远程插入的话，最好使用RMI

caolyf 2001-11-14

打赏
举报

<%@ page contentType="text/html; charset=gb2312" %>
<html>
<title>测试</title>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn =DriverManager.getConnection("jdbc:oracle:thin:@10.234.0.4:1521:ORCL","user","pass");
PreparedStatement pstmt =
conn.prepareStatement ("insert into oratest (NAME, AGE) values (?, ?)");

pstmt.setString (1, "两个笨蛋");
pstmt.setInt (2, 2);
pstmt.execute ();

pstmt.setString (1, "preting");
pstmt.setInt (2, 6);
pstmt.execute ();

pstmt.close();
conn.close();
out.println("新增成功");
%>
</html>