How to connect eclipse and microsoft sql server to create an application?
-
am using MS sql server 2005 management studio and eclipse to create a database application. my skills in sql are good but i lack complete knowledge in java.So far i have downloaded the sql jdbc connector...now i have no clue as to what to do next. i have created my required database and tables with entries complete. what is left is creating windows and buttons and feilds and connecting each of these to a query in the database. if anyone could show a tutorial website online would be nice also. Please do help....thankyou
-
Answer:
Check the MS docs page at http://msdn.microsoft.com/en-us/library/ms378526.aspx. Here's what it says: Make sure the jar is in your build path, then call... Class.forName("com.microsoft.sqlserver... //only need to call once String connectionUrl = "jdbc:sqlserver://localhost:1433;" + "databaseName=AdventureWorks;user=MyUser... Connection con = DriverManager.getConnection(connectionUr...
tasha nole at Yahoo! Answers Visit the source
Other answers
Check the MS docs page at http://msdn.microsoft.com/en-us/library/ms378526.aspx. Here's what it says: Make sure the jar is in your build path, then call... Class.forName("com.microsoft.sqlserver… //only need to call once String connectionUrl = "jdbc:sqlserver://localhost:1433;" + "databaseName=AdventureWorks;user=MyUser… Connection con = DriverManager.getConnection(connectionUr…
godfathe...
1) Make a connection 2) Open the database 3) Query 4) Close the database http://docs.oracle.com/javase/tutorial/jdbc/index.html
TheSnoopy
1) Make a connection 2) Open the database 3) Query 4) Close the database http://docs.oracle.com/javase/tutorial/jdbc/index.html
TheSnoopy
Related Q & A:
- How to connect Sql Server Database from android app?Best solution by Stack Overflow
- How to increase application performance with Centralised SQL Server?Best solution by Database Administrators
- How to restrict access to a sql server database from Azure?Best solution by Stack Overflow
- How to enable remote connections in SQL Server 2008?Best solution by Server Fault
- How do I connect to SQL Server using C#?Best solution by Stack Overflow
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.