public void incluirCliente(Cliente c) throws SQLException {
		PreparedStatement stmt = null;
		
		try {
			stmt = connection.prepareStatement("insert into MyDB.Cliente (idCliente, nome, dataNascimento, endereco, complemento, cep, telefone)
			values (?,?,?,?,?,?,?)");
			
			stmt.setInt(1,c.getId());
			stmt.setString(2,c.getNome());
			stmt.setInt(3,c.getDataNascimento());
			stmt.setString(4, c.getEndereco());
			stmt.setString(5, c.getComplemento());
			stmt.setString(6, c.getCep());			
			stmt.setString(7, c.getTelefone());
			
			stmt.execute();		
		}
		finally {
			if (stmt != null)
				stmt.close();
		}		
	}
	
	public void alterarCliente(Cliente c) throws SQLException {
		PreparedStatement stmt = null;
		
		try {
			stmt = connection.prepareStatement("update MyDB.Cliente set "
					+ "nome = ?,"
					+ "dataNascimento = ?, "
					+ "endereco = ?, "
					+ "complemento = ?, "
					+ "cep = ?, "
					+ "telefone = ? where idCliente = ?");
			
			stmt.setString(1,c.getNome());
			stmt.setInt(2,c.getDataNascimento());
			stmt.setString(3, c.getEndereco());
			stmt.setString(4, c.getComplemento());
			stmt.setString(5, c.getCep());			
			stmt.setString(6, c.getTelefone());
			stmt.setInt(7,c.getId());
			
			stmt.execute();		
		}
		finally {
			if (stmt != null)
				stmt.close();
		}			
	}
	
	public void excluirCliente(Cliente c) throws SQLException {
		PreparedStatement stmt = null;
		
		try {
			stmt = connection.prepareStatement("delete from MyDB.Cliente where idCliente = ?");

			stmt.setInt(1,c.getId());
			
			stmt.execute();		
		}
		finally {
			if (stmt != null)
				stmt.close();
		}		
	}

	public Cliente carregarCliente(int id) throws SQLException {
		PreparedStatement stmt = null;
		ResultSet rs = null;

		Cliente result = null;
		
		try {
			stmt = connection.prepareStatement("select * from MyDB.Cliente where idCliente = ?");
		
			stmt.setInt(1,id);
			
			rs = stmt.executeQuery();
		
			if (rs.next()) {
				Cliente c = new Cliente();
				c.setId(rs.getInt("idCliente"));
				c.setNome(rs.getString("nome"));
				c.setDataNascimento(rs.getInt("dataNascimento"));
				c.setEndereco(rs.getString("endereco"));
				c.setComplemento(rs.getString("complemento"));
				c.setCep(rs.getString("cep"));
				c.setTelefone(rs.getString("telefone"));
				result = c;
			}
		}
		finally {
			if (rs != null)
				rs.close();
			if (stmt != null)
				stmt.close();
		}
		
		return result;
	}