用什么语言? 连接数据库后直接用一条insert 语句就可以了。比如C#
//设计3个文本框
string devl_no=text1.text.tostring().trim();
string devl_name=text2.text.tostring().trim();
string devl_add=text3.text.tostring().trim();
//SQL 语句
string sql="insert into scott values('"+devl_no+"','"+devl_name+"','"+devl_add+"')";
//一系列连接数据库的语句
.....//执行SQL 语句
..
//设计3个文本框
string devl_no=text1.text.tostring().trim();
string devl_name=text2.text.tostring().trim();
string devl_add=text3.text.tostring().trim();
//SQL 语句
string sql="insert into scott values('"+devl_no+"','"+devl_name+"','"+devl_add+"')";
//一系列连接数据库的语句
.....//执行SQL 语句
..
(
i_dep_num in varchar2,
i_dep_name in varchar2,
i_dep_address in varchar2,
o_sretval out int
) ASBEGIN
INSERT INTO scott.dept (dep_num,dep_name,dep_address)
VALUES (i_dep_num,i_dep_name,i_dep_address);
EXCEPTION
WHEN OTHERS THEN
o_sretval := -1;
END;以上i_ KAI
(
i_dep_num in varchar2,
i_dep_name in varchar2,
i_dep_address in varchar2,) AS
v_sql varchar2(200);
BEGIN
v_sql:='INSERT INTO scott.dept (dep_num,dep_name,dep_address) VALUES(:p1,:p2,:p3) ';
execute immediate v_sql using i_dep_num,i_dep_name,i_dep_address;
END;