Im developing an application which has to upload files within a folder in the server. I'm planning to use UploadBean V1.6 for uploading the file.
Actually the Interface is like this, it has FileID,FileName,FileExt,DateOfCreation,Keywords(Metadata),Source,DeptID,DeptName,Path. When a user wants to upload a file into the server, he need to pick the file..that is the source. Im maintaining these information about the file that is FileID,FileName..in the database..when the user select the file to be Uploaded the File properties like the FileName,FileID...should be generated at should be displayed for the user..On pressing the Upload button the file should be put into the server and the file properties should be inserted into the database..
Im doing this in Servlet and the client side script HTML.
Can anyone tell me how to generate the FIleID( which need to be display the one number grater than the last fileID value in the database) and Current date.
Can anyone help me with the code to perform this operation..
THis is my final sem project, the project submission date is very near.
What database are you using? Different databases have different methods to sequentially increment a field. MS SQL Server and MySql have sequential fields whereas Oracle uses a special sequence structure. As for determining the current date: