database connectivity using jsp code

i have two tables employee and adduser insert into adduser(Emp_Id,Ename,Designation,Password,ReTypePassword)values('6867678po',(select Ename from employee),(select Designation from employee),'bbbb','bbbb'); so this syntax is possible to use in jsp code

based on employee id ename and designation are displayed how it is possible in jsp

employee->(Ename varchar(30),Address varchar(256),Designation varchar(32),DateOfJoining date,ContactNumber numeric(12),PANNumbernumeric(15),Emp_Id varchar(50) primary key)this is employee table schema in mysql adduser->(Emp_ID varchar(50),Ename varchar(30),Designation varchar(32),Password varchar(10),ReTypePassword varchar(10)) this is adduser table schema in mysql