Statement st1=con.createStatement(); String sql="insert into employee values(emp_seq.nextval,'"+ename+"','"+eadd+"','"+ephone+"','"+email+"','"+department+"',"+Integer.parseInt(ebpay)+",20,0)";
-- hello sir,
This is the code i have in which i enter all d values except EID which is generated sequentially. But what i need is, the EID sequence number must be generated according to the department, i.e if department is CSE, the EID series must start with 10KT1 , and if the department is IT the eid sequence must start with 12GT1...
Thanq in advance..
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.