■

1.Looper.java
import java.awt.*;
import java.applet.AudioClip;

public class Looper extends javax.swing.JApplet implements Runnable {
AudioClip bgSound;
AudioClip beep;
Thread runner;
getAudioClip(getCodeBase(),"train.wav")

import java.sql.*;
Connection conn = DriverManager.getConnection(
data, "", "");
Statement st = conn.createStatement();
ResultSet rec = st.executeQuery(
"SELECT * " +
"FROM Coal " +
"WHERE " +
"(Country='" + arguments[0] + "') " +
"ORDER BY Year");

Connection conn = DriverManager.getConnection(
data, "", "");
Statement st = conn.createStatement();
ResultSet rec = st.executeQuery(
"SELECT * " +
"FROM " + quote + "Country Oil Totals " + quote +
"WHERE " +
"(Country='" + arguments[0] + "') " +
"ORDER BY Year");
System.out.println("COUNTRY\tYEAR\tPRODUCTION\t" +
"REFINED\tIMPORTS\tEXPORTS");

ResultSet rec = st.executeQuery(
"SELECT * FROM Contacts ORDER BY NAME");
while(rec.next()) {
System.out.println(rec.getString("NAME") + "\n"
+ rec.getString("ADDRESS1") + "\n"
+ rec.getString("ADDRESS2") + "\n"
+ rec.getString("PHONE") + "\n"
+ rec.getString("E-MAIL") + "\n");

import java.io.*;
import java.net.*;
import java.sql.*;
import java.util.*;

retrieveQuote() {
StringBuffer buf = new StringBuffer();
URL page = new URL("http://quote.yahoo.com/d/quotes.csv?s=" + ticker
+ "&f=sl1d1t1c1ohgv&e=.csv");
String line;
URLConnection conn = page.openConnection();
conn.connect();
InputStreamReader in= new InputStreamReader(conn.getInputStream());
BufferedReader data = new BufferedReader(in);
while *1 != null) {
buf.append(line + "\n");

XML
import javax.xml.parsers.*;
import org.xml.sax.*;
import org.xml.sax.helpers.*;
import java.io.*;

public class CountTag extends DefaultHandler
File input = new File(xmlFile);
SAXParserFactory factory = SAXParserFactory.newInstance();
factory.setValidating(false);
SAXParser sax = factory.newSAXParser();
CountTagHandler cth = new CountTagHandler(tagName);
sax.parse(input, cth);
System.out.println("The " + cth.tag + " tag appears "
+ cth.count + " times.");
} catch (ParserConfigurationException pce) {
System.out.println("Could not create that parser.");
System.out.println(pce.getMessage());
} catch (SAXException se) {
System.out.println("Problem with the SAX parser.");
System.out.println(se.getMessage());
} catch (IOException ioe) {
System.out.println("Error reading file.");
System.out.println(ioe.getMessage());
}
}
}

import javax.xml.parsers.*;
import org.xml.sax.*;
import org.xml.sax.helpers.*;
import java.io.*;

ReadCoalTotalsXML read = new ReadCoalTotalsXML();
ReadCoalTotalsXML()
SAXParserFactory factory = SAXParserFactory.newInstance();
factory.setValidating(true);
try {
SAXParser sax = factory.newSAXParser();
sax.parse(input, new CoalTotalsXMLHandler() );
public class ReadCoalTotalsXML extends DefaultHandler

class CoalTotalsXMLHandler extends DefaultHandler {
qName.equals
import javax.xml.parsers.*;
import org.xml.sax.*;
import org.xml.sax.helpers.*;
import java.io.*;

*1:line = data.readLine(