Conversion of data type from MySql to JSP

[jith87]

My proj involves JSP @ front end n MySql @ back end and connectivity is established thru JDBC. The thing is when i store values from the front end into the db i need to change the data types n vice versa.Consider ths.

I m retrieving date from the db thru the result set i m traversing thru each n every record(next() function is used).

String d1 = rs.getString(2) ;System.out.pri ntln("Date="+da te);

How do i convert the date field into a java.sq.Date value such dat it can be retrieved back @ front end? If i directly the variable d1(mentioned above) as java.sql.Date then there is arises compatibility error....

Help me pls..........

[madhoriya22]

My proj involves JSP @ front end n MySql @ back end and connectivity is established thru JDBC. The thing is when i store values from the front end into the db i need to change the data types n vice versa.Consider ths.

I m retrieving date from the db thru the result set i m traversing thru each n every record(next() function is used).

String d1 = rs.getString(2) ;System.out.pri ntln("Date="+da te);

How do i convert the date field into a java.sq.Date value such dat it can be retrieved back @ front end? If i directly the variable d1(mentioned above) as java.sql.Date then there is arises compatibility error....

Help me pls..........

Hi,
Can u make urself more clear? when do you want to convert the date :
1. while sending date from jsp to mysql or
2. while getting date from db and sending it to jsp.

[jith87]

Hi,
Can u make urself more clear? when do you want to convert the date :
1. while sending date from jsp to mysql or
2. while getting date from db and sending it to jsp.

while getting date from db and sending it to jsp

[madhoriya22]

while getting date from db and sending it to jsp

Hi,
then db itself retunrs date in sql format, isn't it ?

[dmjpro]

My proj involves JSP @ front end n MySql @ back end and connectivity is established thru JDBC. The thing is when i store values from the front end into the db i need to change the data types n vice versa.Consider ths.

I m retrieving date from the db thru the result set i m traversing thru each n every record(next() function is used).

String d1 = rs.getString(2) ;System.out.pri ntln("Date="+da te);

How do i convert the date field into a java.sq.Date value such dat it can be retrieved back @ front end? If i directly the variable d1(mentioned above) as java.sql.Date then there is arises compatibility error....

Help me pls..........

Have a look at this Code.

[code=java]
Calendar c = new GregorianCalend ar();
c.setTime(rs.ge tDate(2));
int day = c.get(Calendar. DATE);
int month = c.get(Calendar. MONTH);
int year = c.get(Calendar. YEAR);
String date_str = ""+day+"/"+month+"/"+year;
[/code]

Are you looking for this?
Then go and enjoy with this code.
Good Luck!

Kind regards,
Dmjpro.

[jith87]

Hi,
then db itself retunrs date in sql format, isn't it ?

Yes bt i wanna convert the sql format date to java compatible date format. Wht to do for that?

[dmjpro]

Yes bt i wanna convert the sql format date to java compatible date format. Wht to do for that?

Have a look at my Code.
Then you will understand by yourself.

Kind regards,
Dmjpro.

[jith87]

Have a look at my Code.
Then you will understand by yourself.

Kind regards,
Dmjpro.

date_rs_test.ja va:36: cannot find symbol
symbol : variable Calendar

ths s the error dat i got....

[r035198x]

date_rs_test.ja va:36: cannot find symbol
symbol : variable Calendar

ths s the error dat i got....

Open the API docs for ResultSet and you will see that there is a getDate method.

[dmjpro]

date_rs_test.ja va:36: cannot find symbol
symbol : variable Calendar

ths s the error dat i got....

[code=java]
import java.util.*;
[/code]

Kind regards,
Dmjpro.