posted 22 years ago
This is Stored Procedure for EMPID
Stored procedure Name : INSERT_PROCEDURE
EMPID SEQUENCE NAME : EMPSEQ
IN PARAMETERS : ALL PARAMETER EXCEPT EMPID
OUT PARAMETER : EMPID (U CAN GET THE EMPID AFTER INSERTING THE DATA INTO DATABASE)
CREATE OR REPLACE PROCEDURE INSERT_PROCEDURE(
NAME VARCHAR2(100),
CREATEDBY VARCHAR2(20),
EMPID OUT NUMBER) AS
BEGIN
SELECT EMPSEQ.NEXTVAL INTO EMPID FROM DUAL;
INSERT INTO EMP VALUES(EMPID,NAME,SHORTDESC,SUPERUSERFL,CREATEDBY,
MODIFIEDBY,CREATIONDATE,MODIFIEDDATE );
COMMIT;
END;
-----------------------------------------------------
//This normal bean or accessor class
class EmpTB{
//setXXX()....
//getXXX()...
}
//This is main class
class MainClass{
.......
public long insert(EmpTB myrecord)throws CreateException {
CreateException ce = null;
Connection dbConnection=null;
ResultSet rs=null;
CallableStatement cstmt=null;
long empId=0
try {
dbConnection = getConnection();
strQry="{call INSERT_PROCEDURE(?, ?, ? , ? )}";
cstmt = dbConnection.prepareCall(strQry);
cstmt.setString(1,myrecord.getName());
cstmt.setString(2,myrecord.getCreatedBy());
cstmt.setString(3,myrecord.getModifiedBy());
cstmt.registerOutParameter(4,java.sql.Types.NUMERIC);
int i=cstmt.executeUpdate();
if(i!=0)
{
//throw exception
}
empId=cstmt.getLong(8);
} catch(SQLException se) {
throw new CreateException(se.getMessage());
} finally {
try {
if( cstmt !=null) cstmt.close();
if (dbConnection != null ) dbConnection.close();
} catch (Exception e) {
throw new CreateException(e.getMessage());
}
return empId;
}
}//EOF INSERT
....
}
[This message has been edited by DAYANAND BURAMSHETTY (edited August 07, 2001).]
Dil se....,<BR>Dayanand<BR>0065-8839071(off)<BR>0065-7547034(Res0