set IDENTITY_INSERT [表名] on --打开 set IDENTITY_INSERT [表名] off --关闭
加上具体的字段名 可行set IDENTITY_INSERT textA on go insert into textA(test,tname) values(100,'30') go set IDENTITY_INSERT textA off go不可行set IDENTITY_INSERT textA on go insert into textA values(100,'30') go set IDENTITY_INSERT textA off go
} }/*下面是pp存储过程的书写格式,目的是根据名字修改年龄。 create procedure pp (vage number,vname varchar2) is begin update test set age=vage where name=vname; end; *//*下面是表的结构 create table TEST ( AGE NUMBER, NAME VARCHAR2(90) );
set IDENTITY_INSERT [表名] on --打开
set IDENTITY_INSERT [表名] off --关闭
go
insert into textA(test,tname) values(100,'30')
go
set IDENTITY_INSERT textA off
go不可行set IDENTITY_INSERT textA on
go
insert into textA values(100,'30')
go
set IDENTITY_INSERT textA off
go
我是在后台用JDBC语句添加的!!!!
import java.sql.*;public class TestKuai {
public static void main(String[] args){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");
//下面的意思要调用那个存储过程,存储过程名字是PP;
CallableStatement cs =conn.prepareCall("{call pp(?,?)}");
// 下面是对表的修改
cs.setInt(1, 5);
cs.setString(2, "jack");
//执行存储过程
cs.execute();
cs.close();
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}/*下面是pp存储过程的书写格式,目的是根据名字修改年龄。
create procedure pp (vage number,vname varchar2) is
begin
update test set age=vage where name=vname;
end;
*//*下面是表的结构
create table TEST
(
AGE NUMBER,
NAME VARCHAR2(90)
);