eclipse利用sql语句对Oracle数据库进行操作

对Oracle数据库执行操作的sql语句中表名和列名都需用英文双引号("")括起来。 

注(为转义符)

1.插入数据

sql = "insert into "table_name"("row_name1","row_name2")" values(?,?)";

2.删除数据

sql = "delete from "table_name" where "row_name" = ?";

3查找数据

sql = "select "row_name1","row_name2" from "table_name" where "row3" = ?";

4更改数据

sql = "update "table_name" set "row_name1" = ?, "row_name2" = ? where "row_name3" = ?";
原文地址:https://www.cnblogs.com/wei-jing/p/9541115.html