Find Jobs
Hire Freelancers

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

$1600-4000 HKD

処理中
投稿日: 12年以上前

$1600-4000 HKD

完了時にお支払い
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.
プロジェクト ID: 1171430

プロジェクトについて

14個の提案
リモートプロジェクト
アクティブ 13年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
Please check your PM
$1,600 HKD 20日以内
5.0 (1 レビュー)
2.6
2.6
この仕事に14人のフリーランサーが、平均$2,997 HKDで入札しています
ユーザーアバター
We have 10+ years experience in JSP Web application development ! Please check PMB for references !
$3,456 HKD 15日以内
4.9 (340 レビュー)
7.2
7.2
ユーザーアバター
Hello, I am JSP&Javascript developer, please check your pm Thanks
$3,800 HKD 12日以内
4.9 (59 レビュー)
6.7
6.7
ユーザーアバター
Hello, Please view PMB. Ashwin
$4,000 HKD 15日以内
4.8 (42 レビュー)
5.7
5.7
ユーザーアバター
I am very good expertise in Java technologies but new to freelancer. I can finish this project efficiently
$3,600 HKD 15日以内
4.6 (5 レビュー)
3.5
3.5
ユーザーアバター
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
$4,000 HKD 30日以内
4.9 (6 レビュー)
3.0
3.0
ユーザーアバター
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.
$4,000 HKD 30日以内
5.0 (1 レビュー)
3.0
3.0
ユーザーアバター
HI, please see your inbox
$4,000 HKD 60日以内
5.0 (2 レビュー)
1.8
1.8
ユーザーアバター
Hello. I am 4+ years experiences java developer and can do it for you.
$1,600 HKD 10日以内
5.0 (1 レビュー)
1.0
1.0
ユーザーアバター
Please check PMB
$3,000 HKD 30日以内
5.0 (1 レビュー)
1.0
1.0
ユーザーアバター
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 ...
$1,600 HKD 10日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi, we are from Singapore, we are the best for this job. Please also see PM for more details. Thanks
$4,000 HKD 35日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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, EDMS98 client customization and development, strong skills in API, DFC, Docbasic , Lifecycle, Workflow Programming Languages ( 4 years ) C, C++ , PHP , ASP.Net 4.0(including MVC 3 Rajor architecture) with VB and C# , C#.Net, VB.net, Web Scrapping ,AJAX, WCF, WPF, Silverlight, MVC architecture of J2EE (Integration of Spring 3.0(as model or dependency injuction) , JSF 2.0 with Rich faces 3.3.3(as view and controller(faces servlet)), Hibernate 3.0(annotations) or EJB 3.0 for database layer) , LDAP (Light Weight directory access protocol) security with Tomcat server and JBoss or any other application server, Google App Engine, Java, J++, JSP, Servlets, Swings, Struts 2.0 , Remote Method Invocation(RMI), Web Services , EJB 3.0 , Web Services , HTML 5.0, XML ,XSLT, JavaScript, VB Script, Basic, Pascal Payment Gateways:Paypal, American Express, Visa, Master Card Database : Microsoft Sql server 2008, Mysql 5.0, Oracle 10g Technologies ( 2 years ) COM, EJB, J2EE, MFC, ATL, ODBC,ADO, JDBC, ActiveX Application servers ( 3 years ) Apache Tomcat, Oracle Weblogic 10.0 , IBM Websphere,JBOSS IDE ( 3 years ) Microsoft Developer Studio (C++, J++, Basic), Eclispe,Netbeans, JBuilder, JDeveloper, Oracle Spring Source Platforms ( 5 years ) Windows Vista,XP,7 Office Programming ( 5 years ) Word, Excel, Access Contact: Gtalk :deepakmalik866 Skype :deepakmalik866 Mobile:+91-9037807998 Thanks and Regards, Deepak Malik
$1,700 HKD 20日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

HONG KONGのフラグ
Hong Kong, Hong Kong
5.0
16
お支払い方法確認済み
メンバー登録日:6月 13, 2011

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。