=======oracle 表 sql
CREATE TABLE "SMALL19RAIN"."R_TABLE_STU"
( "NAME" VARCHAR2(200 BYTE),
"AGE" NUMBER,
"STU_ID" NUMBER NOT NULL ENABLE,
"DATARAIN" VARCHAR2(200 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SMALLRAIN19TABLESPACE" ;
=======Java 代码
package org.rain.db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class SmallRainDBUpdate {
public static void main(String[] args) {
Connection smallrainConn = null;
Statement smallrainStmt = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
smallrainConn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "smallrain123456789",
"Xiaoyu123456789");
smallrainStmt = smallrainConn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet smallRainResultSet = smallrainStmt.executeQuery("SELECT STU_ID, AGE, NAME FROM R_TABLE_STU");
if (smallRainResultSet.next()) {
smallRainResultSet.updateString("NAME", "rain更新");
smallRainResultSet.updateInt("AGE", 56);
smallRainResultSet.updateRow();
System.out.println("数据更新成功");
}
} catch (Exception e) {
System.out.println("SQL出错");
} finally {
if (null != smallrainStmt) {
try {
smallrainStmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (null != smallrainConn) {
try {
smallrainConn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}