gistfile1.java

   Connection conn = null;
   Statement stmt = null;
   try{
      
      Class.forName("com.mysql.jdbc.Driver");

      conn = DriverManager.getConnection(DB_URL,USER,PASS);

      
      stmt = conn.createStatement();
      String sql;
      sql = "SELECT id, first, last, age FROM Employees";
      ResultSet rs = stmt.executeQuery(sql);

      
      while(rs.next()){
      
         int id  = rs.getInt("id");
         int age = rs.getInt("age");
         String first = rs.getString("first");
         String last = rs.getString("last");
      }
      
      rs.close();
      stmt.close();
      conn.close();
   }catch(SQLException se){
      se.printStackTrace();
   }catch(Exception e){
      e.printStackTrace();
   }finally{
      try{
         if(stmt!=null)
            stmt.close();
      }catch(SQLException se2){
      }
      try{
         if(conn!=null)
            conn.close();
      }catch(SQLException se){
         se.printStackTrace();
      }
   }

gistfile2.java

public class JDBCEmployeeDAOImpl {
    private DataSource dataSource;
    private JdbcTemplate jdbcTemplate;
  
    public void setDataSource(DataSource dataSource) {
        this.dataSource = dataSource;
    }
  
    public void insert(Employee employee){
  
        String sql = "SELECT id, first, last, age FROM Employees WHERE id = ?";
  
        jdbcTemplate = new JdbcTemplate(dataSource);
  
        Employee employee = (Employee) jdbcTemplate.queryForObject(
            sql, new Object[] { id }, new EmployeeRowMapper());
    }   
}

gistfile3.java

	public class JdbcCustomerDAO extends JdbcDaoSupport {
	   
	   public void insert(Customer customer){
 
		String sql = "INSERT INTO CUSTOMER " +
			"(CUST_ID, NAME, AGE) VALUES (?, ?, ?)";
 
		getJdbcTemplate().update(sql, new Object[] { customer.getCustId(),
				customer.getName(),customer.getAge()  
		});
 
	}