Insert in Microsoft SQL using JDBC

Question

I have some data coming from a machine in the following format: A (some value) B (some value) C (some value) and so on.

I have a database in the Microsoft SQL server 2008 with the columns named A, B, C and so on.

I have downloaded the jdbc drivers for the MS SQL server 2008 and included in my classpath.

I want to insert the values of A, B, C, etc in SQL when i receive it over from a different machine(port). Basically i have to design a server in Java which listens to that port for the values and when it receives the values, it inserts it into the MS SQL database.

Can someone help me code the above in Java? I am new to Java, hence finding it a bit difficult.

Thank you.

duffymo · Accepted Answer · 2011-10-10 15:15:14Z

1

Start with the JDBC tutorial:

http://download.oracle.com/javase/tutorial/jdbc/

It should sort you out.

Microsoft also has examples specific to SQL Server here:

http://support.microsoft.com/kb/313100

That takes care of the database side. When you say "server", I'll assume that you want a web based server that's listening on a port for HTTP requests. You'll need a servlet running in a servlet/JSP engine like Tomcat.

Write an interface-based object that handles your database work; thoroughly test it and put it aside. Then write a servlet that calls that object after validating and binding input values.

edited Oct 10, 2011 at 15:15

answered Oct 10, 2011 at 15:04

duffymo

310k46 gold badges377 silver badges572 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

KV Prajapati · Accepted Answer · 2011-10-10 15:14:41Z

0

Tutorials and articles on Microsoft JDBC driver for MSSQL server.

answered Oct 10, 2011 at 15:14

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

Collectives™ on Stack Overflow

Insert in Microsoft SQL using JDBC

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related