Cancelled

Use my Java SQL Select and make a WebPage input

Update code to present a web page with two input fields, one text and one date that will select SQL records. There is a simple database “SSA Information” in a table called ‘sometable’ with 5 columns uniquename, somenumber, somedate, somename, somedetail

InputDate: 01/02/2014

InputUNIQUEname: Anderson

Somenumber Somedate Somename Somedetail

1234 01/02/2014 Tom Likes this

5678 01/02/2014 Mike Likes that

8765 01/02/2014 Harry Goes fishing

4321 01/02/2014 Robert Stays home

What I would like is a simple Java based WebPage with two inputs of inputDate and inputUNIQUEname:

Database: Remote MS SQL Server

Java/Javac Java 1.8

OS SUSE Linux

WebServer Apache

Please see the attached code, this Java code is working and pulling data that lists records in a table like format. There could be 5 to 500 or more rows of data that should just be listed. Compiles with [url removed, login to view] (attached)

"java SelectDataDemo"

"java -cp ./[url removed, login to view]: . SelectDataDemo"

import [url removed, login to view];

import [url removed, login to view];

import [url removed, login to view];

import [url removed, login to view];

public class SelectDataDemo {

public static void main(String[] args) {

Connection connection = null;

Statement insertStmt = null;

Statement selectStmt = null;

String url ="jdbc:jtds:sqlserver://[url removed, login to view]";

String username = "ssareaddb";

String password = "ssareaddb";

[url removed, login to view]("Connecting database...");

try {

[url removed, login to view]("[url removed, login to view]");

String strConnection = url + ";user=" + username + ";password=" + password;

connection = [url removed, login to view](strConnection);

[url removed, login to view]("Database connected!");

} catch (Exception e) { throw new IllegalStateException("Cannot connect the database!", e); }

try {

String myselect1 = "SELECT ";

String myselect2 = "somenumber, somedate, somename, somedetail ";

String myselect3 = "FROM sometable ";

String myselect4 = "WHERE myinputdate = somedate AND myinputname = sometime”;

[url removed, login to view]("\nmysqlcmd: %s\n\n ", mysqlcmd);

selectStmt = [url removed, login to view]();

ResultSet rs = [url removed, login to view] (mysqlcmd);

while([url removed, login to view]()) {

[url removed, login to view]([url removed, login to view](1)); //somenumber

[url removed, login to view](" ");

[url removed, login to view]([url removed, login to view](2)); //somedate

[url removed, login to view](" ");

[url removed, login to view]([url removed, login to view](3)); //somename

[url removed, login to view](" ");

[url removed, login to view]([url removed, login to view](4)); //somedetail

}

}

catch (Exception e) {

[url removed, login to view]();

}finally {

try {

[url removed, login to view]();

//[url removed, login to view]();

[url removed, login to view]();

} catch (Exception e) {

[url removed, login to view]();

}

}

}

}

Skills: Java, Linux, Microsoft SQL Server, Website Design

See more: working from home data input, what is new in java 1.5, webpage format, rs design web, print println java, new in java 1.5, make a web page, linux based webpage design, driver select, java mysql picture select, oracle sql statement select employees database work projects, post select php sql, jquery select box manipulation use, auto select fron sql data base javascript, select data sql server 2000 month, php sql forms select show details option selected, sql 2005 select chinese, sql query select last date customer order, componentart use select method

About the Employer:
( 58 reviews ) Lyndhurst, United States

Project ID: #9218714

32 freelancers are bidding on average $32 for this job

kapasiyash

Hello there. I am expert in java. I can do the work as per your requirement. Looking forward for your reply. Thanks..

$55 USD in 1 day
(39 Reviews)
5.9
tumakha

Hi. I can do it using Java 8, Servlets 3.0, Maven-3.3.9 and jtds-1.3.1 <dependency> <groupId>[login to view URL]</groupId> <artifactId>jtds</artifactId> <version>1.3.1</version> </dependency>

$50 USD in 1 day
(13 Reviews)
4.9
Shchipunov

Hello! I understood the task and I can implement the required functionalities. After you award me this project you MUST NOT worry about task's implementation - only wait for the final completed result. All diffic More

$25 USD in 1 day
(20 Reviews)
4.3
MohamedIbrahimCS

We are Egyptian team, and i am sure that you will get our work is a great as you expect, all of team have a diploma in javaSE, JavaEE, JavaFX using many technologies like Struts1, Struts2, Hibernate, JPA, Spring, Sprin More

$30 USD in 1 day
(18 Reviews)
4.2
CodingWhiz

If I understand correctly, you just want to be able to add entries to your database via a form on a webpage. That would be very easy to achieve with a simple Servlet. Please let me know the specifics of what you want d More

$16 USD in 3 days
(13 Reviews)
4.2
ashishtiwari2005

I am a sun certified java programmer with over 12 years of experience in designing and developing applications. My clientele includes tier-1 companies in banking and insurance domain in the UK. Having extensive exp More

$35 USD in 1 day
(9 Reviews)
3.8
anuragiitk

I am an IITK graduate, 9 year experienced software professional and I have got top notch developers in my team, who have got experience across a span of technologies. The members in my team have worked with top notch t More

$222 USD in 1 day
(19 Reviews)
5.2
thanhtuan5787

A proposal has not yet been provided

$35 USD in 1 day
(11 Reviews)
3.3
kanishk25

A proposal has not yet been provided

$30 USD in 1 day
(5 Reviews)
3.1
mjkaja

Hi I am an expert in Java. I have completely understood your requirements and would like to discuss more in chat. Kindly ping me if you are interested in my proposal Thanks

$15 USD in 3 days
(16 Reviews)
3.1
Jai1982

I have 11+ years of experience working in java/j2EE projects. I am certified Java Enterprise architect. I am interested in your project. Here are some of my certifications. we can discuss further if you are in More

$25 USD in 1 day
(8 Reviews)
2.9
u386063

Having expertise in JAVA, HTML5, Spring, Hibernate & JavaScript frameworks. ;

$10 USD in 1 day
(6 Reviews)
2.3
remonengineer

HI, i have a very experience in java development and java web development ( JSP , JSF). Regards,

$23 USD in 1 day
(7 Reviews)
3.1
viktor16

I am a master student of Information tehnology and I can do this job for a few hours. I was read all codes which you set, and I can do that. You can be sure it will be well done... I worked similar projects many ti More

$16 USD in 1 day
(1 Review)
1.7
mohdarshad1009

I have an experience of 3 years in ASP.Net and SQL Server and I have worked with Infosys Limited and National Informatics Centre on SQL based projects for Reports. Currently working as freelancer.

$24 USD in 1 day
(0 Reviews)
0.0
praka80402

Hi,we have a team of 4 people,who can work on above mentioned project

$25 USD in 2 days
(0 Reviews)
0.0
amit28091992

A proposal has not yet been provided

$10 USD in 1 day
(0 Reviews)
0.0
dineshmycareers

Use my Java SQL Select and make a WebPage input Use my Java SQL Select and make a WebPage input Use my Java SQL Select and make a WebPage input

$25 USD in 1 day
(0 Reviews)
0.0
srikanthchenna

A proposal has not yet been provided

$14 USD in 1 day
(0 Reviews)
0.0
harieng

Hi, We have two member with 4+ experience we will do it with more quality code and in future you required any support for same code we will provide with minimum time effort.

$35 USD in 2 days
(0 Reviews)
0.0