Archive

Archive for the ‘Java’ Category

Eclipse: Java project from source

May 21st, 2007 No comments

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.

Categories: Eclipse, Java Tags:

Wicket addon to Eclipse (Wicket Bench)

May 20th, 2007 No comments

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

Categories: Eclipse, Java, Wicket Tags:

Insert Java Date type into MSSQL’s datetime

May 17th, 2007 No comments

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
{
}

Categories: Java, MSSQL Tags:

Setting up MSSQL in Eclipse

May 16th, 2007 No comments

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

Categories: Eclipse, Java, MSSQL Tags: