On 10/10/2011 2:31 AM, Linus Flustillbe wrote:
My previous posts to this group contained copy/paste Java code
from the Eclipse IDE directly into slrn's message area. 80
characters does not seem to be enough to contain well indented and
formatted code. I would like to do this correctly for future posts
in an effort to be a good usenet citizen. Does anyone have
any suggestions? I was thinking that if you did something like this
package testing;
import java.sql.*;
public class ConnectionTest {
public static void main(String[] args)
throws ClassNotFoundException, SQLException
{
Class.forName("oracle.jdbc.driver.OracleDriver");
String tableName="LU_MEDIA_USAGE";
TableConnect myConnection = new TableConnect();
Statement stmt = myConnection.getStatement();
ResultSet rset = myConnection.GetResultSet(stmt, tableName);
while (rset.next()) {
System.out.println (rset.getString(1));
}
stmt.close();
}
}
It's not pretty but should now be SSCCE as long as all the classes are
in the same package (no need to create a new package)
I usually use 2 spaces per indent level, and format, e.g. in Eclipse, to
well under 80 spaces. I rarely post code with more than 4 levels, so 2
spaces per indent only costs 6 columns, but makes it much more readable.
If I only need one public class I put all the code in one file, with no
package statement. That is not good practice for actual development, but
makes it simple for someone who wants to compile and run the code.
Your code would come out as:
import java.sql.*;
public class ConnectionTest {
public static void main(String[] args)
throws ClassNotFoundException, SQLException {
Class.forName("oracle.jdbc.driver.OracleDriver");
String tableName = "LU_MEDIA_USAGE";
TableConnect myConnection = new TableConnect();
Statement stmt = myConnection.getStatement();
ResultSet rset = myConnection.GetResultSet(stmt, tableName);
while (rset.next()) {
System.out.println(rset.getString(1));
}
stmt.close();
}
}