Friday, March 28, 2014

Date Query Run in toad tools

N.B: Only Date query run
Sql java file ://query = "insert into teacher_personal_info(TEACHER_ID,TEACHER_NAME,DESIGNATION,MPO_ID,GENDER,DOB,HOME_DISTRICT,NATIONALITY,RELIGION,MARITAL_STATUS) values ('"+teacher_id+"','"+teacherName+"','"+designation+"','"+mpoIndex+"','"+statusValA+"','"+dob+"','"+homeDistrict+"')";      

insert into teacher_personal_info(TEACHER_ID,TEACHER_NAME,DESIGNATION,MPO_ID,GENDER,DOB,HOME_DISTRICT,NATIONALITY,RELIGION,MARITAL_STATUS) values ('P011403000022','My ','108','3','F','01/01/2000','29','1','1','Un')



outPut: This query is not run because database DOB coloumn name is Date not varchar, if it is varchar then no problem.
As only database coloumn name is Date , so sql java file date(dob) variable is
Sql java file ://query = "insert into teacher_personal_info(TEACHER_ID,TEACHER_NAME,DESIGNATION,MPO_ID,GENDER,DOB,HOME_DISTRICT,NATIONALITY,RELIGION,MARITAL_STATUS) values ('"+teacher_id+"','"+teacherName+"','"+designation+"','"+mpoIndex+"','"+statusValA+"',TO_DATE('"+dob+"','dd/MM/yyyy'),'"+homeDistrict+"')";

insert into teacher_personal_info(TEACHER_ID,TEACHER_NAME,DESIGNATION,MPO_ID,GENDER,DOB,HOME_DISTRICT) values ('P011403000023','My name','108','123','M',TO_DATE('01/01/1983','dd/MM/yyyy'),'18')    
 
So this  situation '"+dob+"' = TO_DATE('"+dob+"','dd/MM/yyyy')


N.B: Although jsp age , java action class and sql file dob is declare As string .insert situation
 Direct save path : jsp page -> Java action class -> java sql class file through database

No comments:

Post a Comment