Java

public static void main(String[] args) {
        int i=1;
        int f=0;
        while (i <=8){
            f=f+i;
            i++;

        }System.out.println(Math.pow(f, 2));
    }

}

import java.sql.*;

public class selectStmt {
	private static final String DB_DRIVER = "com.mysql.jdbc.Driver";
	private static final String DB_CONNECTION = "jdbc:mysql://127.0.0.1:3306/abo";
	private static final String DB_USER = "username";
	private static final String DB_PASSWORD = "pswd";
	
	public selectStmt(){
		try {
			 
			selectRecordsFromTable();
 
		} catch (SQLException e) {
 
			System.out.println(e.getMessage());
 
		}
 
	}
 
	private static void selectRecordsFromTable() throws SQLException {
 
		Connection dbConnection = null;
		PreparedStatement preparedStatement = null;
 
		String selectSQL = "SELECT * FROM abo.pathitems where ObjectID=1";
 
		try {
			dbConnection = getDBConnection();
			preparedStatement = dbConnection.prepareStatement(selectSQL);
			//preparedStatement.setInt(1, 100);
			
			// execute select SQL stetement
			ResultSet rs = preparedStatement.executeQuery();
 
			while (rs.next()) {
                            
				/*  how can i use GeneralPath class here and its functions such as moveTo() and curveTo() to pass all points properly */
			}
 
		} catch (SQLException e) {
 
			System.out.println(e.getMessage());
 
		} finally {
 
			if (preparedStatement != null) {
				preparedStatement.close();
			}
 
			if (dbConnection != null) {
				dbConnection.close();
			}
 
		}
 
	}
 
	private static Connection getDBConnection() {
 
		Connection dbConnection = null;
 
		try {
 
			Class.forName(DB_DRIVER);
 
		} catch (ClassNotFoundException e) {
 
			System.out.println(e.getMessage());
 
		}
 
		try {
 
			dbConnection = DriverManager.getConnection(
                             DB_CONNECTION, DB_USER,DB_PASSWORD);
			return dbConnection;
 
		} catch (SQLException e) {
 
			System.out.println(e.getMessage());
 
		}
 
		return dbConnection;
	}

}

I am looking for making a database program by myself, but I don't want to end up in a dead end for some reason, so I need ton of examples and even better the entire source code of a sample database program. Any good book for this?

I don't care about the theory. I just want to know how to make a db program and then focus on using design patterns to improve the code.

Also, I am looking for a good book on Java Swing so I end up knowing all the ins and outs of Java Swing. I want tons of examples.

public class Capture extends JFrame {

	  protected boolean running;
	  ByteArrayOutputStream out;

	  public Capture() {
	    super("Capture Sound Demo");
	    setDefaultCloseOperation(EXIT_ON_CLOSE);
	    Container content = getContentPane();

	    final JButton capture = new JButton("Capture");
	    final JButton stop = new JButton("Stop");
	    final JButton play = new JButton("Play");

	    capture.setEnabled(true);
	    stop.setEnabled(false);
	    play.setEnabled(false);

	    ActionListener captureListener = 
	        new ActionListener() {
	      public void actionPerformed(ActionEvent e) {
	        capture.setEnabled(false);
	        stop.setEnabled(true);
	        play.setEnabled(false);
	        captureAudio();
	      }
	    };
	    capture.addActionListener(captureListener);
	    content.add(capture, BorderLayout.NORTH);

	    ActionListener stopListener = 
	        new ActionListener() {
	      public void actionPerformed(ActionEvent e) {
	        capture.setEnabled(true);
	        stop.setEnabled(false);
	        play.setEnabled(true);
	        running = false;
	      }
	    };
	    stop.addActionListener(stopListener);
	    content.add(stop, BorderLayout.CENTER);

	    ActionListener playListener = 
	        new ActionListener() {
	      public void actionPerformed(ActionEvent e) {
	        playAudio();
	      }
	    };
	    play.addActionListener(playListener);
	    content.add(play, BorderLayout.SOUTH);
	  }

	  private void captureAudio() {
	    try {
	      final AudioFormat format = getFormat();
	      DataLine.Info info = new DataLine.Info(
	        TargetDataLine.class, format);
	      final TargetDataLine line = (TargetDataLine)
	        AudioSystem.getLine(info);
	      line.open(format);
	      line.start();
	      
	      Runnable runner = new Runnable() {
	        int bufferSize = (int)format.getSampleRate() 
	          * format.getFrameSize();
	        byte buffer[] = new byte[bufferSize];
	 
	        public void run() {
	          out = new ByteArrayOutputStream();
	          running = true;
	          try {
	            while (running) {
	              int count = 
	                line.read(buffer, 0, buffer.length);
	              if (count > 0) {
	                out.write(buffer, 0, count);
	               
	                System.out.println(line.getLevel());  // |-this is what i added-|
	              }
	            }
	            out.close();
	          } catch (IOException e) {
	            System.err.println("I/O problems: " + e);
	            System.exit(-1);
	          }
	        }
	      };
	      Thread captureThread = new Thread(runner);
	      captureThread.start();
	    } catch (LineUnavailableException e) {
	      System.err.println("Line unavailable: " + e);
	      System.exit(-2);
	    }
	  }

	  private void playAudio() {
	    try {
	      byte audio[] = out.toByteArray();
	      InputStream input = 
	        new ByteArrayInputStream(audio);
	      final AudioFormat format = getFormat();
	      final AudioInputStream ais = 
	        new AudioInputStream(input, format, 
	        audio.length / format.getFrameSize());
	      DataLine.Info info = new DataLine.Info(
	        SourceDataLine.class, format);
	      final SourceDataLine line = (SourceDataLine)
	        AudioSystem.getLine(info);
	      line.open(format);
	      line.start();
	      
	      Runnable runner = new Runnable() {
	        int bufferSize = (int) format.getSampleRate() 
	          * format.getFrameSize();
	        byte buffer[] = new byte[bufferSize];
	 
	        public void run() {
	          try {
	            int count;
	            while ((count = ais.read(
	                buffer, 0, buffer.length)) != -1) {
	              if (count > 0) {
	                line.write(buffer, 0, count);
	              }
	            }
	            
	            line.drain();
	            line.close();
	            
	          } catch (IOException e) {
	            System.err.println("I/O problems: " + e);
	            System.exit(-3);
	          }
	        }
	      };

      Thread playThread = new Thread(runner);
	      playThread.start();
	    } catch (LineUnavailableException e) {
	      System.err.println("Line unavailable: " + e);
	      System.exit(-4);
	    } 
	  }

	  private AudioFormat getFormat() {
	    float sampleRate = 8000;
	    int sampleSizeInBits = 8;
	    int channels = 1;
	    boolean signed = true;
	    boolean bigEndian = true;
	    return new AudioFormat(sampleRate, 
	      sampleSizeInBits, channels, signed, bigEndian);
	  }
	  
	  @SuppressWarnings("deprecation")
	public static void main(String args[]) {
	    JFrame frame = new Capture();
	    frame.pack();
	    frame.show();
	  }	  
}