Yet another Java/Eclipse quirk. Even though there is a GUI designed to work off an existing project. The real way to do it is to put the existing project in your workspace (the folder you set to be your default area in Eclipse) and then create a new project with the same name as the name given to the folder of the existing project.
This Eclipse add on helps with Wicket development allowing you to compile and run just components to speed up development. (http://www.laughingpanda.org/mediawiki/index.php/Wicket_Bench)
Help -> Software Updates -> Find and Install
Search for new features to install
New Remote Site:
http://www.laughingpanda.org/svn/wicket-bench/trunk/wicket-bench-site
Seems a little ugly for what it does, but hey it’s OO-fantastic.
Statement stmt = null;
Connection con = null;
try
{
Class.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver”);
con = DriverManager.getConnection(connectionURL);
stmt=con.createStatement();
java.text.DateFormat df = new java.text.SimpleDateFormat(“MM/dd/yyyy”);
String startDate = df.format(date_var);
stmt.executeUpdate(“INSERT INTO XX (day_entry) VALUES (‘” + startDate + “‘);”);
}
catch(Exception e)
{
System.out.println(query);
e.printStackTrace();
}
finally
{
}
Download MSSQL Driver:
http://msdn2.microsoft.com/en-us/data/aa937724.aspx
Note: If you are running MSSQL 2000 the MSSQL 2005 driver will work for you too.
Add driver to eclipse project:
1. Right-click on the project then go to properties
2. ‘Java Build Path’
3. ‘Libraries’ tab
4. ‘Add External JAR’.
SQL Explorer in Eclipse:
Setup instructions