Hi, I am implenting a project on Library Management System(Web application). I have a form as New User Registration Form in which user enters his/her information.There is one field as DateOfBirth which takes input as string(i.e date of birth of the user).Now I am extracting this inputs in Servlet. My aim is to insert these inputs in a user table.I am using SQL Server 2000. I am using Prepared Statement for Insert query.I convert the date of birth which is in string to java.sql.Date object using the following code:-
The JDBC/ODBC driver does not provide a complete set of JDBC 2.0 features so this example must result in a call that is not supported in the driver. You could try using the Microsoft JDBC driver or the JDTS driver. They should provide better performance as well.
Hi, Thankyou for your replies.Now the problem is solved.Now i am using different Driver i.e sql driver(Type4).Now again some problems comes out.When the user enter Date in String form ,i convert that date in java.sql.date using the following function: