Tamamlanmış

Web based JSP program to run SQL queries & manage a database

Need a reliable JSP and Javascript developer to develop web based JSP programs to help us managing a database. The database is built with SQLite 3. The JSP programs will be run under Jetty. The deliverables should be in WAR format. The layout of the webpage is shown in the attached file.

Below are the requirements:

(1) Run Analysis - The JSP programs should allow a user to select and run a SQL statement with a time period option. Then retrieve the records. The records are then shown in a table, a bar chart and a line chart. The attached picture is the expected result. The charts should be created on the fly by using any jQuery library.

(2) Manage Analysis - The JSP programs should allow a user to add, edit, delete SQL statements that are shown in (1). The SQL statements should be stored in a separate table in the SQLite database.

(3) Import data - everyday, many new files (0 to thousands files) with the same CSV format are created in a directory by other programs. Each file contains 0 to thousands of line (each line is a record). The JSP program should:

a.) When a user imports files, records of the new files will be stored into the SQLite database.

b.) If a user tries to import a file more than once on the same day, there is no record to be stored into the SQLite database because the records have already been imported. Please do not use SQL to restrict the import. Should use JSP. This is because contents of records may be identical.

c.) If a user has not imported files for some time, the JSP program should be able to import all the files that are not imported yet.

d.) If there is no database available, the JSP program will create the database.

(4) Submit data – The JSP program should email (SMTP with and without SSL) and upload records (HTTP and HTTPS) retrieved from running SQL statements to an email address and to another URL address. A user will preview the records before emailing and uploading the results. The user has the choice not to email and upload one or more particular records.

(5) Move data - as number of files will keep increasing, the JSP program should move the files to other directories for backup and easy management purpose every month. The naming conventions of the backup directories should be “<MONTH>-<YEAR>”, like “07-2011”. The SQLite database file should be backuped every month and store under the backup directories.

(6) Settings – The JSP program should allow a user to edit the parameters of the programs. The parameters are stored in a table in the SQLlite database. The parameters are:

a.) database path - the full path of the SQLite database

b.) directory (as described in 3) - where the new files are stored.

c.) email (as described in 4)

d.) URL (as described in 4)

e.) backup directory (as described in 5) - where the backup directories are.

Milestones will be created for:

a.) 25% of the payment - Successful demonstration on developer’s or employer’s Jetty server for (1), (2), and (3).

b.) 25% of the payment - Successful demonstration on developer’s or employer’s Jetty server for (4), (5), and (6).

c.) 50% of the payment - Delivery of the WAR file and all source code.

ALL RIGHTS CREATED AND DEVELOPED UNDER THIS PROJECT BELONG TO THE EMPLOYER. THE DEVELOPER AGREES TO TRANSFER AND ASSIGN ALL RIGHTS IN THIS PROJECT TO THE EMPLOYER. THE DEVELOPER AGREES TO WAIVE MORAL RIGHTS.

Please do not bid unless you understand fully about the requirements. Please feel free to message me if you have any questions.

Beceriler: Java, Javascript, JSP, SQL, Web Sitesi Tasarımı

Daha fazlasını gör: web based database jsp, jsp sql manage, jsp database program, manage database file jsp project, web source format, web programs, web developer programs, web developer path, web developer on line, web developer free, web developer directory, web based programs, web 2 programs, tries in java, table in web developer, successful web developer, run javascript, programs new web, need java developer for a project, need free web developer

İşveren Hakkında:
( 16 değerlendirme ) Hong Kong, Hong Kong

Proje NO: #1171430

Seçilen:

biso

Please check your PM

%selectedBids___i_period_sub_7% gün içinde 1600%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(1 Yorum)
2.6

Bu iş için 14 freelancer ortalamada $2997 teklif veriyor

eperfections

We have 10+ years experience in JSP Web application development ! Please check PMB for references !

$3456 HKD in 15 gün içinde
(340 Değerlendirme)
7.2
IMSeriousBidder

Hello, I am JSP&Javascript developer, please check your pm Thanks

$3800 HKD in 12 gün içinde
(59 Değerlendirme)
6.7
AshwinSen

Hello, Please view PMB. Ashwin

$4000 HKD in 15 gün içinde
(42 Değerlendirme)
5.7
csanuragjain

Hi I can do the [login to view URL] with all condtions of [login to view URL] to start [login to view URL] me if you are intrested

$1600 HKD in 15 gün içinde
(25 Değerlendirme)
5.2
madhavan03

I am very good expertise in Java technologies but new to freelancer. I can finish this project efficiently

$3600 HKD in 15 gün içinde
(5 Değerlendirme)
3.5
urssoulmate

Dear Sir/Madam I have gone through the requirement. And I am having 3 yrs of java j2ee development exp and i am SCWCD certified. Looking for your Positive response. Thanks and Regards

$4000 HKD in 30 gün içinde
(6 Değerlendirme)
3.0
souvikbasu00

We would love to work for you and believe we will be able to deliver as per your requirement and expectations. Eagerly looking forward to do business with you. Please visit PM for details about us.

$4000 HKD in 30 gün içinde
(1 Yorum)
3.0
java4uNu

HI, please see your inbox

$4000 HKD in 60 gün içinde
(2 Değerlendirme)
1.8
stalker2011

Hello. I am 4+ years experiences java developer and can do it for you.

$1600 HKD in 10 gün içinde
(1 Yorum)
1.0
pavan45

Please check PMB

$3000 HKD in 30 gün içinde
(1 Yorum)
1.0
softking13

i have an expert team to develop this kind of work .. so lets start our project sir ?? i am waiting for your positive response ... please check PM for your more benefit sir ...

$1600 HKD in 10 gün içinde
(0 Değerlendirme)
0.0
orangeFrontier

Hi, we are from Singapore, we are the best for this job. Please also see PM for more details. Thanks

$4000 HKD in 35 gün içinde
(0 Değerlendirme)
0.0
GauravMalik8666

Work 4 years as a Software Developer. Familiar with Enterprise technologies (Documentum, different Application Servers) and many programming languages. Technical Skills: Documentum ( 2 years ) DC, WebTop, Daha Fazla

$1700 HKD in 20 gün içinde
(0 Değerlendirme)
0.0